|
2283.4.9
by Stewart Smith
add JSON_SERVER_PORT to test-run.pl and dbqp. Make the basic json_server test actually test something useful, such as interaction between SQL from normal protocol and SQL from http |
1 |
create table t1 (a int primary key auto_increment, b varchar(100)); |
|
2283.4.15
by Stewart Smith
use http_post() function to test json_server |
2 |
select http_post("http://localhost:PORT/0.1/sql", 'select * from t1;');; |
3 |
http_post("http://localhost:PORT/0.1/sql", 'select * from t1;') |
|
|
2283.4.9
by Stewart Smith
add JSON_SERVER_PORT to test-run.pl and dbqp. Make the basic json_server test actually test something useful, such as interaction between SQL from normal protocol and SQL from http |
4 |
{
|
5 |
"query" : "select * from t1;", |
|
6 |
"result_set" : [ |
|
7 |
[ "", "" ] |
|
8 |
],
|
|
9 |
"sqlstate" : "00000" |
|
10 |
}
|
|
|
2283.4.15
by Stewart Smith
use http_post() function to test json_server |
11 |
|
|
2283.4.9
by Stewart Smith
add JSON_SERVER_PORT to test-run.pl and dbqp. Make the basic json_server test actually test something useful, such as interaction between SQL from normal protocol and SQL from http |
12 |
insert into t1 (b) values ("from MySQL protocol"); |
|
2283.4.15
by Stewart Smith
use http_post() function to test json_server |
13 |
select http_post('http://localhost:PORT/0.1/sql', 'select * from t1;');; |
14 |
http_post('http://localhost:PORT/0.1/sql', 'select * from t1;') |
|
|
2283.4.9
by Stewart Smith
add JSON_SERVER_PORT to test-run.pl and dbqp. Make the basic json_server test actually test something useful, such as interaction between SQL from normal protocol and SQL from http |
15 |
{
|
16 |
"query" : "select * from t1;", |
|
17 |
"result_set" : [ |
|
18 |
[ "1", "from MySQL protocol" ], |
|
19 |
[ "", "" ] |
|
20 |
],
|
|
21 |
"sqlstate" : "00000" |
|
22 |
}
|
|
|
2283.4.15
by Stewart Smith
use http_post() function to test json_server |
23 |
|
24 |
select http_post('http://localhost:PORT/0.1/sql', 'insert into t1 (b) values (\'from http\');');; |
|
25 |
http_post('http://localhost:PORT/0.1/sql', 'insert into t1 (b) values (\'from http\');') |
|
|
2283.4.9
by Stewart Smith
add JSON_SERVER_PORT to test-run.pl and dbqp. Make the basic json_server test actually test something useful, such as interaction between SQL from normal protocol and SQL from http |
26 |
{
|
|
2283.4.15
by Stewart Smith
use http_post() function to test json_server |
27 |
"query" : "insert into t1 (b) values ('from http');", |
|
2283.4.9
by Stewart Smith
add JSON_SERVER_PORT to test-run.pl and dbqp. Make the basic json_server test actually test something useful, such as interaction between SQL from normal protocol and SQL from http |
28 |
"sqlstate" : "00000" |
29 |
}
|
|
|
2283.4.15
by Stewart Smith
use http_post() function to test json_server |
30 |
|
|
2283.4.9
by Stewart Smith
add JSON_SERVER_PORT to test-run.pl and dbqp. Make the basic json_server test actually test something useful, such as interaction between SQL from normal protocol and SQL from http |
31 |
SELECT * from t1; |
32 |
a b |
|
33 |
1 from MySQL protocol |
|
|
2283.4.15
by Stewart Smith
use http_post() function to test json_server |
34 |
2 from http |
|
2283.4.9
by Stewart Smith
add JSON_SERVER_PORT to test-run.pl and dbqp. Make the basic json_server test actually test something useful, such as interaction between SQL from normal protocol and SQL from http |
35 |
drop table t1; |