lp:~zeomega/storm/storm_ms_sql_2005
Added module to allow Storm to register a database backend to support the Microsoft SQL 2005; development supported by ZeOmega.com.
- Get this branch:
- bzr branch lp:~zeomega/storm/storm_ms_sql_2005
Branch merges
Related bugs
Related blueprints
Recent revisions
- 227. By ballen <email address hidden>
-
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. - 226. By ballen <email address hidden>
-
Added examples of using other db connectors such as pymssql and adodbapi
- 225. By ballen <email address hidden>
-
Corrected another broken import statement; ran unit tests this time before commit; there were 88 errors out of 348 test cases
- 224. By ballen <email address hidden>
-
Corrected broken import statement caused by renaming ms_sql_connector.py to mssql_connector.py.
- 223. By ballen <email address hidden>
-
Corrected license docs, renamed ms_sql testrunner module to be more consistent with backend name, added missing exception import in mssql backend.
- 222. By ballen <email address hidden>
-
Retired duplicate module name (ms_sql.py was duplicate of mssql2005.py) and changed unit tests and related modules to be consistent with new name of mssql2005.py.
- 221. By ballen <email address hidden>
-
Changes to mssql.py to help pass unit tests. Now passing 263 store tests,
but still have failures=6, errors=79. This commit fixes the following
issues:
- MS SQL does not recognize LIMIT keyword; backend Insert compiler
now uses TOP instead
- Now support IDENTITY_INSERT; SQL Server needs specific commands
to allow inserts into identity columns. Uses database introspection
so the unit tests need not be changed.
- Now supports Unicode round trip to and from the database for
mxODBC driver
In addition, this commit removes direct dependence on mxODBC, by
moving the import statement to an mssql_connector.py module which
could be configured to support other ways to connect to MS SQL Server. - 218. By ballen <email address hidden>
-
Added top level testrunner script hard coded for testing MS SQL backend
Branch metadata
- Branch format:
- Branch format 6
- Repository format:
- Bazaar-NG Knit Repository Format 1