This is a pre-production deployment of Warehouse, however changes made here WILL affect the production instance of PyPI.
Latest Version Dependencies status unknown Test status unknown Test coverage unknown
Project Description

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:

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

Recent Changes

Version 2.1.3 - 2016-06-22 - Ramiro Morales

  • We now publish Linux PEP 513 manylinux wheels on PyPI.
  • Windows official binaries: Rollback changes to Windows binaries we had implemented in pymssql 2.1.2; go back to using:
    • A statically linked version of FreeTDS (v0.95.95)
    • No SSL support

Version 2.1.2 - 2016-02-10 - Ramiro Morales

Attention!

Windows users: You need to download and install additional DLLs

pymssql version 2.1.2 includes a change in the official Windows binaries: FreeTDS isn’t statically linked as it happened up to release 2.1.1, as that FreeTDS copy lacked SSL support.

Please see http://pymssql.org/en/latest/freetds.html#windows for futher details.

We are trying to find a balance between security and convenience and will be evaluating the situation for future releases. Your feedback is greatly welcome.

Features

  • Add ability to set TDS protocol version from pymssql when connecting to SQL Server. For the remaining pymssql 2.1.x releases its default value will be 7.1 (GH-323)
  • Add Dockerfile and a Docker image and instructions on how to use it (GH-258). This could be a convenient way to use pymssql without having to build stuff. See http://pymssql.readthedocs.org/en/latest/intro.html#docker Thanks Marc Abramowitz.
  • Floating point values are now accepted as Stored Procedure arguments (GH-287). Thanks Runzhou Li (Leo) for the report and Bill Adams for the implementation.
  • Send pymssql version in the appname TDS protocol login record field when the application doesn’t provide one (GH-354)

Bug fixes

  • Fix a couple of very common causes of segmentation faults in presence of network a partition between a pymssql-based app and SQL Server (GH-147, GH-271) Thanks Marc Abramowitz. See also GH-373.
  • Fix failures and inconsistencies in query parameter interpolation when UTF-8-encoded literals are present (GH-185). Thanks Bill Adams. Also, GH-291.
  • Fix login_timeout parameter of pymssql.connect() (GH-318)
  • Fixed some cases of cursor.rowcont having a -1 value after iterating over the value returned by pymssql cursor fetchmany() and fetchone() methods (GH-141)
  • Remove automatic treatment of string literals passed in queries that start with '0x' as hexadecimal values (GH-286)
  • Fix build fatal error when using Cython >= 0.22 (GH-311)

Internals

  • Add Appveyor hosted CI setup for running tests on Windows (GH-347)
  • Travis CI: Use newer, faster, container-based infrastructure. Also, test against more than one FreeTDS version.
  • Make it possible to build official release files (sdist, wheels) on Travis & AppVeyor.

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.

    Note

    If you need to connect to Azure make sure you use FreeTDS 0.91 or newer.

  • 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…

Release History

Release History

2.1.3

This version

History Node

TODO: Figure out how to actually get changelog content.

Changelog content for this version goes here.

Donec et mollis dolor. Praesent et diam eget libero egestas mattis sit amet vitae augue. Nam tincidunt congue enim, ut porta lorem lacinia consectetur. Donec ut libero sed arcu vehicula ultricies a non tortor. Lorem ipsum dolor sit amet, consectetur adipiscing elit.

Show More

2.1.2

History Node

TODO: Figure out how to actually get changelog content.

Changelog content for this version goes here.

Donec et mollis dolor. Praesent et diam eget libero egestas mattis sit amet vitae augue. Nam tincidunt congue enim, ut porta lorem lacinia consectetur. Donec ut libero sed arcu vehicula ultricies a non tortor. Lorem ipsum dolor sit amet, consectetur adipiscing elit.

Show More

2.1.1

History Node

TODO: Figure out how to actually get changelog content.

Changelog content for this version goes here.

Donec et mollis dolor. Praesent et diam eget libero egestas mattis sit amet vitae augue. Nam tincidunt congue enim, ut porta lorem lacinia consectetur. Donec ut libero sed arcu vehicula ultricies a non tortor. Lorem ipsum dolor sit amet, consectetur adipiscing elit.

Show More

2.1.0

History Node

TODO: Figure out how to actually get changelog content.

Changelog content for this version goes here.

Donec et mollis dolor. Praesent et diam eget libero egestas mattis sit amet vitae augue. Nam tincidunt congue enim, ut porta lorem lacinia consectetur. Donec ut libero sed arcu vehicula ultricies a non tortor. Lorem ipsum dolor sit amet, consectetur adipiscing elit.

Show More

2.0.1

History Node

TODO: Figure out how to actually get changelog content.

Changelog content for this version goes here.

Donec et mollis dolor. Praesent et diam eget libero egestas mattis sit amet vitae augue. Nam tincidunt congue enim, ut porta lorem lacinia consectetur. Donec ut libero sed arcu vehicula ultricies a non tortor. Lorem ipsum dolor sit amet, consectetur adipiscing elit.

Show More

2.0.0

History Node

TODO: Figure out how to actually get changelog content.

Changelog content for this version goes here.

Donec et mollis dolor. Praesent et diam eget libero egestas mattis sit amet vitae augue. Nam tincidunt congue enim, ut porta lorem lacinia consectetur. Donec ut libero sed arcu vehicula ultricies a non tortor. Lorem ipsum dolor sit amet, consectetur adipiscing elit.

Show More

1.0.3

History Node

TODO: Figure out how to actually get changelog content.

Changelog content for this version goes here.

Donec et mollis dolor. Praesent et diam eget libero egestas mattis sit amet vitae augue. Nam tincidunt congue enim, ut porta lorem lacinia consectetur. Donec ut libero sed arcu vehicula ultricies a non tortor. Lorem ipsum dolor sit amet, consectetur adipiscing elit.

Show More

1.0.2

History Node

TODO: Figure out how to actually get changelog content.

Changelog content for this version goes here.

Donec et mollis dolor. Praesent et diam eget libero egestas mattis sit amet vitae augue. Nam tincidunt congue enim, ut porta lorem lacinia consectetur. Donec ut libero sed arcu vehicula ultricies a non tortor. Lorem ipsum dolor sit amet, consectetur adipiscing elit.

Show More

1.0.1

History Node

TODO: Figure out how to actually get changelog content.

Changelog content for this version goes here.

Donec et mollis dolor. Praesent et diam eget libero egestas mattis sit amet vitae augue. Nam tincidunt congue enim, ut porta lorem lacinia consectetur. Donec ut libero sed arcu vehicula ultricies a non tortor. Lorem ipsum dolor sit amet, consectetur adipiscing elit.

Show More

1.0.0

History Node

TODO: Figure out how to actually get changelog content.

Changelog content for this version goes here.

Donec et mollis dolor. Praesent et diam eget libero egestas mattis sit amet vitae augue. Nam tincidunt congue enim, ut porta lorem lacinia consectetur. Donec ut libero sed arcu vehicula ultricies a non tortor. Lorem ipsum dolor sit amet, consectetur adipiscing elit.

Show More

0.7.4

History Node

TODO: Figure out how to actually get changelog content.

Changelog content for this version goes here.

Donec et mollis dolor. Praesent et diam eget libero egestas mattis sit amet vitae augue. Nam tincidunt congue enim, ut porta lorem lacinia consectetur. Donec ut libero sed arcu vehicula ultricies a non tortor. Lorem ipsum dolor sit amet, consectetur adipiscing elit.

Show More

0.7.1

History Node

TODO: Figure out how to actually get changelog content.

Changelog content for this version goes here.

Donec et mollis dolor. Praesent et diam eget libero egestas mattis sit amet vitae augue. Nam tincidunt congue enim, ut porta lorem lacinia consectetur. Donec ut libero sed arcu vehicula ultricies a non tortor. Lorem ipsum dolor sit amet, consectetur adipiscing elit.

Show More

0.6.0

History Node

TODO: Figure out how to actually get changelog content.

Changelog content for this version goes here.

Donec et mollis dolor. Praesent et diam eget libero egestas mattis sit amet vitae augue. Nam tincidunt congue enim, ut porta lorem lacinia consectetur. Donec ut libero sed arcu vehicula ultricies a non tortor. Lorem ipsum dolor sit amet, consectetur adipiscing elit.

Show More

0.5.2

History Node

TODO: Figure out how to actually get changelog content.

Changelog content for this version goes here.

Donec et mollis dolor. Praesent et diam eget libero egestas mattis sit amet vitae augue. Nam tincidunt congue enim, ut porta lorem lacinia consectetur. Donec ut libero sed arcu vehicula ultricies a non tortor. Lorem ipsum dolor sit amet, consectetur adipiscing elit.

Show More

Download Files

Download Files

TODO: Brief introduction on what you do with files - including link to relevant help section.

File Name & Checksum SHA256 Checksum Help Version File Type Upload Date
pymssql-2.1.3-cp27-cp27mu-manylinux1_i686.whl (1.0 MB) Copy SHA256 Checksum SHA256 2.7 Wheel Jun 22, 2016
pymssql-2.1.3-cp27-cp27mu-manylinux1_x86_64.whl (1.1 MB) Copy SHA256 Checksum SHA256 2.7 Wheel Jun 22, 2016
pymssql-2.1.3-cp27-cp27m-win32.whl (330.0 kB) Copy SHA256 Checksum SHA256 cp27 Wheel Jun 22, 2016
pymssql-2.1.3-cp27-cp27m-win_amd64.whl (377.0 kB) Copy SHA256 Checksum SHA256 cp27 Wheel Jun 22, 2016
pymssql-2.1.3-cp33-cp33m-manylinux1_i686.whl (1.0 MB) Copy SHA256 Checksum SHA256 3.3 Wheel Jun 22, 2016
pymssql-2.1.3-cp33-cp33m-manylinux1_x86_64.whl (1.1 MB) Copy SHA256 Checksum SHA256 3.3 Wheel Jun 22, 2016
pymssql-2.1.3-cp33-cp33m-win32.whl (331.6 kB) Copy SHA256 Checksum SHA256 cp33 Wheel Jun 22, 2016
pymssql-2.1.3-cp33-cp33m-win_amd64.whl (371.3 kB) Copy SHA256 Checksum SHA256 cp33 Wheel Jun 22, 2016
pymssql-2.1.3-cp34-cp34m-manylinux1_i686.whl (1.1 MB) Copy SHA256 Checksum SHA256 3.4 Wheel Jun 22, 2016
pymssql-2.1.3-cp34-cp34m-manylinux1_x86_64.whl (1.2 MB) Copy SHA256 Checksum SHA256 3.4 Wheel Jun 22, 2016
pymssql-2.1.3-cp34-cp34m-win32.whl (331.5 kB) Copy SHA256 Checksum SHA256 cp34 Wheel Jun 22, 2016
pymssql-2.1.3-cp34-cp34m-win_amd64.whl (371.3 kB) Copy SHA256 Checksum SHA256 cp34 Wheel Jun 22, 2016
pymssql-2.1.3-cp35-cp35m-manylinux1_i686.whl (1.1 MB) Copy SHA256 Checksum SHA256 3.5 Wheel Jun 22, 2016
pymssql-2.1.3-cp35-cp35m-manylinux1_x86_64.whl (1.2 MB) Copy SHA256 Checksum SHA256 3.5 Wheel Jun 22, 2016
pymssql-2.1.3-cp35-cp35m-win32.whl (322.3 kB) Copy SHA256 Checksum SHA256 cp35 Wheel Jun 22, 2016
pymssql-2.1.3-cp35-cp35m-win_amd64.whl (367.4 kB) Copy SHA256 Checksum SHA256 cp35 Wheel Jun 22, 2016
pymssql-2.1.3.tar.gz (898.0 kB) Copy SHA256 Checksum SHA256 Source Jun 22, 2016

Supported By

WebFaction WebFaction Technical Writing Elastic Elastic Search Pingdom Pingdom Monitoring Dyn Dyn DNS HPE HPE Development Sentry Sentry Error Logging CloudAMQP CloudAMQP RabbitMQ Heroku Heroku PaaS Kabu Creative Kabu Creative UX & Design Fastly Fastly CDN DigiCert DigiCert EV Certificate Rackspace Rackspace Cloud Servers DreamHost DreamHost Log Hosting