import sqlite3
import random
db = sqlite3.connect('users.db')
cur = db.cursor()
cur.execute("""CREATE TABLE IF NOT EXISTS orders(
orderid INT PRIMARY KEY,
date TEXT,
userid TEXT,
total TEXT);
""")
db.commit()
a=[]
def paf():
for i in range(1,100000):
a.append(i)
global b
b=random.choice(a)
paf
cur.execute("""CREATE TABLE IF NOT EXISTS users(
userid INT PRIMARY KEY,
fname TEXT,
lname TEXT,
gender TEXT);
""")
db.commit()
cur.execute("select userid from users where userid=?", ("196",))
data = cur.fetchall()
if not data:
pass
user = (b, input("имя:"), input("фамилия:"), input("пол:"))
cur.execute("INSERT INTO users VALUES(?, ?, ?, ?);", user)
db.commit()