Hi,

I've got a whole script full of SQL for Firebird that I want to execute
from python with fdb. Is there a way?

The sqlite3 module has an 'executescript' extension for this.

Currently I'm using sqlparse to split the script into individual
statements and executing those individually. There are two problems I've
run into so far;

1. Any COMMIT statement causes the following commands to fail with an
"SQL error code = -901\n- invalid transaction handle (expecting explicit
transaction start" error. I've trapped those and converted them to
cursor.commit() which is ugly; there must be a better way.

2. Now I'm trying to declare a procedure in the SQL, which requires SET
TERM before and after, and sqlparse can't grok that.


Any suggestions?


Thanks

Hamish