通过sqlalchemy执行时启用执行多个语句 [英] Enable executing multiple statements while execution via sqlalchemy
问题描述
我有一个包含创建函数语句的DDL对象(create_function_foo
).在它的第一行中,我放入了DROP FUNCTION IF EXISTS foo;
,但engine.execute(create_function_foo)
返回:
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
我将multi=True
用作create_engine
,engine.execute_options
和engine.execute
的参数,但是它不起作用.
I put multi=True
as parameter for create_engine
, engine.execute_options
and engine.execute
but it doesn't work.
注意:如果我的create_engine
注意:我正在使用python 3.2 + mysql.connector 1.0.12 + sqlalchemy 0.8.2
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
""")
我应该放在哪里?
推荐答案
multi=True
是MySql连接器的要求.您不能设置将此标志传递给SQLAlchemy方法.这样做:
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)
此处的更多信息: http://www.mail-archive. com/sqlalchemy@googlegroups.com/msg30129.html
这篇关于通过sqlalchemy执行时启用执行多个语句的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!