/** @override */
public function toSql($tableSql, EarthIT_DBC_Namer $dbObjectNamer, EarthIT_DBC_ParamsBuilder $params)
{
$columnName = $dbObjectNamer->getColumnName($this->rc, $this->field);
$fieldValueSql = $tableSql . '.{' . $params->bind(new EarthIT_DBC_SQLIdentifier($columnName)) . '}';
$valueParamName = $params->bind($this->value);
return "{$fieldValueSql} = {{$valueParamName}}";
}
/**
* @param string $tableSql SQL fragment giving the table name or alias
*/
public function toSql($tableSql, EarthIT_DBC_Namer $dbObjectNamer, EarthIT_DBC_ParamsBuilder $params)
{
$columnName = $dbObjectNamer->getColumnName($this->rc, $this->field);
$fieldValueSql = $tableSql . '.{' . $params->bind(new EarthIT_DBC_SQLIdentifier($columnName)) . '}';
$valueValueSql = $this->valueExpression->toSql($params);
return $this->comparisonOp->toSql($fieldValueSql, $valueValueSql);
}
/** @override */
public function toSql(EarthIT_DBC_ParamsBuilder $params)
{
$s = array();
foreach ($this->values as $v) {
$s[] = '{' . $params->bind($v) . '}';
}
return '(' . implode(', ', $s) . ')';
}
/** @override */
public function toSql($tableSql, EarthIT_DBC_Namer $dbObjectNamer, EarthIT_DBC_ParamsBuilder $params)
{
$columnSqls = array();
foreach ($this->fields as $field) {
$columnName = $dbObjectNamer->getColumnName($this->rc, $field);
$fieldValueSql = $tableSql . '.{' . $params->bind(new EarthIT_DBC_SQLIdentifier($columnName)) . '}';
$columnSqls[] = $fieldValueSql;
}
$valueTupleSqls = array();
foreach ($this->valueTuples as $valueTuple) {
$valueSqls = array();
foreach ($valueTuple as $value) {
$valueSqls[] = '{' . $params->bind($value) . '}';
}
$valueTupleSqls[] = '(' . implode(', ', $valueSqls) . ')';
}
return "(" . implode(', ', $columnSqls) . ") IN (" . implode(', ', $valueTupleSqls) . ')';
}
/**
* @param string $tableSql SQL fragment giving the table name or alias
*/
public function toSql($tableSql, EarthIT_DBC_Namer $dbObjectNamer, EarthIT_DBC_ParamsBuilder $params)
{
$columnName = $dbObjectNamer->getColumnName($this->rc, $this->field);
$fieldValueSql = $tableSql . '.{' . $params->bind(new EarthIT_DBC_SQLIdentifier($columnName)) . '}';
$patternParamName = $params->newParam('pattern', $this->getLikePattern());
if ($this->caseInsensitive) {
$fieldValueSql = "lower({$fieldValueSql})";
// Works on Postgres, anyway!
}
return "{$fieldValueSql} LIKE {{$patternParamName}}";
}
/** @override */
public function toSql(EarthIT_DBC_ParamsBuilder $params)
{
return '{' . $params->bind($this->value) . '}';
}
/**
* @param array $selects array of alias => SQL expression text
* @return array of select parts [x, y, ...] of 'SELECT x, y, ... FROM yaddah yaddah'
*/
public static function formatSelectComponents(array $selects, EarthIT_DBC_ParamsBuilder $PB)
{
$sqlz = array();
foreach ($selects as $k => $selSql) {
if (is_integer($k)) {
$sqlz[] = $selSql;
} else {
$aliasParamName = $PB->bind(new EarthIT_DBC_SQLIdentifier($k));
$sqlz[] = "{$selSql} AS {{$aliasParamName}}";
}
}
return $sqlz;
}
