abstraction for ETL Database interaction
Project description
easy_database
description
This is a personal package used to hold code patterns used for relational ETL database access.
Usage
environment setup
pyenv install 3.8.0
pyenv virtualenv 3.8.0 app_3.8
pyenv activate app_3.8
# for integration tests
export PASSWORD=testing1234
export USERNAME=testing1234
export DATABASE=testing1234
export TABLE=customers
export INTEGRATION_TEST=True
export DB_IP_ADDRESS=127.0.0.1
export DATABASE_TYPE=postgresql
sudo --preserve-env docker-compose up
python
import easy_database.database as db
database_manager = db.database_factory("postgresql")
database_manager.set_connection_string("...")
database_manager.open_conn()
database_manager.send_sql("SELECT * FROM TEST;")
database_manager.close_conn()
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
easy_database-1.1.7.tar.gz
(4.1 kB
view hashes)
Built Distribution
Close
Hashes for easy_database-1.1.7-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 300f90e13b5c4504a1b7c1dfbb67f54b900458ddd6340d39592f93910c4fcb52 |
|
MD5 | cf62db79acf8cc8bff07c974732a1dc7 |
|
BLAKE2b-256 | 6ddc26e6c75d5b730e1b7b9f9f9bdc4cca33272bee0ef8ed29edb9e8848a4d18 |