SQLAlchemy dialect for SQream Blue
Project description
Requirements
Python > 3.9.
SQLAlchemy == 1.3.18
SQream Blue DB-API Connector >= 1.0.42
Installation
Install from the PyPi repository using pip:
pip3.9 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
Connection String
sqream_blue://<domain>:443/<db_name>
Parameters
Parameter |
Description |
---|---|
domain |
Specifies the domain |
port |
Specifies the port number |
database |
Specifies the database name |
Limitations
Parameterized Queries
SQream SQLAlchemy supports only the BULK INSERT statement.
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.8.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 07e1911e57d9c4766d8be5498a0e3c9aa83d4986a127573e82fdcb7f00258573 |
|
MD5 | 1d877c6afe4f75d12c632cc430b8c497 |
|
BLAKE2b-256 | 23127b068a113a69f0a2205ef71e1b59574654747d02045b1dd0f548f2e63941 |
Close
Hashes for pysqream_blue_sqlalchemy-0.8-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | de5c33fc348874d288a69de78ea4c05e13867663b35a0a6affb6dbb81bf92b5a |
|
MD5 | 4bc905aecaa69d2a6bbae458d7c6afc1 |
|
BLAKE2b-256 | df9a75c21e7295de9f129d3ce72b315c62ee5b1382d9ddd1dc54665a8c8c2651 |