diff options
Diffstat (limited to 'src/database/dbmission.py')
| -rw-r--r-- | src/database/dbmission.py | 113 |
1 files changed, 56 insertions, 57 deletions
diff --git a/src/database/dbmission.py b/src/database/dbmission.py index 7f6620e..9d23288 100644 --- a/src/database/dbmission.py +++ b/src/database/dbmission.py @@ -24,10 +24,10 @@ class DbMission(dbmain.DbMain): def register_mission(self, subject, clientId, proId, jobId): # Préparation de la requète pour enregistrement de la mission reqAddMission = """ - INSERT INTO """ + self.TABLEMISSION + """ - (date, subject, clientId, proId, jobCategoryId) - VALUES - (?, ?, ?, ?, ?)""" + INSERT INTO """ + self.TABLEMISSION + """ + (date, subject, clientId, proId, jobCategoryId) + VALUES + (%s, %s, %s, %s, %s)""" # Exécution de la requète self.exec_cmd(reqAddMission, [datetime.now().strftime("%Y-%m-%d %H:%M:%S"), @@ -43,54 +43,53 @@ class DbMission(dbmain.DbMain): def accept_mission_by_missionid(self, missionId): # Préparation de la requète pour enregistrement de la mission reqAddMission = """ - UPDATE - """ + self.TABLEMISSION + """ + UPDATE + """ + self.TABLEMISSION + """ SET - acceptedByPro = ? - WHERE - missionId = ?""" + acceptedByPro = %s + WHERE + missionId = %s""" # Exécution de la requète - self.exec_cmd(reqAddMission, [datetime.now().strftime("%Y-%m-%d %H:%M:%S"), missionId]) + self.exec_cmd(reqAddMission, [datetime.now().strftime("%Y-%m-%d %H:%M:%S"), missionId], True) return 1 def validate_mission_pro_by_missionid(self, missionId): # Préparation de la requète pour enregistrement de la mission reqAddMission = """ - UPDATE - """ + self.TABLEMISSION + """ + UPDATE + """ + self.TABLEMISSION + """ SET - validatedByPro = ? - WHERE - missionId = ?""" + validatedByPro = %s + WHERE + missionId = %s""" # Exécution de la requète - self.exec_cmd(reqAddMission, [datetime.now().strftime("%Y-%m-%d %H:%M:%S"), missionId]) + self.exec_cmd(reqAddMission, [datetime.now().strftime("%Y-%m-%d %H:%M:%S"), missionId], True) return 1 def validate_mission_client_by_missionid(self, missionId): # Préparation de la requète pour enregistrement de la mission reqAddMission = """ - UPDATE - """ + self.TABLEMISSION + """ + UPDATE + """ + self.TABLEMISSION + """ SET - validatedByClient = ? - WHERE - missionId = ?""" + validatedByClient = %s + WHERE + missionId = %s""" # Exécution de la requète - self.exec_cmd(reqAddMission, [datetime.now().strftime("%Y-%m-%d %H:%M:%S"), missionId]) + self.exec_cmd(reqAddMission, [datetime.now().strftime("%Y-%m-%d %H:%M:%S"), missionId], True) return 1 - def review_mission(self, missionId, review, note): + def review_mission(self, missionId: int, review: str, note: int) -> None: # Préparation de la requète pour enregistrement de la mission reqAddMission = """ - UPDATE - """ + self.TABLEMISSION + """ + UPDATE + """ + self.TABLEMISSION + """ SET - review = ?, note = ? - WHERE - missionId = ?""" + review = %s, note = %s + WHERE + missionId = %s""" # Exécution de la requète - self.exec_cmd(reqAddMission, [review, note, missionId]) - return 1 + self.exec_cmd(reqAddMission, [review, note, missionId], True) # **************************************************************************** # RECUPERATION DES INFORMATIONS RELATIVES AUX MISSIONS @@ -98,18 +97,18 @@ class DbMission(dbmain.DbMain): # Récupérations des missions d'un pro par son id def get_mission_by_proid(self, proId): reqGetMissionsProId = """ - SELECT + SELECT missionId, date, subject, note, review, - acceptedByPro, validatedByClient, - validatedByPro, jobCategoryId, proId, lastname - FROM + acceptedByPro, validatedByClient, + validatedByPro, jobCategoryId, proId, lastname + FROM """ + self.TABLEMISSION + """ - LEFT JOIN - """ + self.TABLEUSERINFO + """ - ON + LEFT JOIN + """ + self.TABLEUSERINFO + """ + ON """ + self.TABLEMISSION + """.proId = """ + self.TABLEUSERINFO + """.userId - WHERE - proId = ?""" + WHERE + proId = %s""" self.exec_cmd(reqGetMissionsProId, [proId]) result = self.cur.fetchall() return result @@ -117,18 +116,18 @@ class DbMission(dbmain.DbMain): # Récupérations des missions d'un client par son id def get_mission_by_clientid(self, clientId): reqGetMissionsClientId = """ - SELECT + SELECT missionId, date, subject, note, review, - acceptedByPro, validatedByClient, - validatedByPro, jobCategoryId, proId, lastname - FROM + acceptedByPro, validatedByClient, + validatedByPro, jobCategoryId, proId, lastname + FROM """ + self.TABLEMISSION + """ - LEFT JOIN - """ + self.TABLEUSERINFO + """ - ON + LEFT JOIN + """ + self.TABLEUSERINFO + """ + ON """ + self.TABLEMISSION + """.proId = """ + self.TABLEUSERINFO + """.userId - WHERE - clientId = ?""" + WHERE + clientId = %s""" self.exec_cmd(reqGetMissionsClientId, [clientId]) result = self.cur.fetchall() return result @@ -136,9 +135,9 @@ class DbMission(dbmain.DbMain): # Récupérations des missions d'un client par son id def get_all_missions(self): reqGetAllMission = """ - SELECT - * - FROM + SELECT + * + FROM """ + self.TABLEMISSION self.exec_cmd(reqGetAllMission) result = self.cur.fetchall() @@ -147,14 +146,14 @@ class DbMission(dbmain.DbMain): # Compte le nombre de mission d'un consultant par son nom def count_pro_missions_by_proid(self, proId): reqCountMission = """ - SELECT COUNT(*) FROM + SELECT COUNT(*) FROM """ + self.TABLEMISSION + """ - INNER JOIN - """ + self.TABLEUSERINFO + """ - ON + INNER JOIN + """ + self.TABLEUSERINFO + """ + ON """ + self.TABLEMISSION + """.proId = """ + self.TABLEUSERINFO + """.userId - WHERE - proId = ?""" + WHERE + proId = %s""" self.exec_cmd(reqCountMission, [proId]) result = self.cur.fetchall() return result |