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 



150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
 
# File 'lib/active_record/turntable/sql_tree_patch.rb', line 150

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 



144
145
146
147
148
 
# File 'lib/active_record/turntable/sql_tree_patch.rb', line 144

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