Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commita7df540

Browse files
committed
referee ext. tests and contrib Makefile
1 parente444329 commita7df540

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
ifdefUSE_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*FROMreferee.decision;
4+
5+
SELECTreferee.get_winner(1);
6+
SELECTreferee.get_winner(2);
7+
SELECTreferee.get_winner(4);
8+
SELECTreferee.get_winner(1);
9+
SELECT*FROMreferee.decision;
10+
11+
SELECTreferee.clean();
12+
SELECTreferee.get_winner(4);
13+
SELECTreferee.get_winner(2);
14+
SELECTreferee.get_winner(1);
15+
SELECTreferee.get_winner(4);
16+
SELECT*FROMreferee.decision;
17+
18+
SELECTreferee.clean();
19+
SELECTreferee.clean();
20+
SELECT*FROMreferee.decision;

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp