DBDiff\SQLGen\DiffToSQL\UpdateDataSQL::getUp PHP Method

getUp() public method

public getUp ( )
    public function getUp()
    {
        $table = $this->obj->table;
        $values = $this->obj->diff['diff'];
        array_walk($values, function (&$diff, $column) {
            if (!is_null($diff->getNewValue())) {
                $diff = '`' . $column . "` = '" . addslashes($diff->getNewValue()) . "'";
            } else {
                $diff = '`' . $column . "` = NULL";
            }
        });
        $values = implode(', ', $values);
        $keys = $this->obj->diff['keys'];
        array_walk($keys, function (&$value, $column) {
            $value = '`' . $column . "` = '" . addslashes($value) . "'";
        });
        $condition = implode(' AND ', $keys);
        return "UPDATE `{$table}` SET {$values} WHERE {$condition};";
    }