package-maintenance.dev

play-sql

======== play sql ======== .. image:: https://img.shields.io/pypi/v/play_sql.svg :target: https://pypi.python.org/pypi/play_sql .. image:: https://travis-ci.org/davidemoro/play_sql.svg?branch=develop :target: https://travis-ci.org/davidemoro/play_sql .. image:: https://readthedocs.org/projects/play-sql/badge/?version=latest :target: https://play-sql.readthedocs.io/en/latest/?badge=latest :alt: Documentation Status .. image:: https://codecov.io/gh/davidemoro/play_sql/branch/develop/graph/badge.svg :target: https://codecov.io/gh/davidemoro/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). .. Cookiecutter: https://github.com/audreyr/cookiecutter .. audreyr/cookiecutter-pypackage: https://github.com/audreyr/cookiecutter-pypackage .. cookiecutter-play-plugin: https://github.com/davidemoro/cookiecutter-play-plugin .. _pytest-play: https://github.com/davidemoro/pytest-play .. _cookiecutter-qa: https://github.com/davidemoro/cookiecutter-qa .. @davidemoro: https://twitter.com/davidemoro ======= 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

pypi package. Binary | Source

Latest version: 0.0.3 Released: 2019-01-25