doctrine / dbal

        $this->assertEquals('foo', $row['test_string']);

    }

    public function testFetchAssocWithTypes()

    {

        $datetimeString = '2010-01-01 10:10:10';

        $datetime = new \DateTime($datetimeString);

        $sql = "SELECT test_int, test_datetime FROM fetch_table WHERE test_int = ? AND test_datetime = ?";

        $row = $this->_conn->fetchAssoc($sql, array(1, $datetime), array(PDO::PARAM_STR, Type::DATETIME));

        $this->assertTrue($row !== false);

        $row = array_change_key_case($row, \CASE_LOWER);

        $this->assertEquals(1, $row['test_int']);

        $this->assertStringStartsWith($datetimeString, $row['test_datetime']);

    }

    /**

     * @expectedException \Doctrine\DBAL\DBALException

        $this->assertEquals('foo', $row[1]);

    }

    public function testFetchArrayWithTypes()

    {

        $datetimeString = '2010-01-01 10:10:10';

        $datetime = new \DateTime($datetimeString);

        $sql = "SELECT test_int, test_datetime FROM fetch_table WHERE test_int = ? AND test_datetime = ?";

        $row = $this->_conn->fetchArray($sql, array(1, $datetime), array(PDO::PARAM_STR, Type::DATETIME));

        $this->assertTrue($row !== false);

        $row = array_change_key_case($row, \CASE_LOWER);

        $this->assertEquals(1, $row[0]);

        $this->assertStringStartsWith($datetimeString, $row[1]);

    }

    /**

     * @expectedException \Doctrine\DBAL\DBALException