omni_test

pig build pkg omnigres;		# build rpm/deb

pig repo add pgsql -u   # add both repo and update cache

pig install omnigres;		# install via package name, for the active PG version
pig install omni_test;		# install by extension name, for the current active PG version

pig install omni_test -v 18;   # install for PG 18
pig install omni_test -v 17;   # install for PG 17
pig install omni_test -v 16;   # install for PG 16
pig install omni_test -v 15;   # install for PG 15
pig install omni_test -v 14;   # install for PG 14

CREATE EXTENSION omni_test CASCADE; -- requires dblink, omni_cloudevents

CREATE DATABASE myapp_test;
UPDATE pg_database SET datistemplate = true WHERE datname = 'myapp_test';

CREATE FUNCTION my_test() RETURNS omni_test.test
    LANGUAGE plpgsql AS $$
BEGIN
    -- test assertions here
END;
$$;

CREATE PROCEDURE my_test(INOUT omni_test.test)
    LANGUAGE plpgsql AS $$
BEGIN
    -- test logic
END;
$$;

CREATE PROCEDURE tx_test(INOUT test omni_test.test)
    SET omni_test.transaction_isolation = serializable
    LANGUAGE plpgsql AS $$ ... $$;

SELECT * FROM omni_test.run_tests('myapp_test');

-- Exclude tests marked @slow:
SELECT * FROM omni_test.run_tests('myapp_test', filter => '^(?!.*@slow).*');