/** edit a field
* @param $request
* @return PDOStatement|string
*/
public function edit_field($request)
{
$controller = new Controller();
try {
$str = "ALTER TABLE " . $request['name_db'] . "." . $request['table_name'] . " CHANGE ";
$str = $str . $request['odl_field_name'] . " " . $request['new_field_name'] . " " . $request['new_type_field'] . "(" . $request['new_size_field'] . ")";
$str = $request['new_isNull_field'] == "NO" ? $str . " NOT NULL" : $str . " NULL";
if ($request['new_default_field'] == "NULL") {
$str = $str . " DEFAULT NULL";
} else {
if ($request['new_default_field'] == "CURRENT_TIMESTAMP") {
$str = $str . " DEFAULT CURRENT_TIMESTAMP";
} else {
if ($request['new_default_field'] == "Aucune") {
$str = $str . "";
} else {
$str . " DEFAULT '" . $request['new_default_field'] . "'";
}
}
}
$controller->write_log_sql($str);
$result = Connector::prepare($str, NULL);
return $result;
} catch (PDOException $e) {
return $e->getMessage();
}
unset($controller);
}
