python-oracledb Examples in a Container

This Dockerfile creates a container with python-oracledb samples and a running Oracle Database.

Python-oracledb is the Python database driver for Oracle Database. See https://oracle.github.io/python-oracledb/.

Usage

Get an Oracle Database container (see https://hub.docker.com/r/gvenzl/oracle-xe):
```
podman pull docker.io/gvenzl/oracle-xe:21-slim
```
Create a container with the database, Python, python-oracledb and the samples. Choose a password for the sample schemas and pass it as an argument:
```
podman build -t cjones/pyo --build-arg PYO_PASSWORD=a_secret .
```
Start the container, which creates the database. Choose a password for the privileged database users and pass it as a variable:
```
podman run -d --name pyo -p 1521:1521 -it -e ORACLE_PASSWORD=a_secret_password cjones/pyo
```
Log into the container:
```
podman exec -it pyo bash
```
At the first login, create the sample schema:
```
python setup.py
```
The schema used can be seen in sql/create_schema.sql
In the container, run samples like:
```
python bind_insert.py
```
Use vim to edit files, if required.

The database will persist across container shutdowns, but will be deleted when the container is deleted.

Python-oracledb is the new name for Oracle's popular Python cx_Oracle driver for Oracle Database.
Python-oracledb 1.0 is a new major release - the successor to cx_Oracle 8.3.
Python-oracledb is simple and small to install — under 15 MB (including Python package dependencies): pip install oracledb
Python-oracledb is now a Thin driver by default - it connects directly to Oracle Database without always needing Oracle Client libraries.
Python-oracledb has comprehensive functionality conforming to the Python Database API v2.0 Specification, with many additions and just a couple of exclusions.
A "Thick" mode can be optionally enabled by an application call. This mode has similar functionality to cx_Oracle and supports Oracle Database features that extend the Python DB API. To use this mode, the widely used and tested Oracle Client libraries such as from Oracle Instant Client must be installed separately.
Python-oracledb runs on many platforms including favorites like Linux, macOS and Windows. It can also be used on platforms where Oracle Client libraries are not available (such as Apple M1, Alpine Linux, or IoT devices), or where the client libraries are not easily installed (such as some cloud environments).

Name		Name	Last commit message	Last commit date
Latest commit History 4 Commits
Dockerfile		Dockerfile
LICENSE		LICENSE
README.md		README.md
setup.py		setup.py