| Name | pymssgl JSON |
| Version |
2.2.9.dev0
JSON |
| download |
| home_page | |
| Summary | DB-API interface to Microsoft SQL Server for Python. (new Cython-based version) |
| upload_time | 2023-07-26 14:37:18 |
| maintainer | pymssql development team |
| docs_url | None |
| author | Damien Churchill |
| requires_python | |
| license | LGPL |
| keywords |
mssql
sql server
database
db-api
|
| VCS |
 |
| bugtrack_url |
|
| requirements |
No requirements were recorded.
|
| Travis-CI |
No Travis.
|
| coveralls test coverage |
No coveralls.
|
pymssql - DB-API interface to Microsoft SQL Server
==================================================
.. image:: https://github.com/pymssql/pymssql/workflows/Linux/badge.svg
:target: https://github.com/pymssql/pymssql/actions?query=workflow%3A%22Linux%22
.. image:: https://github.com/pymssql/pymssql/workflows/macOS/badge.svg
:target: https://github.com/pymssql/pymssql/actions?query=workflow%3A%22macOS%22
.. image:: https://github.com/pymssql/pymssql/workflows/Windows/badge.svg
:target: https://github.com/pymssql/pymssql/actions?query=workflow%3A%22Windows%22
.. image:: http://img.shields.io/pypi/dm/pymssql.svg
:target: https://pypi.python.org/pypi/pymssql/
.. image:: http://img.shields.io/pypi/v/pymssql.svg
:target: https://pypi.python.org/pypi/pymssql/
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`_.
.. _Microsoft SQL Server: http://www.microsoft.com/sqlserver/
.. _Python: http://www.python.org/
.. _PEP-249: http://www.python.org/dev/peps/pep-0249/
.. _FreeTDS: http://www.freetds.org/
Detailed information on pymssql is available on the website:
`pymssql.readthedocs.io <https://pymssql.readthedocs.io/en/stable/>`_
New development is happening on GitHub at:
`github.com/pymssql/pymssql <https://github.com/pymssql/pymssql>`_
There is a Google Group for discussion at:
`groups.google.com <https://groups.google.com/forum/?fromgroups#!forum/pymssql>`_
Getting started
===============
pymssql wheels are available from PyPi. To install it run:
.. code-block:: bash
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.
.. note::
On some Linux distributions `pip` version is too old to support all
the flavors of manylinux wheels, so upgrading `pip` is necessary.
An example of such distributions would be Ubuntu 18.04 or
Python3.6 module in RHEL8 and CentOS8.
Basic example
=============
.. code-block:: python
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).
Raw data
{
"_id": null,
"home_page": "",
"name": "pymssgl",
"maintainer": "pymssql development team",
"docs_url": null,
"requires_python": "",
"maintainer_email": "pymssql@googlegroups.com",
"keywords": "mssql,SQL Server,database,DB-API",
"author": "Damien Churchill",
"author_email": "damoxc@gmail.com",
"download_url": "https://files.pythonhosted.org/packages/0a/20/bfdc9369f3483c62ae3fc8c6ea7bf7dffc0136a28b4867aa4c78473d0d98/pymssgl-2.2.9.dev0.tar.gz",
"platform": "any",
"description": "\npymssql - DB-API interface to Microsoft SQL Server\n==================================================\n\n.. image:: https://github.com/pymssql/pymssql/workflows/Linux/badge.svg\n :target: https://github.com/pymssql/pymssql/actions?query=workflow%3A%22Linux%22\n\n.. image:: https://github.com/pymssql/pymssql/workflows/macOS/badge.svg\n :target: https://github.com/pymssql/pymssql/actions?query=workflow%3A%22macOS%22\n\n.. image:: https://github.com/pymssql/pymssql/workflows/Windows/badge.svg\n :target: https://github.com/pymssql/pymssql/actions?query=workflow%3A%22Windows%22\n\n.. image:: http://img.shields.io/pypi/dm/pymssql.svg\n :target: https://pypi.python.org/pypi/pymssql/\n\n.. image:: http://img.shields.io/pypi/v/pymssql.svg\n :target: https://pypi.python.org/pypi/pymssql/\n\nA simple database interface for `Python`_ that builds on top of `FreeTDS`_ to\nprovide a Python DB-API (`PEP-249`_) interface to `Microsoft SQL Server`_.\n\n.. _Microsoft SQL Server: http://www.microsoft.com/sqlserver/\n.. _Python: http://www.python.org/\n.. _PEP-249: http://www.python.org/dev/peps/pep-0249/\n.. _FreeTDS: http://www.freetds.org/\n\nDetailed information on pymssql is available on the website:\n\n`pymssql.readthedocs.io <https://pymssql.readthedocs.io/en/stable/>`_\n\nNew development is happening on GitHub at:\n\n`github.com/pymssql/pymssql <https://github.com/pymssql/pymssql>`_\n\nThere is a Google Group for discussion at:\n\n`groups.google.com <https://groups.google.com/forum/?fromgroups#!forum/pymssql>`_\n\n\nGetting started\n===============\n\npymssql wheels are available from PyPi. To install it run:\n\n.. code-block:: bash\n\n pip install -U pip\n pip install pymssql\n\nMost of the times this should be all what's needed.\nThe official pymssql wheels bundle a static copy of FreeTDS\nand have SSL support so they can be used to connect to Azure.\n\n.. note::\n On some Linux distributions `pip` version is too old to support all\n the flavors of manylinux wheels, so upgrading `pip` is necessary.\n An example of such distributions would be Ubuntu 18.04 or\n Python3.6 module in RHEL8 and CentOS8.\n\n\nBasic example\n=============\n\n.. code-block:: python\n\n conn = pymssql.connect(server, user, password, \"tempdb\")\n cursor = conn.cursor(as_dict=True)\n\n cursor.execute('SELECT * FROM persons WHERE salesrep=%s', 'John Doe')\n for row in cursor:\n print(\"ID=%d, Name=%s\" % (row['id'], row['name']))\n\n conn.close()\n\n\nRecent Changes\n==============\n\nVersion 2.2.4 - 2022-04-12 - Mikhail Terekhov\n==============================================\n\nGeneral\n-------\n\n- Added bytes and bytearray to support bulk_copy types, thanks to steve-strickland (#756).\n- Use FreeTDS-1.3.9 for official wheels on PyPi.\n- Enable krb5 in Linux wheels, this time for real (#754).\n",
"bugtrack_url": null,
"license": "LGPL",
"summary": "DB-API interface to Microsoft SQL Server for Python. (new Cython-based version)",
"version": "2.2.9.dev0",
"project_urls": {
"Changelog": "https://github.com/pymssql/pymssql/blob/master/ChangeLog.rst",
"Documentation": "http://pymssql.readthedocs.io",
"Source": "https://github.com/pymssql/pymssql"
},
"split_keywords": [
"mssql",
"sql server",
"database",
"db-api"
],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "0a20bfdc9369f3483c62ae3fc8c6ea7bf7dffc0136a28b4867aa4c78473d0d98",
"md5": "9a7d9c1691f876cfe68b0fe4c9c1d106",
"sha256": "c848bf235f39700dbab808cc7ab899f92b08e5aa24b1b5c7b78012233a18e8f6"
},
"downloads": -1,
"filename": "pymssgl-2.2.9.dev0.tar.gz",
"has_sig": false,
"md5_digest": "9a7d9c1691f876cfe68b0fe4c9c1d106",
"packagetype": "sdist",
"python_version": "source",
"requires_python": null,
"size": 170514,
"upload_time": "2023-07-26T14:37:18",
"upload_time_iso_8601": "2023-07-26T14:37:18.985421Z",
"url": "https://files.pythonhosted.org/packages/0a/20/bfdc9369f3483c62ae3fc8c6ea7bf7dffc0136a28b4867aa4c78473d0d98/pymssgl-2.2.9.dev0.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2023-07-26 14:37:18",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "pymssql",
"github_project": "pymssql",
"travis_ci": false,
"coveralls": false,
"github_actions": true,
"appveyor": true,
"lcname": "pymssgl"
}
