Debian Codegraph @

examples/example_executemany_oldstyle.py

raw
1 import asyncio
2 import aiomysql
3
4
5 loop = asyncio.get_event_loop()
6
7
8 @asyncio.coroutine
9 def test_example_executemany():
10 conn = yield from aiomysql.connect(host='127.0.0.1', port=3306,
11 user='root', password='',
12 db='test_pymysql', loop=loop)
13
14 cur = yield from conn.cursor()
15 yield from cur.execute("DROP TABLE IF EXISTS music_style;")
16 yield from cur.execute("""CREATE TABLE music_style
17 (id INT,
18 name VARCHAR(255),
19 PRIMARY KEY (id));""")
20 yield from conn.commit()
21
22 # insert 3 rows one by one
23 yield from cur.execute("INSERT INTO music_style VALUES(1,'heavy metal')")
24 yield from cur.execute("INSERT INTO music_style VALUES(2,'death metal');")
25 yield from cur.execute("INSERT INTO music_style VALUES(3,'power metal');")
26 yield from conn.commit()
27
28 # insert 3 row by one long query using *executemane* method
29 data = [(4, 'gothic metal'), (5, 'doom metal'), (6, 'post metal')]
30 yield from cur.executemany(
31 "INSERT INTO music_style (id, name)"
32 "values (%s,%s)", data)
33 yield from conn.commit()
34
35 # fetch all insert row from table music_style
36 yield from cur.execute("SELECT * FROM music_style;")
37 result = yield from cur.fetchall()
38 print(result)
39
40 yield from cur.close()
41 conn.close()
42
43
44 loop.run_until_complete(test_example_executemany())