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;
 }