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.
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.
The SQLAlchemy Project
sqlalchemy-sybase is affiliated with the SQLAlchemy Project and adheres to the same standards and conventions as the core project.
Development / Bug reporting / Pull requests
Please refer to the SQLAlchemy Community Guide 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.
License
sqlalchemy-sybase is distributed under the MIT license.
3 maintainers
Metadata
3 maintainers
Release files for sqlalchemy-sybase 2.0.0
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| sqlalchemy-sybase-2.0.0.tar.gz | 18.9 kB | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| sqlalchemy_sybase-2.0.0-py3-none-any.whl | Python 3 | none | any | Details |
Total release size: 33.9 kB
Release files / sqlalchemy-sybase-2.0.0.tar.gz
| Download URL | sqlalchemy-sybase-2.0.0.tar.gz |
|---|---|
| Size | 18.9 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
fb328b9542d24f2b9b8a68da3d3637eb43450c8ab37a4acf397124c93095409e
|
|
BLAKE2b-256 checksum How to use checksums |
ff17396c5c385d4d94a571ba599e6c3f76de908f13f6c2dbe923e05d72390b3d
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/4.0.2 CPython/3.9.6
|
Release files / sqlalchemy_sybase-2.0.0-py3-none-any.whl
| Download URL | sqlalchemy_sybase-2.0.0-py3-none-any.whl |
|---|---|
| Size | 15.0 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
164beadeab2eef0507813d39e1d27ece268f022b446a00eccba2fe65d57f8bfa
|
|
BLAKE2b-256 checksum How to use checksums |
c8a565e84b11082374a00c9c775e337fa6bcec7516c9b930dcf114040900f72f
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/4.0.2 CPython/3.9.6
|
