File size: 1,273 Bytes
915b731 2b79f7a 0b93878 915b731 a198937 2b79f7a a198937 2b79f7a 915b731 a198937 2b79f7a a198937 915b731 a198937 2b79f7a 3f94976 a198937 2b79f7a |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 |
# /modules/auth.py
import streamlit as st
import pymssql
from modules.db_connection import get_db_connection
# Funci贸n para registrar un nuevo usuario
def register_user(username, password, role):
conn = get_db_connection()
cursor = conn.cursor()
try:
cursor.execute("INSERT INTO Users (Username, Password, Role) VALUES (%s, %s, %s)", (username, password, role))
conn.commit()
return True
except pymssql.IntegrityError:
return False
finally:
cursor.close()
conn.close()
# Funci贸n para autenticar un usuario
def authenticate_user(username, password):
conn = get_db_connection()
cursor = conn.cursor()
try:
cursor.execute("SELECT UserID, Role FROM Users WHERE Username = %s AND Password = %s", (username, password))
user = cursor.fetchone()
return bool(user)
finally:
cursor.close()
conn.close()
# Funci贸n para obtener el rol del usuario
def get_user_role(username):
conn = get_db_connection()
cursor = conn.cursor()
try:
cursor.execute("SELECT Role FROM Users WHERE Username = %s", (username,))
role = cursor.fetchone()
return role[0] if role else None
finally:
cursor.close()
conn.close() |