This repository has been archived by the owner on Mar 14, 2018. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 3
/
test_yafa.php
81 lines (68 loc) · 2.79 KB
/
test_yafa.php
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
<?php
echo "test start ", microtime(), "\n";
$mysql_config = [
"master"=>[
// ["host"=>"192.168.56.1", "port"=>3306, "user"=> "root", "pass"=>"", "db"=>"mysql"]
["host"=>"172.16.0.251", "port"=>3306, "user"=> "wuhao", "pass"=>"mysqlwuhao!", "db"=>"test"]
],
];
$redis_config = [
"master"=>[
["host"=>"172.16.0.251", "port"=>14000, "auth"=> "panda.tv@2015", "prefix"=>"test_"],
],
];
$ssdb_config = [
"master"=>[
["host"=>"172.16.0.251", "port"=>8888, "prefix"=>"test_"],
],
];
// var_dump("testFunction:", testFunction($mysql_config));
// $a = new testClass();
// echo "test -----------------\n";
// var_dump($a->test($mysql_config));
// var_dump($a->prop1, $a->prop2,
// testClass::$save);
// yafa_database_mysql::init($mysql_config);
// $m = yafa_database_mysql::get_master();
// echo "format: ", $m->format("SELECT * FROM `user` LIMIT ?", 2), "\n";
// echo "escape:", $i->escape_string("xx'xx"), "\n";
// $table = "admin_project_info";
// $start = 0; $max_page_list = 10;
// $params = array(
// 'field' => '*',
// 'cond' => array('isdel' => 0, 'fpid' => 0,),
// 'group' => null,
// 'order' => "`pid` DESC",
// 'limit' => array($start, $max_page_list),
// );
// debug_zval_dump($m);
// var_dump( $m->select($table, $params["field"], $params["cond"], $params["group"], $params["order"], $params["limit"]) );
// var_dump( $m->query("select * from `aaauser`") );
// echo "error: [", isset($m->error),"] ", var_dump($m->error);
// echo "done.\n";
// echo $m->update("table", ["a"=>"b", "c"=>["c1"=>"xxx", "c2"=>"yyy"]]), "\n";
// echo $m->update("table", ["a"=>"b", "c"=>"d"], ["a"=>"b", "c[!]"=>"d", "e[<>]"=>[100, 200], "OR"=>["f[><]"=>[300, 400], "g[~]"=>"pre_%"]]), "\n";
// echo $m->insert("table", ["a"=>"b", "c"=>"d", "e"=>"f"]), "\n";
// echo $m->insert("table", [["a"=>"b"], ["a"=>"c"], ["a"=>"c"]]), "\n";
// echo "select1: ", $m->select("table", ["a","b"], ["b"=>"bbbb"], null, "`a`", [10, 50]), "\n";
// echo "select2: ", $m->select("table", "*", ["b[!]"=>"cccc"], ["a"], ["a"=>true, "b"=>"DESC"]), "\n";
// echo "remove: ", $m->remove("table", ["a"=>"aaaa"]), "\n";
// echo "one: ", $m->one("table", ["a"=>"aaaa"]), "\n";
// echo "error: [", isset($m->error),"] ", $m->error, "\n";
// yafa_database_redis::init($redis_config);
// $db = yafa_database_redis::get_master();
// var_dump($db);
// var_dump($db->get("abc"));
// var_dump($db->hgetall("hash"));
// var_dump($db->smembers("set"));
// var_dump( $db->multi()->get("abc")->hgetall("hash")->exec() );
// $c = 0;
// var_dump($db->scan($c));
yafa_database_ssdb::init($ssdb_config);
$db = yafa_database_ssdb::get_master();
var_dump($db);
var_dump($db->exists("abc"));
var_dump($db->get("abc"));
var_dump($db->hgetall("hash"));
var_dump($db->zscan("zset", "", "", "", 10));
exit(0);