A Python tool/library that traces a value in MySQL general logs.
Project description
query-log-tracer
A Python tool/library that traces a value in MySQL general logs.
Usage
Set up
$ pip install query-log-tracer
Example usage
./tests/files/general-query.log
is a sample query log file of MySQL 5.7. Most of the queries are generated by EC-CUBE 4.
$ query-log-tracer --log-file=./tests/files/general-query.log --target-table=dtb_customer --target-column=point --filter-column=id --filter-value=1
=== Searching in ./tests/files/general-query.log ===
2020-02-02T07:19:51.127168Z dtb_customer.point (id = 1) is set: '0'
2020-02-02T07:20:19.927027Z dtb_customer.point (id = 1) is set: '0'
2020-02-02T07:20:26.901577Z dtb_customer.point (id = 1) is set: '100'
2020-02-02T07:20:31.034901Z dtb_customer.point (id = 1) is set: '1000'
2020-02-02T07:20:39.396236Z dtb_customer.point (id = 1) is set: '2000'
2020-02-02T07:20:46.379143Z dtb_customer.point (id = 1) is set: '0'
2020-02-02T07:26:37.443522Z dtb_customer.point (id = 1) is set: '0'
2020-02-02T07:26:55.216881Z dtb_customer.point (id = 1) is set: '0'
2020-02-02T07:27:13.008757Z dtb_customer.point (id = 1) is set: '50'
2020-02-02T07:28:01.128957Z dtb_customer.point (id = 1) is set: '0'
2020-02-02T07:28:09.995354Z dtb_customer.point (id = 1) is set: '0'
2020-02-02T07:28:14.172518Z dtb_customer.point (id = 1) is set: '27'
2020-02-02T07:33:41.745400Z dtb_customer.point (id = 1) changes: +500
For EC-CUBE 2, try the following command.
$ query-log-tracer --log-dir=your-directory --target-table=dtb_customer --target-column=point --filter-column=customer_id --filter-value=1
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
query-log-tracer-0.0.1.tar.gz
(10.6 kB
view hashes)
Built Distribution
Close
Hashes for query_log_tracer-0.0.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 340370c44f426c700cd008466ef38ce805c993cf35c2437a0a437a1d52f36338 |
|
MD5 | d2444f54b6f34f1211f43c73d5cefd20 |
|
BLAKE2b-256 | 104ad28864a5fe46028ef69523aebc1e5351dbe958fc7c77c02bab3d7c368ac9 |