Code Duplication    Length = 18-18 lines in 2 locations

tests/Cases/BooleanTest.php 2 locations

@@ 34-51 (lines=18) @@
31
				$this->assertEquals(true, $result[0]['foo']);
32
		}
33
34
		public function testBooleanSet()
35
		{
36
				self::$connection->query('CREATE TABLE BooleanSetTest (foo boolean PRIMARY KEY, bar set<boolean>)');
37
				self::$connection->query(
38
						'INSERT INTO BooleanSetTest (foo, bar) VALUES (:foo, :bar)',
39
						['foo' => true, 'bar' => [true, false]]
40
				);
41
				$result = self::$connection->query('SELECT * FROM BooleanSetTest WHERE foo = :foo', ['foo' => true]);
42
				$this->assertEquals([false, true], $result[0]['bar']);
43
				$this->assertEquals(true, $result[0]['foo']);
44
				//according to Spec, this should always be returned alphabetically.
45
				self::$connection->query(
46
						'INSERT INTO BooleanSetTest (foo, bar) VALUES (:foo, :bar)',
47
						['foo' => true, 'bar' => [false, true]]
48
				);
49
				$result = self::$connection->query('SELECT * FROM BooleanSetTest WHERE foo = :foo', ['foo' => true]);
50
				$this->assertEquals([false, true], $result[0]['bar']);
51
		}
52
53
		public function testBooleanList()
54
		{
@@ 53-70 (lines=18) @@
50
				$this->assertEquals([false, true], $result[0]['bar']);
51
		}
52
53
		public function testBooleanList()
54
		{
55
				self::$connection->query('CREATE TABLE BooleanListTest (foo boolean PRIMARY KEY, bar list<boolean>)');
56
				self::$connection->query(
57
						'INSERT INTO BooleanListTest (foo, bar) VALUES (:foo, :bar)',
58
						['foo' => true, 'bar' => [false, true]]
59
				);
60
				$result = self::$connection->query('SELECT * FROM BooleanListTest WHERE foo = :foo', ['foo' => true]);
61
				$this->assertEquals([false, true], $result[0]['bar']);
62
				$this->assertEquals(true, $result[0]['foo']);
63
				//according to Spec, this should be returned in index order - seems for booleans it just doesn't care
64
				self::$connection->query(
65
						'INSERT INTO BooleanListTest (foo, bar) VALUES (:foo, :bar)',
66
						['foo' => false, 'bar' => [true, false]]
67
				);
68
				$result = self::$connection->query('SELECT * FROM BooleanListTest WHERE foo = :foo', ['foo' => false]);
69
				$this->assertEquals([false, true], $result[0]['bar']);
70
		}
71
72
}