doctrine / dbal

        self::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));

        self::assertTrue($row !== false);

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

        self::assertEquals(1, $row['test_int']);

        self::assertStringStartsWith($datetimeString, $row['test_datetime']);

    }

    /**

     * @expectedException \Doctrine\DBAL\DBALException

        self::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));

        self::assertTrue($row !== false);

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

        self::assertEquals(1, $row[0]);

        self::assertStringStartsWith($datetimeString, $row[1]);

    }

    /**

     * @expectedException \Doctrine\DBAL\DBALException