/** * Expands a SQL string * * Clauses defined here: * {key} - the $key property, sql quoted * {keybind} - a string like ":table_id" for use as a named placeholder * * @param sql string * @return string * @see $key, DatabaseObjectAbstractMeta::expandSQL */ protected function expandSQL($sql) { $sql = parent::expandSQL($sql); $sql = str_replace('{key}', "`{$this->key}`", $sql); $sql = str_replace('{keybind}', ":{$this->key}", $sql); return $sql; }
protected function expandSQL($sql) { $sql = parent::expandSQL($sql); $auto = $this->getAutomaticColumns(); if (count($auto)) { $colspec = ', ' . $this->getColumnsSQL($auto, null); $fieldset = ', ' . $this->getFieldSetSQL($auto, false); } else { $colspec = ''; $fieldset = ''; } $sql = str_replace('{+colspec}', $colspec, $sql); $sql = str_replace('{+fieldset}', $fieldset, $sql); if (isset($this->additionalKey)) { $addkey = ', ' . $this->getColumnsSQL($this->additionalKey, null); } else { $addkey = ''; } $sql = str_replace('{+addkey}', $addkey, $sql); $sql = str_replace('{orderfrom}', $this->linkOrderClause[0], $sql); $sql = str_replace('{orderto}', $this->linkOrderClause[1], $sql); $sql = str_replace('{from_key}', $this->getFromKey(), $sql); $sql = str_replace('{to_key}', $this->getToKey(), $sql); $keyList = $this->getKeyColumns(); $sql = str_replace('{keyspec}', $this->getFieldSetSQL($keyList), $sql); return $sql; }