play-sql 0.0.3

Description:

playsql 0.0.3

play sql




pytest-play support for SQL expressions and assertions
More info and examples on:

pytest-play, documentation
cookiecutter-qa, see pytest-play in action with a working example if you want to start hacking


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:

@davidemoro



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