function toDialectString(IDialect $dialect)
{
if (!$this->isEmpty()) {
$list = new SqlValueExpressionArray($this->toArray());
return 'ORDER BY ' . $list->toDialectString($dialect);
}
}
function toDialectString(IDialect $dialect)
{
if (empty($this->set)) {
return null;
}
$values = new SqlValueExpressionArray($this->set);
$compiledSlices = array();
$compiledSlices[] = '(';
$compiledSlices[] = $this->subject->toDialectString($dialect);
$compiledSlices[] = ')';
$compiledSlices[] = $this->operator->toDialectString($dialect);
$compiledSlices[] = '(';
$compiledSlices[] = $values->toDialectString($dialect);
$compiledSlices[] = ')';
$compiledString = join(' ', $compiledSlices);
return $compiledString;
}
function toDialectString(IDialect $dialect)
{
$querySlices = array();
$querySlices[] = 'SELECT';
if ($this->distinct) {
$querySlices[] = 'DISTINCT';
}
$querySlices[] = $this->get->toDialectString($dialect);
if (!$this->sources->isEmpty()) {
$querySlices[] = 'FROM';
$querySlices[] = $this->sources->toDialectString($dialect);
}
// WHERE
if ($this->condition) {
$querySlices[] = 'WHERE';
$querySlices[] = $this->condition->toDialectString($dialect);
}
// GROUP BY
if (!$this->groups->isEmpty()) {
$querySlices[] = 'GROUP BY';
$querySlices[] = $this->groups->toDialectString($dialect);
}
// HAVING
if ($this->having) {
$querySlices[] = 'HAVING';
$querySlices[] = $this->having->toDialectString($dialect);
}
if (!$this->order->isEmpty()) {
$querySlices[] = $this->order->toDialectString($dialect);
}
if ($this->limit) {
$querySlices[] = 'LIMIT';
$querySlices[] = $this->limit;
}
if ($this->offset) {
$querySlices[] = 'OFFSET';
$querySlices[] = $this->offset;
}
$queryString = join(' ', $querySlices);
return $queryString;
}
/**
* @return string
*/
private function getCompiledValues(IDialect $dialect)
{
$list = new SqlValueExpressionArray($this->getRow()->getValues());
return $list->toDialectString($dialect);
}
function toDialectString(IDialect $dialect)
{
$compiledSlices = array();
$compiledSlices[] = $this->name;
$compiledSlices[] = '(';
if ($this->aggregate) {
$compiledSlices[] = $this->aggregate;
}
$args = new SqlValueExpressionArray($this->args);
$compiledSlices[] = $args->toDialectString($dialect);
$compiledSlices[] = ')';
$compiledFunctionCall = join(' ', $compiledSlices);
return $compiledFunctionCall;
}
