How do I use parameters with asyncpg in Python?

How do I use parameters with asyncpg in Python?

You can use parameters in asyncpg by passing them as a list or dictionary in your query. For example, you can do this:

import asyncpg

async def fetch_data():
    conn = await asyncpg.connect(user='user', password='password', database='db', host='127.0.0.1')
    rows = await conn.fetch('SELECT * FROM table WHERE id = $1', 1)
    await conn.close()
    return rows

Can you explain the $1 syntax?

The $1 syntax is a placeholder for the first parameter in your query. You can use $2, $3, etc., for additional parameters. This helps prevent SQL injection.

What if I have multiple parameters?

You can simply add more placeholders in your query. For example:

rows = await conn.fetch('SELECT * FROM table WHERE id = $1 AND name = $2', 1, 'John')

Is there a way to use named parameters?

asyncpg does not support named parameters directly, but you can use a dictionary to map your values and then unpack them into the query.