def update(self, id, request_update_dict):
connection = MsqlConnection()
sentence_searh = "SELECT * FROM request_update WHERE ID = " + str(id)
row = connection.get_one(sentence_searh)
if row:
sentence_search2 = "SELECT * FROM support_department WHERE id='" + request_update_dict[
"id_department_support"] + "'"
row2 = connection.get_all(sentence_search2)
if row2:
sentence_search3 = "SELECT * FROM request WHERE id='" + request_update_dict[
"id_request"] + "'"
row3 = connection.get_all(sentence_search3)
if row3:
x = datetime.datetime.now()
current_date = str(x.year) + "-" + str(
x.month) + "-" + str(x.day)
sentence = "UPDATE request_update set id_department_support = '" + request_update_dict[
"id_department_support"] + "', description = '" + request_update_dict[
"description"] + "', status = '" + request_update_dict[
"status"] + "', date = '" + str(
current_date
) + "', id_request = '" + request_update_dict[
"id_request"] + "' WHERE ID = '" + str(
id) + "'"
connection.execute(sentence)
connection.commit()
connection.close_connection()
return "request_update was updated"
else:
return "id request does not exist"
else:
return "id support deparment does not exist"
return "This request_update does not exist"
def update(self, id, request_dict):
connection = MsqlConnection()
sentenceSearh = "SELECT * FROM request WHERE ID = " + str(id)
row = connection.get_one(sentenceSearh)
if row:
sentence_search = "SELECT * FROM problem_types WHERE id='" + request_dict["id_problem_type"] + "'"
row_2 = connection.get_all(sentence_search)
if row_2:
x = datetime.datetime.now()
current_date = str(x.year) + "-" + str(x.month) + "-" + str(x.day)
sentence = "UPDATE request set id_problemType = '" + request_dict[
"id_problem_type"] + "', description = '" + request_dict["description"] + "', creation_date = '" + \
request_dict["creation_date"] + "', update_date = '" + request_dict[
"update_date"] + "', date_closed_ticket = '" + request_dict[
"date_closed_ticket"] + "', status = '" + request_dict[
"status"] + "', solution = '" + request_dict[
"solution"] + "', priority = '" + request_dict[
"priority"] + "', country = '" + request_dict[
"country"] + "' WHERE ID = '" + str(id) + "'"
connection.execute(sentence)
connection.commit()
connection.close_connection()
return "request was updated"
else:
connection.close_connection()
return "This problem type does not exist"
else:
connection.close_connection()
return "This request does not exist"
def delete(self, id):
connection = MsqlConnection()
sentence_search = "SELECT * FROM departments_involved WHERE ID = " + str(id)
row = connection.get_one(sentence_search)
if row:
sentence = "DELETE FROM departments_involved WHERE ID = '" + str(id) + "'"
connection.execute(sentence)
connection.commit()
connection.close_connection()
return "departments_involved was deleted"
return "This departments_involved does not exist"
def delete(self, id):
connection = MsqlConnection()
sentenceSearh = "SELECT * FROM request WHERE ID = " + str(id)
row = connection.get_one(sentenceSearh)
if row:
sentence = "DELETE FROM request WHERE ID = '" + str(id) + "'"
connection.execute(sentence)
connection.commit()
connection.close_connection()
return "request was deleted"
return "This request does not exist"
def update(self, id, department_dict):
connection = MsqlConnection()
sentenceSearh = "SELECT * FROM department WHERE ID = " + str(id)
row = connection.get_one(sentenceSearh)
if row:
sentence = "UPDATE department set department = '" + department_dict["department"] + "' WHERE ID = '" + str(id) + "'"
connection.execute(sentence)
connection.commit()
connection.close_connection()
return "Department was updated"
return "This department does not exist"
def update(self, id, user_dict):
connection = MsqlConnection()
sentenceSearh = "SELECT * FROM users WHERE ID = " + str(id)
row = connection.get_one(sentenceSearh)
if row:
sentence = "UPDATE users set first_name = '" + user_dict["first_name"] + "', last_name = '" + user_dict["last_name"] + "', phone = '" + user_dict["phone"] + "', email = '" + user_dict["email"] + "', employee_serial = '" + user_dict["employee_serial"] + "' WHERE ID = '" + str(id) + "'"
connection.execute(sentence)
connection.commit()
connection.close_connection()
return "User was updated"
return "This user does not exist"
def delete(self, id):
connection = MsqlConnection()
sentence_search = "SELECT * FROM employee_in_charge WHERE ID = " + str(
id)
row = connection.get_one(sentence_search)
if row:
sentence = "DELETE FROM employee_in_charge WHERE ID = '" + str(
id) + "'"
connection.execute(sentence)
connection.commit()
connection.close_connection()
return "employee_in_charge was deleted"
return "This employee_in_charge does not exist"
def update(self, id, problem_types_dict):
connection = MsqlConnection()
sentenceSearh = "SELECT * FROM problem_types WHERE ID = " + str(id)
row = connection.get_one(sentenceSearh)
if row:
sentence = "UPDATE problem_types set name = '" + problem_types_dict[
"name"] + "', description = '" + problem_types_dict[
"description"] + "' WHERE ID = '" + str(id) + "'"
connection.execute(sentence)
connection.commit()
connection.close_connection()
return "problem_types was updated"
return "This problem_types does not exist"
def update(self, id, employee_in_charge_dict):
connection = MsqlConnection()
sentence_search = "SELECT * FROM employee_in_charge WHERE ID = " + str(
id)
row = connection.get_one(sentence_search)
if row:
sentence = "UPDATE employee_in_charge set id_department = '" + employee_in_charge_dict[
"id_department"] + "', first_name = '" + employee_in_charge_dict["last_name"] + "', phone = '" + \
employee_in_charge_dict["phone"] + "', email = '" + employee_in_charge_dict[
"email"] + "', employee_serial = '" + employee_in_charge_dict[
"employee_serial"] + "' WHERE ID = '" + str(id) + "'"
connection.execute(sentence)
connection.commit()
connection.close_connection()
return "employee_in_charge was updated"
return "This employee_in_charge does not exist"
def update(self, id, department_country_support_dict):
connection = MsqlConnection()
sentenceSearh = "SELECT * FROM department_country_support WHERE ID = " + str(
id)
row = connection.get_one(sentenceSearh)
if row:
sentence_valid_department = "SELECT * FROM department WHERE id ='" + department_country_support_dict[
"id_department"] + "'"
row_valid = connection.get_all(sentence_valid_department)
if row_valid:
sentence = "UPDATE department_country_support set id_department = '" + department_country_support_dict[
"id_department"] + "', country = '" + department_country_support_dict[
"country"] + "' WHERE ID = '" + str(id) + "'"
connection.execute(sentence)
connection.commit()
connection.close_connection()
return "department_country_support was updated"
else:
return "This department id does not exist"
else:
return "This department_country_support does not exist"
def getId(self, mail):
connection = MsqlConnection()
sentenceSearh = "SELECT ID FROM users WHERE EMAIL = '" + mail + "'"
record = connection.get_one(sentenceSearh)
return record[0]
