**********************************
SQLAlchemy Dialect for SQream DB
**********************************
Requirements
=====================
* Python > 3.9.
* SQLAlchemy > 1.3.18
* SQream Blue DB-API Connector >= 1.0.31
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
_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
-----------------------------------------------
.. code-block:: python
%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
Raw data
{
"_id": null,
"home_page": "https://github.com/SQream/pysqream_blue_sqlalchemy",
"name": "pysqream-blue-sqlalchemy",
"maintainer": "",
"docs_url": null,
"requires_python": ">=3.9",
"maintainer_email": "",
"keywords": "database sqlalchemy sqream sqreamdb",
"author": "SQream",
"author_email": "info@sqream.com",
"download_url": "https://files.pythonhosted.org/packages/5f/08/e80682fc6a92369ec641707f93da9373a7c422704d2fede814961710bafb/pysqream_blue_sqlalchemy-0.6.tar.gz",
"platform": null,
"description": "**********************************\nSQLAlchemy Dialect for SQream DB\n**********************************\n\nRequirements\n=====================\n\n* Python > 3.9.\n* SQLAlchemy > 1.3.18\n* SQream Blue DB-API Connector >= 1.0.31\n\nInstallation\n=====================\n\nInstall from the PyPi repository using `pip`:\n\n.. code-block:: bash\n\n pip install --upgrade pysqream_blue_sqlalchemy\n\nUsage\n===============================\n\nIntegrating with SQLAlchemy\n----------------------------\n\n.. code-block:: python\n\n import sqlalchemy as sa\n _access_token = \"ACCESS TOKEN\"\n conn_str = f\"sqream_blue://domain:443/database\"\n connect_args = {'access_token': _access_token}\n engine = sa.create_engine(conn_string, connect_args=connect_args)\n conn = engine.connect()\n res = conn.execute(\"select 'Success' as Test\").fetchall()\n print(res)\n\nIntegrating with the IPython/Jupyter SQL Magic\n-----------------------------------------------\n\n.. code-block:: python\n\n %load_ext sql\n %config SqlMagic.autocommit=False\n %config SqlMagic.displaycon=False\n %config SqlMagic.autopandas=True\n %sql sqream_blue://product.isqream.com/master?access_token=<ACCESS_TOKEN>\n %sql select 'Success' as Test\n\n\n",
"bugtrack_url": null,
"license": "",
"summary": "SQLAlchemy dialect for SQream Blue",
"version": "0.6",
"project_urls": {
"Homepage": "https://github.com/SQream/pysqream_blue_sqlalchemy"
},
"split_keywords": [
"database",
"sqlalchemy",
"sqream",
"sqreamdb"
],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "418054b53f91f763b8137214644d69fd6eb5adf25dd9352ca093a5d831ae9117",
"md5": "91d4304a8e3e85d8c8464eeca889f1ed",
"sha256": "7794e03715979e2f33fb8a513e9604553a966038e72025080b6c30a4514ceda9"
},
"downloads": -1,
"filename": "pysqream_blue_sqlalchemy-0.6-py3-none-any.whl",
"has_sig": false,
"md5_digest": "91d4304a8e3e85d8c8464eeca889f1ed",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": ">=3.9",
"size": 6957,
"upload_time": "2023-07-26T08:00:19",
"upload_time_iso_8601": "2023-07-26T08:00:19.657328Z",
"url": "https://files.pythonhosted.org/packages/41/80/54b53f91f763b8137214644d69fd6eb5adf25dd9352ca093a5d831ae9117/pysqream_blue_sqlalchemy-0.6-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "5f08e80682fc6a92369ec641707f93da9373a7c422704d2fede814961710bafb",
"md5": "cd06dbd9f5b94a9d3df6b8ae461a7094",
"sha256": "ef7d061eecc2c52e657f6d72ecccb6ea6a8a35a81d23f47af7107ea751906f8e"
},
"downloads": -1,
"filename": "pysqream_blue_sqlalchemy-0.6.tar.gz",
"has_sig": false,
"md5_digest": "cd06dbd9f5b94a9d3df6b8ae461a7094",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.9",
"size": 5286,
"upload_time": "2023-07-26T08:00:21",
"upload_time_iso_8601": "2023-07-26T08:00:21.307937Z",
"url": "https://files.pythonhosted.org/packages/5f/08/e80682fc6a92369ec641707f93da9373a7c422704d2fede814961710bafb/pysqream_blue_sqlalchemy-0.6.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2023-07-26 08:00:21",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "SQream",
"github_project": "pysqream_blue_sqlalchemy",
"travis_ci": false,
"coveralls": false,
"github_actions": true,
"lcname": "pysqream-blue-sqlalchemy"
}
JSON
