public function getSQL(\Parm\DataAccessObjectFactory $factory) { if ($this->value === null) { return $this->field . " " . $this->operator . " NULL"; } elseif ($this->value instanceof \DateTime) { return $this->field . " " . $this->operator . " " . $factory->escapeString($this->value->format($factory->getDateStorageFormat())); } elseif (is_numeric($this->value)) { $date = new \DateTime(); $date->setTimestamp((int) $this->value); return $this->field . " " . $this->operator . " " . $factory->escapeString($date->format($factory->getDateStorageFormat())); } else { return $this->field . " " . $this->operator . " " . $factory->escapeString((string) $this->value); } }
/** * Delete the object from the database. * @return TRUE if successful, False if failed or ID is not greater than * * @throws Exception\RecordNotFoundException * @throws Exception\UpdateFailedException */ public function delete() { if (!$this->isNewObject()) { $this->factory->update("DELETE FROM " . $this->getTableName() . " WHERE " . $this->getIdField() . " = " . $this->factory->escapeString($this->getId())); } else { throw new RecordNotFoundException("delete() failed: You can't delete this object from the database as it hasn't been saved yet."); } }
/** * Return the SQL String * * @param \Parm\DataAccessObjectFactory $factory * @return string */ public function getSQL(\Parm\DataAccessObjectFactory $factory) { if ($this->value === null) { return $this->field . " " . $this->operator . " NULL"; } elseif (is_int($this->value)) { return $this->field . " " . $this->operator . " " . $this->value; } else { return $this->field . " " . $this->operator . " " . $factory->escapeString($this->value); } }
public function getSQL(\Parm\DataAccessObjectFactory $factory) { if (count($this->array) > 0) { $escaped = array(); foreach ($this->array as $key => $item) { if (is_numeric($item)) { $escaped[] = $item; } else { $escaped[] = $factory->escapeString($item); } } return $this->field . " IN (" . implode(",", $escaped) . ")"; } else { throw new \Parm\Exception\ErrorException("The array passed to the NotInBinding is empty"); } }
/** * Return the SQL String * * @param $factory DataAccessObjectFactory * @return string */ public function getSQL(DataAccessObjectFactory $factory) { return $this->field . " COLLATE " . Config::getCaseSenstitiveCollation() . " LIKE " . $factory->escapeString(str_replace("_", "\\_", str_replace("%", "\\%", $this->value))); }
/** * Return the SQL String * * @param $factory DataAccessObjectFactory * @return string */ public function getSQL(\Parm\DataAccessObjectFactory $factory) { return $this->field . " LIKE " . $factory->escapeString('%' . str_replace("_", "\\_", str_replace("%", "\\%", $this->query)) . '%') . ""; }