A libpq-based ADBC driver for working with Netezza.
Project description
ADBC Netezza Driver for Python
This package contains bindings for the Netezza driver, using the driver manager to provide a DBAPI 2.0/PEP 249-compatible interface on top.
Example
import adbc_driver_netezza.dbapi
uri = "netezza://username:password@localhost:5480/database_name"
with adbc_driver_netezza.dbapi.connect(uri) as conn:
with conn.cursor() as cur:
cur.execute("SELECT 1")
print(cur.fetch_arrow_table())
Building
Dependencies: a build of the Netezza driver, and the
adbc-driver-manager
Python package. Optionally, install PyArrow to
use the DBAPI 2.0-compatible interface.
Set the environment variable ADBC_NETEZZA_LIBRARY
to the path to
libadbc_driver_netezza.so
before running pip install
.
# If not already installed
pip install -e ../adbc_driver_manager
export ADBC_NETEZZA_LIBRARY=/path/to/libadbc_driver_netezza.so
pip install --no-deps -e .
For users building from the arrow-adbc source repository, you can alternately use CMake to manage library dependencies and set environment variables for you. Assuming you specify -DADBC_DRIVER_NETEZZA=ON
you can also add -DADBC_BUILD_PYTHON=ON
to define a python
target.
For example, assuming you run cmake from the project root:
cmake -S c -B build --preset debug -DADBC_BUILD_PYTHON=ON
cmake --build build --target python
will properly build and install the Python library for you.
See CONTRIBUTING.md for details on the general build process.
Testing
A running instance of Netezza is required.
To run the tests, set the environment variable specifying the Netezza URI before running tests:
$ export ADBC_NETEZZA_TEST_URI=netezza://localhost:5432/netezza?user=username&password=password
$ pytest -vvx
See CONTRIBUTING.md for details on the general test process.
Project details
Release history Release notifications | RSS feed
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
Hashes for adbc-driver-netezza-0.0.2.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 0688b63d5ab4a0099948ba5946b617bcc6a436614d0eadfce407fc526fab178e |
|
MD5 | 05f263f8cfdd87fe2c62f21a7bebea7f |
|
BLAKE2b-256 | 326f8dc4c5e59b77a1cddf09ee6b81ba587c921e8479699c215a439a9c7f9ca3 |
Hashes for adbc_driver_netezza-0.0.2-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 050f056582bb70df3a72a5b676599ab1c2ddebdd1f213ace092cbcd8ad8cc41d |
|
MD5 | 00d30a2d2712f665198a4cb772f19551 |
|
BLAKE2b-256 | f6bf9a5946d93f4344305ada6a43e860b995612305b4fa10cc0eda4746e9fcfb |