How can i add oracle client in PATH in docker container using python?

Viewed 23

Please tell me, how can i add oracle client in PATH in docker container using python?

A normal way to add oracle client path to "PATH" vars using python is:

def create_connection():

    ip, port, service_name, login, password = 'server', 'port', 'db', 'lab', 'pass'

    x = os.path.abspath(os.curdir) 
    client_path = str(os.path.dirname(os.path.dirname(x)))+'\Oracle.client.x64.19.3'
    os.environ["PATH"] = client_path + ";" + os.environ["PATH"] #This row is adding client to PATH

    dsn_tns = cx_Oracle.makedsn(ip, port, service_name)
    con = cx_Oracle.connect(login, password, dsn_tns, encoding='UTF-8')

    cur = con.cursor()

    engine = create_engine('oracle+cx_oracle://%s:%s@%s' % (login, password, dsn_tns))

    return con, cur, engine

But how can i do this in docker container, provided that oracle client located at the root of the project?

0 Answers
Related