Oracle database helper functions and utilities for ETL operations
Project description
ODM Oracle Helper
Oracle database utilities for ETL operations with decorators.
Installation
pip install odm-hlp-oracle
Usage
from odm_hlp_oracle import get_engine, load, call_procedure
# Get Oracle engine
engine = get_engine('dev', 'stg')
# Load data to table
load(engine, dataframe, 'table_name', dtype_dict)
# Call stored procedure
result = call_procedure(engine, 'procedure_name', [param1, param2])
Requirements
- Python 3.8+
- oracledb
- sqlalchemy
- odm-hlp-decorations
Configuration
Create a .env file with Oracle connection parameters:
dev_odm_tns=localhost:1521/XEPDB1
odm_usr_stg=username
odm_pass_stg=password
logs_path=./logs/
License
MIT
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
odm_hlp_oracle-1.0.0.tar.gz
(2.9 kB
view details)
Built Distribution
Filter files by name, interpreter, ABI, and platform.
If you're not sure about the file name format, learn more about wheel file names.
Copy a direct link to the current filters
File details
Details for the file odm_hlp_oracle-1.0.0.tar.gz.
File metadata
- Download URL: odm_hlp_oracle-1.0.0.tar.gz
- Upload date:
- Size: 2.9 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: poetry/2.2.1 CPython/3.13.7 Windows/2019Server
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
f0b3f1fc613dbaf2df7a97b9bfcdc69b9bba87df4f9cf98b5f381fb078e94cde
|
|
| MD5 |
a0a86179d81fc620a7bc7e186f5912bf
|
|
| BLAKE2b-256 |
bc651e06336dd223b3ca924c7e70f08f3119a4f37a7fd74ff47193be9737ffce
|
File details
Details for the file odm_hlp_oracle-1.0.0-py3-none-any.whl.
File metadata
- Download URL: odm_hlp_oracle-1.0.0-py3-none-any.whl
- Upload date:
- Size: 3.3 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via: poetry/2.2.1 CPython/3.13.7 Windows/2019Server
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
98223771999f091cb87b46a38d465f1350890efd99d71e05ef8ad70995f2e6dd
|
|
| MD5 |
a60a664da8fac5d08ea0e4f94945c936
|
|
| BLAKE2b-256 |
46f9ebc6fabe946de97030e404fa674ad083234eef1675783d09260c25289eae
|
