1
|
|
|
<?php |
2
|
|
|
|
3
|
|
|
namespace evseevnn\Cassandra\Tests; |
4
|
|
|
|
5
|
|
|
use evseevnn\Cassandra; |
6
|
|
|
|
7
|
|
View Code Duplication |
class QueryAsciiTest extends Setup\QueryTestCase |
|
|
|
|
8
|
|
|
{ |
9
|
|
|
|
10
|
|
|
public function testAsciiColumn() |
11
|
|
|
{ |
12
|
|
|
self::$connection->query('CREATE TABLE AsciiTest (foo ascii PRIMARY KEY, bar ascii)'); |
13
|
|
|
self::$connection->query( |
14
|
|
|
'INSERT INTO AsciiTest (foo, bar) VALUES (:foo, :bar)', |
15
|
|
|
['foo' => 'baz', 'bar' => 'barbaz'] |
16
|
|
|
); |
17
|
|
|
$result = self::$connection->query('SELECT * FROM AsciiTest WHERE foo = :foo', ['foo' => 'baz']); |
18
|
|
|
$this->assertEquals('barbaz', $result[0]['bar']); |
19
|
|
|
$this->assertEquals('baz', $result[0]['foo']); |
20
|
|
|
} |
21
|
|
|
|
22
|
|
|
public function testAsciiMap() |
23
|
|
|
{ |
24
|
|
|
self::$connection->query('CREATE TABLE AsciiMapTest (foo ascii PRIMARY KEY, bar map<ascii,ascii>)'); |
25
|
|
|
self::$connection->query( |
26
|
|
|
'INSERT INTO AsciiMapTest (foo, bar) VALUES (:foo, :bar)', |
27
|
|
|
['foo' => 'baz', 'bar' => ['barbaz' => 'bazbar']] |
28
|
|
|
); |
29
|
|
|
$result = self::$connection->query('SELECT * FROM AsciiMapTest WHERE foo = :foo', ['foo' => 'baz']); |
30
|
|
|
$this->assertEquals(['barbaz' => 'bazbar'], $result[0]['bar']); |
31
|
|
|
$this->assertEquals('baz', $result[0]['foo']); |
32
|
|
|
} |
33
|
|
|
|
34
|
|
|
public function testAsciiSet() |
35
|
|
|
{ |
36
|
|
|
self::$connection->query('CREATE TABLE AsciiSetTest (foo ascii PRIMARY KEY, bar set<ascii>)'); |
37
|
|
|
self::$connection->query( |
38
|
|
|
'INSERT INTO AsciiSetTest (foo, bar) VALUES (:foo, :bar)', |
39
|
|
|
['foo' => 'baz', 'bar' => ['barbaz', 'bazbar']] |
40
|
|
|
); |
41
|
|
|
$result = self::$connection->query('SELECT * FROM AsciiSetTest WHERE foo = :foo', ['foo' => 'baz']); |
42
|
|
|
$this->assertEquals(['barbaz', 'bazbar'], $result[0]['bar']); |
43
|
|
|
$this->assertEquals('baz', $result[0]['foo']); |
44
|
|
|
//according to Spec, this should always be returned alphabetically. |
45
|
|
|
self::$connection->query( |
46
|
|
|
'INSERT INTO AsciiSetTest (foo, bar) VALUES (:foo, :bar)', |
47
|
|
|
['foo' => 'baz2', 'bar' => ['bazbar', 'barbaz']] |
48
|
|
|
); |
49
|
|
|
$result = self::$connection->query('SELECT * FROM AsciiSetTest WHERE foo = :foo', ['foo' => 'baz2']); |
50
|
|
|
$this->assertEquals(['barbaz', 'bazbar'], $result[0]['bar']); |
51
|
|
|
} |
52
|
|
|
|
53
|
|
|
public function testAsciiList() |
54
|
|
|
{ |
55
|
|
|
self::$connection->query('CREATE TABLE AsciiListTest (foo ascii PRIMARY KEY, bar list<ascii>)'); |
56
|
|
|
self::$connection->query( |
57
|
|
|
'INSERT INTO AsciiListTest (foo, bar) VALUES (:foo, :bar)', |
58
|
|
|
['foo' => 'baz', 'bar' => ['barbaz', 'bazbar']] |
59
|
|
|
); |
60
|
|
|
$result = self::$connection->query('SELECT * FROM AsciiListTest WHERE foo = :foo', ['foo' => 'baz']); |
61
|
|
|
$this->assertEquals(['barbaz', 'bazbar'], $result[0]['bar']); |
62
|
|
|
$this->assertEquals('baz', $result[0]['foo']); |
63
|
|
|
//according to Spec, this should be returned in index order |
64
|
|
|
self::$connection->query( |
65
|
|
|
'INSERT INTO AsciiListTest (foo, bar) VALUES (:foo, :bar)', |
66
|
|
|
['foo' => 'baz2', 'bar' => ['bazbar', 'barbaz']] |
67
|
|
|
); |
68
|
|
|
$result = self::$connection->query('SELECT * FROM AsciiListTest WHERE foo = :foo', ['foo' => 'baz2']); |
69
|
|
|
$this->assertEquals(['bazbar', 'barbaz'], $result[0]['bar']); |
70
|
|
|
} |
71
|
|
|
|
72
|
|
|
} |
Duplicated code is one of the most pungent code smells. If you need to duplicate the same code in three or more different places, we strongly encourage you to look into extracting the code into a single class or operation.
You can also find more detailed suggestions in the “Code” section of your repository.