Skip to content

Commit a7df540

Browse files
kelvichkelvich
committed
referee ext. tests and contrib Makefile
1 parent e444329 commit a7df540

File tree

4 files changed

+111
-0
lines changed

4 files changed

+111
-0
lines changed

‎contrib/Makefile

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -47,6 +47,7 @@ SUBDIRS = \
4747
pg_visibility \
4848
pg_wait_sampling \
4949
postgres_fdw \
50+
referee \
5051
rum \
5152
seg \
5253
spi \

‎contrib/referee/Makefile

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,6 @@
11
EXTENSION = referee
22
DATA = referee--1.0.sql
3+
REGRESS = referee
34

45
ifdef USE_PGXS
56
PG_CONFIG = pg_config

‎contrib/referee/expected/referee.out

Lines changed: 89 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,89 @@
1+
CREATE EXTENSION referee;
2+
SELECT * FROM referee.decision;
3+
key | node_id
4+
-----+---------
5+
(0 rows)
6+
7+
SELECT referee.get_winner(1);
8+
get_winner
9+
------------
10+
1
11+
(1 row)
12+
13+
SELECT referee.get_winner(2);
14+
get_winner
15+
------------
16+
1
17+
(1 row)
18+
19+
SELECT referee.get_winner(4);
20+
get_winner
21+
------------
22+
1
23+
(1 row)
24+
25+
SELECT referee.get_winner(1);
26+
get_winner
27+
------------
28+
1
29+
(1 row)
30+
31+
SELECT * FROM referee.decision;
32+
key | node_id
33+
--------+---------
34+
winner | 1
35+
(1 row)
36+
37+
SELECT referee.clean();
38+
clean
39+
-------
40+
t
41+
(1 row)
42+
43+
SELECT referee.get_winner(4);
44+
get_winner
45+
------------
46+
4
47+
(1 row)
48+
49+
SELECT referee.get_winner(2);
50+
get_winner
51+
------------
52+
4
53+
(1 row)
54+
55+
SELECT referee.get_winner(1);
56+
get_winner
57+
------------
58+
4
59+
(1 row)
60+
61+
SELECT referee.get_winner(4);
62+
get_winner
63+
------------
64+
4
65+
(1 row)
66+
67+
SELECT * FROM referee.decision;
68+
key | node_id
69+
--------+---------
70+
winner | 4
71+
(1 row)
72+
73+
SELECT referee.clean();
74+
clean
75+
-------
76+
t
77+
(1 row)
78+
79+
SELECT referee.clean();
80+
clean
81+
-------
82+
t
83+
(1 row)
84+
85+
SELECT * FROM referee.decision;
86+
key | node_id
87+
-----+---------
88+
(0 rows)
89+

‎contrib/referee/sql/referee.sql

Lines changed: 20 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,20 @@
1+
CREATE EXTENSION referee;
2+
3+
SELECT * FROM referee.decision;
4+
5+
SELECT referee.get_winner(1);
6+
SELECT referee.get_winner(2);
7+
SELECT referee.get_winner(4);
8+
SELECT referee.get_winner(1);
9+
SELECT * FROM referee.decision;
10+
11+
SELECT referee.clean();
12+
SELECT referee.get_winner(4);
13+
SELECT referee.get_winner(2);
14+
SELECT referee.get_winner(1);
15+
SELECT referee.get_winner(4);
16+
SELECT * FROM referee.decision;
17+
18+
SELECT referee.clean();
19+
SELECT referee.clean();
20+
SELECT * FROM referee.decision;

0 commit comments

Comments
 (0)