Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with
or
.
Download ZIP
Branch: master
Fetching contributors…

Cannot retrieve contributors at this time

109 lines (95 sloc) 2.658 kB
# 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
Jump to Line
Something went wrong with that request. Please try again.