/** * @return $this|\Yaoi\Sql\SelectInterface|\Yaoi\Sql\UpdateInterface */ public function build($statExpr) { $symbolsDerived = SymbolStat::table('s'); $symbolsDerivedCols = SymbolStat::columns($symbolsDerived); $symbolCols = Symbol::columns(); $this->expr = Database::getInstance()->statement()->select('? AS ?', $symbolCols->name, new S('function'))->from('? AS s', $statExpr)->leftJoin('? ON ? = ?', Symbol::table(), $symbolsDerivedCols->symbolId, $symbolCols->id)->groupBy('?', $symbolsDerivedCols->symbolId); $this->avgWtSymbols = array(); foreach ($this->runs as $run) { $runXTable = SymbolStat::table($run->name); $runXCols = SymbolStat::columns($runXTable); $this->addColumns($run, $runXCols); $this->expr->leftJoin('? ON ? = ? AND ? = ? AND ? = ?', $runXTable, $runXCols->symbolId, $symbolsDerivedCols->symbolId, $runXCols->isInclusive, $this->isInclusive, $runXCols->runId, $run->id); } $outerExpr = Database::getInstance()->statement()->select('*')->from('? AS ss', $this->expr)->order('COALESCE(null, ?) DESC', array($this->avgWtSymbols))->limit($this->limit); return $outerExpr; }
/** * @return Statement */ public function statement() { return Statement::create()->bindDatabase($this); }