Code: Alles auswählen
def insertTableColumnsData(self,colList,valueList):
sql = "insert into tfoo (%(cols)s) values (%(placeholders)s)" % {
"cols" = ", ".join(colList),
"placeholders" = ", ".join(["%s"] * len(colList))
}
self.con.cursor().execute(sql, tuple(valueList))
self.con.commit()
EDIT: oder einfach so:
Code: Alles auswählen
def insertTableColumnsData(self,colList,valueList):
sql = "insert into tfoo (%s) values (%s)" % [
", ".join(colList), ", ".join(["%s"] * len(colList))
]
self.con.cursor().execute(sql, tuple(valueList))
self.con.commit()