/** * Test the build process. * * @return void */ public function testBuild() { $metaModel = new MetaModel(array('id' => '1', 'sorting' => '1', 'tstamp' => '0', 'name' => 'MetaModel', 'tableName' => 'mm_test', 'mode' => '', 'translated' => '1', 'languages' => array('en' => array('isfallback' => '1'), 'de' => array('isfallback' => '')), 'varsupport' => '1')); /** @var \MetaModels\Attribute\Base $attribute */ $attribute = $this->getMockForAbstractClass('MetaModels\\Attribute\\Base', array($metaModel, array('colname' => 'test1'))); $metaModel->addAttribute($attribute); $config = DefaultConfig::init(); $config->setFilter(array(array('operation' => '=', 'property' => 'foo', 'value' => 0))); $dataBase = Database::getNewTestInstance(); $builder = new FilterBuilderSql($metaModel->getTableName(), 'AND', $dataBase); $dataBase->getQueryCollection()->theQuery('SELECT id FROM mm_test WHERE ((test = ?))')->with(0)->result()->addRows(array(array('id' => 0), array('id' => 1), array('id' => 2), array('id' => 3), array('id' => 4), array('id' => 5))); $this->assertTrue($builder->isEmpty()); $this->assertEquals($builder, $builder->addChild(array('operation' => '=', 'property' => 'test', 'value' => 0))); $this->assertEquals(array(0, 1, 2, 3, 4, 5), $builder->build()->getMatchingIds()); }
/** * Add a sub procedure. * * @param FilterBuilderSql $subProcedure The sub procedure to add. * * @return FilterBuilderSql */ public function addSubProcedure(FilterBuilderSql $subProcedure) { $this->procedures[] = $subProcedure->getProcedure(); $this->parameter = array_merge($this->parameter, $subProcedure->getParameters()); return $this; }
/** * Calculate a native SQL sub procedure. * * @param FilterBuilderSql $procedure The procedure to which to append to. * * @param array $children The children to calculate. * * @return array */ protected function buildNativeSqlProcedure(FilterBuilderSql $procedure, $children) { $skipped = array(); $metaModel = $this->getMetaModel(); $tableName = $metaModel->getTableName(); foreach ($children as $child) { // If there is an attribute contained within this rule, skip it. if (isset($child['property']) && $metaModel->hasAttribute($child['property'])) { $skipped[] = $child; continue; } // Try to parse the sub procedure and extract as much as possible. if ($child['operation'] == 'AND' || $child['operation'] == 'OR') { $subProcedure = new FilterBuilderSql($tableName, $child['operation'], $this->getDatabase()); $subSkipped = $this->buildNativeSqlProcedure($subProcedure, $child['children']); if (count($subSkipped) !== count($child['operation'])) { $procedure->addSubProcedure($subProcedure); } if (!empty($subSkipped)) { $skipped += $subSkipped; } continue; } $procedure->addChild($child); } return $skipped; }