/
pg.t
128 lines (112 loc) · 3.25 KB
/
pg.t
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
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
# vi:filetype=
use lib 'lib';
use Test::Nginx::Socket;
repeat_each(2);
plan tests => repeat_each() * (2 * blocks() + 1);
$ENV{TEST_NGINX_POSTGRESQL_HOST} ||= '127.0.0.1';
$ENV{TEST_NGINX_POSTGRESQL_PORT} ||= 5432;
no_long_string();
run_tests();
__DATA__
=== TEST 1: bool blob field (keepalive off)
--- http_config
upstream backend {
postgres_server $TEST_NGINX_POSTGRESQL_HOST:$TEST_NGINX_POSTGRESQL_PORT
dbname=ngx_test user=ngx_test password=ngx_test;
postgres_keepalive off;
}
--- config
location /test {
echo_location /pg "drop table if exists foo";
echo;
echo_location /pg "create table foo (id serial, flag bool);";
echo;
echo_location /pg "insert into foo (flag) values (true);";
echo;
echo_location /pg "insert into foo (flag) values (false);";
echo;
echo_location /pg "select * from foo order by id;";
echo;
}
location /pg {
postgres_pass backend;
postgres_query $query_string;
rds_json on;
}
location = /pgignore {
postgres_pass backend;
postgres_query $query_string;
rds_json on;
error_page 500 = /ignore;
}
location /ignore { echo "ignore"; }
--- request
GET /test
--- response_body
{"errcode":0}
{"errcode":0}
{"errcode":0,"affected_rows":1}
{"errcode":0,"affected_rows":1}
[{"id":1,"flag":true},{"id":2,"flag":false}]
--- skip_nginx: 2: < 0.7.46
=== TEST 2: bool blob field (keepalive on)
--- http_config
upstream backend {
postgres_server $TEST_NGINX_POSTGRESQL_HOST:$TEST_NGINX_POSTGRESQL_PORT
dbname=ngx_test user=ngx_test password=ngx_test;
}
--- config
location /test {
echo_location /pgignore "drop table if exists foo";
echo;
echo_location /pg "create table foo (id serial, flag bool);";
echo;
echo_location /pg "insert into foo (flag) values (true);";
echo;
echo_location /pg "insert into foo (flag) values (false);";
echo;
echo_location /pg "select * from foo order by id;";
echo;
}
location /pg {
postgres_pass backend;
postgres_query $query_string;
rds_json on;
}
location = /pgignore {
postgres_pass backend;
postgres_query $query_string;
rds_json on;
error_page 500 = /ignore;
}
location /ignore { echo "ignore"; }
--- request
GET /test
--- response_body
{"errcode":0}
{"errcode":0}
{"errcode":0,"affected_rows":1}
{"errcode":0,"affected_rows":1}
[{"id":1,"flag":true},{"id":2,"flag":false}]
--- skip_nginx: 2: < 0.7.46
=== TEST 3: sanity (github issue #2)
--- http_config
upstream backend {
postgres_server $TEST_NGINX_POSTGRESQL_HOST:$TEST_NGINX_POSTGRESQL_PORT
dbname=ngx_test user=ngx_test password=ngx_test;
}
--- config
location /pg {
rds_json on;
rds_json_root url;
postgres_pass backend;
postgres_query GET "select * from cats order by id";
postgres_output rds;
}
--- request
GET /pg
--- response_headers
Content-Type: application/json
--- response_body chop
{"url":[{"id":2,"name":null},{"id":3,"name":"bob"}]}
--- skip_nginx: 2: < 0.7.46