32 lines
964 B
Python
32 lines
964 B
Python
import sqlite3
|
|
import os
|
|
put = os.path.dirname(os.path.realpath(__file__)) + "/" #Путь- (part-1)
|
|
DB_PATH = put + "data.sqlite3"
|
|
bd = sqlite3.connect(DB_PATH)
|
|
sql = bd.cursor()
|
|
|
|
sql.execute("""CREATE TABLE IF NOT EXISTS rs_user (
|
|
user_id INTEGER PRIMARY KEY AUTOINCREMENT,
|
|
user_name TEXT NOT NULL,
|
|
email TEXT,
|
|
password TEXT,
|
|
avatar INTEGER NOT NULL DEFAULT 0,
|
|
active INTEGER NOT NULL DEFAULT 0
|
|
);""")
|
|
sql.close()
|
|
|
|
def check_user(email: str, password: str):
|
|
conn = sqlite3.connect(DB_PATH)
|
|
conn.row_factory = sqlite3.Row
|
|
try:
|
|
row = conn.execute(
|
|
"SELECT user_id, user_name, active FROM rs_user WHERE email = ? AND password = ?",
|
|
(email, password),
|
|
).fetchone()
|
|
|
|
if row is None:
|
|
return None, None, None
|
|
return int(row["user_id"]), row["user_name"], int(row["active"])
|
|
finally:
|
|
conn.close()
|
|
|