1 files changed, 44 insertions, 44 deletions
diff --git a/src/database/dbsearch.py b/src/database/dbsearch.py
index 3089bf1..0561c9d 100644
--- a/src/database/dbsearch.py
+++ b/src/database/dbsearch.py
@@ -20,11 +20,11 @@ class DbSearch(dbmain.DbMain):
     # Récupération des infos d'un compte par son id
     def get_user_account_by_userid(self, userId: int) -> list:
         reqSearchUser = """
-            SELECT 
+            SELECT
                 userId, email, inscriptionDate, userStatus
-            FROM 
+            FROM
                 """ + self.TABLEUSERACCOUNT + """
-            WHERE 
+            WHERE
                 userId = %s"""
         self.exec_cmd(reqSearchUser, [userId])
         return self.cur.fetchall()
@@ -32,13 +32,13 @@ class DbSearch(dbmain.DbMain):
     # Récupération des infos d'un utilisateur par son id
     def get_user_info_by_userid(self, userId: int) -> list:
         reqGetUserInfo = """
-            SELECT 
-                userId, lastname, firstname, degree, 
+            SELECT
+                userId, lastname, firstname, degree,
                 capability, description, phoneNumber,
-                adress, zipCode, city 
-            FROM 
-                """ + self.TABLEUSERINFO + """ 
-            WHERE 
+                adress, zipCode, city
+            FROM
+                """ + self.TABLEUSERINFO + """
+            WHERE
                 userId = %s"""
         self.exec_cmd(reqGetUserInfo, [userId])
         return self.cur.fetchall()
@@ -48,16 +48,16 @@ class DbSearch(dbmain.DbMain):
     # ****************************************************************************
     def get_all_pro_by_jobid(self, jobId):
         reqSearchConsultant = """
-            SELECT 
-                """ + self.TABLEUSERINFO + """.userId, 
-                lastname, firstname, capability 
-            FROM 
+            SELECT
+                """ + self.TABLEUSERINFO + """.userId,
+                lastname, firstname, capability
+            FROM
                 """ + self.TABLEUSERINFO + """
             INNER JOIN
                 """ + self.TABLEUSERJOB + """
             ON
                 """ + self.TABLEUSERINFO + """.userId = """ + self.TABLEUSERJOB + """.userId
-            WHERE 
+            WHERE
                 jobCategoryId = %s"""
         self.exec_cmd(reqSearchConsultant, [jobId])
         return self.cur.fetchall()
@@ -65,18 +65,18 @@ class DbSearch(dbmain.DbMain):
     # Récupération des infos d'un pro par son nom
     def get_pro_info_by_lastname(self, lastname):
         reqSearchConsultant = """
-            SELECT 
-                """ + self.TABLEUSERINFO + """.userId, 
-                lastname, firstname, capability 
-            FROM 
+            SELECT
+                """ + self.TABLEUSERINFO + """.userId,
+                lastname, firstname, capability
+            FROM
                 """ + self.TABLEUSERINFO + """
-            INNER JOIN 
-                """ + self.TABLEUSERACCOUNT + """ 
-            ON 
+            INNER JOIN
+                """ + self.TABLEUSERACCOUNT + """
+            ON
                 """ + self.TABLEUSERINFO + """.userId = """ + self.TABLEUSERACCOUNT + """.userId
-            WHERE 
-                userStatus = '1' 
-            AND 
+            WHERE
+                userStatus = '1'
+            AND
                 lastname LIKE CONCAT('%', %s, '%')"""
         self.exec_cmd(reqSearchConsultant, [lastname])
         return self.cur.fetchall()
@@ -84,16 +84,16 @@ class DbSearch(dbmain.DbMain):
     # Récupération des emploies associés à un pro
     def get_pro_job_by_proid(self, proId):
         reqGetAll = """
-            SELECT 
-                """ + self.TABLEUSERJOB + """.jobCategoryId, 
-                jobCategoryNameEn, jobCategoryNameFr 
-            FROM 
+            SELECT
+                """ + self.TABLEUSERJOB + """.jobCategoryId,
+                jobCategoryNameEn, jobCategoryNameFr
+            FROM
                 """ + self.TABLEUSERJOB + """
-            INNER JOIN 
+            INNER JOIN
                 """ + self.TABLEJOBCATEGORY + """
-            ON 
+            ON
                 """ + self.TABLEUSERJOB + """.jobCategoryId = """ + self.TABLEJOBCATEGORY + """.jobCategoryId
-            WHERE 
+            WHERE
                 userId = %s"""
         self.exec_cmd(reqGetAll, [proId])
         return self.cur.fetchall()
@@ -101,15 +101,15 @@ class DbSearch(dbmain.DbMain):
     # Récupération des notes d'un consultant par son nom
     def get_pro_note_by_proid(self, proId):
         reqCountMission = """
-            SELECT 
-                note 
-            FROM 
+            SELECT
+                note
+            FROM
                 """ + self.TABLEMISSION + """
-            INNER JOIN 
-                """ + self.TABLEUSERINFO + """ 
-            ON 
+            INNER JOIN
+                """ + self.TABLEUSERINFO + """
+            ON
                 """ + self.TABLEMISSION + """.proId = """ + self.TABLEUSERINFO + """.userId
-            WHERE 
+            WHERE
                 proId = %s"""
         self.exec_cmd(reqCountMission, [proId])
         return self.cur.fetchall()
@@ -120,9 +120,9 @@ class DbSearch(dbmain.DbMain):
     # Récupérer toutes les infos de la table jobCategory
     def get_job_all(self) -> list:
         reqGetAllJobs = """
-            SELECT 
-                * 
-            FROM 
+            SELECT
+                *
+            FROM
                 """ + self.TABLEJOBCATEGORY
         self.exec_cmd(reqGetAllJobs)
         return self.cur.fetchall()
@@ -130,9 +130,9 @@ class DbSearch(dbmain.DbMain):
     # Récupérer toutes les infos de la table jobCategory
     def get_job_by_jobid(self, jobId: int) -> list:
         reqGetJobinfo = """
-            SELECT 
-                * 
-            FROM 
+            SELECT
+                *
+            FROM
                 """ + self.TABLEJOBCATEGORY + """
             WHERE
                 jobCategoryId = %s"""