Debian Codegraph @

examples/example_callproc.py

raw
1 import asyncio
2 import aiomysql
3
4
5 async def test_example(loop):
6 conn = await aiomysql.connect(host='127.0.0.1', port=3306,
7 user='root', password='',
8 db='test_pymysql', loop=loop)
9
10 async with conn.cursor() as cur:
11 await cur.execute('DROP PROCEDURE IF EXISTS myinc;')
12 await cur.execute("""CREATE PROCEDURE myinc(p1 INT)
13 BEGIN
14 SELECT p1 + 1;
15 END""")
16
17 await cur.callproc('myinc', [1])
18 (ret, ) = await cur.fetchone()
19 assert 2, ret
20 print(ret)
21
22 conn.close()
23
24
25 loop = asyncio.get_event_loop()
26 loop.run_until_complete(test_example(loop))