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

Metadata

Release files for vdk-postgres 0.0.415625538

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for vdk-postgres 0.0.415625538
File	Size	Uploaded
vdk-postgres-0.0.415625538.tar.gz	3.7 kB	Nov 24, 2021	Details

Release files / vdk-postgres-0.0.415625538.tar.gz

Download URL	vdk-postgres-0.0.415625538.tar.gz
Size	3.7 kB
Tags	Source
SHA-256 checksum How to use checksums	`e0ee1d0e890cbafc1ad00b1db8bf180e14d8c4fb92a7fb47c2ff846d19d5ffdd`
BLAKE2b-256 checksum How to use checksums	`e06745845d688e40cb849dddd1119a8e7632b10fd4d5a5cf9921da40efd55e06`
Upload date	Nov 24, 2021
Uploaded using Trusted Publishing? What is 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`