A cli tool to check and guard against anti-patterns
Project description
sqlcop
A cli tool to check and guard against anti-patterns
Installation
From PyPI:
pip install sqlcop
Usage
sqlcop is designed to use with nose-sqlcapture.
First, you use nose-sqlcapture to generate a SQL capture file:
nosetests [other options] --with-sqlcapture --sqlcapture-filename=sql.log --sqlcapture-format=json
Run sqlcop on the generated sql log fie:
sqlcop sql.log
For some checks, a database schema is needed. In that case, you need to supply the url to the database so sqlcop can grab the metadata:
sqlcop --db-urls=mysql://user:pwd@host:port/db sql.log
You can specify more than one db_urls at once:
sqlcop --db-urls=mysql://user:pwd@host:port/db1,mysql://user:pwd@host:port/db2 sql.log
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
sqlcop-0.10.9.tar.gz
(7.5 kB
view hashes)
Built Distribution
Close
Hashes for sqlcop-0.10.9-py2.py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | e8b4ebae1ae6d45663f3779b7d814de9aedcf85e9fe97dd37805a49c94e0c6cb |
|
MD5 | 4aaecd784994d9b5c07c721c9d3a059a |
|
BLAKE2b-256 | 8e5b405244837211eba1bd135f28da6f38c401044bc4c70475380d5e77100180 |