BioHackersNet|
Size: 753
Comment:
|
← Revision 9 as of 2012-11-02 17:48:45 ⇥
Size: 1341
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 18: | Line 18: |
| 다음처럼 contextmanager로 만들어두면 with절로 쓰기 편하다. {{{#!python from contextlib import contextmanager import cx_Oracle @contextmanager def oraconn(): conn = cx_Oracle.connect('%s/%s' % (config.ORA_USER, config.ORA_PASSWD)) cursor = conn.cursor() try: yield cursor except: conn.rollback() raise else: conn.commit() finally: conn.close() with oraconn() as cursor: cursor.execute('...') }}} |
cx_Oracle, Python binding of Oracle
http://cx-oracle.sourceforge.net/
참고정보
python setup.py build 후, 오류메세지가 나오면, 아래 명령을 수행한 뒤 다시 해본다. --from AIX 에 cx_Oracle 설치하기
/usr/local/lib/python2.4/config/ld_so_aix cc_r -pthread -bI:/usr/local/lib/python2.4/config/python.exp build/temp.aix-5.2-2.4/cx_Oracle.o -L/oracle/product/9.2.0/lib32 -lclntsh -o build/lib.aix-5.2-2.4/cx_Oracle.so -s
각종 정보
다음처럼 contextmanager로 만들어두면 with절로 쓰기 편하다.
1 from contextlib import contextmanager
2 import cx_Oracle
3
4 @contextmanager
5 def oraconn():
6 conn = cx_Oracle.connect('%s/%s' % (config.ORA_USER, config.ORA_PASSWD))
7 cursor = conn.cursor()
8 try:
9 yield cursor
10 except:
11 conn.rollback()
12 raise
13 else:
14 conn.commit()
15 finally:
16 conn.close()
17
18 with oraconn() as cursor:
19 cursor.execute('...')