Commits on Jun 18, 2009
  1. Release 2.2.19

    metaskills committed Jun 18, 2009
  2. Changing add_limit! in ActiveRecord::Base for SQLServer so that it pa…

    …sses through any scoped :order parameters.
    We need these so that our limit and offset code can properly reverse and re-order the inner query and thus correctly paginate the results.
    Signed-off-by: Murray Steele <>
    h-lame committed with metaskills Jun 11, 2009
Commits on Jun 6, 2009
  1. Support changes for new gem packaging to rubyforge in the traditional…

    … "activerecord-sqlserver-adapter".
    metaskills committed Jun 6, 2009
Commits on Jun 5, 2009
  1. Release version 2.2.18.

    metaskills committed Jun 5, 2009
Commits on May 14, 2009
  1. Release version 2.2.17

    metaskills committed May 14, 2009
  2. Add simplified type recognition for varchar(max) and nvarchar(max) un…

    …der SQL Server 2005 to be a :text type. This ensures schema dumper does the right thing. Fixes ticket #30.
    metaskills committed May 14, 2009
  3. Tested ruby 1.9, ruby-odbc 0.9996, and DBI 0.4.1. Also added correct …

    …support for UTF-8 character encoding going in and out of the DB. See before gist and after gist
    metaskills committed May 14, 2009
Commits on May 7, 2009
Commits on Apr 21, 2009
  1. Release 2.2.16 version.

    metaskills committed Apr 21, 2009
  2. Make add_limit_offset! only add locking hints (for tally) when the :l…

    …ock option is present. Added tests to make sure tally SQL is augmented correctly and tests to make sure that add_lock! is doing what it needs for deep sub selects in paginated results.
    metaskills committed Apr 21, 2009
  3. Use reconnect! method in #with_auto_reconnect block since that single…

    … method does the connect and return active? all in one.
    metaskills committed Apr 21, 2009
  4. Add auto reconnect support utilizing a new #with_auto_reconnect block…

    …. By default each query run through the adapter will automatically reconnect at standard intervals, logging attempts along the way, till success or the original exception bubbles up. See docs for more details. Resolves ticket #18
    metaskills committed Apr 21, 2009
Commits on Apr 20, 2009
  1. Provide support for running queries at different isolation levels usi…

    …ng #run_with_isolation_level method that can take a block or not. Also implement a #user_options method that reflects on the current user session values. Resolves #20 [Murray Steele]
    metaskills committed Apr 20, 2009
  2. Supply run_with_isolation_level method to allow running queries at va…

    …rious isolation levels (e.g. to go around other processes locking tables).
    h-lame committed with metaskills Feb 9, 2009
Commits on Mar 24, 2009
  1. Release 2.2.15 version.

    metaskills committed Mar 24, 2009
  2. Better add_lock! method that can add the lock to just about all the e…

    …lements in the statement. This could be eager loaded associations, joins, etc. Done so that paginated results can easily add lock options for performance. Note, the tally count in add_limit_offset! use "WITH (NOLOCK)" explicitly as it can not hurt and is needed.
    metaskills committed Mar 24, 2009
Commits on Mar 17, 2009
  1. Rails2.3 - Back passing tests on 2.2 work. Includes: (1) Created new …

    …test helpers that check ActiveRecord version strings so we can conditionally run 2.2 and 2.3 tests. (2) Making TransactionTestSqlserver use Ship vs Bird model. Also made it conditional run a few blocks for different versions of ActiveRecord. (3) Previous JoinDependency#aliased_table_name_for is now only patched in ActiveRecord equal or greater than 2.3.
    metaskills committed Mar 17, 2009
  2. Rails2.3 - Coerce NestedScopingTest#test_merged_scoped_find to use co…

    …rrect regexp for adapter.
    metaskills committed Mar 17, 2009
  3. Rails2.3 - Implement a custom ActiveRecord::Associations::ClassMethod…

    …s::JoinDependency::JoinAssociation#aliased_table_name_for method that uses a Regexp.escape so that table/column quoting does not get ignored.
    metaskills committed Mar 17, 2009
  4. Rails2.3 - Implement #outside_transaction? and a new transaction test…

    … case to test some SQL Server basic support while implementing this method. Future home of some savepoint tests too.
    metaskills committed Mar 17, 2009
  5. Rails2.3 - Coerced tests that ensure hash conditions on referenced ta…

    …bles are considered when eager loading with limit/offset. Information on these changes and the ticket in rails are.
    metaskills committed Feb 10, 2009
  6. Rails2.3 - Add coerced tests for true/false attributes in selects use…

    … SQL Server case statement.
    metaskills committed Feb 10, 2009
Commits on Mar 16, 2009
  1. Making sure that smalldatetime types are OK to use. Also fixed a bug …

    …in the #view_information method that checks to see if a view definition is equal to 4000 chars, meaning that it is most likely truncated and needs to use the backup method of sp_helptext to get it's view definition.
    metaskills committed Mar 16, 2009