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
|
# vi:filetype=
use lib 'lib';
use Test::Nginx::Socket skip_all => 'subrequests not working';
#repeat_each(2);
plan tests => repeat_each() * 3 * blocks();
$ENV{TEST_NGINX_MEMCACHED_PORT} ||= 11211;
$ENV{TEST_NGINX_MYSQL_PORT} ||= 3306;
no_shuffle();
run_tests();
__DATA__
=== TEST 1: flush all
--- config
location /flush {
set $memc_cmd 'flush_all';
memc_pass 127.0.0.1:$TEST_NGINX_MEMCACHED_PORT;
}
--- response_headers
Content-Type: text/plain
--- request
GET /flush
--- response_body eval: "OK\r\n"
=== TEST 2: basic fetch (cache miss)
--- http_config
upstream backend {
drizzle_server 127.0.0.1:$TEST_NGINX_MYSQL_PORT protocol=mysql
dbname=ngx_test user=ngx_test password=ngx_test;
}
--- config
location /main {
echo_location /cats dir=asc;
echo_location /cats dir=desc;
}
location /cats {
internal;
srcache_fetch GET /memc $uri-$arg_dir;
srcache_store PUT /memc $uri-$arg_dir;
default_type text/css;
drizzle_pass backend;
drizzle_query 'select * from cats order by id $arg_dir';
rds_json on;
}
location /memc {
internal;
set $memc_key $query_string;
set $memc_exptime 300;
memc_pass 127.0.0.1:$TEST_NGINX_MEMCACHED_PORT;
}
--- request
GET /main
--- response_headers
Content-Type: text/plain
--- response_body chomp
[{"id":2,"name":null},{"id":3,"name":"bob"}][{"id":3,"name":"bob"},{"id":2,"name":null}]
=== TEST 3: basic fetch (cache hit)
--- http_config
upstream backend {
drizzle_server 127.0.0.1:$TEST_NGINX_MYSQL_PORT protocol=mysql
dbname=ngx_test user=ngx_test password=ngx_test;
}
--- config
location /main {
echo_location /cats dir=asc;
echo_location /cats dir=desc;
}
location /cats {
internal;
srcache_fetch GET /memc $uri-$arg_dir;
srcache_store PUT /memc $uri-$arg_dir;
default_type text/css;
drizzle_pass backend;
drizzle_query 'invalid sql here';
rds_json on;
}
location /memc {
internal;
set $memc_key $query_string;
set $memc_exptime 300;
memc_pass 127.0.0.1:$TEST_NGINX_MEMCACHED_PORT;
}
--- request
GET /main
--- response_headers
Content-Type: text/plain
--- response_body chomp
[{"id":2,"name":null},{"id":3,"name":"bob"}][{"id":3,"name":"bob"},{"id":2,"name":null}]
|
