# File lib/arel/visitors/to_sql.rb, line 61 def initialize connection super() @connection = connection end
# File lib/arel/visitors/to_sql.rb, line 66 def compile node, &block accept(node, Arel::Collectors::SQLString.new, &block).value end
# File lib/arel/visitors/to_sql.rb, line 807 def aggregate name, o, collector collector << "#{name}(" if o.distinct collector << "DISTINCT " end collector = inject_join(o.expressions, collector, ", ") << ")" if o.alias collector << " AS " visit o.alias, collector else collector end end
FIXME: we should probably have a 2-pass visitor for this
# File lib/arel/visitors/to_sql.rb, line 88 def build_subselect key, o stmt = Nodes::SelectStatement.new core = stmt.cores.first core.froms = o.relation core.wheres = o.wheres core.projections = [key] stmt.limit = o.limit stmt.orders = o.orders stmt end
# File lib/arel/visitors/to_sql.rb, line 180 def column_cache(table) schema_cache.columns_hash(table) end
# File lib/arel/visitors/to_sql.rb, line 170 def column_for attr return unless attr name = attr.name.to_s table = attr.relation.table_name return nil unless table_exists? table column_cache(table)[name] end
# File lib/arel/visitors/to_sql.rb, line 801 def infix_value o, collector, value collector = visit o.left, collector collector << value visit o.right, collector end
# File lib/arel/visitors/to_sql.rb, line 790 def inject_join list, collector, join_str len = list.length - 1 list.each_with_index.inject(collector) { |c, (x,i)| if i == len visit x, c else visit(x, c) << join_str end } end
# File lib/arel/visitors/to_sql.rb, line 720 def literal o, collector; collector << o.to_s; end
# File lib/arel/visitors/to_sql.rb, line 784 def maybe_visit thing, collector return collector unless thing collector << " " visit thing, collector end
# File lib/arel/visitors/to_sql.rb, line 769 def quote value, column = nil return value if Arel::Nodes::SqlLiteral === value @connection.quote value, column end
# File lib/arel/visitors/to_sql.rb, line 779 def quote_column_name name return name if Arel::Nodes::SqlLiteral === name @connection.quote_column_name(name) end
# File lib/arel/visitors/to_sql.rb, line 774 def quote_table_name name return name if Arel::Nodes::SqlLiteral === name @connection.quote_table_name(name) end
# File lib/arel/visitors/to_sql.rb, line 730 def quoted o, a quote(o, column_for(a)) end
# File lib/arel/visitors/to_sql.rb, line 72 def schema_cache @connection.schema_cache end
# File lib/arel/visitors/to_sql.rb, line 166 def table_exists? name schema_cache.table_exists? name end
# File lib/arel/visitors/to_sql.rb, line 734 def unsupported o, collector raise "unsupported: #{o.class.name}" end
# File lib/arel/visitors/to_sql.rb, line 709 def visit_Arel_Attributes_Attribute o, collector join_name = o.relation.table_alias || o.relation.name collector << "#{quote_table_name join_name}.#{quote_column_name o.name}" end
# File lib/arel/visitors/to_sql.rb, line 649 def visit_Arel_Nodes_And o, collector inject_join o.children, collector, " AND " end
# File lib/arel/visitors/to_sql.rb, line 698 def visit_Arel_Nodes_As o, collector collector = visit o.left, collector collector << " AS " visit o.right, collector end
# File lib/arel/visitors/to_sql.rb, line 445 def visit_Arel_Nodes_Ascending o, collector visit(o.expr, collector) << " ASC" end
# File lib/arel/visitors/to_sql.rb, line 659 def visit_Arel_Nodes_Assignment o, collector case o.right when Arel::Nodes::UnqualifiedColumn, Arel::Attributes::Attribute, Arel::Nodes::BindParam collector = visit o.left, collector collector << " = " visit o.right, collector else collector = visit o.left, collector collector << " = " collector << quote(o.right, column_for(o.left)).to_s end end
# File lib/arel/visitors/to_sql.rb, line 491 def visit_Arel_Nodes_Avg o, collector aggregate "AVG", o, collector end
# File lib/arel/visitors/to_sql.rb, line 501 def visit_Arel_Nodes_Between o, collector collector = visit o.left, collector collector << " BETWEEN " visit o.right, collector end
# File lib/arel/visitors/to_sql.rb, line 283 def visit_Arel_Nodes_Bin o, collector visit o.expr, collector end
# File lib/arel/visitors/to_sql.rb, line 722 def visit_Arel_Nodes_BindParam o, collector collector.add_bind(o) { "?" } end
# File lib/arel/visitors/to_sql.rb, line 150 def visit_Arel_Nodes_Casted o, collector collector << quoted(o.val, o.attribute).to_s end
# File lib/arel/visitors/to_sql.rb, line 475 def visit_Arel_Nodes_Count o, collector aggregate "COUNT", o, collector end
# File lib/arel/visitors/to_sql.rb, line 391 def visit_Arel_Nodes_CurrentRow o, collector collector << "CURRENT ROW" end
# File lib/arel/visitors/to_sql.rb, line 76 def visit_Arel_Nodes_DeleteStatement o, collector collector << "DELETE FROM " collector = visit o.relation, collector if o.wheres.any? collector << " WHERE " inject_join o.wheres, collector, AND else collector end end
# File lib/arel/visitors/to_sql.rb, line 449 def visit_Arel_Nodes_Descending o, collector visit(o.expr, collector) << " DESC" end
# File lib/arel/visitors/to_sql.rb, line 287 def visit_Arel_Nodes_Distinct o, collector collector << DISTINCT end
# File lib/arel/visitors/to_sql.rb, line 291 def visit_Arel_Nodes_DistinctOn o, collector raise NotImplementedError, 'DISTINCT ON not implemented for this db' end
# File lib/arel/visitors/to_sql.rb, line 543 def visit_Arel_Nodes_DoesNotMatch o, collector collector = visit o.left, collector collector << " NOT LIKE " collector = visit o.right, collector if o.escape collector << ' ESCAPE ' visit o.escape, collector else collector end end
# File lib/arel/visitors/to_sql.rb, line 672 def visit_Arel_Nodes_Equality o, collector right = o.right collector = visit o.left, collector if right.nil? collector << " IS NULL" else collector << " = " visit right, collector end end
# File lib/arel/visitors/to_sql.rb, line 320 def visit_Arel_Nodes_Except o, collector collector << "( " infix_value(o, collector, " EXCEPT ") << " )" end
# File lib/arel/visitors/to_sql.rb, line 139 def visit_Arel_Nodes_Exists o, collector collector << "EXISTS (" collector = visit(o.expressions, collector) << ")" if o.alias collector << " AS " visit o.alias, collector else collector end end
# File lib/arel/visitors/to_sql.rb, line 470 def visit_Arel_Nodes_Extract o, collector collector << "EXTRACT(#{o.field.to_s.upcase} FROM " visit(o.expr, collector) << ")" end
# File lib/arel/visitors/to_sql.rb, line 162 def visit_Arel_Nodes_False o, collector collector << "FALSE" end
# File lib/arel/visitors/to_sql.rb, line 381 def visit_Arel_Nodes_Following o, collector collector = if o.expr visit o.expr, collector else collector << "UNBOUNDED" end collector << " FOLLOWING" end
# File lib/arel/visitors/to_sql.rb, line 578 def visit_Arel_Nodes_FullOuterJoin o, collector collector << "FULL OUTER JOIN " collector = visit o.left, collector collector << SPACE visit o.right, collector end
# File lib/arel/visitors/to_sql.rb, line 513 def visit_Arel_Nodes_GreaterThan o, collector collector = visit o.left, collector collector << " > " visit o.right, collector end
# File lib/arel/visitors/to_sql.rb, line 507 def visit_Arel_Nodes_GreaterThanOrEqual o, collector collector = visit o.left, collector collector << " >= " visit o.right, collector end
# File lib/arel/visitors/to_sql.rb, line 453 def visit_Arel_Nodes_Group o, collector visit o.expr, collector end
# File lib/arel/visitors/to_sql.rb, line 432 def visit_Arel_Nodes_Grouping o, collector if o.expr.is_a? Nodes::Grouping visit(o.expr, collector) else collector << "(" visit(o.expr, collector) << ")" end end
# File lib/arel/visitors/to_sql.rb, line 408 def visit_Arel_Nodes_Having o, collector collector << "HAVING " visit o.expr, collector end
# File lib/arel/visitors/to_sql.rb, line 628 def visit_Arel_Nodes_In o, collector if Array === o.right && o.right.empty? collector << '1=0' else collector = visit o.left, collector collector << " IN (" visit(o.right, collector) << ")" end end
# File lib/arel/visitors/to_sql.rb, line 753 def visit_Arel_Nodes_InfixOperation o, collector collector = visit o.left, collector collector << " #{o.operator} " visit o.right, collector end
# File lib/arel/visitors/to_sql.rb, line 599 def visit_Arel_Nodes_InnerJoin o, collector collector << "INNER JOIN " collector = visit o.left, collector if o.right collector << SPACE visit(o.right, collector) else collector end end
# File lib/arel/visitors/to_sql.rb, line 121 def visit_Arel_Nodes_InsertStatement o, collector collector << "INSERT INTO " collector = visit o.relation, collector if o.columns.any? collector << " (#{o.columns.map { |x| quote_column_name x.name }.join ', '})" end if o.values maybe_visit o.values, collector elsif o.select maybe_visit o.select, collector else collector end end
# File lib/arel/visitors/to_sql.rb, line 315 def visit_Arel_Nodes_Intersect o, collector collector << "( " infix_value(o, collector, " INTERSECT ") << " )" end
# File lib/arel/visitors/to_sql.rb, line 555 def visit_Arel_Nodes_JoinSource o, collector if o.left collector = visit o.left, collector end if o.right.any? collector << " " if o.left collector = inject_join o.right, collector, ' ' end collector end
# File lib/arel/visitors/to_sql.rb, line 525 def visit_Arel_Nodes_LessThan o, collector collector = visit o.left, collector collector << " < " visit o.right, collector end
# File lib/arel/visitors/to_sql.rb, line 519 def visit_Arel_Nodes_LessThanOrEqual o, collector collector = visit o.left, collector collector << " <= " visit o.right, collector end
# File lib/arel/visitors/to_sql.rb, line 418 def visit_Arel_Nodes_Limit o, collector collector << "LIMIT " visit o.expr, collector end
# File lib/arel/visitors/to_sql.rb, line 428 def visit_Arel_Nodes_Lock o, collector visit o.expr, collector end
# File lib/arel/visitors/to_sql.rb, line 531 def visit_Arel_Nodes_Matches o, collector collector = visit o.left, collector collector << " LIKE " collector = visit o.right, collector if o.escape collector << ' ESCAPE ' visit o.escape, collector else collector end end
# File lib/arel/visitors/to_sql.rb, line 483 def visit_Arel_Nodes_Max o, collector aggregate "MAX", o, collector end
# File lib/arel/visitors/to_sql.rb, line 487 def visit_Arel_Nodes_Min o, collector aggregate "MIN", o, collector end
# File lib/arel/visitors/to_sql.rb, line 457 def visit_Arel_Nodes_NamedFunction o, collector collector << o.name collector << "(" collector << "DISTINCT " if o.distinct collector = inject_join(o.expressions, collector, ", ") << ")" if o.alias collector << " AS " visit o.alias, collector else collector end end
# File lib/arel/visitors/to_sql.rb, line 325 def visit_Arel_Nodes_NamedWindow o, collector collector << quote_column_name(o.name) collector << " AS " visit_Arel_Nodes_Window o, collector end
# File lib/arel/visitors/to_sql.rb, line 615 def visit_Arel_Nodes_Not o, collector collector << "NOT (" visit(o.expr, collector) << ")" end
# File lib/arel/visitors/to_sql.rb, line 685 def visit_Arel_Nodes_NotEqual o, collector right = o.right collector = visit o.left, collector if right.nil? collector << " IS NOT NULL" else collector << " != " visit right, collector end end
# File lib/arel/visitors/to_sql.rb, line 638 def visit_Arel_Nodes_NotIn o, collector if Array === o.right && o.right.empty? collector << '1=1' else collector = visit o.left, collector collector << " NOT IN (" collector = visit o.right, collector collector << ")" end end
# File lib/arel/visitors/to_sql.rb, line 570 def visit_Arel_Nodes_NotRegexp o, collector raise NotImplementedError, '!~ not implemented for this db' end
# File lib/arel/visitors/to_sql.rb, line 413 def visit_Arel_Nodes_Offset o, collector collector << "OFFSET " visit o.expr, collector end
# File lib/arel/visitors/to_sql.rb, line 610 def visit_Arel_Nodes_On o, collector collector << "ON " visit o.expr, collector end
# File lib/arel/visitors/to_sql.rb, line 653 def visit_Arel_Nodes_Or o, collector collector = visit o.left, collector collector << " OR " visit o.right, collector end
# File lib/arel/visitors/to_sql.rb, line 585 def visit_Arel_Nodes_OuterJoin o, collector collector << "LEFT OUTER JOIN " collector = visit o.left, collector collector << " " visit o.right, collector end
# File lib/arel/visitors/to_sql.rb, line 395 def visit_Arel_Nodes_Over o, collector case o.right when nil visit(o.left, collector) << " OVER ()" when Arel::Nodes::SqlLiteral infix_value o, collector, " OVER " when String, Symbol visit(o.left, collector) << " OVER #{quote_column_name o.right.to_s}" else infix_value o, collector, " OVER " end end
# File lib/arel/visitors/to_sql.rb, line 371 def visit_Arel_Nodes_Preceding o, collector collector = if o.expr visit o.expr, collector else collector << "UNBOUNDED" end collector << " PRECEDING" end
# File lib/arel/visitors/to_sql.rb, line 154 def visit_Arel_Nodes_Quoted o, collector collector << quoted(o.expr, nil).to_s end
# File lib/arel/visitors/to_sql.rb, line 362 def visit_Arel_Nodes_Range o, collector if o.expr collector << "RANGE " visit o.expr, collector else collector << "RANGE" end end
# File lib/arel/visitors/to_sql.rb, line 566 def visit_Arel_Nodes_Regexp o, collector raise NotImplementedError, '~ not implemented for this db' end
# File lib/arel/visitors/to_sql.rb, line 592 def visit_Arel_Nodes_RightOuterJoin o, collector collector << "RIGHT OUTER JOIN " collector = visit o.left, collector collector << SPACE visit o.right, collector end
# File lib/arel/visitors/to_sql.rb, line 353 def visit_Arel_Nodes_Rows o, collector if o.expr collector << "ROWS " visit o.expr, collector else collector << "ROWS" end end
# File lib/arel/visitors/to_sql.rb, line 230 def visit_Arel_Nodes_SelectCore o, collector collector << "SELECT" collector = maybe_visit o.top, collector collector = maybe_visit o.set_quantifier, collector unless o.projections.empty? collector << SPACE len = o.projections.length - 1 o.projections.each_with_index do |x, i| collector = visit(x, collector) collector << COMMA unless len == i end end if o.source && !o.source.empty? collector << " FROM " collector = visit o.source, collector end unless o.wheres.empty? collector << WHERE len = o.wheres.length - 1 o.wheres.each_with_index do |x, i| collector = visit(x, collector) collector << AND unless len == i end end unless o.groups.empty? collector << GROUP_BY len = o.groups.length - 1 o.groups.each_with_index do |x, i| collector = visit(x, collector) collector << COMMA unless len == i end end collector = maybe_visit o.having, collector unless o.windows.empty? collector << WINDOW len = o.windows.length - 1 o.windows.each_with_index do |x, i| collector = visit(x, collector) collector << COMMA unless len == i end end collector end
# File lib/arel/visitors/to_sql.rb, line 203 def visit_Arel_Nodes_SelectStatement o, collector if o.with collector = visit o.with, collector collector << SPACE end collector = o.cores.inject(collector) { |c,x| visit_Arel_Nodes_SelectCore(x, c) } unless o.orders.empty? collector << SPACE collector << ORDER_BY len = o.orders.length - 1 o.orders.each_with_index { |x, i| collector = visit(x, collector) collector << COMMA unless len == i } end collector = maybe_visit o.limit, collector collector = maybe_visit o.offset, collector collector = maybe_visit o.lock, collector collector end
# File lib/arel/visitors/to_sql.rb, line 574 def visit_Arel_Nodes_StringJoin o, collector visit o.left, collector end
# File lib/arel/visitors/to_sql.rb, line 479 def visit_Arel_Nodes_Sum o, collector aggregate "SUM", o, collector end
# File lib/arel/visitors/to_sql.rb, line 495 def visit_Arel_Nodes_TableAlias o, collector collector = visit o.relation, collector collector << " " collector << quote_table_name(o.name) end
FIXME: this does nothing on most databases, but does on MSSQL
# File lib/arel/visitors/to_sql.rb, line 424 def visit_Arel_Nodes_Top o, collector collector end
# File lib/arel/visitors/to_sql.rb, line 158 def visit_Arel_Nodes_True o, collector collector << "TRUE" end
# File lib/arel/visitors/to_sql.rb, line 305 def visit_Arel_Nodes_Union o, collector collector << "( " infix_value(o, collector, " UNION ") << " )" end
# File lib/arel/visitors/to_sql.rb, line 310 def visit_Arel_Nodes_UnionAll o, collector collector << "( " infix_value(o, collector, " UNION ALL ") << " )" end
# File lib/arel/visitors/to_sql.rb, line 704 def visit_Arel_Nodes_UnqualifiedColumn o, collector collector << "#{quote_column_name o.name}" collector end
# File lib/arel/visitors/to_sql.rb, line 99 def visit_Arel_Nodes_UpdateStatement o, collector if o.orders.empty? && o.limit.nil? wheres = o.wheres else wheres = [Nodes::In.new(o.key, [build_subselect(o.key, o)])] end collector << "UPDATE " collector = visit o.relation, collector unless o.values.empty? collector << " SET " collector = inject_join o.values, collector, ", " end unless wheres.empty? collector << " WHERE " collector = inject_join wheres, collector, " AND " end collector end
# File lib/arel/visitors/to_sql.rb, line 184 def visit_Arel_Nodes_Values o, collector collector << "VALUES (" len = o.expressions.length - 1 o.expressions.zip(o.columns).each_with_index { |(value, attr), i| case value when Nodes::SqlLiteral, Nodes::BindParam collector = visit value, collector else collector << quote(value, attr && column_for(attr)).to_s end unless i == len collector << ', ' end } collector << ")" end
# File lib/arel/visitors/to_sql.rb, line 331 def visit_Arel_Nodes_Window o, collector collector << "(" if o.partitions.any? collector << "PARTITION BY " collector = inject_join o.partitions, collector, ", " end if o.orders.any? collector << ' ' if o.partitions.any? collector << "ORDER BY " collector = inject_join o.orders, collector, ", " end if o.framing collector << ' ' if o.partitions.any? or o.orders.any? collector = visit o.framing, collector end collector << ")" end
# File lib/arel/visitors/to_sql.rb, line 295 def visit_Arel_Nodes_With o, collector collector << "WITH " inject_join o.children, collector, ', ' end
# File lib/arel/visitors/to_sql.rb, line 300 def visit_Arel_Nodes_WithRecursive o, collector collector << "WITH RECURSIVE " inject_join o.children, collector, ', ' end
# File lib/arel/visitors/to_sql.rb, line 441 def visit_Arel_SelectManager o, collector collector << "(#{o.to_sql.rstrip})" end
# File lib/arel/visitors/to_sql.rb, line 620 def visit_Arel_Table o, collector if o.table_alias collector << "#{quote_table_name o.name} #{quote_table_name o.table_alias}" else collector << quote_table_name(o.name) end end
# File lib/arel/visitors/to_sql.rb, line 764 def visit_Array o, collector inject_join o, collector, ", " end