Reputation: 966
For example i have some sql query:
INSERT INTO categories(category, sub_category)
SELECT category, sub_category
FROM (SELECT "category" as category, "Final" as sub_category) temp
WHERE NOT EXISTS (SELECT 1 FROM categories WHERE categories.category = temp.category AND categories.sub_category = temp.sub_category)
I execute it like this:
async with aiosqlite.connect('categories.db') as db:
await db.execute(sql)
await db.commit()
But i have nothing in output.
Can i somehow get status of this execute like insertion complete
or something else?
Upvotes: 0
Views: 1379