diff options
| author | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-04-14 13:22:15 +0000 |
|---|---|---|
| committer | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-04-14 13:22:15 +0000 |
| commit | 99158ba38e5ad4a210b488951838266fb5cfff95 (patch) | |
| tree | 57d669fe7fed381905dad1dbf19d912f85af71aa /schema/postgresql/t/README.md | |
| parent | Initial commit. (diff) | |
| download | icingaweb2-module-idoreports-upstream.tar.xz icingaweb2-module-idoreports-upstream.zip | |
Adding upstream version 0.10.1.upstream/0.10.1upstream
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'schema/postgresql/t/README.md')
| -rw-r--r-- | schema/postgresql/t/README.md | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/schema/postgresql/t/README.md b/schema/postgresql/t/README.md new file mode 100644 index 0000000..5467be9 --- /dev/null +++ b/schema/postgresql/t/README.md @@ -0,0 +1,18 @@ +Tests for the idoreports_get_sla_ok_percent() function +====================================================== + +These are pg_tap tests. You need pg_tap installed for the PG version you want to test on, e.g. "postgresql-12-pgtap" for Debian/Ubuntu. + +I used these to find the cause for some seamingly strange NULL results. +Which were basically due to a badly chosen ALIAS ("state_time" on line 20, which is now "state_time_"). + +I run these tests on an Ubuntu/Debian system with "pg_virtualenv" like this: + +``` +pg_virtualenv -s pg_prove t/0*.sql +``` +or simply +``` +t/testme.sh +``` + |