public function testCreateStatement()
{
$driver = new Sqlsrv(array());
$resource = sqlsrv_connect($this->variables['hostname'], array('UID' => $this->variables['username'], 'PWD' => $this->variables['password']));
$driver->getConnection()->setResource($resource);
$stmt = $driver->createStatement('SELECT 1');
$this->assertInstanceOf('Zend\\Db\\Adapter\\Driver\\Sqlsrv\\Statement', $stmt);
$stmt = $driver->createStatement($resource);
$this->assertInstanceOf('Zend\\Db\\Adapter\\Driver\\Sqlsrv\\Statement', $stmt);
$this->setExpectedException('Zend\\Db\\Adapter\\Exception\\InvalidArgumentException', 'only accepts an SQL string or a Sqlsrv resource');
$driver->createStatement(new \stdClass());
}
/**
* Prepare
*
* @param string $sql
* @return string
*/
public function prepare($sql)
{
if (!$this->isConnected()) {
$this->connect();
}
$statement = $this->driver->createStatement($sql);
return $statement;
}
/**
* @covers Zend\Db\Adapter\Driver\Sqlsrv\Statement::execute
*/
public function testExecute()
{
$sqlsrv = new Sqlsrv($this->variables);
$statement = $sqlsrv->createStatement("SELECT 'foo'");
$this->assertSame($statement, $statement->prepare());
$result = $statement->execute();
$this->assertInstanceOf('Zend\\Db\\Adapter\\Driver\\Sqlsrv\\Result', $result);
unset($resource, $sqlsrvResource);
}
