Skip to main content

DB-API interface to Microsoft SQL Server for Python. (new Cython-based version)

Project description

pymssql - DB-API interface to Microsoft SQL Server

https://travis-ci.org/pymssql/pymssql.png?branch=master http://img.shields.io/pypi/dm/pymssql.svg http://img.shields.io/pypi/v/pymssql.svg

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:

http://pymssql.org

New development is happening on GitHub at:

https://github.com/pymssql/pymssql

There is a Google Group for discussion at:

https://groups.google.com/forum/?fromgroups#!forum/pymssql

Do you use pymssql?

Can you take a minute and fill out this survey to help us prioritize development tasks?

https://www.surveymonkey.com/s/KMQ8BM5

Bitdeli badge

Recent Changes

Version 2.1.1 - 2014-11-25 - Ramiro Morales

Features

  • Custom message handlers (GH-139)

    The DB-Library API includes a callback mechanism so applications can provide functions known as message handlers that get passed informative messages sent by the server which then can be logged, shown to the user, etc.

    _mssql now allows you to install your own message handlers written in Python. See the _msssql examples and reference sections of the documentation for more details.

    Thanks Marc Abramowitz.

  • Compatibility with Azure

    It is now possible to transparently connect to SQL Server instances accessible as part of the Azure cloud services.

  • Customizable per-connection initialization SQL clauses (both in pymssql and _mssql) (GH-97)

    It is now possible to customize the SQL statements sent right after the connection is established (e.g. 'SET ANSI_NULLS ON;'). Previously it was a hard-coded list of queries. See the _mssql.MSSQLConnection documentation for more details.

    Thanks Marc Abramowitz.

  • Added ability to handle instances of uuid.UUID passed as parameters for SQL queries both in pymssql and _mssql. (GH-209)

    Thanks Marat Mavlyutov.

  • Allow using SQL Server autocommit mode from pymssql at connection opening time. This allows e.g. DDL statements like DROP DATABASE to be executed. (GH-210)

    Thanks Marat Mavlyutov.

  • Documentation: Explicitly mention minimum versions supported of Python (2.6) and SQL Server (2005).

  • Incremental enhancements to the documentation.

Bug fixes

  • Handle errors when calling Stored Procedures via the .callproc() pymssql cursor method. Now it will raise a DB-API DatabaseException; previously it allowed a _mssql.MSSQLDatabaseException exception to surface.

  • Fixes in tds_version _mssql connections property value

    Made it work with TDS protocol version 7.2. (GH-211)

    The value returned for TDS version 7.1 is still 8.0 for backward compatibility (this is because such feature got added in times when Microsoft documentation labeled the two protocol versions that followed 7.0 as 8.0 and 9.0; later it changed them to 7.1 and 7.2 respectively) and will be corrected in a future release (2.2).

  • PEP 249 compliance (GH-251)

    Added type constructors to increase compatibility with other libraries.

    Thanks Aymeric Augustin.

  • pymssql: Made handling of integer SP params more robust (GH-237)

  • Check lower bound value when convering integer values from to Python to SQL (GH-238)

Internals

  • Completed migration of the test suite from nose to py.test.

  • Added a few more test cases to our suite.

  • Tests: Modified a couple of test cases so the full suite can be run against SQL Server 2005.

  • Added testing of successful build of documentation to Travis CI script.

  • Build process: Cleanup intermediate and ad-hoc anciliary files (GH-231, GH-273)

  • setup.py: Fixed handling of release tarballs contents so no extraneous files are shipped and the documentation tree is actually included. Also, removed unused code.

Version 2.1.0 - 2014-02-25 - Marc Abramowitz

Features

Bug Fixes

See ChangeLog for older history…

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

pymssql-2.1.1.tar.gz (2.4 MB view details)

Uploaded Source

Built Distributions

pymssql-2.1.1.win-amd64-py3.4.exe (516.4 kB view details)

Uploaded Source

pymssql-2.1.1.win-amd64-py3.3.exe (516.5 kB view details)

Uploaded Source

pymssql-2.1.1.win-amd64-py2.7.exe (521.0 kB view details)

Uploaded Source

pymssql-2.1.1.win-amd64-py2.6.exe (520.8 kB view details)

Uploaded Source

pymssql-2.1.1.win32-py3.4.exe (457.9 kB view details)

Uploaded Source

pymssql-2.1.1.win32-py3.3.exe (457.9 kB view details)

Uploaded Source

pymssql-2.1.1.win32-py2.7.exe (462.2 kB view details)

Uploaded Source

pymssql-2.1.1.win32-py2.6.exe (462.6 kB view details)

Uploaded Source

pymssql-2.1.1-py3.4-win-amd64.egg (282.9 kB view details)

Uploaded Egg

pymssql-2.1.1-py3.4-win32.egg (255.6 kB view details)

Uploaded Egg

pymssql-2.1.1-py3.3-win-amd64.egg (283.0 kB view details)

Uploaded Egg

pymssql-2.1.1-py3.3-win32.egg (255.6 kB view details)

Uploaded Egg

pymssql-2.1.1-py2.7-win-amd64.egg (285.9 kB view details)

Uploaded Egg

pymssql-2.1.1-py2.7-win32.egg (254.7 kB view details)

Uploaded Egg

pymssql-2.1.1-py2.6-win-amd64.egg (285.7 kB view details)

Uploaded Egg

pymssql-2.1.1-py2.6-win32.egg (255.1 kB view details)

Uploaded Egg

pymssql-2.1.1-cp34-none-win_amd64.whl (286.3 kB view details)

Uploaded CPython 3.4Windows x86-64

pymssql-2.1.1-cp34-none-win32.whl (259.0 kB view details)

Uploaded CPython 3.4Windows x86

pymssql-2.1.1-cp33-none-win_amd64.whl (286.4 kB view details)

Uploaded CPython 3.3Windows x86-64

pymssql-2.1.1-cp33-none-win32.whl (259.0 kB view details)

Uploaded CPython 3.3Windows x86

pymssql-2.1.1-cp27-none-win_amd64.whl (289.4 kB view details)

Uploaded CPython 2.7Windows x86-64

pymssql-2.1.1-cp27-none-win32.whl (258.2 kB view details)

Uploaded CPython 2.7Windows x86

pymssql-2.1.1-cp26-none-win_amd64.whl (289.2 kB view details)

Uploaded CPython 2.6Windows x86-64

pymssql-2.1.1-cp26-none-win32.whl (258.7 kB view details)

Uploaded CPython 2.6Windows x86

File details

Details for the file pymssql-2.1.1.tar.gz.

File metadata

  • Download URL: pymssql-2.1.1.tar.gz
  • Upload date:
  • Size: 2.4 MB
  • Tags: Source
  • Uploaded using Trusted Publishing? No

File hashes

Hashes for pymssql-2.1.1.tar.gz
Algorithm Hash digest
SHA256 f1a1601dc3322c785733c84639d8d640c7204f9db4eab5f2a5cc908fb157140f
MD5 98d596508cb1030eb5451c98f8e845fc
BLAKE2b-256 54852def48892af7236559b6da850c6a0a1751387c94b4280ec1cbfca8b4d75f

See more details on using hashes here.

File details

Details for the file pymssql-2.1.1.win-amd64-py3.4.exe.

File metadata

File hashes

Hashes for pymssql-2.1.1.win-amd64-py3.4.exe
Algorithm Hash digest
SHA256 ab74996f008049a5b50e82839f7c1ff9192e72245706de8ccf0192b4d08a4390
MD5 abde7b8b4aa9ffaf00f4e152d53a6ea0
BLAKE2b-256 73ecfc8c564bac25f38fb4b1a45bfa198eca7579e1ff0fc95e6eb681ac3123c9

See more details on using hashes here.

File details

Details for the file pymssql-2.1.1.win-amd64-py3.3.exe.

File metadata

File hashes

Hashes for pymssql-2.1.1.win-amd64-py3.3.exe
Algorithm Hash digest
SHA256 68fc0c867c983b3da1dcc24f61eb0ba81b07dac60f1ab0a72593149f82144a73
MD5 45cac20d6c01bf6f5f4d36bb352fd6ce
BLAKE2b-256 bd359b9167d4ad3a0b7b204435e703907979d2a9a8480990526d4b875cd2aaea

See more details on using hashes here.

File details

Details for the file pymssql-2.1.1.win-amd64-py2.7.exe.

File metadata

File hashes

Hashes for pymssql-2.1.1.win-amd64-py2.7.exe
Algorithm Hash digest
SHA256 967a3f9f4ffaa100c8cd9c500561799e239f8679fad417876cea29afe6397d6e
MD5 802552a2707734490344740a8c6129d4
BLAKE2b-256 16edf5608867c4f0c20afd743e798c136d253263364b1b280ccc8becf75768bc

See more details on using hashes here.

File details

Details for the file pymssql-2.1.1.win-amd64-py2.6.exe.

File metadata

File hashes

Hashes for pymssql-2.1.1.win-amd64-py2.6.exe
Algorithm Hash digest
SHA256 f736d9bdb069d540b05ea6a2fdc254842f5cbf6ab18772579c38936b4d5620b3
MD5 80571cf7f0b46c05a1e51e4789299a9f
BLAKE2b-256 0bc03d1bdbe21b61383d46ea5f2c46489c1da53c4f5e09bf69a762846756bf8b

See more details on using hashes here.

File details

Details for the file pymssql-2.1.1.win32-py3.4.exe.

File metadata

File hashes

Hashes for pymssql-2.1.1.win32-py3.4.exe
Algorithm Hash digest
SHA256 d0bb4756865279fba8f7c9dcb482cb8f72c32bf498728e364078402fb64cf761
MD5 b7efa698b361133da4c5549e7d9aeddc
BLAKE2b-256 521d365e4c2ce125294f28fd856cdc5121ac1776cb05de6ef0b6be829686bc91

See more details on using hashes here.

File details

Details for the file pymssql-2.1.1.win32-py3.3.exe.

File metadata

File hashes

Hashes for pymssql-2.1.1.win32-py3.3.exe
Algorithm Hash digest
SHA256 e6b9e7da55dd9dbded9bac2936ee4db561c43431046fb1f3177038e99d16a4c9
MD5 f9dbb72bf066404c8b8136f3487232ad
BLAKE2b-256 1ac1af4c2dd29703386473661a78c7a89fe106e7f56b9e74b337e0a6beba696b

See more details on using hashes here.

File details

Details for the file pymssql-2.1.1.win32-py2.7.exe.

File metadata

File hashes

Hashes for pymssql-2.1.1.win32-py2.7.exe
Algorithm Hash digest
SHA256 f684e7c141fa30013035ac85a71f821056eaaf16b04cc6fad610f7480d81b804
MD5 494c6b958edb18f7e3921d76a8efb2af
BLAKE2b-256 613a517ddfb75b3fd4764fc0953b6b845d61f391d701f844402b37a7e85a5c70

See more details on using hashes here.

File details

Details for the file pymssql-2.1.1.win32-py2.6.exe.

File metadata

File hashes

Hashes for pymssql-2.1.1.win32-py2.6.exe
Algorithm Hash digest
SHA256 38c60b3ce33948f0ad358424db4fd3531b649bc91c538bcd1b02ba623b5e73f3
MD5 bce1bc6a487533323a74d60ed8a0d6a5
BLAKE2b-256 ad20fae4ec5315f7b8903a052b8d3767634e718258cc272d2a6c0aed50b647bf

See more details on using hashes here.

File details

Details for the file pymssql-2.1.1-py3.4-win-amd64.egg.

File metadata

File hashes

Hashes for pymssql-2.1.1-py3.4-win-amd64.egg
Algorithm Hash digest
SHA256 40fbd202411befc9b6ab45a39a127333cb218b141b949f27835e977dd27e5880
MD5 8829900547f104a9597519636e636dfe
BLAKE2b-256 48a27f7a2814396c6805e26f15700c0845d3686df5c25418b2304b994601aab8

See more details on using hashes here.

File details

Details for the file pymssql-2.1.1-py3.4-win32.egg.

File metadata

File hashes

Hashes for pymssql-2.1.1-py3.4-win32.egg
Algorithm Hash digest
SHA256 6c0954bf64875280ca9e1a255151686a18ea819e4544ed35884a6685eb180b6e
MD5 aa097570a7a04995f35defe4a74fa373
BLAKE2b-256 05d8c28c2f63fdb24f8db470827d69c3cb72545e3d15356fa43d113e9ed8aa60

See more details on using hashes here.

File details

Details for the file pymssql-2.1.1-py3.3-win-amd64.egg.

File metadata

File hashes

Hashes for pymssql-2.1.1-py3.3-win-amd64.egg
Algorithm Hash digest
SHA256 36b414c0e714fc8c562d2ba39fbb9c0cb74526fc955bc9b471ad9554ca6f7439
MD5 7e54dbc58309e06437feef51b7fa5e2a
BLAKE2b-256 4ca468287f92b580da351c3874c06a53ad17e263409a5a2a7baed442d68bc25d

See more details on using hashes here.

File details

Details for the file pymssql-2.1.1-py3.3-win32.egg.

File metadata

File hashes

Hashes for pymssql-2.1.1-py3.3-win32.egg
Algorithm Hash digest
SHA256 1c912e71be14b12c1527e72a7d3d7213fd5b1b4dc26892ee9b4347c4755e6be5
MD5 28bb10ee84be24b24ccef21199307511
BLAKE2b-256 4f30837b7f3563c7418bf98be77cde095dc18ab28828fdaffee3a708cae8e0a3

See more details on using hashes here.

File details

Details for the file pymssql-2.1.1-py2.7-win-amd64.egg.

File metadata

File hashes

Hashes for pymssql-2.1.1-py2.7-win-amd64.egg
Algorithm Hash digest
SHA256 61bfeae0722e6f86f2ec5bedec10d3ed6d3d3ef0ffd8aff70a0c7b93debf0b35
MD5 192c123efcaa946373788dbd81079958
BLAKE2b-256 7229147ffeb036d5c2d307d2334ce106dbeeda4dca5938254a39f74eaf46a5bb

See more details on using hashes here.

File details

Details for the file pymssql-2.1.1-py2.7-win32.egg.

File metadata

File hashes

Hashes for pymssql-2.1.1-py2.7-win32.egg
Algorithm Hash digest
SHA256 13c6e2213bc7b3dcd973573dd5f093e61789d946f0c983c94c60a3b23df7ebd2
MD5 c499d7ee78cca1dc1bc8e3686ff74722
BLAKE2b-256 29bc47f22e51dbabbafd16cab2766a4b2734484a89c8693489c0f7b2d28417e3

See more details on using hashes here.

File details

Details for the file pymssql-2.1.1-py2.6-win-amd64.egg.

File metadata

File hashes

Hashes for pymssql-2.1.1-py2.6-win-amd64.egg
Algorithm Hash digest
SHA256 d4a6a0e6cdc8d9aabe34f98266a7d9531ed5d33170bcf82a23c11519c0a7dbf9
MD5 2f3d00f5b4c41edeb90763ed70ffd0a6
BLAKE2b-256 0b29067890166433e9df2c88853052f3409efcb812351f169c4f9e9ac0a1f6de

See more details on using hashes here.

File details

Details for the file pymssql-2.1.1-py2.6-win32.egg.

File metadata

File hashes

Hashes for pymssql-2.1.1-py2.6-win32.egg
Algorithm Hash digest
SHA256 17067bfa7bb3ef9132d11e80114cdc258b4ae6d01133504a9ef10e901137779c
MD5 09ac37194bfcffb968b941e93b3fa18a
BLAKE2b-256 343b3dd6cd81513a62fc97e454bc78462f35a12af77b73d40426a31876e4d3ef

See more details on using hashes here.

File details

Details for the file pymssql-2.1.1-cp34-none-win_amd64.whl.

File metadata

File hashes

Hashes for pymssql-2.1.1-cp34-none-win_amd64.whl
Algorithm Hash digest
SHA256 c58cf10ca81b24529f26c6acfaf150b3a98e9e65d5c869865a38c716a99e7ee5
MD5 469f3de7bd97d658566ad172c7dd7de4
BLAKE2b-256 8e740fcf266a601016b996310712239b3cad583a60576c4db6b38841f9514630

See more details on using hashes here.

File details

Details for the file pymssql-2.1.1-cp34-none-win32.whl.

File metadata

File hashes

Hashes for pymssql-2.1.1-cp34-none-win32.whl
Algorithm Hash digest
SHA256 f424277807c628bc5d86bb03fe076271cfad1c71a20be6b97ff08d70f4d274f4
MD5 738f8b96f6545135cdb4c0557c72345e
BLAKE2b-256 0cde9b85c5ad399eeff7c742c4a39f2f679dc529ec769d6597c3388312830676

See more details on using hashes here.

File details

Details for the file pymssql-2.1.1-cp33-none-win_amd64.whl.

File metadata

File hashes

Hashes for pymssql-2.1.1-cp33-none-win_amd64.whl
Algorithm Hash digest
SHA256 6324eadbda3fa2aeed5a9c4ad4d81fb030f3f5c7be4dc43c401c1ebb02bdacaa
MD5 cd19cdc72a4fb883d6efb0b96f9749c6
BLAKE2b-256 bd7151ab0fffb2b5c18fdf708e111d21f26bd8d55b80c08f4eb10d630fe15d32

See more details on using hashes here.

File details

Details for the file pymssql-2.1.1-cp33-none-win32.whl.

File metadata

File hashes

Hashes for pymssql-2.1.1-cp33-none-win32.whl
Algorithm Hash digest
SHA256 107f43403fafcac360f39aff13a141686a0fc9befb8973e5dfadd814e86d1fc0
MD5 bedc7ff3a85ab2836aa570367a706795
BLAKE2b-256 317e4bee86a8b20e08bedd7d0a9712d5f0124578dd6a5d91f2faf375492ecd1a

See more details on using hashes here.

File details

Details for the file pymssql-2.1.1-cp27-none-win_amd64.whl.

File metadata

File hashes

Hashes for pymssql-2.1.1-cp27-none-win_amd64.whl
Algorithm Hash digest
SHA256 c22ba3ed34f05d3ec9e0ab7c47d3a33098bf5c8a61f31d8dc600a18e533f16ef
MD5 152ccee5fca56484969aa89a937c643a
BLAKE2b-256 7f6f945e370f4825ae2af65fd3974c911366be9fa19b6b812a513b722111f133

See more details on using hashes here.

File details

Details for the file pymssql-2.1.1-cp27-none-win32.whl.

File metadata

File hashes

Hashes for pymssql-2.1.1-cp27-none-win32.whl
Algorithm Hash digest
SHA256 be91e58a74c2d26b6131ed03be4a1cfc9d4410c2d4fe301288ae5983fc0fa6ca
MD5 6411ac5bb0d8cca2ba00496c082fc46a
BLAKE2b-256 f62aa362b7cf1e60afd068cca9db3a60a50ca25575bbbdf9664255bc0f79cc00

See more details on using hashes here.

File details

Details for the file pymssql-2.1.1-cp26-none-win_amd64.whl.

File metadata

File hashes

Hashes for pymssql-2.1.1-cp26-none-win_amd64.whl
Algorithm Hash digest
SHA256 8d7cd7c9df592c3fb52b2eb41afbced5740061a1c24caf57534d755d72f3cd6f
MD5 4dff892edde77e25f8bd3362c63ff9a2
BLAKE2b-256 9d189e7b9f0ffc8dd07ea5eb6440ab2e2d7699ed87efbab5b10d4eb4672d3d50

See more details on using hashes here.

File details

Details for the file pymssql-2.1.1-cp26-none-win32.whl.

File metadata

File hashes

Hashes for pymssql-2.1.1-cp26-none-win32.whl
Algorithm Hash digest
SHA256 7a644e8737ac89fb49f3e44be53a9c56baf60631c7d8e15bd068e1c9f16252f4
MD5 0e86f3c6df92bdffecd568404ef10027
BLAKE2b-256 2d6ca64abe073110d565e2a4b00f27261862838d20ce2ca8ff3f95cf21e86e80

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page