622 B
622 B
Expected Results
Use these assertions when verifying connect, inspect, query, and export.
PostgreSQL
- schema:
qa_demo - tables:
accounts,tickets
MySQL
- database:
qa_demo - tables:
accounts,tickets
SQLite
- file:
examples/tmp/dbtool-demo.sqlite - tables:
accounts,tickets
Shared Data Assertions
accountsrow count:3ticketsrow count:4- open tickets:
3 - closed tickets:
1 - at least one
NULLvalue exists intickets.notes - at least one multilingual value exists in
accounts.display_name - export query returns
4rows ordered byticket_id