/**
* @param string $sql
* @return Statement
*/
public function createStatement($sqlOrResource = null)
{
$statement = clone $this->statementPrototype;
if (is_string($sqlOrResource)) {
$statement->setSql($sqlOrResource);
} elseif ($sqlOrResource instanceof \PDOStatement) {
$statement->setResource($sqlOrResource);
}
$statement->initialize($this->connection->getResource());
return $statement;
}
/**
* @covers Zend\Db\Adapter\Driver\Sqlsrv\Connection::getLastGeneratedValue
*/
public function testGetLastGeneratedValue()
{
$this->markTestIncomplete('Need to create a temporary sequence.');
$connection = new Connection($this->variables);
$connection->getLastGeneratedValue();
}
/**
* @covers Zend\Db\Adapter\Driver\Sqlsrv\Connection::getConnectionParameters
*/
public function testGetConnectionParameters()
{
$this->connection->setConnectionParameters(array('foo' => 'bar'));
$this->assertEquals(array('foo' => 'bar'), $this->connection->getConnectionParameters());
}
/**
* @param resource $resource
* @return Result
*/
public function createResult($resource)
{
$result = clone $this->resultPrototype;
$result->initialize($resource, $this->connection->getLastGeneratedValue());
return $result;
}
/**
* @group zf3469
*/
public function testConnectReturnsConnectionWhenResourceSet()
{
$resource = sqlsrv_connect($this->variables['hostname'], array('UID' => $this->variables['username'], 'PWD' => $this->variables['password']));
$connection = new Connection(array());
$connection->setResource($resource);
$this->assertSame($connection, $connection->connect());
$connection->disconnect();
unset($connection);
unset($resource);
}
