lithium\tests\integration\data\source\database\adapter\PostgreSqlTest::testRawSqlQuerying PHP Метод

    public function testRawSqlQuerying()
    {
        $this->assertTrue($this->_db->create('INSERT INTO galleries (name, active) VALUES (?, ?)', array('Test', "t")));
        $result = $this->_db->read('SELECT * FROM galleries AS Company WHERE name = {:name}', array('name' => 'Test', 'return' => 'array'));
        $this->assertCount(1, $result);
        $expected = array('id', 'name', 'active', 'created', 'modified');
        $this->assertEqual($expected, array_keys($result[0]));
        $this->assertInternalType('numeric', $result[0]['id']);
        unset($result[0]['id']);
        $expected = array('name' => 'Test', 'active' => true, 'created' => null, 'modified' => null);
        $this->assertIdentical($expected, $result[0]);
        $this->assertTrue($this->_db->delete('DELETE FROM galleries WHERE name = {:name}', array('name' => 'Test')));
        $result = $this->_db->read('SELECT * FROM galleries AS Company WHERE name = {:name}', array('name' => 'Test', 'return' => 'array'));
        $this->assertEmpty($result);
    }