id,summary,reporter,owner,description,type,status,component,version,severity,resolution,keywords,cc,stage,has_patch,needs_docs,needs_tests,needs_better_patch,easy,ui_ux 1258,[Patch] MS-SQL backend via pymssql,Cheng ,Adrian Holovaty,"The patches are based on the work of Jakub Labath . I merely helped to cut the doctest errors down to 2. This wrapper requires [http://pymssql.sourceforge.net/ pymssql]. I tested with pymssql 0.7.3. A patch of pymssql is attached for boolean typecast and autocommit. The patches tested with Django [2100]. 2 errors left: {{{ 'subclassing' module: API test failed ===================================== Code: 'a3.pub_date' Line: 66 Expected: 'datetime.date(2005, 8, 22)\n' Got: 'datetime.datetime(2005, 8, 22, 0, 0)\n' 'subclassing' module: API test failed ===================================== Code: 'a4.pub_date' Line: 86 Expected: 'datetime.date(2005, 8, 22)\n' Got: 'datetime.datetime(2005, 8, 22, 0, 0)\n' 2 errors: }}} The pymssql provides no hook to do custom typecasts. With the hints from [http://groups.google.com/group/django-developers/browse_frm/thread/9c08abef1fd4d71d/0d8f4bb8ff1e5d7a?q=mssql&rnum=2#0d8f4bb8ff1e5d7a this email thread], I still couldn't find a place to cast MSSQL's native datetime to date or time, if the field type is 'DateField' or 'TimeField'. BTW: I just noticed that pymssql says it works on Windows as well. I didn't test it, but if so, it's more flexible than adodbapi then.",enhancement,closed,"Database layer (models, ORM)",,normal,duplicate,,,Unreviewed,0,0,0,0,0,0