summaryrefslogtreecommitdiffstats
path: root/schema/postgresql/t/05-fill-icinga_objects.sql
blob: 1b11eefcb6a85bb2dbb2fd88e30dcac952748727 (plain)
1
2
3
4
5
6
7
8
9
10
-- Objects get a number and a type (1=host, 2=server)
SELECT plan(1);
INSERT INTO icinga_objects VALUES (1,1);
INSERT INTO icinga_objects VALUES (2,2);
INSERT INTO icinga_objects VALUES (3,1);
INSERT INTO icinga_objects VALUES (4,1);
INSERT INTO icinga_objects VALUES (5,1);
INSERT INTO icinga_objects VALUES (6,1);
INSERT INTO icinga_objects VALUES (7,1);
SELECT is(count(*), 7::bigint, 'icinga_objects has correct # of rows') FROM icinga_objects;