import globalvar as gl

import cx_Oracle


app = gl.get_value("app")

# 连接参数。oracle
user_orcl = app.config.get('USER_ORCL')
password_orcl = app.config.get('PASSWORD_ORCL')
host_orcl = app.config.get('HOST_ORCL')
port_orcl = app.config.get('PORT_ORCL')
instance_orcl = app.config.get('INSTANCE_ORCL')


# 连接Oracle数据库
def connect_db_orcl():
    try:
        conn = cx_Oracle.connect(
            user_orcl, password_orcl,
            host_orcl + ':' + port_orcl + '/' + instance_orcl)
        print("oracle已连接")
    except Exception as e:
        app.logger.error(e)
    else:
        return conn
    return None


# 关闭Oracle数据库连接
def close_db_connection_orcl(conn):
    cur = conn.cursor()
    cur.close()
    conn.close()