up/ОАиП/2024-25/36гр/тест.py

import sqlite3

db = sqlite3.connect("D:\\_gogs\\up\\ОАиП\\2024-25\\36гр\\users.db")

cur = db.cursor()

"""
cur.execute("CREATE TABLE users (id INTEGER NOT NULL PRIMARY KEY, fam TEXT NOT NULL, name TEXT NOT NULL, login TEXT NOT NULL, pass TEXT NOT NULL);")
db.commit()

cur.execute("INSERT INTO users (fam, name, login, pass) VALUES ('Байдукова', \"Ксения\", 'baydukova', '1111');")
db.commit()


cur.execute("INSERT INTO users (fam, name, login, pass) VALUES ('Шишкова', 'Anastasiya', 'shiskova', '1234');")
cur.execute("INSERT INTO users (fam, name, login, pass) VALUES ('Ermolenko', 'Artyom', 'ermolka', 911);")
db.commit()

cur.execute("UPDATE users SET 'login'='ermolenko' WHERE id=3;")
db.commit()

"""
cur.execute("SELECT * FROM users")
user_id, fam, name, login, user_pass = cur.fetchone()

print(f"Логин {fam} под ID#{user_id} = {login}")