wdb_utils
Utilities for querying an Oracle, Snowflake, or Postgres database. Gradually expanding to more database types.
All the methods in this package require a yaml config file. For convenience, we assume this file is located in /Users/username/configs/config-default.yml.
Installation
pip install wdb_utils
Usage
import wdb_utils as db
# Assuming your config file is located at /Users/myname/configs/config-default.yml
# Pull all the data from an Oracle database table into a data frame
df = db.run_query_oracle('select * from my_table')
# Pull all the data from a Snowflake database table into a data frame
df = db.run_query_snowflake('select * from other_table')
# Pull all the data from a Postgres database table into a data frame
df = db.run_query_postgres('select * from third_table')
# Delete all the data in those same tables
db.run_command_oracle('delete from my_table')
db.run_command_snowflake('delete from other_table')
db.run_command_postgres('delete from third_table')
# Put all the data back into the table
# Be aware that record order is not guaranteed to be preserved here
# Trying to decide if that's enough of a problem to fix it
db.load_data_oracle(df, 'my_schema', 'my_table')
db.load_data_snowflake(df, 'another_schema', 'other_table')
db.load_data_postgres(df, 'third_schema', 'third_table')
Backward compatibility
Because this package was initially only for Oracle databases, I've also aliased the following methods to keep working:
- run_query is an alias for run_query_oracle
- run_command is an alias for run_command_oracle
- load_data is an alias for load_data_oracle
1 maintainer
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
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 wdb_utils-3.8.0.tar.gz.
File metadata
- Download URL: wdb_utils-3.8.0.tar.gz
- Upload date:
- Size: 5.9 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via:
twine/7.0.0 CPython/3.13.5
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
387e4c6f3b7bbb83e67b8aa910ef1d648c2f14ce56a2c2da6c234289ea3a65a2
|
|
| MD5 |
2b0931fe58ca3599b1b94d76474056c0
|
|
| BLAKE2b-256 |
a6eb1b156c9f9cdbd757f2a2a972b71aeb2f69a6a0c53ea2401ea4d4296adf3e
|
File details
Details for the file wdb_utils-3.8.0-py3-none-any.whl.
File metadata
- Download URL: wdb_utils-3.8.0-py3-none-any.whl
- Upload date:
- Size: 6.1 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via:
twine/7.0.0 CPython/3.13.5
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
269239f688b4aa41aa689cee9f13d108f56388b43f98bdda60337bb3bec133bc
|
|
| MD5 |
e6f14976d53042ab5179fc1fa62fb7b8
|
|
| BLAKE2b-256 |
3b15735391bb3447e367a2aad7efec139b204483450c2e35e1a781da581dbd74
|
