evseevnn\Cassandra\Tests\QueryDoubleTest

Complexity

Total Complexity

4

Size/Duplication

Total Lines	63
Duplicated Lines	100 %

Coupling/Cohesion

Components	1
Dependencies	2

Importance

Changes

0

4 Methods

Rating	Name	Duplication	Size	Complexity
A	testDoubleRow()	8	8	1
A	testDoubleMap()	11	11	1
A	testDoubleSet()	18	18	1
A	testDoubleList()	18	18	1

<?php

namespace evseevnn\Cassandra\Tests;

use evseevnn\Cassandra;

class QueryDoubleTest extends Setup\QueryTestCase

This class seems to be duplicated in your project.

{

		public function testDoubleRow()
		{
				self::$connection->query('CREATE TABLE DoubleTest (foo double PRIMARY KEY, bar double)');
				self::$connection->query('INSERT INTO DoubleTest (foo, bar) VALUES (:foo, :bar)', ['foo' => 0.2, 'bar' => 5.2]);
				$result = self::$connection->query('SELECT * FROM DoubleTest WHERE foo = :foo', ['foo' => 0.2]);
				$this->assertFloatEquals(5.2, $result[0]['bar']);
				$this->assertFloatEquals(0.2, $result[0]['foo']);
		}

		public function testDoubleMap()
		{
				self::$connection->query('CREATE TABLE DoubleMapTest (foo double PRIMARY KEY, bar map<double,double>)');
				self::$connection->query(
						'INSERT INTO DoubleMapTest (foo, bar) VALUES (:foo, :bar)',
						['foo' => 0.2, 'bar' => [5.2 => 2.5]]
				);
				$result = self::$connection->query('SELECT * FROM DoubleMapTest WHERE foo = :foo', ['foo' => 0.2]);
				$this->assertFloatEquals([5.2 => 2.5], $result[0]['bar']);
				$this->assertFloatEquals(0.2, $result[0]['foo']);
		}

		public function testDoubleSet()
		{
				self::$connection->query('CREATE TABLE DoubleSetTest (foo double PRIMARY KEY, bar set<double>)');
				self::$connection->query(
						'INSERT INTO DoubleSetTest (foo, bar) VALUES (:foo, :bar)',
						['foo' => 0.2, 'bar' => [2.5, 5.2]]
				);
				$result = self::$connection->query('SELECT * FROM DoubleSetTest WHERE foo = :foo', ['foo' => 0.2]);
				$this->assertFloatEquals([2.5, 5.2], $result[0]['bar']);
				$this->assertFloatEquals(0.2, $result[0]['foo']);
				//according to Spec, this should always be returned alphabetically.
				self::$connection->query(
						'INSERT INTO DoubleSetTest (foo, bar) VALUES (:foo, :bar)',
						['foo' => 2.2, 'bar' => [5.2, 2.5]]
				);
				$result = self::$connection->query('SELECT * FROM DoubleSetTest WHERE foo = :foo', ['foo' => 2.2]);
				$this->assertFloatEquals([2.5, 5.2], $result[0]['bar']);
		}

		public function testDoubleList()
		{
				self::$connection->query('CREATE TABLE DoubleListTest (foo double PRIMARY KEY, bar list<double>)');
				self::$connection->query(
						'INSERT INTO DoubleListTest (foo, bar) VALUES (:foo, :bar)',
						['foo' => 0.2, 'bar' => [5.2, 2.5]]
				);
				$result = self::$connection->query('SELECT * FROM DoubleListTest WHERE foo = :foo', ['foo' => 0.2]);
				$this->assertFloatEquals([5.2, 2.5], $result[0]['bar']);
				$this->assertFloatEquals(0.2, $result[0]['foo']);
				//according to Spec, this should be returned in index order
				self::$connection->query(
						'INSERT INTO DoubleListTest (foo, bar) VALUES (:foo, :bar)',
						['foo' => 2.2, 'bar' => [2.5, 5.2]]
				);
				$result = self::$connection->query('SELECT * FROM DoubleListTest WHERE foo = :foo', ['foo' => 2.2]);
				$this->assertFloatEquals([2.5, 5.2], $result[0]['bar']);
		}

}