Decorator for measuring the time and number of database queries
Project description
Decorator for measuring the time and number of database queries
Provides a decorator for measuring the time and number of database queries
Install
- Install package
pip install capture-db-queries
About decorator
capture_queries
decorator it can call the body of the decorated function the specified number of times for multiple measurements, it can validate the total number of queries.
- Optional parameters:
assert_q_count
: The expected number of database requests is otherwise "AssertionError: N not less than or equal to N queries"number_runs
: The number of runs of the test function_
verbose
: Displaying the final results of the test measurementsadvanced_verb
: Displaying the result of each test measurementqueries
: Displaying raw SQL queries to the database
About context manager
ExtCaptureQueriesContext
- Optional parameters:
assert_q_count
: The expected number of database requests is otherwise "AssertionError: N not less than or equal to N queries"verbose
: Displaying the final results of the test measurementsqueries
: Displaying raw SQL queries to the database
Usage example
from capture_db_queries.decorators import capture_queries
@capture_queries(number_runs=2, advanced_verb=True)
def _():
response = self.client.get(url)
>>> Test №1 | Queries count: 10 | Execution time: 0.04s
>>> Test №2 | Queries count: 10 | Execution time: 0.04s
>>> Tests count: 2 | Total queries count: 20 | Total execution time: 0.08s | Median time one test is: 0.041s
from capture_db_queries.decorators import ExtCaptureQueriesContext
with ExtCaptureQueriesContext():
response = self.client.get(url)
>>> Queries count: 164 | Execution time: 0.923s
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
capture_db_queries-1.0.2.tar.gz
(16.6 kB
view hashes)
Built Distribution
Close
Hashes for capture_db_queries-1.0.2-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 35bda975a9d0ee77726ae8126a39513f9008cdeba6736018dc25cbbc13139479 |
|
MD5 | 6bb5bc8a23a1de72483dde9fba1172cc |
|
BLAKE2b-256 | 754f24b59b72655fe8f604bc1bb5deb09e520afff5ebbdc8c95900aa0884796e |