On Thu, May 27, 2010 at 12:56 PM, MRAB <pyt...@mrabarnett.plus.com> wrote:
> 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.
>>
>> Yes it did. Thanks. Also figured out the "import logging" :-}
beno
--
http://mail.python.org/mailman/listinfo/python-list
