可以同时执行多个语句,但它是半hacky.您需要包装语句并一次执行一个语句.
>>> import cx_Oracle
>>>
>>> a = cx_Oracle.connect('schema/pw@db')
>>> curs = a.cursor()
>>> SQL = (("""create table tmp_test ( a date )"""),
... ("""insert into tmp_test values ( sysdate )""")
... )
>>> for i in SQL:
... print i
...
create table tmp_test ( a date )
insert into tmp_test values ( sysdate )
>>> for i in SQL:
... curs.execute(i)
...
>>> a.commit()
>>>
正如您所指出的,这并不能解决分号问题,因为没有简单的答案.在我看来,你有3个选择:
>编写一个过于复杂的解析器,我认为这根本不是一个好选择.
>不要从Python执行SQL脚本;将代码放在单独的SQL脚本中,以便解析很容易,在单独的Python文件中,嵌入在Python代码中,在数据库中的过程中…等等.这可能是我的首选选项.
>使用子进程并以这种方式调用脚本.这是最简单,最快捷的选项,但根本不使用cx_Oracle.
>>> import subprocess
>>> cmdline = ['sqlplus','schema/pw@db','@','tmp_test.sql']
>>> subprocess.call(cmdline)
SQL*Plus: Release 9.2.0.1.0 - Production on Fri Apr 13 09:40:41 2012
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle Database 11g Release 11.2.0.1.0 - 64bit Production
SQL>
SQL> CREATE TABLE FOO(id number);
Table created.
SQL>
SQL> BEGIN
2 INSERT INTO FOO VALUES(1);
3 INSERT INTO FOO VALUES(2);
4 INSERT INTO FOO VALUES(3);
5 END;
6 /
PL/SQL procedure successfully completed.
SQL> CREATE TABLE BAR(id number);
Table created.
SQL>
SQL> quit
Disconnected from Oracle Database 11g Release 11.2.0.1.0 - 64bit Production
0
>>>