Skip to main content
This is a pre-production deployment of Warehouse. Changes made here affect the production instance of PyPI (pypi.python.org).
Help us improve Python packaging - Donate today!

Database driver to add Microsoft SQL Server/Azure support to Peewee

Project Description
Peewee
######
A database driver to add Microsoft SQL Server and Azure support using
`pymssql <http://pymssql.org>`__ and `FreeTDS <http://freetds.org>`__ in
Peewee and should run on most Unix-like systems, Microsoft Windows and Mac OS X.

In it's current state you should be able to access data and possibly do certain
updates. You will not be able to create tables or introspect existing databases,
so you will have to write your models manually. Offsets will also not work,
since the query compiler will need some significant rewrite to support TSQL
dialect, however limit will work (TOP).

Installation
============
Install the latest stable release from Pypi:

$ pip install peewee-mssql

Or alternatively, select a release or development version from Github and run:

$ python setup.py install

Getting Started
===============
For help on installing and configuring `FreeTDS <http://freetds.org>`__ I
recommend taking a look at the
`guide <http://pymssql.org/en/latest/freetds.html>`__ in the
`pymssql <http://www.pymssql.org>`__ documentation.

And then you should be able to instantiate a database as below and start
building your models for accessing data:

.. code-block:: python

from peewee_mssql import MssqlDatabase

db = MssqlDatabase('MyDatabase', host='host.example.com', user='domain\\username', password='password')

If you are using Microsoft SQL Server 2005 you will need to use the legacy
datetime data types, simple pass `use_legacy_datetime=True` to the
database driver when initializing.
Release History

Release History

This version
History Node

0.1.2

History Node

0.1.1

History Node

0.1.0

Download Files

Download Files

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

File Name & Checksum SHA256 Checksum Help Version File Type Upload Date
peewee-mssql-0.1.2.tar.gz (3.9 kB) Copy SHA256 Checksum SHA256 Source Aug 18, 2017

Supported By

WebFaction WebFaction Technical Writing Elastic Elastic Search Pingdom Pingdom Monitoring Dyn Dyn DNS 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