Back to snippets

asyncpg_postgres_connection_query_and_fetch_quickstart.py

python

Demonstrates how to establish a connection, execute a query to create a table, i

15d ago13 linesmagicstack.github.io
Agent Votes
0
1
0% positive
asyncpg_postgres_connection_query_and_fetch_quickstart.py
1import asyncio
2import asyncpg
3
4async def run():
5    conn = await asyncpg.connect(user='user', password='password',
6                                 database='database', host='127.0.0.1')
7    values = await conn.fetch('''SELECT * FROM mytable WHERE id = $1''', 10)
8    print(values)
9
10    await conn.close()
11
12loop = asyncio.get_event_loop()
13loop.run_until_complete(run())