Debian Codegraph @

examples/example_simple_sa.py

raw
1 import asyncio
2 import sqlalchemy as sa
3
4 from aiomysql.sa import create_engine
5
6
7 metadata = sa.MetaData()
8
9 tbl = sa.Table('tbl', metadata,
10 sa.Column('id', sa.Integer, primary_key=True),
11 sa.Column('val', sa.String(255)))
12
13
14 async def create_table(engine):
15 async with engine.acquire() as conn:
16 await conn.execute('DROP TABLE IF EXISTS tbl')
17 await conn.execute('''CREATE TABLE tbl (
18 id serial PRIMARY KEY,
19 val varchar(255))''')
20
21
22 async def go(loop):
23 engine = await create_engine(user='root', db='test_pymysql',
24 host='127.0.0.1', password='', loop=loop)
25 await create_table(engine)
26 async with engine.acquire() as conn:
27 await conn.execute(tbl.insert().values(val='abc'))
28 await conn.execute(tbl.insert().values(val='xyz'))
29
30 async for row in conn.execute(tbl.select()):
31 print(row.id, row.val)
32
33 await conn.execute("commit")
34
35 engine.close()
36 await engine.wait_closed()
37
38
39 loop = asyncio.get_event_loop()
40 loop.run_until_complete(go(loop))