| Conditions | 1 |
| Paths | 1 |
| Total Lines | 15 |
| Code Lines | 10 |
| Lines | 0 |
| Ratio | 0 % |
| Changes | 0 | ||
| 1 | <?php |
||
| 9 | public function testRetrievedTimestampRow() |
||
| 10 | { |
||
| 11 | self::$connection->query('CREATE TABLE TimestampTest (p_key text, c_key timestamp, some_data double, |
||
| 12 | PRIMARY KEY (p_key, c_key));'); |
||
| 13 | self::$connection->query( |
||
| 14 | 'INSERT INTO TimestampTest (p_key, c_key, some_data) VALUES (:p_key, :c_key, :some_data)', |
||
| 15 | ['p_key' => '2014', 'c_key' => 1417302000, 'some_data' => 0.12321] |
||
| 16 | ); |
||
| 17 | $result = self::$connection->query( |
||
| 18 | 'SELECT * FROM TimestampTest WHERE p_key = :p_key', |
||
| 19 | ['p_key' => '2014'] |
||
| 20 | ); |
||
| 21 | $this->assertFloatEquals(0.12321, $result[0]['some_data']); |
||
| 22 | $this->assertFloatEquals(1417302000, $result[0]['c_key']); |
||
| 23 | } |
||
| 24 | } |
||
| 25 |