コード例 #1
0
 def new(self, request_dict):
     connection = MsqlConnection()
     sentence_search = "SELECT * FROM problem_types WHERE id='" + request_dict[
         "id_problem_type"] + "'"
     row = connection.get_all(sentence_search)
     if row:
         sentence_search2 = "SELECT * FROM users WHERE id='" + request_dict[
             "user_id_creation"] + "'"
         row2 = connection.get_all(sentence_search2)
         if row2:
             x = datetime.datetime.now()
             current_date = str(x.year) + "-" + str(x.month) + "-" + str(
                 x.day)
             sentence = "INSERT request(id_problemType, description, creation_date, user_id_creation, status, priority, country) VALUES('" + request_dict["id_problem_type"] + "','" \
                        + request_dict["description"] + "','" + str(current_date) + "','" \
                        + request_dict["user_id_creation"] + "','IN PROCESS','" + request_dict["priority"] \
                        + "','" + request_dict["country"] +"')"
             connection.execute(sentence)
             connection.commit()
             connection.close_connection()
             return "This request was created succesfully"
         else:
             connection.close_connection()
             return "This user does not exist"
     else:
         connection.close_connection()
         return "This problem type does not exist"
コード例 #2
0
ファイル: department.py プロジェクト: javier1196/TechTeam
 def new(self, department_dict):
     connection = MsqlConnection()
     sentence = "INSERT department(department) VALUES('" + department_dict["department"] + "')"
     connection.execute(sentence)
     connection.commit()
     connection.close_connection()
     return "Department was created correctly"""
コード例 #3
0
ファイル: request_update.py プロジェクト: javier1196/TechTeam
 def new(self, request_update_dict):
     connection = MsqlConnection()
     sentence_search = "SELECT * FROM support_department WHERE id='" + request_update_dict[
         "id_department_support"] + "'"
     row = connection.get_all(sentence_search)
     if row:
         sentence_search2 = "SELECT * FROM request WHERE id='" + request_update_dict[
             "id_request"] + "'"
         row2 = connection.get_all((sentence_search2))
         if row2:
             x = datetime.datetime.now()
             current_date = str(x.year) + "-" + str(x.month) + "-" + str(
                 x.day)
             sentence = "INSERT request_update(id_department_support, description, " \
                        "status, date, id_request) VALUES('" + request_update_dict["id_department_support"] + "','" + \
                        request_update_dict["description"] + "','" + request_update_dict["status"] + "','" \
                        + str(current_date) + "','" + request_update_dict["id_request"] + "')"
             connection.execute(sentence)
             connection.commit()
             connection.close_connection()
             return "request_update was created correctly"
         else:
             connection.close_connection()
             return "This id request does not exist"
     else:
         connection.close_connection()
         return "This id support department does not exist"
コード例 #4
0
    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"
コード例 #5
0
ファイル: request_update.py プロジェクト: javier1196/TechTeam
    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"
コード例 #6
0
ファイル: user.py プロジェクト: javier1196/flask_supply
 def new(self, user_dict):
     connection = MsqlConnection()
     sentence = "INSERT users(first_name, last_name, phone, email, employee_serial) VALUES('" + user_dict["first_name"] + "','" + user_dict["last_name"] + "','" + user_dict["phone"] + "','" + user_dict["email"] + "','" + user_dict["employee_serial"] + "') "
     connection.execute(sentence)
     connection.commit()
     connection.close_connection()
     return "User was created correctly"""
コード例 #7
0
ファイル: problem_type.py プロジェクト: javier1196/TechTeam
 def new(self, problem_type_dict):
     connection = MsqlConnection()
     sentence = "INSERT problem_types(name, description) " \
                "VALUES('" + problem_type_dict["name"] + "','" + problem_type_dict[
                    "description"] + "')"
     connection.execute(sentence)
     connection.commit()
     connection.close_connection()
     return "problem_types was created correctly" ""
コード例 #8
0
 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"
コード例 #9
0
 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"
コード例 #10
0
ファイル: department.py プロジェクト: javier1196/TechTeam
    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"
コード例 #11
0
ファイル: user.py プロジェクト: javier1196/flask_supply
    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"
コード例 #12
0
 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"
コード例 #13
0
ファイル: problem_type.py プロジェクト: javier1196/TechTeam
    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"
コード例 #14
0
 def new(self, support_department_dict):
     connection = MsqlConnection()
     sentence_search = "SELECT * FROM department WHERE id='" \
                       + support_department_dict["id_department"] + "'"
     row = connection.get_all(sentence_search)
     if row:
         sentence = "INSERT support_department(id_department, name, " \
                    "email) VALUES('" + support_department_dict["id_department"] + "','" + \
                    support_department_dict["name"] + "','" + support_department_dict["email"] + "') "
         connection.execute(sentence)
         connection.commit()
         connection.close_connection()
         return "This support department was created succesfully"
     else:
         connection.close_connection()
         return "This support department does not exist"
コード例 #15
0
 def new(self, department_country_support_dict):
     connection = MsqlConnection()
     sentence_search = "SELECT * FROM department WHERE id ='" + department_country_support_dict[
         "id_department"] + "'"
     row = connection.get_all(sentence_search)
     if row:
         sentence = "INSERT department_country_support(id_department, country) VALUES('" + department_country_support_dict[
             "id_department"] + "','" + department_country_support_dict[
                 "country"] + "') "
         connection.execute(sentence)
         connection.commit()
         connection.close_connection()
         return "departments_involved was created correctly"
     else:
         connection.close_connection()
         return "This department was incorrectly"
コード例 #16
0
 def update(self, id, admin_dict):
     connection = MsqlConnection()
     sentence_search = "SELECT * FROM support_department WHERE id='" + admin_dict["id_support_department"] + "'"
     row = connection.get_all(sentence_search)
     if row:
         sentence = "UPDATE admin_support set first_name = '" + admin_dict["first_name"] + "',  last_name = '" + \
                    admin_dict["last_name"] + "', phone = '" + admin_dict["phone"] + "', email = '" + admin_dict[
                        "email"] + "', employee_serial = '" + admin_dict["employee_serial"] + "', employee_serial = '" + \
                    admin_dict["id_support_department"] + "' WHERE ID = '" + str(id) + "'"
         connection.execute(sentence)
         connection.commit()
         connection.close_connection()
         return "admin_support was updated correctly"
     else:
         connection.close_connection()
         return "This support department does not exist"
コード例 #17
0
    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"
コード例 #18
0
 def new(self, employee_in_charge_dict):
     connection = MsqlConnection()
     # sentence_search no jala
     sentence_search = "SELECT * FROM employee_in_charge WHERE id ='" + employee_in_charge_dict[
         "id_department"] + "'"
     row = connection.get_all(sentence_search)
     if row:
         connection.close_connection()
         return "This employee_in_charge is repeated"
     else:
         print("hola2")
         sentence = "INSERT employee_in_charge(id_department, first_name, last_name, phone, email, employee_serial) " \
                    "VALUES('" + employee_in_charge_dict["id_department"] + "','" + employee_in_charge_dict[
                        "first_name"] + "','" + employee_in_charge_dict["last_name"] + "','" + \
                    employee_in_charge_dict[
                        "phone"] + \
                    "','" + employee_in_charge_dict["email"] + "','" + employee_in_charge_dict[
                        "employee_serial"] + "')"
         connection.execute(sentence)
         connection.commit()
         connection.close_connection()
         return "employee_in_charge was created correctly" ""
コード例 #19
0
    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"
コード例 #20
0
 def update(self, id, department_involved_dict):
     connection = MsqlConnection()
     sentence_search_department_support = "SELECT * FROM support_department WHERE id ='" \
                                          + department_involved_dict["id_department_support"] + "'"
     row = connection.get_all(sentence_search_department_support)
     if row:
         sentence_search_request = "SELECT * FROM request WHERE id='" \
                                   + department_involved_dict["id_request"] + "'"
         row_request = connection.get_all(sentence_search_request)
         if row_request:
             sentence = "UPDATE departments_involved set id_department_support = '" + department_involved_dict[
                 "id_department_support"] + "',  id_request = '" + department_involved_dict[
                            "id_request"] + "' WHERE ID = '" + str(id) + "'"
             connection.execute(sentence)
             connection.commit()
             connection.close_connection()
             return "departments_involved was updated"
         else:
             connection.close_connection()
             return "This request does not exist"
     else:
         connection.close_connection()
         return "This department support does not exist"
コード例 #21
0
 def new(self, department_involved_dict):
     connection = MsqlConnection()
     sentence_search_department_support = "SELECT * FROM support_department WHERE id ='" \
                                          + str(department_involved_dict["id_department_support"]) + "'"
     row = connection.get_all(sentence_search_department_support)
     if row:
         sentence_search_request = "SELECT * FROM problem_types WHERE id='" \
                                   + str(department_involved_dict["id_problem_type"]) + "'"
         row_request = connection.get_all(sentence_search_request)
         if row_request:
             sentence = "INSERT support_department_problem_type(id_problem_type, id_support_department) VALUES('" + \
                        str(department_involved_dict[
                            "id_problem_type"]) + "','" + str(department_involved_dict["id_department_support"]) + "') "
             connection.execute(sentence)
             connection.commit()
             connection.close_connection()
             return "This request was created correctly"
         else:
             connection.close_connection()
             return "This problem type does not exist"
     else:
         connection.close_connection()
         return "This department support does not exist" ""
コード例 #22
0
 def new(self, department_involved_dict):
     connection = MsqlConnection()
     sentence_search_department_support = "SELECT * FROM support_department WHERE id ='" \
                                          + department_involved_dict["id_department_support"] + "'"
     row = connection.get_all(sentence_search_department_support)
     if row:
         sentence_search_request = "SELECT * FROM request WHERE id='" \
                                   + department_involved_dict["id_request"] + "'"
         row_request = connection.get_all(sentence_search_request)
         if row_request:
             sentence = "INSERT departments_involved(id_department_support, id_request) VALUES('" + \
                        department_involved_dict[
                            "id_department_support"] + "','" + department_involved_dict["id_request"] + "') "
             connection.execute(sentence)
             connection.commit()
             connection.close_connection()
             return "This department involved was created correctly"
         else:
             connection.close_connection()
             return "This request does not exist"
     else:
         connection.close_connection()
         return "This department support does not exist"
コード例 #23
0
 def update(self, id, support_department_dict):
     connection = MsqlConnection()
     sentence_search = "SELECT * FROM support_department WHERE id='" + str(
         id) + "'"
     row = connection.get_all(sentence_search)
     if row:
         sentence_search_department = "SELECT * FROM department WHERE id='" \
                                      + support_department_dict["id_department"] + "'"
         row_search = connection.get_all(sentence_search_department)
         if row_search:
             sentence = "UPDATE support_department set id_department = '" + support_department_dict[
                 "id_department"] + "',  name = '" + support_department_dict["name"] + "',  email = '"\
                        + support_department_dict["email"] + "' WHERE ID = '" + str(id) + "'"
             connection.execute(sentence)
             connection.commit()
             connection.close_connection()
             return "departments_involved was updated"
         else:
             connection.close_connection()
             return "This id department does not exist"
     else:
         connection.close_connection()
         return "This request does not exist"