Import sqlite3 as sq from create_bot import dp, bot base = sq.connect("shop.dp") cur

Question

Import sqlite3 as sq from create_bot import dp, bot base = sq.connect("shop.dp") cur

= base.cursor()

def start():
global base, cur
if base:
print("data base connector OK!")
base.execute("CREATE TABLE IF NOT EXISTS katalog(img TEXT, name TEXT PRIMARY KEY, description TEXT, price TEXT)")
base.commit()

async def sql_add_cmd(state):
async with state.proxy() as data:
cur.execute("INSERT INTO katalog VALUES (?, ?, ?, ?)", tuple(data.values()))
base.commit()

async def sql_read(message):
for ret in cur.execute("SELECT * FROM katalog").fetchall():
await bot.send_photo(message.from_user.id, ret[0], f"{ret[1]}\nОписание: {ret[2]}\nЦена {ret[-1]}")

async def sql_del(state):
cur.execute("DELETE FROM katalog WHERE name= ?;", (name_del, ))