Class: SQLTree::Node::InsertQuery

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_value_list(tokens) ⇒ Object 



340
341
342
343
344
345
346
347
348
349
350
351
352
353
 
# File 'lib/active_record/turntable/sql_tree_patch.rb', line 340

def self.parse_value_list(tokens)
  values = []
  tokens.consume(SQLTree::Token::VALUES)
  tokens.consume(SQLTree::Token::LPAREN)
  values << parse_list(tokens)
  tokens.consume(SQLTree::Token::RPAREN)
  while SQLTree::Token::COMMA === tokens.peek
    tokens.consume(SQLTree::Token::COMMA)
    tokens.consume(SQLTree::Token::LPAREN)
    values << parse_list(tokens)
    tokens.consume(SQLTree::Token::RPAREN)
  end
  values
end

Instance Method Details

#to_sql(options = {}) ⇒ Object 



330
331
332
333
334
335
336
337
338
 
# File 'lib/active_record/turntable/sql_tree_patch.rb', line 330

def to_sql(options = {})
  sql = "INSERT INTO #{table.to_sql(options)} "
  sql << "(" + fields.map { |f| f.to_sql(options) }.join(", ") + ") " if fields
  sql << "VALUES"
  sql << values.map do |value|
    " (" + value.map { |v| v.to_sql(options) }.join(", ") + ")"
  end.join(",")
  sql
end