Skip to main content

pytest-play support for SQL expressions and assertions

Project description

play sql

Documentation Status

pytest-play support for SQL expressions and assertions

More info and examples on:

Features

This project defines a new pytest-play command:

{'type': 'sql',
 'provider': 'play_sql',
 'database_url': 'postgresql://$db_user:$db_pwd@$db_host/$db_name',
 'query': 'SELECT id, title FROM invoices',
 'variable': 'invoice_id',
 'variable_expression': 'results.first()[0]',
 'assertion': 'invoice_id == $invoice_id'}

where:

  • database_url follows the format described http://docs.sqlalchemy.org/en/latest/core/engines.html#database-urls
  • variable_expression is a Python expression
    • results.fetchone() returns an array whose elements matches with the next row’s columns and it could be invoked many times until there will be no more rows (eg: first call (1, 'first',), second call (2, 'second'))
    • results.first() returns an array whose elements matches with the first row’s colums and it can be invoked exactly one time
    • results.fetchall() returns an array of tuples whose elements matches with the selected colums (eg: [(1, 'first'), (2, 'second'), (3, 'third')])

Twitter

pytest-play tweets happens here:

Credits

This package was created with Cookiecutter and the cookiecutter-play-plugin (based on audreyr/cookiecutter-pypackage project template).

CHANGES

0.0.2 (2018-01-22)

  • No more depends on play_python (deprecated)

0.0.1 (2018-01-11)

  • First release

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Filename, size & hash SHA256 hash help File type Python version Upload date
play_sql-0.0.2-py2.py3-none-any.whl (5.8 kB) Copy SHA256 hash SHA256 Wheel py2.py3 Jan 22, 2018
play_sql-0.0.2.tar.gz (14.6 kB) Copy SHA256 hash SHA256 Source None Jan 22, 2018

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page