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/dbuser.py | |
| parent | 4c4f70bf6eb88a419add86e182d3080674196433 (diff) | |
Mise en place du système de connexion / enregistrement
Diffstat (limited to 'src/database/dbuser.py')
| -rw-r--r-- | src/database/dbuser.py | 23 |
1 files changed, 12 insertions, 11 deletions
diff --git a/src/database/dbuser.py b/src/database/dbuser.py index e0a62fb..e71d936 100644 --- a/src/database/dbuser.py +++ b/src/database/dbuser.py @@ -10,7 +10,7 @@ from datetime import datetime from passlib.hash import sha512_crypt # Import de dbmain -from . import dbmain +from src.database import dbmain # Extension de cette classe avec dbmain class DbUser(dbmain.DbMain): @@ -19,28 +19,29 @@ class DbUser(dbmain.DbMain): # GESTION DES UTILISATEURS # **************************************************************************** # Enregistrement d'un nouvel utilisateur - def register_user(self, email, password, userStatus): + def register_user(self, email: str, password: str, userStatus: int) -> int: # On vérifie si l'email existe deja dans la bdd exist = self.check_exist_email(email) # Si non if not exist: # Chiffrement du pass - hash = self.crypt_pass(password) + passwordHash = self.crypt_pass(password) # Préparation de la requète - reqAddUser = """"" + reqAddUser = """ INSERT INTO """ + self.TABLEUSERACCOUNT + """ (email, password, inscriptionDate, userStatus) VALUES (%s, %s, %s, %s)""" # Execution de la requète - self.exec_cmd(reqAddUser, - [email, - hash, - datetime.now().strftime("%Y-%m-%d %H:%M:%S"), - userStatus - ] - ) + self.exec_cmd( + reqAddUser, + [email, + passwordHash, + datetime.now().strftime("%Y-%m-%d %H:%M:%S"), + userStatus], + True + ) # Retourne 1 pour réussite return 1 else: |