oracle 轻量级python连接驱动

version: '3'

services:

  oracle:

     image:  container-registry.oracle.com/database/express:21.3.0-xe

     ports:

       - 1521:1521

     volumes:

       - ./data:/opt/oracle/oradata

     environment:

       - ORACLE_PWD=Ccda5662E

       - ORACLE_CHARACTERSET=AL32UTF8

       - ORACLE_EDITION=xe

       - ORACLE_SID=XE

import oracledb

import os

un = os.environ.get('PYTHON_USERNAME')

pw = os.environ.get('PYTHON_PASSWORD')

cs = os.environ.get('PYTHON_CONNECTSTRING')

with oracledb.connect(user=un, password=pw, dsn=cs) as connection:

    with connection.cursor() as cursor:

        sql = """select 'dalong' from dual"""

        for r in cursor.execute(sql):

            print(r)

export PYTHON_USERNAME=system

export PYTHON_PASSWORD=Ccda5662E

export PYTHON_CONNECTSTRING=localhost/xe