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 Db\Connection($testAdapter, "schema");
$dataSet = new \PHPUnit_Extensions_Database_DataSet_FlatXmlDataSet(__DIR__ . "/_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());
}
