Class: SQLTree::Node::TableReference

Inherits:

Base

• Object
• Base
• SQLTree::Node::TableReference

Defined in:

lib/active_record/turntable/sql_tree_patch.rb

Class Method Summary

• .parse(tokens) ⇒ Object

Instance Method Summary

• #initialize(table, table_alias = nil, index_hint = nil) ⇒ TableReference constructor

  A new instance of TableReference.

• #to_sql(options = {}) ⇒ Object

Methods inherited from Base

#quote_field_name

Constructor Details

#initialize(table, table_alias = nil, index_hint = nil) ⇒ TableReference

Returns a new instance of TableReference.

# File 'lib/active_record/turntable/sql_tree_patch.rb', line 156

def initialize(table, table_alias = nil, index_hint = nil)
  @table = table
  @table_alias = table_alias
  @index_hint = index_hint
end

Class Method Details

.parse(tokens) ⇒ Object

# File 'lib/active_record/turntable/sql_tree_patch.rb', line 169

def self.parse(tokens)
  if SQLTree::Token::Identifier === tokens.peek
    tokens.next
    table_reference = self.new(tokens.current.literal)
    if tokens.peek && !tokens.peek.possible_index_hint? &&
       (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
    if tokens.peek && tokens.peek.possible_index_hint? && tokens.peek(2).index_keyword?
      table_reference.index_hint = SQLTree::Node::IndexHint.parse(tokens)
    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, tokens.current
  end
end

Instance Method Details

#to_sql(options = {}) ⇒ Object

# File 'lib/active_record/turntable/sql_tree_patch.rb', line 162

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
  sql << " " << index_hint.to_sql if index_hint
  sql
end