- Notifications
You must be signed in to change notification settings - Fork39
Open
Description
To insert mutliple values at once there is the sqlccopyfrom, but it it is unsupported in sqlc-gen-python
But it should be quite easy to implement using anexecutemany statement:
https://stackoverflow.com/questions/13020908/sql-multiple-inserts-with-python
rows= []forrowinrange(sheet.nrows):"""name is in the 0th col. email is the 4th col."""name=sheet.cell(row,0).valueemail=sheet.cell(row,4).valuerows.append((name,email))db=MySQLdb.connect(host=host,user=user,db=dbname,passwd=pwd)cursor=db.cursor()cursor.executemany("""INSERT INTO mailing_list (name,email) VALUES (%s,%s)""",rows)
Metadata
Metadata
Assignees
Labels
No labels