/**
* Get the SQL for a select statement
* @param zibo\library\database\manipulation\statement\manipulation\SelectStatement $statement
* @return string SQL of the select statement
*/
protected function parseSelectStatement(SelectStatement $statement)
{
$operator = $statement->getOperator();
$sql = 'SELECT ';
if ($statement->isDistinct()) {
$sql .= 'DISTINCT ';
}
$fields = $statement->getFields();
if (empty($fields)) {
$sql . '*';
} else {
$sql .= $this->parseExpressionsForSelect($fields);
}
$tables = $statement->getTables();
if ($tables) {
$sql .= ' FROM ' . $this->parseTableExpressionsForFrom($tables);
}
$conditions = $statement->getConditions();
if ($conditions) {
$sql .= ' WHERE ' . $this->parseConditions($conditions, $operator, false);
}
$group = $statement->getGroupBy();
if ($group) {
$sql .= ' GROUP BY ' . $this->parseExpressions($group, ', ', true);
}
$having = $statement->getHaving();
if ($having) {
$sql .= ' HAVING ' . $this->parseConditions($having, $operator, true);
}
$order = $statement->getOrderBy();
if ($order) {
$sql .= ' ORDER BY ' . $this->parseExpressions($order, ', ', false);
}
$limit = $statement->getLimit();
if ($limit) {
$sql .= $this->parseLimitExpression($limit);
}
return $sql;
}
/**
* Gets the names of the models used by this query
* @param zibo\library\database\manipulation\statement\SelectStatement $statemenet
* @return array Array with the names of the models used by this query
*/
private function getUsedModels(SelectStatement $statement)
{
$usedModels = array();
$tables = $statement->getTables();
foreach ($tables as $table) {
$usedModels[] = $table->getName();
$joins = $table->getJoins();
foreach ($joins as $join) {
$modelName = $join->getTable()->getName();
$usedModels[$modelName] = $modelName;
}
}
return $usedModels;
}
