public function testSimpleCountSql()
{
$con = \Propel\Runtime\Propel::getConnection();
$con->useDebug(true);
$exec = QuerycacheTable1Query::create()->count($con);
$expectedSql = $this->getSql("SELECT COUNT(*) FROM querycache_table1");
$renderedSql = \Propel\Runtime\Propel::getConnection()->getLastExecutedQuery();
$this->assertEquals($expectedSql, $renderedSql);
}
public function testCacheGeneratedSql()
{
$q = QuerycacheTable1Query::create()->setQueryKey('test2')->filterByTitle('bar');
$exec = $q->find();
$expectedSql = $this->getSql("SELECT querycache_table1.ID, querycache_table1.TITLE FROM `querycache_table1` WHERE querycache_table1.TITLE=:p1");
$params = array();
$this->assertTrue(QuerycacheTable1Query::create()->cacheContains('test2'), ' cache contains "test2" key');
$this->assertEquals($expectedSql, $q->cacheFetch('test2'));
}
protected function getPager($maxPerPage, $page = 1)
{
$query = QuerycacheTable1Query::create()->setQueryKey('query cache with paginate')->orderByTitle();
$pager = new PropelModelPager($query, $maxPerPage);
$pager->setPage($page);
$pager->init();
return $pager;
}
