Skip to content
This repository

HTTPS clone URL

Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP
branch: master
Fetching contributors…

Octocat-spinner-32-eaf2f5

Cannot retrieve contributors at this time

file 109 lines (95 sloc) 2.658 kb
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

Something went wrong with that request. Please try again.