const_defined?(:MSSQL) ? MSSQL : ToSql
@note AREL set’s up `Arel::Visitors::MSSQL` but we should not use that one !
@private
@private
# File lib/arel/visitors/sql_server.rb, line 85 def visit_Arel_Nodes_Bin o, a = nil "#{do_visit o.expr, a} COLLATE Latin1_General_CS_AS_WS" end
# File lib/arel/visitors/sql_server.rb, line 72 def visit_Arel_Nodes_Limit o, a = nil "TOP (#{do_visit o.expr, a})" end
# File lib/arel/visitors/sql_server.rb, line 56 def visit_Arel_Nodes_Lock o, a = nil # MS-SQL doesn't support "SELECT...FOR UPDATE". Instead, it needs # WITH(ROWLOCK,UPDLOCK) specified after each table in the FROM clause. # # we return nothing here and add the appropriate stuff with #add_lock! #do_visit o.expr, a end
# File lib/arel/visitors/sql_server.rb, line 76 def visit_Arel_Nodes_Ordering o, a = nil expr = do_visit o.expr, a if o.respond_to?(:direction) "#{expr} #{o.ascending? ? 'ASC' : 'DESC'}" else expr end end
# File lib/arel/visitors/sql_server.rb, line 8 def visit_Arel_Nodes_SelectStatement(*args) # [o] AR <= 4.0 [o, a] on 4.1 o, a = args.first, args.last return super if ! o.limit && ! o.offset # NOTE: really? unless o.orders.empty? select_order_by = "ORDER BY #{do_visit_columns(o.orders, a).join(', ')}" end select_count = false sql = o.cores.map do |x| x = x.dup order_by = select_order_by || determine_order_by(x, a) if select_count? x p = order_by ? row_num_literal(order_by) : Arel::Nodes::SqlLiteral.new("*") x.projections = [p] select_count = true else # NOTE: this should really be added here and we should built the # wrapping SQL but than #replace_limit_offset! assumes it does that # ... MS-SQL adapter code seems to be 'hacked' by a lot of people #x.projections << row_num_literal(order_by) end do_visit_select_core x, a end.join #sql = "SELECT _t.* FROM (#{sql}) as _t WHERE #{get_offset_limit_clause(o)}" select_order_by ||= "ORDER BY #{@connection.determine_order_clause(sql)}" replace_limit_offset!(sql, limit_for(o.limit), o.offset && o.offset.value.to_i, select_order_by) sql = "SELECT COUNT(*) AS count_id FROM (#{sql}) AS subquery" if select_count add_lock!(sql, :lock => o.lock && true) sql end
# File lib/arel/visitors/sql_server.rb, line 64 def visit_Arel_Nodes_Top o, a = nil # `top` wouldn't really work here: # User.select("distinct first_name").limit(10) # would generate "select top 10 distinct first_name from users", # which is invalid should be "select distinct top 10 first_name ..." '' end
Generated with the Darkfish Rdoc Generator 2.