public function listTop()
{
$database = Database::getInstance();
$esc = SymbolStat::columns();
$statement = $database->select(SymbolStat::table())->select("SUM(?) AS total_wt, SUM(?) AS total_ct, COUNT(DISTINCT ?) AS runs, ?, ?", $esc->wallTime, $esc->calls, $esc->runId, $esc->symbolId, Symbol::columns()->name)->leftJoin('? ON ? = ?', Symbol::table(), Symbol::columns()->id, $esc->symbolId)->groupBy(SymbolStat::columns()->symbolId)->order('total_wt DESC')->limit(50);
$res = $statement->query();
$table = new HTML();
foreach ($res as $row) {
$row['name'] = '<a href="?symbol=' . urlencode($row['name']) . '">' . $row['name'] . '</a>';
unset($row['symbol_id']);
$table->addRow($row);
}
$this->layout->pushMain($table)->render();
}
/**
* @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;
}