Module: ArJdbc::MSSQL::TSqlMethods
- Included in:
- ArJdbc::MSSQL
- Defined in:
- lib/arjdbc/mssql/tsql_methods.rb
Instance Method Summary collapse
- #add_limit_offset!(sql, options) ⇒ Object
-
#type_to_sql(type, limit = nil, precision = nil, scale = nil) ⇒ Object
:nodoc:.
Instance Method Details
#add_limit_offset!(sql, options) ⇒ Object
22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 |
# File 'lib/arjdbc/mssql/tsql_methods.rb', line 22 def add_limit_offset!(sql, ) if [:limit] and [:offset] total_rows = select_all("SELECT count(*) as TotalRows from (#{sql.gsub(/\bSELECT(\s+DISTINCT)?\b/i, "SELECT\\1 TOP 1000000000")}) tally")[0]["TotalRows"].to_i if ([:limit] + [:offset]) >= total_rows [:limit] = (total_rows - [:offset] >= 0) ? (total_rows - [:offset]) : 0 end sql.sub!(/^\s*SELECT(\s+DISTINCT)?/i, "SELECT * FROM (SELECT TOP #{[:limit]} * FROM (SELECT\\1 TOP #{[:limit] + [:offset]} ") sql << ") AS tmp1" if [:order] [:order] = [:order].split(',').map do |field| parts = field.split(" ") tc = parts[0] if sql =~ /\.\[/ and tc =~ /\./ # if column quoting used in query tc.gsub!(/\./, '\\.\\[') tc << '\\]' end if sql =~ /#{tc} AS (t\d_r\d\d?)/ parts[0] = $1 elsif parts[0] =~ /\w+\.(\w+)/ parts[0] = $1 end parts.join(' ') end.join(', ') sql << " ORDER BY #{change_order_direction([:order])}) AS tmp2 ORDER BY #{[:order]}" else sql << " ) AS tmp2" end elsif sql !~ /^\s*SELECT (@@|COUNT\()/i sql.sub!(/^\s*SELECT(\s+DISTINCT)?/i) do "SELECT#{$1} TOP #{[:limit]}" end unless [:limit].nil? end end |
#type_to_sql(type, limit = nil, precision = nil, scale = nil) ⇒ Object
:nodoc:
6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 |
# File 'lib/arjdbc/mssql/tsql_methods.rb', line 6 def type_to_sql(type, limit = nil, precision = nil, scale = nil) # :nodoc: limit = nil if %w(text binary).include? type.to_s return 'uniqueidentifier' if (type.to_s == 'uniqueidentifier') return super unless type.to_s == 'integer' if limit.nil? || limit == 4 'int' elsif limit == 2 'smallint' elsif limit == 1 'tinyint' else 'bigint' end end |