| 1234567891011121314151617181920212223242526272829303132333435363738394041 |
- 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}")
|
