aboutsummaryrefslogtreecommitdiffstats
path: root/activerecord/lib/active_record/connection_adapters/sqlserver_adapter.rb
Commit message (Collapse)AuthorAgeFilesLines
* SQLServer: recognize real column type as Ruby float, correctly schema-dump ↵Jeremy Kemper2007-03-031-11/+21
| | | | | | tables with no indexes or descending indexes. References #7057, #7703. Closes #7333. git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@6297 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* SQLServer: don't choke on strings containing 'null'. Closes #7083.Jeremy Kemper2007-01-281-1/+1
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@6084 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* SQLServer: quote table name in indexes query. Closes #2928.Jeremy Kemper2007-01-231-1/+1
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@6014 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* be like a duck. Let's not rely on explicit classes, so we can pass proxy ↵Jamis Buck2007-01-151-3/+8
| | | | | | objects around and have them interpreted correctly by ActiveRecord's serialization routines git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@5953 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* change_column accepts :default => nil. Closes #6956.Jeremy Kemper2007-01-151-2/+2
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@5937 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* SQLServer: handle [quoted] table names. Closes #6635.Jeremy Kemper2007-01-121-0/+1
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@5891 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Oracle: resolve test failures, use prefetched primary key for inserts, check ↵Jeremy Kemper2006-11-011-11/+1
| | | | | | for null defaults. Factor out some common methods from all adapters. Closes #6515. git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@5384 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* SQLServer: work around bug where some unambiguous date formats are not ↵Jeremy Kemper2006-08-251-1/+2
| | | | | | correctly identified if the session language is set to german. Closes #5894. git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@4816 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Refactored select routing for SQL Server adapter (closes #5683) [tom@popdog.net]David Heinemeier Hansson2006-08-051-11/+11
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@4671 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* SQLServer: added tests to ensure all database statements are closed, ↵Jeremy Kemper2006-07-101-94/+123
| | | | | | refactored identity_insert management code to use blocks, removed update/delete rowcount code out of execute and into update/delete, changed insert to go through execute method, removed unused quoting methods, disabled pessimistic locking tests as feature is currently unsupported, fixed RakeFile to load sqlserver specific tests whether running in ado or odbc mode, fixed support for recently added decimal types, added support for limits on integer types. Closes #5670. git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@4601 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* r4704@asus: jeremy | 2006-06-27 12:00:19 -0700Jeremy Kemper2006-07-081-45/+36
| | | | | | | | | | | | | | | decimal r4705@asus: jeremy | 2006-06-27 12:20:47 -0700 current_adapter? checks whether any of its arguments is the name of the current adapter class r4834@asus: jeremy | 2006-07-08 13:08:24 -0700 Room to float. r4835@asus: jeremy | 2006-07-08 13:09:18 -0700 Give lock test a few chances. r4836@asus: jeremy | 2006-07-08 13:12:05 -0700 Numeric and decimal columns map to BigDecimal instead of Float. Those with scale 0 map to Integer. Closes #5454. git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@4596 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Fixed problems with eager loading and counting on SQL Server (closed #5212) ↵David Heinemeier Hansson2006-06-031-4/+6
| | | | | | [kajism@yahoo.com] git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@4418 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Mind the order of things.Jeremy Kemper2006-06-011-0/+2
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@4393 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Various fixes for sqlserver_adapter (odbc statement finishing, ado schema ↵Marcel Molina2006-04-261-18/+30
| | | | | | dumper, drop index). Closes #4831. [kajism@yahoo.com] git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@4279 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Only string_to_binary if the column respondsDavid Heinemeier Hansson2006-03-261-1/+1
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@4040 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* SQL Server adapter gets some love (closes #4298) [rtomayko@gmail.com]David Heinemeier Hansson2006-03-181-13/+21
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@3949 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Added connection#current_database that'll return of the current database ↵David Heinemeier Hansson2006-03-181-0/+4
| | | | | | (only works in MySQL, SQL Server, and Oracle so far -- please help implement for the rest of the adapters) (closes #3663) [Tom ward] git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@3911 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* ActiveRecord::Base.remove_connection explicitly closes database connections ↵Jeremy Kemper2006-02-261-1/+7
| | | | | | and doesn't corrupt the connection cache. Introducing the disconnect! instance method for the PostgreSQL, MySQL, and SQL Server adapters; implementations for the others are welcome. References #3591. git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@3674 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* SQLServer: more compatible limit/offset emulation. Closes #3779.Jeremy Kemper2006-02-091-1/+3
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@3564 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* SQLServer: fix obscure optimistic locking bug, support uniqueidentifier ↵Jeremy Kemper2005-12-101-4/+8
| | | | | | columns, cope with tables names qualified by owner, cope with columns with desc in the name, cope with primary keys with select in the name. Closes #3068, #2930, #3067, #1950, #3057, #3162. git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@3270 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* SQLServer: resolve column aliasing/quoting collision when using limit or ↵Jeremy Kemper2005-11-241-1/+6
| | | | | | offset in an eager find. References #2974. git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@3184 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* SQLServer: active? and reconnect! methods for handling stale connections. ↵Jeremy Kemper2005-11-151-11/+8
| | | | | | References #428. git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@3045 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* SQLServer: active? and reconnect! methods for handling stale connections. ↵Jeremy Kemper2005-11-151-3/+32
| | | | | | References #428. git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@3044 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* SQLServer: insert uses given primary key value if not nil rather than SELECT ↵Jeremy Kemper2005-11-141-1/+1
| | | | | | @@IDENTITY. References #2866. git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@3035 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* SQLServer: don't report limits for unsupported field types. Closes #2835.Jeremy Kemper2005-11-111-0/+2
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@2982 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Correct handling of complex order clauses with SQL Server limit emulation. ↵Jeremy Kemper2005-11-081-1/+1
| | | | | | Closes #2770. git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@2943 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Fixed faulty regex in get_table_name method (SQLServerAdapter) (closes ↵David Heinemeier Hansson2005-11-071-2/+2
| | | | | | #2639) [Ryan Tomayko] git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@2910 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Fixed that SQL Server should ignore :size declarations on anything but ↵David Heinemeier Hansson2005-11-061-1/+10
| | | | | | integer and string in the agnostic schema representation (closes #2756) [Ryan Tomayko] git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@2887 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Omit internal dtproperties table from SQLServer table list. Closes #2729.Jeremy Kemper2005-11-041-5/+7
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@2869 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Fixed SQL Server adapter so it honors options[:conditions] when applying ↵David Heinemeier Hansson2005-10-281-13/+27
| | | | | | :limits (closes #1978) [Tom Ward] Fixed SQL Server adapter to pass even more tests and do even better (closes #2634) [rtomayko@gmail.com] git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@2781 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Added migration support to SQL Server adapter (please someone do the same ↵David Heinemeier Hansson2005-10-281-0/+66
| | | | | | for Oracle and DB2) (closes #2625) [Tom Ward] git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@2778 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Refactor DB exceptions and deal more with DB2 (closes #2624)David Heinemeier Hansson2005-10-271-0/+2
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@2761 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* SQL Server needs to quote booleans just like MySQL 1/0David Heinemeier Hansson2005-10-141-0/+8
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@2586 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Corrections to SQLServer native data types. Closes #2267.Marcel Molina2005-10-121-10/+10
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@2545 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Add option (true by default) to generate reader methods for each attribute ↵Marcel Molina2005-10-071-3/+3
| | | | | | of a record to avoid the overhead of calling method missing. In partial fullfilment of #1236. git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@2483 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Remove straggling symbolize_strings_in_hash from [2427].Jeremy Kemper2005-10-061-1/+1
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@2479 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Fixed that the SQL Server adapter would sometimes return DBI::Timestamp ↵David Heinemeier Hansson2005-09-091-0/+1
| | | | | | objects instead of Time #2127 [Tom Ward] git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@2169 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Made Oracle a first-class connection adapter by adhering closer to idiomatic ↵David Heinemeier Hansson2005-07-241-1/+1
| | | | | | Oracle style #1798 [The Gang of Oracles] git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@1912 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Fixed optimistic locking with SQL Server #1660 [tom@popdog.net]David Heinemeier Hansson2005-07-091-2/+2
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@1784 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Fixed SQL Server test #1678 [Tom Ward]David Heinemeier Hansson2005-07-091-1/+1
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@1782 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Made documentation ready for release (AR)David Heinemeier Hansson2005-07-061-43/+41
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@1733 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Fixed Base.content_columns call for SQL Server adapter #1450 [DeLynn Berry] ↵David Heinemeier Hansson2005-07-031-1/+5
| | | | | | And a bug with the offset rules git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@1647 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* r1611@asus: jeremy | 2005-07-03 04:21:52 -0700Jeremy Kemper2005-07-031-26/+17
| | | | | | | No longer pass superfluous connection to AbstractAdapter#log. git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@1629 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* r1603@asus: jeremy | 2005-07-02 14:38:52 -0700Jeremy Kemper2005-07-031-4/+4
| | | | | | | Faster MysqlAdapter#select. git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@1622 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Added support for ODBC connections to MS SQL Server so you can connect from ↵David Heinemeier Hansson2005-07-011-94/+128
| | | | | | a non-Windows machine #1569 [Mark Imbriaco/DeLynn Berry] Added support for limit/offset with the MS SQL Server driver so that pagination will now work #1569 [DeLynn Berry] git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@1583 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Fixes a problem with the SQL Adapter which was resulting in IDENTITY_INSERT ↵David Heinemeier Hansson2005-04-171-2/+1
| | | | | | not being set to ON when it should be #1104 [adelle] git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@1192 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Fixed the MS SQL adapter to work with the new limit/offset approach and with ↵David Heinemeier Hansson2005-03-231-127/+133
| | | | | | binary data (still suffering from 7KB limit, though) #901 [delynnb] git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@982 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Added adapter independent limit clause as a two-element array with the first ↵David Heinemeier Hansson2005-03-201-13/+6
| | | | | | being the limit, the second being the offset #795 [Sam Stephenson] git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@944 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Finished polishing API docsDavid Heinemeier Hansson2005-02-231-5/+5
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@773 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Added documentation for database adapters to visible RDocDavid Heinemeier Hansson2005-02-231-20/+18
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@771 5ecf4fe2-1ee6-0310-87b1-e25e094e27de