Metadata-Version: 2.1
Name: pysqream-blue-sqlalchemy
Version: 0.1
Summary: SQLAlchemy dialect for SQream Blue
Home-page: https://github.com/SQream/pysqream_blue_sqlalchemy
Author: SQream
Author-email: info@sqream.com
License: UNKNOWN
Keywords: database sqlalchemy sqream sqreamdb
Platform: UNKNOWN
Classifier: Programming Language :: Python :: 3.6
Classifier: License :: OSI Approved :: BSD License
Classifier: Operating System :: OS Independent
Requires-Python: >=3.7
Requires-Dist: sqlalchemy (>=1.3.18)
Requires-Dist: pysqream-blue (>=1.0.22)
Requires-Dist: setuptools (==57.4.0)
Requires-Dist: pytest (==6.2.3)
Requires-Dist: pudb (==2022.1.2)
Requires-Dist: pandas (==1.1.5)
Requires-Dist: numpy (==1.20)
Requires-Dist: alembic (==1.5.8)

**********************************
SQLAlchemy Dialect for SQream DB
**********************************

Requirements
=====================

* Python > 3.7. Python 3.8.1+ recommended
* SQLAlchemy > 1.3.18
* SQream Blue DB-API Connector >= 1.0.22

Installation
=====================

Install from the PyPi repository using `pip`:

.. code-block:: bash

    pip install --upgrade pysqream_blue_sqlalchemy

Usage
===============================

Integrating with SQLAlchemy
----------------------------

.. code-block:: python

    import sqlalchemy as sa
    conn_string = 'sqream_blue://username:password@url/database'
    engine = sa.create_engine(conn_string)
    conn = engine.connect()
    res = conn.execute("select 'Success' as Test").fetchall()
    print(res)

Integrating with the IPython/Jupyter SQL Magic
-----------------------------------------------

.. code-block:: python

    %load_ext sql
    %config SqlMagic.autocommit=False
    %config SqlMagic.displaycon=False
    %config SqlMagic.autopandas=True
    %env DATABASE_URL sqream_blue://sqream:sqream@product.isqream.com/master
    %sql select 'Success' as Test


