import sqlite3

db = sqlite3.connect("D:\\_gogs\\up\\ОАиП\\2025-26\\36гр\\1 сем\\users.db")

# объект, предназначенный для работы с SQL
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 ('Литвинова-Стадник', \"Снежана\", 'u23-27litvon0va', '1111');")
# db.commit()

# cur.execute("INSERT INTO users (fam, name, login, pass) VALUES ('Трофимова', 'Arina', 'trofimova_arina', '1234');")
# cur.execute("INSERT INTO users (fam, name, login, pass) VALUES ('Guzeev', 'Ivan', '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}")

"""

"""
cur.execute("SELECT id, fam FROM users")
user_id, fam = cur.fetchone()
print(f"Логин {fam} под ID#{user_id}")
"""

cur.execute("SELECT * FROM users where id=1")
users_list = cur.fetchall()
for users_item in users_list:
    user_id, fam, name, login, user_pass = users_item
    print(f"Логин {fam} под ID#{user_id} = {login}")