Skip to content

Instantly share code, notes, and snippets.

@jannson
Last active November 29, 2015 06:21
Show Gist options
  • Save jannson/0a3fd04a8a2758053ee8 to your computer and use it in GitHub Desktop.
Save jannson/0a3fd04a8a2758053ee8 to your computer and use it in GitHub Desktop.
def insert_sample(table, sample):
place_holder = ",".join(["{%d} " % idx for idx, _ in enumerate(sample.values())])
columns = ", ".join(sample.keys())
sql = "insert into `%s` (%s) values(%s)" % (table, columns, place_holder)
exec_sql = sql.format(*sample.values())
print exec_sql
cursor.execute(exec_sql)
insert_sample('firmware', {"aaa":"bbb","ccc":"ddd"})
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment