Spaces:
Sleeping
Sleeping
File size: 1,107 Bytes
df218ae |
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 44 45 46 47 48 49 50 51 52 53 54 55 |
import sqlite3
def create_connection():
conn = sqlite3.connect("user_data.db")
return conn
def create_table():
conn = create_connection()
cursor = conn.cursor()
cursor.execute("""
CREATE TABLE IF NOT EXISTS users(
id INTEGER PRIMARY KEY AUTOINCREMENT,
username TEXT UNIQUE NOT NULL,
password TEXT NOT NULL
)
""")
conn.commit()
conn.close()
def add_user(username, password):
conn = create_connection()
cursor = conn.cursor()
cursor.execute("""
INSERT INTO users(username, password) VALUES (?, ?)
""", (username, password))
conn.commit()
conn.close()
def peek():
conn = create_connection()
cursor = conn.cursor()
cursor.execute("""
SELECT * FROM users
""")
users = cursor.fetchall()
for user in users:
print(user)
conn.close()
def verify_user(username, password):
conn = create_connection()
cursor = conn.cursor()
cursor.execute("""
SELECT * FROM users
WHERE username = ? AND password = ?
""", (username, password))
user = cursor.fetchone()
conn.close()
return user |