public function setLimit(AbstractExpression $start, AbstractExpression $length)
{
$offset = $start->getMysql();
$count = $length->getMysql();
$mysql = "{$offset}, {$count}";
$this->limit = $mysql;
}
protected function getWhereClause()
{
if ($this->where === null) {
return null;
}
$where = $this->where->getMysql();
return "\tWHERE {$where}\n";
}
public function addPropertyValuePair($tableId, Column $column, AbstractExpression $expression)
{
$columnMysql = $column->getMysql();
$table = self::getIdentifier($tableId);
$name = self::getAbsoluteExpression($table, $columnMysql);
$this->values[$name] = $expression->getMysql();
return self::insert($this->columns, $name);
}
public function addPropertyValuePair($tableId, Column $column, AbstractExpression $expression)
{
$name = self::getColumnNameFromExpression($column->getMysql());
$this->values[$name] = $expression->getMysql();
return self::insert($this->columns, $name);
}
public function setLimit(AbstractExpression $length)
{
$this->limit = $length->getMysql();
}