public function testDataIsLoadedOnlyOnce()
{
$fixtureSql = "SELECT * FROM foo";
$statementMock = new Zend_Test_DbStatement();
$statementMock->append(array('foo' => 'bar'));
$adapterMock = $this->getMock('Zend_Test_DbAdapter');
$adapterMock->expects($this->once())->method('query')->with($fixtureSql)->will($this->returnValue($statementMock));
$this->decorateConnectionGetConnectionWith($adapterMock);
$queryTable = new Zend_Test_PHPUnit_Db_DataSet_QueryTable("foo", $fixtureSql, $this->connectionMock);
$this->assertEquals(1, $queryTable->getRowCount());
$this->assertEquals(1, $queryTable->getRowCount());
$row = $queryTable->getRow(0);
$this->assertEquals(array('foo' => 'bar'), $row);
}
public function testIsInstalled()
{
$installer = new Installer_Default($this->db);
$this->assertFalse($installer->isInstalled());
$this->dbAdapter->appendStatementToStack(Zend_Test_DbStatement::createSelectStatement(array('omeka_options')));
$this->assertTrue($installer->isInstalled());
$this->profilerHelper->assertDbQuery("SHOW TABLES LIKE 'omeka_options'");
}
public function testAppendStatementToStack()
{
$stmt1 = Zend_Test_DbStatement::createSelectStatement(array());
$this->_adapter->appendStatementToStack($stmt1);
$stmt2 = Zend_Test_DbStatement::createSelectStatement(array());
$this->_adapter->appendStatementToStack($stmt2);
$this->assertSame($stmt2, $this->_adapter->query("foo"));
$this->assertSame($stmt1, $this->_adapter->query("foo"));
}
public function testSetRecordUsingIntegerId()
{
$builder = new DummyRecordBuilder($this->db);
$this->dbAdapter->appendStatementToStack(Zend_Test_DbStatement::createSelectStatement(array(array('id' => self::DUMMY_RECORD_ID, 'description' => 'foobar'))));
$builder->setRecord(self::DUMMY_RECORD_ID);
$record = $builder->getRecord();
$this->assertThat($record, $this->isInstanceOf('DummyRecordBuilderRecord'));
$this->assertTrue($record->exists());
}
public function testTotalItems()
{
$collectionId = 1;
$this->dbAdapter = new Zend_Test_DbAdapter();
$this->dbAdapter->appendLastInsertIdToStack($collectionId);
$this->db = new Omeka_Db($this->dbAdapter);
$this->collection = new Collection($this->db);
$this->profilerHelper = new Omeka_Test_Helper_DbProfiler($this->db->getAdapter()->getProfiler(), $this);
$this->dbAdapter->appendStatementToStack(Zend_Test_DbStatement::createSelectStatement(array(array(3))));
$this->assertEquals(3, $this->collection->totalItems());
}
public function testFetchObject_ClassNotExists_ThrowsException()
{
$this->setExpectedException("Zend_Db_Statement_Exception");
$row = array("foo" => "bar", "bar" => "baz");
$stmt = new Zend_Test_DbStatement();
$stmt->append($row);
$object = $stmt->fetchObject("anInvalidClassName");
}
/**
* Prepare a statement and return a PDOStatement-like object.
*
* @param string|Zend_Db_Select $sql SQL query
* @return Zend_Db_Statment|PDOStatement
*/
public function prepare($sql)
{
$queryId = $this->getProfiler()->queryStart($sql);
if (count($this->_statementStack)) {
$stmt = array_pop($this->_statementStack);
} else {
$stmt = new Zend_Test_DbStatement();
}
if ($this->getProfiler()->getEnabled() == true) {
$qp = $this->getProfiler()->getQueryProfile($queryId);
$stmt->setQueryProfile($qp);
}
return $stmt;
}
/**
* Create a Row Count Statement
*
* @param int $affectedRows
* @return Zend_Test_DbStatement
*/
protected static function _createRowCountStatement($affectedRows)
{
$stmt = new Zend_Test_DbStatement();
$stmt->setRowCount($affectedRows);
return $stmt;
}