Exemplos de sfDoctrineFinder::filterBy em PHP

Exemplo n.º 1

Arquivo: sfDoctrineFinderFilterTest.php Projeto: jonphipps/Metadata-Registry

$t->is($finder->getLatestQuery(), 'SELECT d.id AS d__id, d.title AS d__title, d.category_id AS d__category_id FROM d_article d WHERE d.category_id = \'1\'', 'filterBy() called on a sfModelFinderColumn::INTEGER column type adds a WHERE ... = condition');


$finder = new sfDoctrineFinder('DArticle');
$finder->filterBy('CategoryId', ' 1 ')->find();

$t->is($finder->getLatestQuery(), 'SELECT d.id AS d__id, d.title AS d__title, d.category_id AS d__category_id FROM d_article d WHERE d.category_id = \'1\'', 'filterBy() called on a sfModelFinderColumn::INTEGER column type converts the value to an integer');

$finder = new sfDoctrineFinder('DCivility');
$finder->filterBy('IsMan', true)->find();

$t->is($finder->getLatestQuery(), 'SELECT d.id AS d__id, d.is_man AS d__is_man FROM d_civility d WHERE d.is_man = \'1\'', 'filterBy() called on a sfModelFinderColumn::BOOLEAN column type adds a WHERE ... = condition');

$finder = new sfDoctrineFinder('DCivility');
$finder->filterBy('IsMan', '12')->find();

$t->is($finder->getLatestQuery(), 'SELECT d.id AS d__id, d.is_man AS d__is_man FROM d_civility d WHERE d.is_man = \'1\'', 'filterBy() called on a sfModelFinderColumn::BOOLEAN column type converts the value to a boolean');

/****************************/
/* sfDoctrineFinder::filter() */
/****************************/

$t->diag('sfDoctrineFinder::filter()');

$finder = new sfDoctrineFinder('DArticle');

try 
{
  $finder->filter('Foo');
  $throwException = false;