Kushal Kumaran wrote:
[snip]
Since I'm in a good mood today, here's a little present:
def insert(cursor, table, columns, values):
"""Insert a row into a table. columns must be a list of column
names. values must be a list of values for the new row. The
columns and values must correspond."""
assert len(columns) == len(values)
stmt = """
insert into %s (%s) values (%s)
""" % (table,
', '.join(columns),
', '.join('%s' * len(values)))
That should be:
', '.join(['%s'] * len(values)))
logging.debug('stmt: %s, values: %s' % (stmt, values))
cursor.execute(stmt, values)
Hope it helps.
--
http://mail.python.org/mailman/listinfo/python-list
