diff options
| author | Debulois <quentin@debulois.fr> | 2022-04-24 17:16:05 +0200 |
|---|---|---|
| committer | Debulois <quentin@debulois.fr> | 2022-04-24 17:16:05 +0200 |
| commit | 6104a59cbdf6474acea6a8a1d4c865f3d88d2296 (patch) | |
| tree | 2920dea1346aafb041643d87ba1bb6dc1a813ee2 /src/database/dbsearch.py | |
| parent | 4c4f70bf6eb88a419add86e182d3080674196433 (diff) | |
Mise en place du système de connexion / enregistrement
Diffstat (limited to 'src/database/dbsearch.py')
| -rw-r--r-- | src/database/dbsearch.py | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/src/database/dbsearch.py b/src/database/dbsearch.py index 15d4a24..3089bf1 100644 --- a/src/database/dbsearch.py +++ b/src/database/dbsearch.py @@ -9,7 +9,7 @@ # https:#www.freecodecamp.org/news/sql-joins-tutorial/ # Import de dbmain -from . import dbmain +from src.database import dbmain # Extension de cette classe avec dbmain @@ -18,7 +18,7 @@ class DbSearch(dbmain.DbMain): # RECUPERATION DES INFORMATIONS RELATIVES AUX UTILISATEURS # **************************************************************************** # Récupération des infos d'un compte par son id - def get_user_account_by_userid(self, userId): + def get_user_account_by_userid(self, userId: int) -> list: reqSearchUser = """ SELECT userId, email, inscriptionDate, userStatus @@ -30,7 +30,7 @@ class DbSearch(dbmain.DbMain): return self.cur.fetchall() # Récupération des infos d'un utilisateur par son id - def get_user_info_by_userid(self, userId): + def get_user_info_by_userid(self, userId: int) -> list: reqGetUserInfo = """ SELECT userId, lastname, firstname, degree, @@ -118,7 +118,7 @@ class DbSearch(dbmain.DbMain): # RECUPERATION DES INFORMATIONS RELATIVES AUX EMPLOIS # **************************************************************************** # Récupérer toutes les infos de la table jobCategory - def get_job_all(self): + def get_job_all(self) -> list: reqGetAllJobs = """ SELECT * @@ -128,7 +128,7 @@ class DbSearch(dbmain.DbMain): return self.cur.fetchall() # Récupérer toutes les infos de la table jobCategory - def get_job_by_jobid(self, jobId): + def get_job_by_jobid(self, jobId: int) -> list: reqGetJobinfo = """ SELECT * |