public function GetSQL()
{
$result = $this->sql;
foreach ($this->GetKeyFieldValues() as $fieldName => $value) {
$fieldInfo = $this->GetFieldByName($fieldName);
if (isset($fieldInfo) && $this->HasKeyFieldValueFor($fieldInfo->Name)) {
$result = ReplaceFirst($result, ':OLD_' . $fieldName, $this->GetCommandImp()->GetFieldValueAsSQLForUpdate($fieldInfo, $this->GetKeyFieldValueByName($fieldInfo->Name), $this->IsSetFieldValueToDefault($fieldName)));
}
}
foreach ($this->GetFields() as $fieldInfo) {
if ($this->HasFieldValueFor($fieldInfo->Name)) {
$result = ReplaceFirst($result, ':' . $fieldInfo->Name, $this->GetCommandImp()->GetFieldValueAsSQLForUpdate($fieldInfo, $this->GetFieldValueByName($fieldInfo->Name), $this->IsSetFieldValueToDefault($fieldName)));
}
}
return $result;
}
public function GetSQL()
{
assert(count($this->keyFieldValues) > 0);
$result = $this->sql;
foreach ($this->keyFieldValues as $fieldName => $value) {
$result = ReplaceFirst($result, ':' . $fieldName, $this->GetCommandImp()->GetFieldValueAsSQLForDelete($this->GetFieldByName($fieldName), $value));
}
return $result;
}
public function GetSQL()
{
$result = $this->sql;
foreach ($this->fields as $fieldInfo) {
if (array_key_exists($fieldInfo->Name, $this->fieldValues)) {
$result = ReplaceFirst($result, ':' . $fieldInfo->Name, $this->GetCommandImp()->GetFieldValueForInsert($fieldInfo, $this->fieldValues[$fieldInfo->Name], isset($this->setToDefaultFields[$fieldInfo->Name])));
}
}
return $result;
}
