evseevnn\Cassandra\Tests\QueryVarIntTest::testVarIntSet PHP Method

testVarIntSet() public method

public testVarIntSet ( )
    public function testVarIntSet()
    {
        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']);
    }