/** * 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; }