1
# vim:set ft=perl ts=4 sw=4 et fdm=marker:
4
use Test::Nginx::Socket;
8
plan tests => repeat_each() * (blocks() + 1 * 1);
10
$ENV{TEST_NGINX_MEMCACHED_PORT} ||= 11211;
11
$ENV{TEST_NGINX_MYSQL_PORT} ||= 3306;
13
our $http_config = <<'_EOC_';
15
drizzle_server 127.0.0.1:$TEST_NGINX_MYSQL_PORT protocol=mysql
16
dbname=ngx_test user=ngx_test password=ngx_test;
25
=== TEST 1: conv_uid - drop table
26
--- http_config eval: $::http_config
29
drizzle_pass database;
30
drizzle_query "DROP TABLE IF EXISTS conv_uid";
39
=== TEST 2: conv_uid - create table
40
--- http_config eval: $::http_config
43
drizzle_pass database;
44
drizzle_query "CREATE TABLE conv_uid(id serial primary key, new_uid integer, old_uid integer)";
53
=== TEST 3: conv_uid - insert value
54
--- http_config eval: $::http_config
57
drizzle_pass database;
58
drizzle_query "INSERT INTO conv_uid(old_uid,new_uid) VALUES(32,56),(35,78)";
67
=== TEST 4: flush data from memcached
70
set $memc_cmd flush_all;
71
memc_pass 127.0.0.1:$TEST_NGINX_MEMCACHED_PORT;
76
--- response_body eval