Method: ArelExtensions::Nodes::DateAdd#mssql_datepart

Defined in:
lib/arel_extensions/nodes/date_diff.rb

#mssql_datepart(v = nil) ⇒ Object 



136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
 
# File 'lib/arel_extensions/nodes/date_diff.rb', line 136

def mssql_datepart(v = nil)
  v ||= self.expressions.last
  if defined?(ActiveSupport::Duration) && ActiveSupport::Duration === v
    if @date_type == :date
      Arel.sql('day')
    elsif @date_type == :datetime
      res = if v.parts.size == 1
              #       first entry in the dict v.parts; one of [:years, :months, :weeks, :days, :hours, :minutes, :seconds]
              #       |     the key
              #       |     |     convert symbol to string
              #       |     |     |   remove the plural suffix `s`
              #       v     v     v   v
              v.parts.first.first.to_s[0..-2]
            else
              'second'
            end
      Arel.sql(res)
    end
  else
    if ArelExtensions::Nodes::Duration === v
      v.with_interval = true
      case v.left
      when 'd', 'm', 'y'
        Arel.sql('day')
      when 'h', 'mn', 's'
        Arel.sql('second')
      when /i\z/
        Arel.sql(ArelExtensions::Visitors::MSSQL::LOADED_VISITOR::DATE_MAPPING[v.left[0..-2]])
      else
        Arel.sql(ArelExtensions::Visitors::MSSQL::LOADED_VISITOR::DATE_MAPPING[v.left])
      end
    end
  end
end