]> git.evergreen-ils.org Git - working/Evergreen.git/blob - Open-ILS/src/sql/Pg/t/lp980296-void-lost-lo-claims-returned.pg
Lp 1730726: Basic Patch to build the database with PostgreSQL 10.
[working/Evergreen.git] / Open-ILS / src / sql / Pg / t / lp980296-void-lost-lo-claims-returned.pg
1 \set ECHO
2 \set QUIET 1
3 -- Turn off echo and keep things quiet.
4
5 -- Format the output for nice TAP.
6 \pset format unaligned
7 \pset tuples_only true
8 \pset pager
9
10 -- Revert all changes on failure.
11 \set ON_ERROR_ROLLBACK 1
12 \set ON_ERROR_STOP true
13 \set QUIET 1
14
15 -- Load the TAP functions.
16 BEGIN;
17
18 -- Plan the tests.
19 SELECT plan(4);
20
21 -- Run the tests.
22
23 SELECT isnt_empty(
24     'SELECT * FROM config.org_unit_setting_type WHERE name = $$circ.void_lost_on_claimsreturned$$',
25     'circ.void_lost_on_claimsreturned exists'
26 );
27
28 SELECT isnt_empty(
29     'SELECT * FROM config.org_unit_setting_type WHERE name = $$circ.void_lost_proc_fee_on_claimsreturned$$',
30     'circ.void_lost_proc_fee_on_claimsreturned exists'
31 );
32
33 SELECT isnt_empty(
34     'SELECT * FROM config.org_unit_setting_type WHERE name = $$circ.void_longoverdue_on_claimsreturned$$',
35     'circ.void_longoverdue_on_claimsreturned exists'
36 );
37
38 SELECT isnt_empty(
39     'SELECT * FROM config.org_unit_setting_type WHERE name = $$circ.void_longoverdue_proc_fee_on_claimsreturned$$',
40     'circ.void_longoverdue_proc_fee_on_claimsreturned exists'
41 );
42
43 -- Finish the tests and clean up.
44 SELECT * FROM finish();
45 ROLLBACK;