How to pass limit and offset values ​​to select sqlite function?

Question

Python

async def select_all (one, two):
  async with aiosqlite.connect('db') as conn:
    cursor = await conn.execute("SELECT * FROM table WHERE a=b LIMIT one OFFSET two"
    row = await cursor.fetchall()
    return row

Sobsno, it gives an error - sqlite3.OperationalError: no such column: one
Through %s the same way .. but how should it be?

Answer 1

Apparently, something was not written correctly the first time with %s
Here is the solution:

async def select_all (par, part):
    async with aiosqlite.connect('db') as conn:
        cursor = await conn.execute("SELECT * FROM table WHERE a=b LIMIT %s OFFSET %s" % (par, part)
        row = await cursor.fetchall()
        return row