ppc64le/linux-1.0.0/: pymssql-2.2.5 metadata and description
DB-API interface to Microsoft SQL Server for Python. (new Cython-based version)
| author | Damien Churchill |
| author_email | [email protected] |
| classifiers |
|
| description_content_type | text/x-rst |
| dynamic |
|
| keywords | mssql,SQL Server,database,DB-API |
| license | LGPL |
| license_file |
|
| maintainer | pymssql development team |
| maintainer_email | [email protected] |
| metadata_version | 2.4 |
| project_urls |
|
| File | Tox results | History |
|---|---|---|
pymssql-2.2.5-cp310-cp310-linux_ppc64le.whl
|
|
|
pymssql-2.2.5-cp311-cp311-linux_ppc64le.whl
|
|
|
pymssql-2.2.5-cp39-cp39-linux_ppc64le.whl
|
|
pymssql - DB-API interface to Microsoft SQL Server
A simple database interface for Python that builds on top of FreeTDS to provide a Python DB-API (PEP-249) interface to Microsoft SQL Server.
Detailed information on pymssql is available on the website:
New development is happening on GitHub at:
There is a Google Group for discussion at:
Getting started
pymssql wheels are available from PyPi. To install it run:
pip install -U pip
pip install pymssql
Most of the times this should be all what’s needed. The official pymssql wheels bundle a static copy of FreeTDS and have SSL support so they can be used to connect to Azure.
Basic example
conn = pymssql.connect(server, user, password, "tempdb")
cursor = conn.cursor(as_dict=True)
cursor.execute('SELECT * FROM persons WHERE salesrep=%s', 'John Doe')
for row in cursor:
print("ID=%d, Name=%s" % (row['id'], row['name']))
conn.close()
Recent Changes
Version 2.2.4 - 2022-04-12 - Mikhail Terekhov
General
Added bytes and bytearray to support bulk_copy types, thanks to steve-strickland (#756).
Use FreeTDS-1.3.9 for official wheels on PyPi.
Enable krb5 in Linux wheels, this time for real (#754).