sqlalchemy-sybase
=================
.. image:: https://img.shields.io/pypi/dm/sqlalchemy-sybase.svg
:target: https://pypi.org/project/sqlalchemy-sybase/
SAP ASE (Sybase) dialect for SQLAlchemy.
The latest version of this dialect requires SQLAlchemy 2.0 or later. To work with earlier versions of SQLAlchemy, do::
pip install sqlalchemy-sybase<2.0.0
Overview
--------
This is a fork of SQLAlchemy's internal "sybase" dialect
which was deprecated in SQLAlchemy 1.4 and was removed from
SQLAlchemy 2.0.
Database Version Support
------------------------
This dialect is tested against SAP ASE version 16. Some features may not work
on earlier versions of SAP ASE.
Pre-requisites
--------------
You will need an ODBC driver for SAP ASE installed on the machine from which
you want to connect to the SAP ASE server. This dialect is tested with
the SAP ASE ODBC driver (``libsybdrvodb-sqllen8.so`` on Linux).
Also, if you are running on Linux and using `unixODBC`_, check the version via
``odbcinst -j`` from a console prompt (or use the `odbcinst`_ module).
The official repositories of several Linux distributions
contain versions of unixODBC that are quite old and somewhat buggy.
.. _unixODBC: http://www.unixodbc.org/
.. _odbcinst: https://github.com/gordthompson/odbcinst
Installing
----------
SQLAlchemy and pyodbc are specified as requirements so ``pip`` will install
them if they are not already in place. To install, just::
pip install sqlalchemy-sybase
Getting Started
---------------
Create an `ODBC DSN (Data Source Name)`_ that points to your SAP ASE database.
Then, in your Python app, you can connect to the database via::
from sqlalchemy import create_engine
engine = create_engine("sybase+pyodbc://scott:tiger@your_dsn")
For other ways of connecting see the `Getting Connected`_ page in the Wiki.
.. _ODBC DSN (Data Source Name): https://support.microsoft.com/en-ca/help/966849/what-is-a-dsn-data-source-name
.. _Getting Connected: https://github.com/gordthompson/sqlalchemy-sybase/wiki/Getting-Connected
The SQLAlchemy Project
======================
sqlalchemy-sybase is affiliated with the `SQLAlchemy Project <https://www.sqlalchemy.org>`_ and
adheres to the same standards and conventions as the core project.
Development / Bug reporting / Pull requests
-------------------------------------------
Please refer to the
`SQLAlchemy Community Guide <https://www.sqlalchemy.org/develop.html>`_ for
guidelines on coding and participating in this project.
Code of Conduct
_______________
Above all, SQLAlchemy places great emphasis on polite, thoughtful, and
constructive communication between users and developers.
Please see the current Code of Conduct at
`Code of Conduct <https://www.sqlalchemy.org/codeofconduct.html>`_.
License
=======
sqlalchemy-sybase is distributed under the `MIT license
<https://opensource.org/licenses/MIT>`_.
Raw data
{
"_id": null,
"home_page": "https://github.com/gordthompson/sqlalchemy-sybase",
"name": "sqlalchemy-sybase",
"maintainer": "",
"docs_url": null,
"requires_python": "",
"maintainer_email": "",
"keywords": "ASE SAP SQLAlchemy Sybase",
"author": "Gord Thompson",
"author_email": "gord@gordthompson.com",
"download_url": "https://files.pythonhosted.org/packages/ff/17/396c5c385d4d94a571ba599e6c3f76de908f13f6c2dbe923e05d72390b3d/sqlalchemy-sybase-2.0.0.tar.gz",
"platform": null,
"description": "sqlalchemy-sybase\n=================\n\n.. image:: https://img.shields.io/pypi/dm/sqlalchemy-sybase.svg\n :target: https://pypi.org/project/sqlalchemy-sybase/\n\nSAP ASE (Sybase) dialect for SQLAlchemy.\n\nThe latest version of this dialect requires SQLAlchemy 2.0 or later. To work with earlier versions of SQLAlchemy, do::\n\n pip install sqlalchemy-sybase<2.0.0\n\nOverview\n--------\n\nThis is a fork of SQLAlchemy's internal \"sybase\" dialect\nwhich was deprecated in SQLAlchemy 1.4 and was removed from\nSQLAlchemy 2.0.\n\nDatabase Version Support\n------------------------\n\nThis dialect is tested against SAP ASE version 16. Some features may not work\non earlier versions of SAP ASE.\n\nPre-requisites\n--------------\n\nYou will need an ODBC driver for SAP ASE installed on the machine from which\nyou want to connect to the SAP ASE server. This dialect is tested with\nthe SAP ASE ODBC driver (``libsybdrvodb-sqllen8.so`` on Linux).\n\nAlso, if you are running on Linux and using `unixODBC`_, check the version via\n``odbcinst -j`` from a console prompt (or use the `odbcinst`_ module).\nThe official repositories of several Linux distributions\ncontain versions of unixODBC that are quite old and somewhat buggy.\n\n.. _unixODBC: http://www.unixodbc.org/\n.. _odbcinst: https://github.com/gordthompson/odbcinst\n\nInstalling\n----------\n\nSQLAlchemy and pyodbc are specified as requirements so ``pip`` will install\nthem if they are not already in place. To install, just::\n\n pip install sqlalchemy-sybase\n\nGetting Started\n---------------\n\nCreate an `ODBC DSN (Data Source Name)`_ that points to your SAP ASE database.\nThen, in your Python app, you can connect to the database via::\n\n from sqlalchemy import create_engine\n engine = create_engine(\"sybase+pyodbc://scott:tiger@your_dsn\")\n\nFor other ways of connecting see the `Getting Connected`_ page in the Wiki.\n\n.. _ODBC DSN (Data Source Name): https://support.microsoft.com/en-ca/help/966849/what-is-a-dsn-data-source-name\n.. _Getting Connected: https://github.com/gordthompson/sqlalchemy-sybase/wiki/Getting-Connected\n\nThe SQLAlchemy Project\n======================\n\nsqlalchemy-sybase is affiliated with the `SQLAlchemy Project <https://www.sqlalchemy.org>`_ and\nadheres to the same standards and conventions as the core project.\n\nDevelopment / Bug reporting / Pull requests\n-------------------------------------------\n\nPlease refer to the\n`SQLAlchemy Community Guide <https://www.sqlalchemy.org/develop.html>`_ for\nguidelines on coding and participating in this project.\n\nCode of Conduct\n_______________\n\nAbove all, SQLAlchemy places great emphasis on polite, thoughtful, and\nconstructive communication between users and developers.\nPlease see the current Code of Conduct at\n`Code of Conduct <https://www.sqlalchemy.org/codeofconduct.html>`_.\n\nLicense\n=======\n\nsqlalchemy-sybase is distributed under the `MIT license\n<https://opensource.org/licenses/MIT>`_.\n",
"bugtrack_url": null,
"license": "MIT",
"summary": "SAP ASE (Sybase) for SQLAlchemy",
"version": "2.0.0",
"split_keywords": [
"ase",
"sap",
"sqlalchemy",
"sybase"
],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "c8a565e84b11082374a00c9c775e337fa6bcec7516c9b930dcf114040900f72f",
"md5": "60a7585df8502c46646b5edf05c87876",
"sha256": "164beadeab2eef0507813d39e1d27ece268f022b446a00eccba2fe65d57f8bfa"
},
"downloads": -1,
"filename": "sqlalchemy_sybase-2.0.0-py3-none-any.whl",
"has_sig": false,
"md5_digest": "60a7585df8502c46646b5edf05c87876",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": null,
"size": 14965,
"upload_time": "2023-01-31T21:43:37",
"upload_time_iso_8601": "2023-01-31T21:43:37.580291Z",
"url": "https://files.pythonhosted.org/packages/c8/a5/65e84b11082374a00c9c775e337fa6bcec7516c9b930dcf114040900f72f/sqlalchemy_sybase-2.0.0-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "ff17396c5c385d4d94a571ba599e6c3f76de908f13f6c2dbe923e05d72390b3d",
"md5": "f52ff95af9d88d3b6c0127d430adcc5e",
"sha256": "fb328b9542d24f2b9b8a68da3d3637eb43450c8ab37a4acf397124c93095409e"
},
"downloads": -1,
"filename": "sqlalchemy-sybase-2.0.0.tar.gz",
"has_sig": false,
"md5_digest": "f52ff95af9d88d3b6c0127d430adcc5e",
"packagetype": "sdist",
"python_version": "source",
"requires_python": null,
"size": 18906,
"upload_time": "2023-01-31T21:43:39",
"upload_time_iso_8601": "2023-01-31T21:43:39.265289Z",
"url": "https://files.pythonhosted.org/packages/ff/17/396c5c385d4d94a571ba599e6c3f76de908f13f6c2dbe923e05d72390b3d/sqlalchemy-sybase-2.0.0.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2023-01-31 21:43:39",
"github": true,
"gitlab": false,
"bitbucket": false,
"github_user": "gordthompson",
"github_project": "sqlalchemy-sybase",
"travis_ci": false,
"coveralls": false,
"github_actions": false,
"lcname": "sqlalchemy-sybase"
}
JSON
