1
|
|
|
<?php |
2
|
|
|
|
3
|
|
|
namespace evseevnn\Cassandra\Tests; |
4
|
|
|
|
5
|
|
|
use evseevnn\Cassandra; |
6
|
|
|
|
7
|
|
View Code Duplication |
class QueryBlobTest extends Setup\QueryTestCase |
|
|
|
|
8
|
|
|
{ |
9
|
|
|
|
10
|
|
|
public function testBlobColumn() |
11
|
|
|
{ |
12
|
|
|
self::$connection->query('CREATE TABLE BlobTest (foo blob PRIMARY KEY, bar blob)'); |
13
|
|
|
self::$connection->query('INSERT INTO BlobTest (foo, bar) VALUES (:foo, :bar)', ['foo' => '2', 'bar' => '52']); |
14
|
|
|
$result = self::$connection->query('SELECT * FROM BlobTest WHERE foo = :foo', ['foo' => '2']); |
15
|
|
|
$this->assertEquals('52', $result[0]['bar']); |
16
|
|
|
$this->assertEquals('2', $result[0]['foo']); |
17
|
|
|
} |
18
|
|
|
|
19
|
|
|
public function testBlobMap() |
20
|
|
|
{ |
21
|
|
|
self::$connection->query('CREATE TABLE BlobMapTest (foo blob PRIMARY KEY, bar map<blob,blob>)'); |
22
|
|
|
self::$connection->query( |
23
|
|
|
'INSERT INTO BlobMapTest (foo, bar) VALUES (:foo, :bar)', |
24
|
|
|
['foo' => '2', 'bar' => ['52' => '25']] |
25
|
|
|
); |
26
|
|
|
$result = self::$connection->query('SELECT * FROM BlobMapTest WHERE foo = :foo', ['foo' => '2']); |
27
|
|
|
$this->assertEquals(['52' => '25'], $result[0]['bar']); |
28
|
|
|
$this->assertEquals('2', $result[0]['foo']); |
29
|
|
|
} |
30
|
|
|
|
31
|
|
|
public function testBlobSet() |
32
|
|
|
{ |
33
|
|
|
self::$connection->query('CREATE TABLE BlobSetTest (foo blob PRIMARY KEY, bar set<blob>)'); |
34
|
|
|
self::$connection->query( |
35
|
|
|
'INSERT INTO BlobSetTest (foo, bar) VALUES (:foo, :bar)', |
36
|
|
|
['foo' => '2', 'bar' => ['25', '52']] |
37
|
|
|
); |
38
|
|
|
$result = self::$connection->query('SELECT * FROM BlobSetTest WHERE foo = :foo', ['foo' => '2']); |
39
|
|
|
$this->assertEquals([25, 52], $result[0]['bar']); |
40
|
|
|
$this->assertEquals('2', $result[0]['foo']); |
41
|
|
|
//according to Spec, this should always be returned alphabetically. |
42
|
|
|
self::$connection->query( |
43
|
|
|
'INSERT INTO BlobSetTest (foo, bar) VALUES (:foo, :bar)', |
44
|
|
|
['foo' => '22', 'bar' => ['52', '25']] |
45
|
|
|
); |
46
|
|
|
$result = self::$connection->query('SELECT * FROM BlobSetTest WHERE foo = :foo', ['foo' => '22']); |
47
|
|
|
$this->assertEquals([25, 52], $result[0]['bar']); |
48
|
|
|
} |
49
|
|
|
|
50
|
|
|
public function testBlobList() |
51
|
|
|
{ |
52
|
|
|
self::$connection->query('CREATE TABLE BlobListTest (foo blob PRIMARY KEY, bar list<blob>)'); |
53
|
|
|
self::$connection->query( |
54
|
|
|
'INSERT INTO BlobListTest (foo, bar) VALUES (:foo, :bar)', |
55
|
|
|
['foo' => '2', 'bar' => ['52', '25']] |
56
|
|
|
); |
57
|
|
|
$result = self::$connection->query('SELECT * FROM BlobListTest WHERE foo = :foo', ['foo' => '2']); |
58
|
|
|
$this->assertEquals(['52', '25'], $result[0]['bar']); |
59
|
|
|
$this->assertEquals('2', $result[0]['foo']); |
60
|
|
|
//according to Spec, this should be returned in index order |
61
|
|
|
self::$connection->query( |
62
|
|
|
'INSERT INTO BlobListTest (foo, bar) VALUES (:foo, :bar)', |
63
|
|
|
['foo' => '22', 'bar' => ['25', '52']] |
64
|
|
|
); |
65
|
|
|
$result = self::$connection->query('SELECT * FROM BlobListTest WHERE foo = :foo', ['foo' => '22']); |
66
|
|
|
$this->assertEquals(['25', '52'], $result[0]['bar']); |
67
|
|
|
} |
68
|
|
|
|
69
|
|
|
} |
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.