This plugin allows vdk-core to interface with and execute queries against a PostgreSQL database.
Usage
Run
pip install vdk-postgres
After this, data jobs will have access to a Postgres database connection, managed by Versatile Data Kit SDK.
If it is the only database plugin installed , vdk would automatically use it. Otherwise, users need to set VDK_DB_DEFAULT_TYPE=POSTGRES as an environment variable or set 'db_default_type' option in the data job config file (config.ini).
For example
def run(job_input: IJobInput):
job_input.execute_query("select 'Hi Postgres!'")
Configuration
Run vdk config-help - search for those prefixed with "POSTGRES_" to see what configuration options are available.
Testing
Testing this plugin locally requires installing the dependencies listed in plugins/vdk-postgres/requirements.txt
Run
pip install -r requirements.txt
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
File details
Details for the file vdk-postgres-0.0.415625538.tar.gz.
File metadata
- Download URL: vdk-postgres-0.0.415625538.tar.gz
- Upload date:
- Size: 3.7 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via:
twine/3.6.0 importlib_metadata/4.8.2 pkginfo/1.8.1 requests/2.26.0 requests-toolbelt/0.9.1 tqdm/4.62.3 CPython/3.7.12
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
e0ee1d0e890cbafc1ad00b1db8bf180e14d8c4fb92a7fb47c2ff846d19d5ffdd
|
|
| MD5 |
6983fde71b09cb56f13620e6f6bfd19e
|
|
| BLAKE2b-256 |
e06745845d688e40cb849dddd1119a8e7632b10fd4d5a5cf9921da40efd55e06
|
