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

testVarIntList() public method

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