Class: SQLTree::Node::TableReference

Inherits:
Base
  • Object
show all
Defined in:
lib/active_record/turntable/sql_tree_patch.rb

Class Method Summary collapse

Instance Method Summary collapse

Methods inherited from Base

#quote_field_name

Class Method Details

.parse(tokens) ⇒ Object 



110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
 
# File 'lib/active_record/turntable/sql_tree_patch.rb', line 110

def self.parse(tokens)
  if SQLTree::Token::Identifier === tokens.peek
    tokens.next
    table_reference = self.new(tokens.current.literal)
    if SQLTree::Token::AS === tokens.peek || SQLTree::Token::Identifier === tokens.peek
      tokens.consume(SQLTree::Token::AS) if SQLTree::Token::AS === tokens.peek
      table_reference.table_alias = tokens.next.literal
    end
    return table_reference
  elsif SQLTree::Token::SELECT === tokens.peek(2)
    table_reference = self.new(SQLTree::Node::SubQuery.parse(tokens))
    if SQLTree::Token::AS === tokens.peek || SQLTree::Token::Identifier === tokens.peek
      tokens.consume(SQLTree::Token::AS) if SQLTree::Token::AS === tokens.peek
      table_reference.table_alias = tokens.next.literal
    end
    table_reference
  else
    raise SQLTree::Parser::UnexpectedToken.new(tokens.current)
  end
end

Instance Method Details

#to_sql(options = {}) ⇒ Object 



104
105
106
107
108
 
# File 'lib/active_record/turntable/sql_tree_patch.rb', line 104

def to_sql(options={})
  sql = (SQLTree::Node::SubQuery === table) ? table.to_sql : quote_field_name(table)
  sql << " AS " << quote_field_name(table_alias) if table_alias
  return sql
end