| Name | sqlalchemy-altibase7 JSON |
| Version |
0.0.3
JSON |
| download |
| home_page | None |
| Summary | Altibase for SQLAlchemy |
| upload_time | 2024-05-29 03:53:19 |
| maintainer | None |
| docs_url | None |
| author | None |
| requires_python | None |
| license | MIT |
| keywords |
sqlalchemy
altibase
|
| VCS |
 |
| bugtrack_url |
|
| requirements |
No requirements were recorded.
|
| Travis-CI |
No Travis.
|
| coveralls test coverage |
No coveralls.
|
# sqlalchemy-altibase7
- Altibase support for SQLAlchemy implemented as an external dialect.
- It is test on Altibase v7.
- This source code is based on https://pypi.org/project/sqlalchemy-altibase .
- This package itself is uploaded on https://pypi.org/project/sqlalchemy-altibase7 .
# Changes from sqlalchemy-altibase
- It is mainly supplemented for langchain connectivity.
- sqlalchemy version upper limit requirement is removed.
# Prereqisite
- unixodbc
- pyodbc
## unixodbc
- install : sudo apt-get install unixodbc-dev
- example configuration :
```
$ cat /etc/odbc.ini
[PYODBC]
Driver = /home/hess/work/altidev4/altibase_home/lib/libaltibase_odbc-64bit-ul64.so
Database = mydb
ServerType = Altibase
Server = 127.0.0.1
Port = 21121
UserName = SYS
Password = MANAGER
FetchBuffersize = 64
ReadOnly = no
$ cat /etc/odbcinst.ini
[ODBC]
Trace=Yes
TraceFile=/tmp/odbc_trace.log
```
## pyodbc
- install : pip install pyodbc
- test :
```
$ python
>>> import pyodbc
>>> conn = pyodbc.connect('DSN=PYODBC')
>>> curs = conn.cursor()
>>> curs.execute("select * from v$table")
>>> curs.fetchall()
```
# sqlalchemy-altibase7 using langchain
- install : pip install sqlalchemy-altibase7
- reference : https://python.langchain.com/v0.1/docs/use_cases/sql/quickstart/
- test preparation : Populate sample data into Altibase database using "test/Chinook_Altibase.sql" file in this repository.
- test :
- simple :
- python test/altitest.py
Raw data
{
"_id": null,
"home_page": null,
"name": "sqlalchemy-altibase7",
"maintainer": null,
"docs_url": null,
"requires_python": null,
"maintainer_email": null,
"keywords": "SQLAlchemy Altibase",
"author": null,
"author_email": "Hess Lee <hess.lee@altibase.com>",
"download_url": "https://files.pythonhosted.org/packages/10/be/9657194e04c4e312940a435056cd5e2e16656af4f02163e5db1fe97bdc85/sqlalchemy_altibase7-0.0.3.tar.gz",
"platform": null,
"description": "# sqlalchemy-altibase7\n- Altibase support for SQLAlchemy implemented as an external dialect.\n- It is test on Altibase v7.\n- This source code is based on https://pypi.org/project/sqlalchemy-altibase .\n- This package itself is uploaded on https://pypi.org/project/sqlalchemy-altibase7 .\n\n# Changes from sqlalchemy-altibase\n- It is mainly supplemented for langchain connectivity.\n- sqlalchemy version upper limit requirement is removed.\n\n# Prereqisite\n- unixodbc\n- pyodbc\n\n## unixodbc\n- install : sudo apt-get install unixodbc-dev\n- example configuration :\n```\n$ cat /etc/odbc.ini \n[PYODBC]\nDriver = /home/hess/work/altidev4/altibase_home/lib/libaltibase_odbc-64bit-ul64.so\nDatabase = mydb\nServerType = Altibase\nServer = 127.0.0.1\nPort = 21121\nUserName = SYS\nPassword = MANAGER\nFetchBuffersize = 64\nReadOnly = no\n\n$ cat /etc/odbcinst.ini \n[ODBC]\nTrace=Yes\nTraceFile=/tmp/odbc_trace.log\n```\n\n## pyodbc\n- install : pip install pyodbc\n- test :\n```\n$ python\n>>> import pyodbc\n>>> conn = pyodbc.connect('DSN=PYODBC')\n>>> curs = conn.cursor()\n>>> curs.execute(\"select * from v$table\")\n>>> curs.fetchall()\n```\n\n# sqlalchemy-altibase7 using langchain\n- install : pip install sqlalchemy-altibase7\n- reference : https://python.langchain.com/v0.1/docs/use_cases/sql/quickstart/\n- test preparation : Populate sample data into Altibase database using \"test/Chinook_Altibase.sql\" file in this repository.\n- test :\n - simple :\n - python test/altitest.py\n",
"bugtrack_url": null,
"license": "MIT",
"summary": "Altibase for SQLAlchemy",
"version": "0.0.3",
"project_urls": {
"Source Code": "https://github.com/hesslee/sqlalchemy-altibase7"
},
"split_keywords": [
"sqlalchemy",
"altibase"
],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "089a19af9681874a37fe1d91c17dad42921539d33581de8d1383b1162782a338",
"md5": "bc017affd6edf70b2a67b298c3e9a425",
"sha256": "81418d65e2612108e8877053e70a4ee8e68cf572ffd404c72e28ee12ccc3a696"
},
"downloads": -1,
"filename": "sqlalchemy_altibase7-0.0.3-py3-none-any.whl",
"has_sig": false,
"md5_digest": "bc017affd6edf70b2a67b298c3e9a425",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": null,
"size": 12467,
"upload_time": "2024-05-29T03:53:17",
"upload_time_iso_8601": "2024-05-29T03:53:17.757200Z",
"url": "https://files.pythonhosted.org/packages/08/9a/19af9681874a37fe1d91c17dad42921539d33581de8d1383b1162782a338/sqlalchemy_altibase7-0.0.3-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "10be9657194e04c4e312940a435056cd5e2e16656af4f02163e5db1fe97bdc85",
"md5": "48680b13b33af7f1164329d4a6411591",
"sha256": "49bf6ea4807de7bbc40eb1b617b1e4d3ad9d9a68e0d972b52ea8acf9bbbeb7f4"
},
"downloads": -1,
"filename": "sqlalchemy_altibase7-0.0.3.tar.gz",
"has_sig": false,
"md5_digest": "48680b13b33af7f1164329d4a6411591",
"packagetype": "sdist",
"python_version": "source",
"requires_python": null,
"size": 14616,
"upload_time": "2024-05-29T03:53:19",
"upload_time_iso_8601": "2024-05-29T03:53:19.603595Z",
"url": "https://files.pythonhosted.org/packages/10/be/9657194e04c4e312940a435056cd5e2e16656af4f02163e5db1fe97bdc85/sqlalchemy_altibase7-0.0.3.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2024-05-29 03:53:19",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "hesslee",
"github_project": "sqlalchemy-altibase7",
"travis_ci": false,
"coveralls": false,
"github_actions": false,
"lcname": "sqlalchemy-altibase7"
}
