python 连接Oracle数据库，cx_Oracle

python 连接Oracle数据库

from cx_Oracle import makedsn, Connection, Cursor
import cx_Oracle

dsn = makedsn(dev_host, port, service_name=dev_service_name)


def get_connection() -> Connection:
    connection: Connection = cx_Oracle.connect(dev_user, dev_pw, dsn)
    return connection


def get_curs(connection: Connection) -> Cursor:
    cursor: Cursor = connection.cursor()
    return cursor


if __name__ == '__main__':
	sql = f"""insert into xxxx""
	conn = get_connection()
	cur: Cursor = conn.cursor()
	try:
		# insert
		cur.execute(sql)
		conn.commit()
		## get
		# cur.execute(sql)
		# data = cur.fetchall()
    except Exception as e:
        conn.rollback()
    finally:
        cur.close()
        conn.close()