web.py

MS SQL Server support

Bug #235525 reported by Kiran Jonnalagadda on 2008-05-28

Affects		Status	Importance	Assigned to	Milestone
	web.py	Fix Released	Medium	Anand Chitipothu	web.py 0.3

Web.py does not support MS SQL Server, but this is easily patched using the excellent PyMSSQL module from http://pymssql.sourceforge.net/

I've attached a patch.

Revision history for this message

Kiran Jonnalagadda (jackerhack) wrote on 2008-05-28:

Aaron Swartz (aaronsw) on 2008-05-28

Revision history for this message

Anand Chitipothu (anandology) wrote on 2008-06-01:

I have added support for MSSQL in web.py development branch, which will be released as 0.3.

In 0.3, you need to use

db = web.database(dbn='mssql', ...)
db.query(...)

instead of

web.select

see http://webpy.org/roadmap for proposed changes in 0.3.

Revision history for this message

Kiran Jonnalagadda (jackerhack) wrote on 2008-06-01:

Thanks, Anand. The db.query method will be useful for complicated queries that can't be handled by web.select, insert, etc. Recent example:

INSERT INTO attendance (kiosk)
SELECT kiosk FROM kioskmaster WHERE kiosk NOT IN (SELECT kiosk FROM attendance WHERE date = current_date)

(Turns out the SQL Server equivalent of this PostgreSQL query uses getdate() instead of current_date.)

FWIW, I've put the MSSQL-patched Web.py into production use last week and so far haven't had anything else to worry about.

Anand Chitipothu (anandology) on 2008-12-06

Changed in webpy:
status:	Fix Committed → Fix Released

This report contains Public information

Everyone can see this information.

You are

Subscribing...

Bug watches keep track of this bug in other bug trackers.