public function testComplexConditions()
{
$qc = new QC('users');
$qc->and('age < :d', 10)->use('name')->indexBy('id')->orderBy('id DESC')->limit(1, 2)->groupBy('age');
$this->assertEquals('SELECT * FROM `users` WHERE ((age < 10)) GROUP BY `age` ORDER BY id DESC LIMIT 1, 2', $qc->getSQL(), '');
$sql = QC::create('users')->where('age > :d', 12)->update('title = :s and id = :d', 'new title', 1)->getSQL();
$this->assertEquals('UPDATE `users` SET title = \'new title\' and id = 1 WHERE ((age > 12))', $sql, 'multiple update with parameters');
}
public function infoAction()
{
$modelName = $this->_moduleConfig['model'];
$qc = new QC();
if ($id = $this->request->getVar('id')) {
$qc->and(array('id' => $id));
}
/**
* @var Model $object
*/
$object = call_user_func(array($modelName, 'loadOne'), $qc);
$this->loadAbilitiesForCaller($object);
$this->setData($object->getArray(), 'object');
}
