File size: 835 Bytes
e71e0a6 970e245 e71e0a6 970e245 e71e0a6 970e245 e71e0a6 970e245 e71e0a6 970e245 e71e0a6 | 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 | import sqlite3
conn = sqlite3.connect("users.db", check_same_thread=False)
cursor = conn.cursor()
cursor.execute("""
CREATE TABLE IF NOT EXISTS users (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT,
email TEXT UNIQUE,
password TEXT
)
""")
conn.commit()
def add_user(name, email, password):
try:
cursor.execute(
"INSERT INTO users (name,email,password) VALUES (?,?,?)",
(name, email, password)
)
conn.commit()
return True
except:
return False
def user_exists(email):
cursor.execute("SELECT * FROM users WHERE email=?", (email,))
return cursor.fetchone()
def verify_login(email, password):
cursor.execute(
"SELECT * FROM users WHERE email=? AND password=?",
(email, password)
)
return cursor.fetchone() |