blob: f66afbde3a438e535d3c82c839bda7089b06f294 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
|
-- Rows are: state_time, object_id, state, state_type
SELECT plan(1);
COPY icinga_statehistory FROM STDIN;
2019-02-01 00:00:00+01 1 0 1
2019-02-05 11:00:00+01 1 3 0
2019-02-05 12:00:00+01 1 3 1
2019-02-05 13:00:00+01 1 0 0
2019-02-05 14:00:00+01 1 0 1
2019-03-01 00:00:00+01 1 0 1
2019-03-05 11:00:00+01 1 3 0
2019-03-05 12:00:00+01 1 3 1
2019-02-01 00:00:00+01 2 0 1
2019-02-05 11:00:00+01 2 3 0
2019-02-05 12:00:00+01 2 3 1
2019-02-05 13:00:00+01 2 0 0
2019-02-05 14:00:00+01 2 0 1
2019-03-01 00:00:00+01 2 0 1
2019-03-05 11:00:00+01 2 3 0
2019-03-05 12:00:00+01 2 3 1
2019-03-10 16:05:00+01 3 1 0
2019-03-10 16:10:00+01 3 1 1
2020-03-01 14:00:00+01 4 0 1
2020-04-01 00:00:00+01 5 1 1
2019-03-31 21:50:48+01 6 1 1
2019-03-27 15:15:42+01 6 0 1
2019-03-27 01:00:00+01 7 0 1
\.
SELECT is(count(*), 23::bigint, 'icinga_statehistory has correct # of rows rows') FROM icinga_statehistory;
|
