/
025-activecolumnfamily.phpt
81 lines (71 loc) · 1.93 KB
/
025-activecolumnfamily.phpt
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
--TEST--
Test that active columnfamily is tracked correctly
--SKIPIF--
<?php require_once(dirname(__FILE__) . '/skipif.inc'); ?>
--FILE--
<?php
require_once(dirname(__FILE__) . '/config.inc');
$db = new PDO($dsn);
pdo_cassandra_init ($db, $keyspace);
$db->exec ("CREATE TABLE my_cf1 (my_key1 text PRIMARY KEY)");
$db->exec ("CREATE TABLE my_cf2 (my_key2 text PRIMARY KEY)");
$db->exec ("CREATE TABLE my_cf3 (my_key3 text PRIMARY KEY)");
$db->exec ("UPDATE my_cf1 SET first_cf = 'first1' WHERE my_key1 = 'aa1'");
$db->exec ("UPDATE my_cf1 SET first_cf = 'first2' WHERE my_key1 = 'aa2'");
$db->exec ("UPDATE my_cf2 SET second_cf = 'second1' WHERE my_key2 = 'aa1'");
$db->exec ("UPDATE my_cf2 SET second_cf = 'second2' WHERE my_key2 = 'aa2'");
$db->exec ("UPDATE my_cf3 SET third_cf = 'third1' WHERE my_key3 = 'aa1'");
$db->exec ("UPDATE my_cf3 SET third_cf = 'third2' WHERE my_key3 = 'aa2'");
$stmt2 = $db->prepare("SELECT * FROM my_cf2");
$stmt2->execute();
$stmt3 = $db->prepare("SELECT * FROM my_cf3");
$stmt3->execute();
$stmt1 = $db->prepare("SELECT * FROM my_cf1");
$stmt1->execute();
var_dump ($stmt2->fetch (PDO::FETCH_ASSOC));
var_dump ($stmt1->fetch (PDO::FETCH_ASSOC));
var_dump ($stmt3->fetch (PDO::FETCH_ASSOC));
var_dump ($stmt3->fetch (PDO::FETCH_ASSOC));
var_dump ($stmt1->fetch (PDO::FETCH_ASSOC));
$db->exec ("SELECT * FROM my_cf1");
var_dump ($stmt2->fetch (PDO::FETCH_ASSOC));
pdo_cassandra_done ($db, $keyspace);
echo "OK";
--EXPECT--
array(2) {
["my_key2"]=>
string(3) "aa2"
["second_cf"]=>
string(7) "second2"
}
array(2) {
["my_key1"]=>
string(3) "aa2"
["first_cf"]=>
string(6) "first2"
}
array(2) {
["my_key3"]=>
string(3) "aa2"
["third_cf"]=>
string(6) "third2"
}
array(2) {
["my_key3"]=>
string(3) "aa1"
["third_cf"]=>
string(6) "third1"
}
array(2) {
["my_key1"]=>
string(3) "aa1"
["first_cf"]=>
string(6) "first1"
}
array(2) {
["my_key2"]=>
string(3) "aa1"
["second_cf"]=>
string(7) "second1"
}
OK