Python SQLAlchemy Dialect for JDBCAPI.
Project description
JDBC Connection for SQLAlchemy.
The primary purpose of this dialect is provide JDBC connection using required driver.
Installation
Installing the dialect is straightforward.
python3 -m pip install git+https://github.com/daneshpatel/sqlalchemy-jdbcapi.git
Usage
PostgressSQL
Set an environment variable `PG_JDBC_DRIVER_PATH`
from sqlalchemy import create_engine create_engine('jdbcapi+pgjdbc://{}:{}@{}/{}'.format(username, password, <ip:host>', <database name>))
Oracle
Set an environment variable `ORACLE_JDBC_DRIVER_PATH`
create_engine("jdbcapi+oraclejdbc://username:password@HOST:1521/Database")
#GenericJDBCConnection
Set an environment variable JDBC_DRIVER_PATH
Supported databases
In theory every database with a suitable JDBC driver should work.
- SQLite
- Hypersonic SQL (HSQLDB)
- IBM DB2
- IBM DB2 for mainframes
- Oracle
- Teradata DB
- Netezza
- Mimer DB
- Microsoft SQL Server
- MySQL
- PostgreSQL
- many more...
Contributing
Please submit bugs and patches <https://github.com/daneshpatel/sqlalchemy-jdbcapi/issues>
_.
All contributors will be acknowledged. Thanks!
Project details
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 sqlalchemy_jdbcapi-1.0.0-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | e6d1756ab1c375867e1d303c9f12441f3c99a020c09a761278f440fbc6292d53 |
|
MD5 | 89f744a2aaf7aa04097fa90341fc3b88 |
|
BLAKE2b-256 | c04a46ad07bd37be57b9d9e4277b7b9a03ab154b4321df80bb50a0a3c32b3d89 |