Code to Aid the Upgrade to python-oracledb

admin

The sample oracledb_upgrade.py shows a way to toggle applications between cx_Oracle and the two python-oracledb modes.

1. # test.py
   
2. 
   
3. import oracledb_upgrade as cx_Oracle
   
4. import os
   
5. 
   
6. un = os.environ.get("PYTHON_USERNAME")
   
7. pw = os.environ.get("PYTHON_PASSWORD")
   
8. cs = os.environ.get("PYTHON_CONNECTSTRING")
   
9. 
   
10. connection = cx_Oracle.connect(user=un, password=pw, dsn=cs)
    
11. with connection.cursor() as cursor:
    
12.     sql = """SELECT UNIQUE CLIENT_DRIVER
    
13.              FROM V$SESSION_CONNECT_INFO
    
14.              WHERE SID = SYS_CONTEXT('USERENV', 'SID')"""
    
15.     for r, in cursor.execute(sql):
    
16.         print(r)

複製代碼

You can then choose what mode is in use by setting the environment variable ORA_PYTHON_DRIVER_TYPE to one of “cx”, “thin”, or “thick”:

export ORA_PYTHON_DRIVER_TYPE=thin
python test.py

Output shows the python-oracledb Thin mode was used:
python-oracledb thn : 1.0.0Testing Which Driver is in Use

1. import oracledb as cx_Oracle
   
2. # or:
   
3. # import cx_Oracle
   
4. 
   
5. if cx_Oracle.__name__ == 'cx_Oracle':
   
6.        print('cx_Oracle')
   
7. else:
   
8.        print('oracledb')

複製代碼