public function testQueryProfiler_PrepareBindExecute() { $var = 1234; $stmt = $this->_adapter->prepare("SELECT * FROM foo WHERE bar = ?"); $stmt->bindParam(1, $var); $qp = $this->_adapter->getProfiler()->getLastQueryProfile(); /* @var $qp Zend_Db_Profiler_Query */ $this->assertEquals(array(1 => 1234), $qp->getQueryParams()); $this->assertEquals("SELECT * FROM foo WHERE bar = ?", $qp->getQuery()); }
/** * @group ZF-7936 */ public function testTruncateAppliedToTablesInReverseOrder() { $testAdapter = new Zend_Test_DbAdapter(); $connection = new Zend_Test_PHPUnit_Db_Connection($testAdapter, "schema"); $dataSet = new PHPUnit_Extensions_Database_DataSet_FlatXmlDataSet(dirname(__FILE__) . "/_files/truncateFixture.xml"); $this->operation->execute($connection, $dataSet); $profiler = $testAdapter->getProfiler(); $queries = $profiler->getQueryProfiles(); $this->assertEquals(2, count($queries)); $this->assertContains('bar', $queries[0]->getQuery()); $this->assertContains('foo', $queries[1]->getQuery()); }