Skip to main content

pytest-play support for SQL expressions and assertions

Project description

========
play sql
========


.. image:: https://img.shields.io/pypi/v/play_sql.svg
:target: https://pypi-hypernode.com/pypi/play_sql

.. image:: https://img.shields.io/travis/tierratelematics/play_sql.svg
:target: https://travis-ci.org/tierratelematics/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/tierratelematics/play_sql/branch/develop/graph/badge.svg
:target: https://codecov.io/gh/tierratelematics/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]',
'condition': '1 > 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')]``)

Fetch first
===========

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/tierratelematics/cookiecutter-play-plugin
.. _pytest-play: https://github.com/tierratelematics/pytest-play
.. _cookiecutter-qa: https://github.com/tierratelematics/cookiecutter-qa
.. _`@davidemoro`: https://twitter.com/davidemoro


=======
CHANGES
=======

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.1.tar.gz (14.7 kB view hashes)

Uploaded Source

Built Distribution

play_sql-0.0.1-py2.py3-none-any.whl (5.8 kB view hashes)

Uploaded Python 2 Python 3

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page