Subject Re: [firebird-python] execute a whole script
Author Philippe Makowski
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?
>
certainly,

> The sqlite3 module has an 'executescript' extension for this.
>
we don't, but feel free to help to write it ;)

> Any suggestions?
>
just format your script in a way it can be splitted, using for example '§'

and do something like :
f = open('tabledefinition.sql')
full_sql = f.read()
sql_commands = full_sql.split('§')

for sql_command in sql_commands:
if sql_command == 'COMMIT':
myconnection.commit()
else:
myconnection.execute_immediate(sql_command)

you got the idea