Change model source dinamycally using query builder

Question

Change model source dinamycally using query builder

Philippe Santana Costa Aug '13

Created Aug '13	Last Reply Aug '13	Replies 1	Views 773	Votes 1

Philippe Santana Costa 11.2k

Aug '13

My scenario here is that I have to tables with the exactly same structure but the table name (one of them table_es and the other table_en). So there is no need for two different models.

Is there a way that I could change the model source ( change the table name ) when executing a query with query builder?

1

Philippe Santana Costa
11.2k

Accepted
answer

Aug '13

Thanks @jeffreycahyono, this is a way to solve my problem.

The problem I have is that I have just one model and two tables, both of them belonging to the same model. I'd like to be able to change the model source (table) and the query builder dinamically. For exemple:


public static function getPosts($language) 
{
     $builder =  \Phalcon\Di::getDefault()->get('modelsManager')->createBuilder();
     $bulder->setModelSource('table_' . $language)
     ...
}

Sorry, I might have not explained clearly.

jeffreycahyono · Answer 1 · 2013-08-03T07:34:19-07:00

$models = ['ModelA','ModelB'];
$builder = $this->modelsManager->createBuilder()
  ->where('id=?0', [$id])
  ->limit(20)
  ->orderBy('Robots.name');

$resultSetOutput = []; 
foreach($modellist as $m){
    $builder->from($m);
    resultSetOutput[$m] = $builder->getQuery()->execute();
}