-
Committer:
ballen
-
Date:
2009-04-17 00:31:55 UTC
-
Revision ID:
ballen@ze-ballen.local-20090417003155-64vn3nplgrbp8y7z
This update contains about eight months of changes resulting
from use in a production environment, including:
* MS SQL backend for Storm now supports checking for T-SQL reserved keywords
and escaping them with square brackets.
* Added docstring to explain configurable options for db connectors,
enabling of select statements WITH(NOLOCK), and enabling
options for managing SET IDENTITY_INSERT.
* SET IDENTITY INSERT management is now disabled by default
because it seriously harms performance (but it enables more
Storm unit tests to pass).
* Storm backend for MS SQL Server now supports using WITH(NOLOCK), as
a configurable global setting.
* Added the SQL Server ISNULL function (called IsNull in Python)
* Added configurable support mx executedirect option for Storm MSSQL backend;
however, this needs to be refactored out of the main mssql.py module.
* Fixed bug encountered when ENABLE_IDENTITY_INSERT = False in which
all SQL statements were double executed.
* The mxODBC Storm backend connector now customizes mxODBC to use Python datetime
instead of mxODBC datetime, because Storm doesn't handle mxDateTime.