play-sql 0.0.3

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).

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