nose-sqlcapture

Capture SQL queries being generated from a nosetests run


Keywords
nose-sqlcapture
License
BSD-3-Clause
Install
pip install nose-sqlcapture==1.0.3

Documentation

SQLCapture nose plugin

Capture SQL queries being generated from a nosetests run

https://badge.fury.io/py/nose-sqlcapture.png https://travis-ci.org/freshbooks/nose-sqlcapture.svg?branch=master https://pypip.in/d/nose-sqlcapture/badge.png

Installation

Do `pip install nose-sqlcapture` in your project. Your project should already have `nosetests` and `sqlalchemy` installed.

Usage

`nosetests [other options] --with-sqlcapture --sqlcapture-filename=sql.log --sqlcapture-format=json`

  • sqlcapture-filename the output file. Default: /tmp/sqlcapture.log
  • sqlcapture-format the format of the log file, either json or plain. Default: plain

Formats

Plain (plain)

Output in plain-text form that's meant for human consumption. The output is of the following format:

test1
test2
SQL1
---
test1
test3
SQL2
---
...

JSON (json)

Ouptut the queries and their corresponding tests in json format:

{
    SQL1: [test1, test2],
    SQL2: [test1, test3],
    ...
}