Re: Python Multiline

[Tobin Cataldo]

Either execute the commands one at a time via a loop or try to use the alternative executemany method as defined in the DB API 2.0 spec (http://www.python.org/dev/peps/pep-0249/).

.executemany(operation,seq_of_parameters)

Prepare a database operation (query or command) and then
execute it against all parameter sequences or mappings
found in the sequence seq_of_parameters.

Modules are free to implement this method using multiple
calls to the execute() method or by using array operations
to have the database process the sequence as a whole in
one call.

Use of this method for an operation which produces one or
more result sets constitutes undefined behavior, and the
implementation is permitted (but not required) to raise
an exception when it detects that a result set has been
created by an invocation of the operation.

The same comments as for execute() also apply accordingly
to this method.

Return values are not defined.