Guest User

Untitled

a guest
Jan 14th, 2019
108
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.74 KB | None | 0 0
  1. TypeError: not all arguments converted during string formatting
  2.  
  3. import asyncio
  4. import aiomysql
  5. import string
  6.  
  7. keys=list(string.ascii_uppercase)[0:23]
  8.  
  9.  
  10. async def test_example_executemany(loop):
  11. conn = await aiomysql.connect(host='127.0.0.1', port=3306,
  12. user='root', password='',
  13. db='mint_loan', loop=loop)
  14. cur = await conn.cursor()
  15. #val=tuple(['S']*23)
  16. async with conn.cursor() as cur:
  17. await cur.executemany("INSERT INTO ABC ("+','.join(keys)+")"+"values ("+','.join(tuple(['%s'] * len(keys)))+")", ['AB']*23)
  18. await conn.commit()
  19. conn.close()
  20.  
  21.  
  22. loop = asyncio.get_event_loop()
  23. loop.run_until_complete(test_example_executemany(loop))
Add Comment
Please, Sign In to add comment