SQLAlchemy dialect for SQream Blue
Project description
Requirements
Python > 3.9.
SQLAlchemy > 1.3.18
SQream Blue DB-API Connector >= 1.0.30
Installation
Install from the PyPi repository using pip:
pip install --upgrade pysqream_blue_sqlalchemy
Usage
Integrating with SQLAlchemy
import sqlalchemy as sa
_access_token = "ACCESS TOKEN"
conn_str = f"sqream_blue://domain:443/database"
connect_args = {'access_token': _access_token}
engine = sa.create_engine(conn_string, connect_args=connect_args)
conn = engine.connect()
res = conn.execute("select 'Success' as Test").fetchall()
print(res)
Integrating with the IPython/Jupyter SQL Magic
%load_ext sql
%config SqlMagic.autocommit=False
%config SqlMagic.displaycon=False
%config SqlMagic.autopandas=True
%sql sqream_blue://product.isqream.com/master?access_token=<ACCESS_TOKEN>
%sql select 'Success' as Test
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
Close
Hashes for pysqream_blue_sqlalchemy-0.5.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | c1cd2e47c2a1e054db0fc3ba5ce627b0448b151334ee1f67b1c90eb78e1e9560 |
|
MD5 | d2ff073e0622f2ff627ad5af613e7bb4 |
|
BLAKE2b-256 | f78d9dd08d2629e68c69466e598b7374ca8138ca2d588829187b1051dadcdf73 |
Close
Hashes for pysqream_blue_sqlalchemy-0.5-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | caf5ed642f490ab083df1a41e30c3e5055ae4bd731cf9212a7dc232cc4902015 |
|
MD5 | 2f7fbf416830563bd6638546225b98c2 |
|
BLAKE2b-256 | 2da97e47ad934bd16d3b02dfc3d5c038592913dde183a06d0cda8c5c9ecb583b |