semvec/pypi-packages huggingface dataset:
sqlcop 0.10.18
A cli tool to check and guard against anti-patterns
License: BSD
Keywords: sqlcop

===============================
sqlcop
===============================

A cli tool to check and guard against anti-patterns

.. image:: https://badge.fury.io/py/sqlcop.png
    :target: http://badge.fury.io/py/sqlcop
.. image:: https://travis-ci.org/freshbooks/sqlcop.svg?branch=master
    :target: https://travis-ci.org/freshbooks/sqlcop
.. image:: https://pypip.in/d/sqlcop/badge.png
    :target: https://crate.io/packages/sqlcop?version=latest

============
Installation
============

From PyPI::

    pip install sqlcop

============
Usage
============

sqlcop is designed to use with `nose-sqlcapture <https://github.com/freshbooks/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