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.1.dev0.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 36eb60c8d7d7fff4eabaf8da4b448f0428fc51de28e6797d47fd428754e97d6c |
|
MD5 | 2de6f57d7d51e441c4c1d02d20e44182 |
|
BLAKE2b-256 | a71de95f1aaf148c8cf625b623711a8aac7a0a4bd0594639939b50bfacbaecff |
Hashes for adbc_driver_netezza-0.0.1.dev0-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | c4cfe9e5e9c1e026aa62d9e50ffd3c39ba134215b828811b344d73373c47ef0e |
|
MD5 | 8c7a5b59379adc170517d58d4eeda43a |
|
BLAKE2b-256 | 079c5bf1b1c6411f93646c9c699a63e0deec8bc449bad3df81f6f883fb9abc5b |