drizzle-nginx-module/t/000_init.t at master · openresty/drizzle-nginx-module · GitHub

Name: drizzle-nginx-module/t/000_init.t at master · openresty/drizzle-nginx-module · GitHub
Rating: 4.4 (2698 reviews)
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
# vi:filetype=

use lib 'lib';
use Test::Nginx::Socket;

repeat_each(1);

plan tests => repeat_each() * blocks();

$ENV{TEST_NGINX_MYSQL_PORT} ||= 3306;
$ENV{TEST_NGINX_MYSQL_HOST} ||= '127.0.0.1';

our $http_config = <<'_EOC_';
 upstream database {
 drizzle_server $TEST_NGINX_MYSQL_HOST:$TEST_NGINX_MYSQL_PORT protocol=mysql
 dbname=ngx_test user=ngx_test password=ngx_test;
 }
_EOC_

worker_connections(128);
no_shuffle();
#log_level 'warn';
no_diff();

run_tests();

__DATA__

=== TEST 1: cats - drop table
--- http_config eval: $::http_config
--- config
 location = /init {
 drizzle_pass database;
 drizzle_query "DROP TABLE IF EXISTS cats";
 }
--- request
GET /init
--- error_code: 200
--- timeout: 10


=== TEST 2: cats - create table
--- http_config eval: $::http_config
--- config
 location = /init {
 drizzle_pass database;
 drizzle_query "CREATE TABLE cats (id integer, name text)";
 }
--- request
GET /init
--- error_code: 200
--- timeout: 10


=== TEST 3: cats - insert value
--- http_config eval: $::http_config
--- config
 location = /init {
 drizzle_pass database;
 drizzle_query "INSERT INTO cats (id) VALUES (2)";
 }
--- request
GET /init
--- error_code: 200
--- timeout: 10


=== TEST 4: cats - insert value
--- http_config eval: $::http_config
--- config
 location = /init {
 drizzle_pass database;
 drizzle_query "INSERT INTO cats (id, name) VALUES (3, 'bob')";
 }
--- request
GET /init
--- error_code: 200
--- timeout: 10