evseevnn\Cassandra\Tests\QueryCounterTest::testCounterIncreaseDecrease()

Complexity

Conditions	1
Paths	1

Size

Total Lines	23
Code Lines	14

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

<?php
	public function testCounterIncreaseDecrease()
	{
		self::$connection->query('CREATE TABLE CounterTest (row_key text, test_counter counter, PRIMARY KEY (row_key));');

		self::$connection->query(
			'UPDATE CounterTest SET "test_counter" = "test_counter" + :increase_value where "row_key" = :row_key',
			['increase_value' => 1000, 'row_key' => 'KEY']
		);
		$result = self::$connection->query(
			'SELECT * FROM CounterTest WHERE row_key = :row_key', ['row_key' => 'KEY']
		);
		$this->assertFloatEquals(1000, $result[0]['test_counter']);

		self::$connection->query(
			'UPDATE CounterTest SET "test_counter" = "test_counter" + :increase_value where "row_key" = :row_key',
			['increase_value' => -2000, 'row_key' => 'KEY']
		);

		$result = self::$connection->query(
			'SELECT * FROM CounterTest WHERE row_key = :row_key', ['row_key' => 'KEY']
		);
		$this->assertFloatEquals(-1000, $result[0]['test_counter']);
	}
}