METADATA 3.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114
  1. Metadata-Version: 2.0
  2. Name: django-pymssql
  3. Version: 1.7.1
  4. Summary: Django database backend for Microsoft SQL Server that works on non-Windows systems.
  5. Home-page: https://github.com/aaugustin/django-pymssql
  6. Author: Aymeric Augustin
  7. Author-email: aymeric.augustin@m4x.org
  8. License: BSD
  9. Download-URL: http://pypi.python.org/pypi/django-pymssql
  10. Platform: all
  11. Classifier: Development Status :: 4 - Beta
  12. Classifier: Environment :: Web Environment
  13. Classifier: Framework :: Django
  14. Classifier: Framework :: Django :: 1.7
  15. Classifier: Intended Audience :: Developers
  16. Classifier: License :: OSI Approved :: BSD License
  17. Classifier: Operating System :: OS Independent
  18. Classifier: Programming Language :: Python
  19. Classifier: Programming Language :: Python :: 2
  20. Classifier: Programming Language :: Python :: 2.7
  21. Classifier: Programming Language :: Python :: 3
  22. Classifier: Programming Language :: Python :: 3.4
  23. Requires-Dist: Django
  24. Requires-Dist: django-mssql
  25. Requires-Dist: pymssql
  26. Goals
  27. -----
  28. django-pymssql is a Django database backend for Microsoft SQL Server that
  29. works on non-Windows systems.
  30. It's a small wrapper around django-mssql_ that uses pymssql_ instead of ADO to
  31. connect to SQL Server.
  32. It should support the same versions of Python, Django and SQL Server as
  33. django-mssql_.
  34. The original use case was to connect to SQL Server from a Django project
  35. written in Python 3 and running on Linux.
  36. Status
  37. ------
  38. django-pymssql 1.7 almost_ passes Django's test suite with:
  39. - Python 2.7 or 3.4
  40. - Django 1.7.x + django-mssql 1.6.1 + pymssql 2.1.1
  41. - Microsoft® SQL Server® 2012 Express
  42. Usage
  43. -----
  44. django-pymssql provides a Django database engine called ``sqlserver_pymssql``:
  45. .. code-block:: python
  46. DATABASES = {
  47. 'default': {
  48. 'ENGINE': 'sqlserver_pymssql',
  49. 'HOST': '...',
  50. 'NAME': '...',
  51. 'USER': '...',
  52. 'PASSWORD': '...','
  53. 'OPTIONS': {
  54. # ...
  55. },
  56. },
  57. }
  58. Any parameter accepted by `pymssql.connect`_ can be passed in OPTIONS.
  59. Alternatives
  60. ------------
  61. django-sqlserver_ is a fork of django-mssql_ that supports python-tds_ and
  62. pymssql_ in addition to ADO on Windows. Unfortunately it has diverged and it
  63. lags behind django-mssql_ when it comes to supporting newer Django versions.
  64. django-pyodbc_ relies on pyodbc_ to connect to SQL Server. It requires a
  65. complex stack that doesn't bring actual benefits. Besides it doesn't appear
  66. to be very mature nor actively maintained.
  67. Hacking
  68. -------
  69. Clone Django, pymssql, django-mssql and django-pymssql and ``pip install -e
  70. .`` each of them in a virtualenv.
  71. Create a Django tests settings file with the database engine set to
  72. ``'sqlserver_pymssql'`` and credentials for a testing SQL Server instance.
  73. Go the the ``tests`` subdirectory in a clone of Django and execute
  74. ``./runtests.py --settings=test_pymssql``.
  75. License
  76. -------
  77. django-pymssql is released under the MIT license, like django-mssql_. See the
  78. LICENSE file for details. Note that pymssql_ is released under the LGPL.
  79. Some database version checking code was borrowed from django-sqlserver_ which
  80. is also released under the MIT license..
  81. .. _almost: https://github.com/aaugustin/django-pymssql/search?q=failing_tests
  82. .. _django-mssql: http://django-mssql.readthedocs.org/
  83. .. _django-pyodbc: https://github.com/lionheart/django-pyodbc
  84. .. _django-sqlserver: https://github.com/denisenkom/django-sqlserver
  85. .. _pymssql: http://www.pymssql.org/
  86. .. _pymssql.connect: http://pymssql.org/en/latest/ref/pymssql.html#pymssql.connect
  87. .. _pyodbc: https://github.com/mkleehammer/pyodbc
  88. .. _python-tds: https://github.com/denisenkom/pytds