sql.execute("""CREATE TABLE IF NOT EXISTS waste_1 (
Walks BIGINT
)""")
db.commit()
sql.execute("""CREATE TABLE IF NOT EXISTS waste_2 (
Sticks BIGINT
)""")
db.commit()
sql.execute("""CREATE TABLE IF NOT EXISTS waste_3 (
Alcohol BIGINT
)""")
db.commit()
sql.execute("""CREATE TABLE IF NOT EXISTS waste_4 (
Subscriptions BIGINT
)""")
db.commit()
sql.execute("""CREATE TABLE IF NOT EXISTS waste_5 (
Taxi BIGINT
)""")
db.commit()
sql.execute("""CREATE TABLE IF NOT EXISTS waste_6 (
Food BIGINT
)""")
db.commit()
waste_1 = input('Walks: ')
waste_2 = input('Sticks: ')
waste_3 = input('Alcohol: ')
waste_4 = input('Subscriptions: ')
waste_5 = input('Taxi: ')
waste_6 = input('Food: ')
sql.execute("SELECT Walks From waste_1 ")
sql.execute("SELECT Sticks From waste_2 ")
sql.execute("SELECT Alcohol From waste_3 ")
sql.execute("SELECT Subscriptions From waste_4 ")
sql.execute("SELECT Taxi From waste_5 ")
sql.execute("SELECT Food From waste_6 ")
if sql.fetchone() is None:
sql.execute(f"INSERT INTO waste VALUES (?,?,?), (waste_1, waste_2 )")
db.commit()
print([writline])
else:
print('Идентичная запись имееться')