/**
* generate sql string
*
* @return string
* @throws base_database_Exception
*/
public function toString()
{
$result = 'DELETE FROM ';
$result .= $this->table->getName();
if (empty($this->where)) {
throw new base_database_Exception(TMS(base_database_Exception::NO_WHERE_GIVEN));
}
$result .= ' WHERE ';
$result .= $this->where->toString();
return $result;
}
/**
* generate sql string
*
* @return string
*/
public function toString()
{
if (empty($this->columnValues)) {
return '';
}
$result = 'INSERT INTO ';
$result .= $this->table->getName();
$result .= ' (' . implode(',', array_keys($this->columnValues)) . ') ';
$result .= 'VALUES (' . implode(',', array_values($this->columnValues)) . ')';
return $result;
}
/**
* generate sql string
*
* @return string
*/
public function toString()
{
$result = 'UPDATE ';
$result .= $this->table->getName();
$result .= ' SET ';
if (empty($this->columnValues) === false) {
$result .= implode(', ', $this->columnValues);
}
if (empty($this->where) === false) {
$result .= ' WHERE ';
$result .= $this->where->toString();
}
return $result;
}
