doctrine / dbal

     * @group DBAL-209

     * @expectedException \Doctrine\DBAL\DBALException

     */

    public function testFetchAllWithMissingTypes()

    {

        if ($this->_conn->getDriver() instanceof \Doctrine\DBAL\Driver\Mysqli\Driver ||

            $this->_conn->getDriver() instanceof \Doctrine\DBAL\Driver\SQLSrv\Driver) {

            $this->markTestSkipped('mysqli and sqlsrv actually supports this');

        }

        $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 = ?";

        $data = $this->_conn->fetchAll($sql, array(1, $datetime));

    }

    public function testFetchBoth()

    {

    /**

     * @expectedException \Doctrine\DBAL\DBALException

     */

    public function testFetchAssocWithMissingTypes()

    {

        if ($this->_conn->getDriver() instanceof \Doctrine\DBAL\Driver\Mysqli\Driver ||

            $this->_conn->getDriver() instanceof \Doctrine\DBAL\Driver\SQLSrv\Driver) {

            $this->markTestSkipped('mysqli and sqlsrv actually supports this');

        }

        $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));

    }

    public function testFetchArray()

    {

    /**

     * @expectedException \Doctrine\DBAL\DBALException

     */

    public function testFetchArrayWithMissingTypes()

    {

        if ($this->_conn->getDriver() instanceof \Doctrine\DBAL\Driver\Mysqli\Driver ||

            $this->_conn->getDriver() instanceof \Doctrine\DBAL\Driver\SQLSrv\Driver) {

            $this->markTestSkipped('mysqli and sqlsrv actually supports this');

        }

        $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));

    }

    public function testFetchColumn()

    {

    /**

     * @expectedException \Doctrine\DBAL\DBALException

     */

    public function testFetchColumnWithMissingTypes()

    {

        if ($this->_conn->getDriver() instanceof \Doctrine\DBAL\Driver\Mysqli\Driver ||

            $this->_conn->getDriver() instanceof \Doctrine\DBAL\Driver\SQLSrv\Driver) {

            $this->markTestSkipped('mysqli and sqlsrv actually supports this');

        }

        $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 = ?";

        $column = $this->_conn->fetchColumn($sql, array(1, $datetime), 1);

    }

    /**

     * @group DDC-697