Practicing pgTAP

Testing everything against PostgreSQL.

Anatomy of a test: example

Testing existence of

• extensions
• functions
• languages
• roles
• schemas
• tables
• type
• users
• views

Testing what a table has got

• a primary key
• a column which is primary key
• specific column types
• specified columns
• specified not null columns
• specified null columns
• specified index
• a unique column
• a unique constraint
• indexed or not

Testing what a table has NOT got

• column
• foreign key

Being precise on what should be intact in DB

• columns of a table
• extensions
• functions
• groups
• languages
• roles
• schemas
• tables
• types
• users
• views
• indexes

Knowing exceptions and successes

• a test that asserting an exception is being thrown
• a test that asserting there is no exception is being thrown
• a test that asserting the performance of a query
• a test that asserting the performance of a query in a range

Simple assertions

• ok'ness of a test
• ok'ness of a test with a query
• assert two values that should be same
• assert two values that should be different
• comparing equality of results
• assert that query returns NO data
• assert that query returns data
• comparing equality of rows