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?