PostgreSQL#
Steps for interacting with PostgreSQL databases
Multi-line Content
Steps ending with : accept multi-line content using Gherkin's docstring syntax ("""). See examples below each section.
Data Setup#
| Step | Description |
|---|---|
"db" table "users" has values: |
Insert rows from table |
"db" clears table "users" |
Truncate a table (removes all rows) |
"db" clears tables: |
Truncate multiple tables from list |
"db" executes: |
Execute raw SQL |
"db" executes file "fixtures/seed.sql" |
Execute SQL from file |
Assertions#
| Step | Description |
|---|---|
"db" table "users" contains: |
Assert table contains rows |
"db" table "users" is empty |
Assert table is empty |
"db" table "users" has "5" rows |
Assert row count |