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 vdk-plugins/vdk-postgres/requirements.txt

Run

pip install -r requirements.txt

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

vdk-postgres-0.0.692283840.tar.gz (4.7 kB view details)

Uploaded Nov 11, 2022 Source

File details

Details for the file vdk-postgres-0.0.692283840.tar.gz.

File metadata

Download URL: vdk-postgres-0.0.692283840.tar.gz
Upload date: Nov 11, 2022
Size: 4.7 kB
Tags: Source
Uploaded using Trusted Publishing? No
Uploaded via: twine/4.0.1 CPython/3.7.15

File hashes

Hashes for vdk-postgres-0.0.692283840.tar.gz
Algorithm	Hash digest
SHA256	`891d18cbc2dfa82ba526537bab0c7488bbdb2a8b177629df8e0ca0c57ab88d4e`
MD5	`68e5b247fb7e659df45c9ea339ef5d11`
BLAKE2b-256	`740f71d3d65f3911930b7920192e43c33a10798b9f87fc792738d303a75a70cd`