pgtap
pgtap copied to clipboard
PostgreSQL Unit Testing Suite
We need tests for being able to correctly install and uninstall when not doing that as part of an extension. See also #224.
Hey folks! What would be the right way to test in parallel with setup fixtures? I am thinking about something that will: 1. Run my test in a separate isolated...
```sql SELECT has_column('schema'::name, 'table'::name, 'column'::name); ``` treated as ```sql SELECT has_column('schema'::name, 'table'::name, 'column'::text); ```
Postgres 14.2 pgTAP 1.2.0 --Schema and no description SELECT has_pk('utility', 'eqpt_model_info'); not ok 3 - eqpt_model_info \# Failed test 3: "eqpt_model_info" --No schema and no description SELECT has_pk('eqpt_model_info'); ok 3...
Users have no choice but to supply a description if they want to specify a schema. ``` List of functions Schema | Name | Result data type | Argument data...
sh ./tools/testers/pg_prove_tests.sh ``` RELEASE_TYPE b cd ./tools/testers/ psql -f setup_db.sql OK PANIC: could not determine iterator for input at /usr/share/perl/5.26/App/Prove.pm line 546. ```
> Feature Request: has_rls_enabled, hasnt_rls_enabled Tests whether or not a table has row level security (RLS) enabled. **has_rls_enabled()** ``` SELECT has_rls_enabled( :schema, :table, :description ); SELECT has_rls_enabled( :table, :description );...
Hi, I’m working a project where I develop locally using a PostgreSQL docker container. Doing the install, I ran into errors that are apparently because I’ve installed pgtap in my...
Hello, i started to use tap and for my testing scenarios i need to pretty print queries before and after i run a function. But when i raise a notice...
Currently there's nothing that verifies that pgtap-core or pgtap-schema are correct.