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