evseevnn\Cassandra\Tests\QueryVarIntTest

Complexity

Total Complexity

4

Size/Duplication

Total Lines	75
Duplicated Lines	48 %

Coupling/Cohesion

Components	1
Dependencies	2

Importance

Changes

0

4 Methods

Rating	Name	Duplication	Size	Complexity
A	testVarIntColumn()	0	12	1
A	testVarIntMap()	0	19	1
A	testVarIntSet()	18	18	1
A	testVarIntList()	18	18	1

<?php

namespace evseevnn\Cassandra\Tests;

use evseevnn\Cassandra;

class QueryVarIntTest extends Setup\QueryTestCase
{

		public function testVarIntColumn()
		{
				self::$connection->query('CREATE TABLE VarIntTest (foo varint PRIMARY KEY, bar varint, realybigint varint)');
				self::$connection->query(
						'INSERT INTO VarIntTest (foo, bar, realybigint) VALUES (:foo, :bar, :realybigint)',
						['foo' => '2', 'bar' => '52', 'realybigint' => '14156250080000000000003002']
				);
				$result = self::$connection->query('SELECT * FROM VarIntTest WHERE foo = :foo', ['foo' => '2']);
				$this->assertEquals('52', $result[0]['bar']);
				$this->assertEquals('2', $result[0]['foo']);
				$this->assertEquals('14156250080000000000003002', $result[0]['realybigint']);
		}

		public function testVarIntMap()
		{
				self::$connection->query('CREATE TABLE VarIntMapTest (foo varint PRIMARY KEY, bar map<varint,varint>)');
				self::$connection->query(
						'INSERT INTO VarIntMapTest (foo, bar) VALUES (:foo, :bar)',
						['foo' => '2', 'bar' => ['52' => '25']]
				);
				$result = self::$connection->query('SELECT * FROM VarIntMapTest WHERE foo = :foo', ['foo' => '2']);
				$this->assertEquals(['52' => '25'], $result[0]['bar']);
				$this->assertEquals('2', $result[0]['foo']);

				self::$connection->query(
						'INSERT INTO VarIntMapTest (foo, bar) VALUES (:foo, :bar)',
						['foo' => '22', 'bar' => ['522' => '14156250080000000000003002']]
				);
				$result = self::$connection->query('SELECT * FROM VarIntMapTest WHERE foo = :foo', ['foo' => '22']);
				$this->assertEquals(['522' => '14156250080000000000003002'], $result[0]['bar']);
				$this->assertEquals('22', $result[0]['foo']);
		}

		public function testVarIntSet()

This method seems to be duplicated in your project.

		{
				self::$connection->query('CREATE TABLE VarIntSetTest (foo varint PRIMARY KEY, bar set<varint>)');
				self::$connection->query(
						'INSERT INTO VarIntSetTest (foo, bar) VALUES (:foo, :bar)',
						['foo' => '2', 'bar' => ['25', '14156250080000000000003002', '52']]
				);
				$result = self::$connection->query('SELECT * FROM VarIntSetTest WHERE foo = :foo', ['foo' => '2']);
				$this->assertEquals(['25', '52', '14156250080000000000003002'], $result[0]['bar']);
				$this->assertEquals('2', $result[0]['foo']);
				//according to Spec, this should always be returned alphabetically.
				self::$connection->query(
						'INSERT INTO VarIntSetTest (foo, bar) VALUES (:foo, :bar)',
						['foo' => '22', 'bar' => ['52', '14156250080000000000003002', '25']]
				);
				$result = self::$connection->query('SELECT * FROM VarIntSetTest WHERE foo = :foo', ['foo' => '22']);
				$this->assertEquals(['25', '52', '14156250080000000000003002'], $result[0]['bar']);
		}

		public function testVarIntList()

This method seems to be duplicated in your project.

		{
				self::$connection->query('CREATE TABLE VarIntListTest (foo varint PRIMARY KEY, bar list<varint>)');
				self::$connection->query(
						'INSERT INTO VarIntListTest (foo, bar) VALUES (:foo, :bar)',
						['foo' => '2', 'bar' => ['52', '25', '14156250080000000000003002']]
				);
				$result = self::$connection->query('SELECT * FROM VarIntListTest WHERE foo = :foo', ['foo' => '2']);
				$this->assertEquals(['52', '25', '14156250080000000000003002'], $result[0]['bar']);
				$this->assertEquals('2', $result[0]['foo']);
				//according to Spec, this should be returned in index order
				self::$connection->query(
						'INSERT INTO VarIntListTest (foo, bar) VALUES (:foo, :bar)',
						['foo' => '22', 'bar' => ['25', '52', '14156250080000000000003002']]
				);
				$result = self::$connection->query('SELECT * FROM VarIntListTest WHERE foo = :foo', ['foo' => '22']);
				$this->assertEquals(['25', '52', '14156250080000000000003002'], $result[0]['bar']);
		}

}