sqlalchemy-sqlany
This project provides a SQLAlchemy dialect for communicating with a SQL Anywhere database server. It is built upon the Python SQL Anywhere Database Interface.
Requirements
The following software is required to use the SQL Anywhere dialect for SQLAlchemy:
SQL Anywhere 11.0.1 or higher
Python 2.4, 2.5, 2.6, 2.7, or 3.4
The Python SQL Anywhere Database Interface version 1.0.6 or later
SQLAlchemy version 0.8.0 or higher
Installing the required software
The dialect uses the SQL Anywhere Python driver, which must also be installed. If you are using pip to install the sqlalchemy-sqlany dialect, you can skip this step since the SQL Anywhere Python driver will be installed as part of that step.
The SQL Anywhere Database Interface for Python provides a Database API v2 compliant driver (see Python PEP 249) for accessing SQL Anywhere databases from Python. The SQL Anywhere backend for Django is built on top of this interface so installing it is required.
You can use pip to make this easy:
$ pip install sqlanydb
Alternatively, you can obtain the Python SQL Anywhere Database Interface from https://github.com/sqlanywhere/sqlanydb. Install the driver by downloading the source and running the following command:
$ python setup.py install
Installing the sqlalchemy-sqlany dialect
Again, use pip to install this easily:
$ pip install sqlalchemy-sqlany
This will install the SQL Anywhere python driver if it was not already installed.
Or you can obtain the dialect from https://github.com/sqlanywhere/sqlalchemy-sqlany/. Install the dialect by downloading the source and running the following command:
$ python setup.py install
Testing the dialect
Once the Python SQL Anywhere Database Interface driver and the sqlalchemy-sqlany dialect are installed, you can run the standard SQLAlchemy tests by following the following instructions:
Create an empty database.
Start a SQL Anywhere server on that database. Make sure the server is listening for TCP/IP connections on the default port (2638) using -x “tcpip(port=2638)”.
Execute
$ python run_tests.py
License
This package is licensed under the terms of the Apache License, Version 2.0. See the LICENSE file for details.
Feedback and Questions
For feedback on this project, or for general questions about using SQL Anywhere please use the SQL Anywhere Forum at http://sqlanywhere-forum.sap.com/
1 maintainer
Metadata
1 maintainer
Release files for sqlalchemy-sqlany 1.0.4
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | Provenance | Actions |
|---|---|---|---|---|
| sqlalchemy_sqlany-1.0.4.tar.gz | 17.9 kB | Without provenance | Details for sqlalchemy_sqlany-1.0.4.tar.gz |
Release files / sqlalchemy_sqlany-1.0.4.tar.gz
| Download URL | sqlalchemy_sqlany-1.0.4.tar.gz |
|---|---|
| Size | 17.9 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
c5bc4d86c463e157680b6f488f884667c378105811d3611704a95570e9794720
|
|
BLAKE2b-256 checksum How to use checksums |
7a0d577e193c78736e37e87ac9c45b9b636e784580550d3e2aecf93fb3061d9b
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/3.3.0 pkginfo/1.7.0 requests/2.25.1 setuptools/49.2.1 requests-toolbelt/0.9.1 tqdm/4.58.0 CPython/3.9.2
|
Security for sqlalchemy-sqlany 1.0.4
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
No provenance found
None of the files in this release were uploaded with provenance metadata.
A note on package security
PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.
To learn more about protecting yourself from malicious actors, visit our package security documentation.
