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
|
# vi:filetype=
use lib 'lib';
use Test::Nginx::Socket;
repeat_each(2);
plan tests => repeat_each() * 2 * blocks();
$ENV{TEST_NGINX_POSTGRESQL_PORT} ||= 5432;
no_long_string();
no_diff();
run_tests();
__DATA__
=== TEST 1: bool blob field (keepalive off)
--- http_config
upstream backend {
postgres_server 127.0.0.1:$TEST_NGINX_POSTGRESQL_PORT
dbname=ngx_test user=ngx_test password=ngx_test;
postgres_keepalive off;
}
--- config
location /test {
echo_location /pgignore "drop table if exists foo";
echo_location /pg "create table foo (id serial, flag bool);";
echo_location /pg "insert into foo (flag) values (true);";
echo_location /pg "insert into foo (flag) values (false);";
echo_location /pg "select * from foo order by id;";
}
location /pg {
postgres_pass backend;
postgres_query $query_string;
rds_csv on;
}
location = /pgignore {
postgres_pass backend;
postgres_query $query_string;
rds_csv on;
error_page 500 = /ignore;
}
location /ignore { echo "ignore"; }
--- request
GET /test
--- response_body eval
qq{errcode,errstr,insert_id,affected_rows\r
0,,0,0\r
errcode,errstr,insert_id,affected_rows\r
0,,0,0\r
errcode,errstr,insert_id,affected_rows\r
0,,0,1\r
errcode,errstr,insert_id,affected_rows\r
0,,0,1\r
id,flag\r
1,t\r
2,f\r
}
--- skip_nginx: 2: < 0.7.46
=== TEST 2: bool blob field (keepalive on)
--- http_config
upstream backend {
postgres_server 127.0.0.1:$TEST_NGINX_POSTGRESQL_PORT
dbname=ngx_test user=ngx_test password=ngx_test;
}
--- config
location /test {
echo_location /pg "drop table if exists foo";
echo_location /pg "create table foo (id serial, flag bool);";
echo_location /pg "insert into foo (flag) values (true);";
echo_location /pg "insert into foo (flag) values (false);";
echo_location /pg "select * from foo order by id;";
}
location /pg {
postgres_pass backend;
postgres_query $query_string;
rds_csv on;
}
location = /pgignore {
postgres_pass backend;
postgres_query $query_string;
rds_csv on;
error_page 500 = /ignore;
}
location /ignore { echo "ignore"; }
--- request
GET /test
--- response_body eval
qq{errcode,errstr,insert_id,affected_rows\r
0,,0,0\r
errcode,errstr,insert_id,affected_rows\r
0,,0,0\r
errcode,errstr,insert_id,affected_rows\r
0,,0,1\r
errcode,errstr,insert_id,affected_rows\r
0,,0,1\r
id,flag\r
1,t\r
2,f\r
}
--- skip_nginx: 2: < 0.7.46
|
