python执行多个sql语句_通过sqlalchemy执行时启用执行多个语句

I have a DDL object (create_function_foo) that contains a create function statement. In first line of it I put DROP FUNCTION IF EXISTS foo; but engine.execute(create_function_foo) returns:

sqlalchemy.exc.InterfaceError: (InterfaceError) Use multi=True when executing multiple statements

I put multi=True as parameter for create_engine, engine.execute_options and engine.execute but it doesn't work.

NOTE: engine if my instance of create_engine

NOTE: I'm using python 3.2 + mysql.connector 1.0.12 + sqlalchemy 0.8.2

create_function_foo = DDL("""\

DROP FUNCTION IF EXISTS foo;

CREATE FUNCTION `foo`(

SID INT

) RETURNS double

READS SQL DATA

BEGIN

...

END

""")

Where I should put it?

解决方案

multi=True is a requirement for MySql connector. You can not set this flag passing it to SQLAlchemy methods. Do this:

conn = session.connection().connection

cursor = conn.cursor() # get mysql db-api cursor

cursor.execute(sql, multi=True)