Storm

lp:~zeomega/storm/storm_ms_sql_2005

Created by ZeOmega and last modified

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
Members of ZeOmega can upload to this branch. Log in for directions.

Branch merges

Related bugs

Related blueprints

Branch information

Owner:
ZeOmega
Project:
Storm
Status:
Development

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.

220. By ballen <email address hidden>

merged files added by Jeff to my local branch

219. By ballen <email address hidden>

Added MS SQL backend modules.

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
This branch contains Public information 
Everyone can see this information.