Skip to main content

pytest-play support for SQL expressions and assertions

Project description

play sql

https://img.shields.io/pypi/v/play_sql.svg https://travis-ci.org/davidemoro/play_sql.svg?branch=develop Documentation Status https://codecov.io/gh/davidemoro/play_sql/branch/develop/graph/badge.svg

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.3 (2019-01-25)

  • Supports new pytest-play >= 2.0 YAML based syntax (json no more supported)

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.

Source Distribution

play_sql-0.0.3.tar.gz (17.7 kB view hashes)

Uploaded source

Built Distribution

play_sql-0.0.3-py2.py3-none-any.whl (7.8 kB view hashes)

Uploaded py2 py3

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring Facebook / Instagram Facebook / Instagram PSF Sponsor Fastly Fastly CDN Google Google Object Storage and Download Analytics Huawei Huawei PSF Sponsor Microsoft Microsoft PSF Sponsor NVIDIA NVIDIA PSF Sponsor Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page