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 



120
121
122
123
124
125
126
127
128
 
# File 'lib/ransack/adapters/active_record/3.0/compat.rb', line 120

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

#column_for(attr) ⇒ Object 



113
114
115
116
117
118
 
# File 'lib/ransack/adapters/active_record/3.0/compat.rb', line 113

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 



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

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

#visit_Arel_Nodes_InfixOperation(o) ⇒ Object 



130
131
132
 
# File 'lib/ransack/adapters/active_record/3.0/compat.rb', line 130

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

#visit_Arel_Nodes_NamedFunction(o) ⇒ Object 



134
135
136
137
138
139
140
141
142
143
144
 
# File 'lib/ransack/adapters/active_record/3.0/compat.rb', line 134

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

#visit_Arel_Nodes_Not(o) ⇒ Object 



150
151
152
 
# File 'lib/ransack/adapters/active_record/3.0/compat.rb', line 150

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

#visit_Arel_Nodes_Values(o) ⇒ Object 



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

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(Ransack::Constants::COMMA_SPACE)
  })"
end