forked from Shravyabhat/DreamHouse-DBMS
-
Notifications
You must be signed in to change notification settings - Fork 0
/
loginRegister.py
43 lines (31 loc) · 979 Bytes
/
loginRegister.py
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
43
import mysql.connector
import os
from dotenv import load_dotenv
import tkinter as tk
load_dotenv()
mydb = mysql.connector.connect( host= "localhost",
user= os.getenv("DB_USER"),
password= os.getenv("DB_PASSWORD"),
database = os.getenv("DB_NAME")
)
dbCursor = mydb.cursor()
def validateUser(role, id):
dbCursor.execute(f"""SELECT * FROM {role} WHERE {role}_number = '{id}'""")
user = dbCursor.fetchone()
if user:
return True
else:
warningWindow("Login failed")
return False
# def registerStaff(id):
def warningWindow(message):
root = tk.Tk()
frame1 = tk.Frame(root)
root.title("Warning")
root.geometry('200x75')
label= tk.Label(frame1,text=message)
label.pack()
cancel = tk.Button(frame1,text="Cancel",command=root.destroy)
cancel.pack()
frame1.pack()
root.mainloop()