aiosqlite error how to fix?

Question

Python

I tried to make an automatic code for sending requests as in SQLite3 (Everything worked fine there) and an error appeared, I suffered for 30 minutes and did not understand what the problem was :(

async def post_sql_query_fetchone(call): #1 значение
    async with aiosqlite.connect("all.db") as cu:
        try:
            await cu.execute(call)
        except Error:
            pass
        result = await cu.fetchone()
        return(result)

def create_tables():
    users_query = '''CREATE TABLE IF NOT EXISTS USERS
                        (id INTEGER PRIMARY KEY NOT NULL);'''
    post_sql_query_fetchone(users_query)

create_tables()

Error:

RuntimeWarning: coroutine 'post_sql_query_fetchone' was never awaited
post_sql_query_fetchone(users_query)
RuntimeWarning: Enable tracemalloc to get the object allocation traceback

Answer 1

post_sql_query_fetchone returns a coroutine that you don't execute in the event loop. Don't use async libraries if you don't know asyncio.