Software testing for charms¶

Most types of standard software tests are applicable to Charmed PostgreSQL.

Smoke test¶

This type of test ensures that basic functionality works over a short amount of time.

Steps¶

Deploy database with test application
Start “continuous write” test

Example

juju add-model smoke-test

juju deploy postgresql-k8s --channel 14/edge --trust
juju scale-application postgresql-k8s 3 # (optional)

juju deploy postgresql-test-app
juju integrate postgresql-test-app:first-database postgresql-k8s

# Start "continuous write" test:
juju run postgresql-test-app/leader start-continuous-writes

export user=operator
export pass=$(juju run postgresql-k8s/leader get-password username=${user} | yq '.. | select(. | has("password")).password')
export relname=first-database
export ip=$(juju show-unit postgresql-k8s/0 --endpoint database | yq '.. | select(. | has("public-address")).public-address')
export db=$(juju show-unit postgresql-k8s/0 --endpoint database | yq '.. | select(. | has("database")).database')
export relid=$(juju show-unit postgresql-k8s/0 --endpoint database | yq '.. | select(. | has("relation-id")).relation-id')
export query="select count(*) from continuous_writes"

watch -n1 -x juju run postgresql-test-app/leader run-sql dbname=${db} query="${query}" relation-id=${relid} relation-name=${relname}

# OR

watch -n1 -x juju ssh --container postgresql postgresql-k8s/leader "psql postgresql://${user}:${pass}@${ip}:5432/${db} -c \"${query}\""

# Watch that the counter is growing!

Expected results¶

postgresql-test-app continuously inserts records into the database received through the integration (the table continuous_writes).
The counters (amount of records in table) are growing on all cluster members

Tips¶

To stop the “continuous write” test, run

juju run postgresql-test-app/leader stop-continuous-writes

To truncate the “continuous write” table (i.e. delete all records from database), run

juju run postgresql-test-app/leader clear-continuous-writes

Unit test¶

Check the Contributing guide on GitHub and follow tox run -e unit examples there.

Integration test¶

Check the Contributing guide on GitHub and follow tox run -e integration examples there.

System test¶

To perform a system test, deploy postgresql-k8s-bundle. This charm bundle automatically deploys and tests all the necessary parts at once.