Class: Arel::Visitors::ToSql

Inherits:
Object
  • Object
show all
Defined in:
lib/ransack/adapters/active_record/3.0/compat.rb

Instance Method Summary collapse

Instance Method Details

#column_cache ⇒ Object 



117
118
119
120
121
122
123
124
125
 
# File 'lib/ransack/adapters/active_record/3.0/compat.rb', line 117

def column_cache
  @column_cache ||= Hash.new do |hash, key|
    hash[key] = Hash[
      @engine.connection
      .columns(key, "#{key} Columns")
      .map { |c| [c.name, c] }
    ]
  end
end

#column_for(attr) ⇒ Object 



110
111
112
113
114
115
 
# File 'lib/ransack/adapters/active_record/3.0/compat.rb', line 110

def column_for attr
  name    = attr.name.to_s
  table   = attr.relation.table_name

  column_cache[table][name]
end

#visit_Arel_Nodes_And(o) ⇒ Object 



143
144
145
 
# File 'lib/ransack/adapters/active_record/3.0/compat.rb', line 143

def visit_Arel_Nodes_And o
  o.children.map { |x| visit x }.join(' AND '.freeze)
end

#visit_Arel_Nodes_InfixOperation(o) ⇒ Object 



127
128
129
 
# File 'lib/ransack/adapters/active_record/3.0/compat.rb', line 127

def visit_Arel_Nodes_InfixOperation o
  "#{visit o.left} #{o.operator} #{visit o.right}"
end

#visit_Arel_Nodes_NamedFunction(o) ⇒ Object 



131
132
133
134
135
136
137
138
139
140
141
 
# File 'lib/ransack/adapters/active_record/3.0/compat.rb', line 131

def visit_Arel_Nodes_NamedFunction o
  "#{
    o.name
    }(#{
    o.distinct ? Ransack::Constants::DISTINCT : ''.freeze
    }#{
    o.expressions.map { |x| visit x }.join(', '.freeze)
    })#{
    o.alias ? " AS #{visit o.alias}" : ''.freeze
    }"
end

#visit_Arel_Nodes_Not(o) ⇒ Object 



147
148
149
 
# File 'lib/ransack/adapters/active_record/3.0/compat.rb', line 147

def visit_Arel_Nodes_Not o
  "NOT (#{visit o.expr})"
end

#visit_Arel_Nodes_Values(o) ⇒ Object 



151
152
153
154
155
156
157
158
159
160
161
162
163
 
# File 'lib/ransack/adapters/active_record/3.0/compat.rb', line 151

def visit_Arel_Nodes_Values o
  "VALUES (#{
  o.expressions.zip(o.columns)
  .map { |value, attr|
    if Nodes::SqlLiteral === value
      visit_Arel_Nodes_SqlLiteral value
    else
      quote(value, attr && column_for(attr))
    end
  }
  .join(', '.freeze)
  })"
end