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.3.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 310884967599728d7fa2d565e831410ccfcdea56924b2198add83bd5c8285339 |
|
MD5 | e8ce3cee944352b276b6f2a17a24b867 |
|
BLAKE2b-256 | 8e4c946941e36c0e0d516134b320f3e6805a48e6f8ca7fde162bd2324f889adb |
Hashes for adbc_driver_netezza-0.0.3-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 44e00b311ea586e27f521862b5fe981625f5b78b2995b23081300df531a895ad |
|
MD5 | 7d99165098dfdf0433add4308880510d |
|
BLAKE2b-256 | 0555ef2c454d04ecf1009945b8fe900e3b54d7416df17b08ccd09ecf715544a0 |