Method: Extract::Export::Table#inserts

Defined in:
lib/extract/export/table.rb

#inserts ⇒ Object 



28
29
30
31
32
33
34
35
36
37
 
# File 'lib/extract/export/table.rb', line 28

def inserts
  res = []
  rows.each do |row|
    col_str = row.keys.map { |x| quoted_col(x) }.join(",")
    val_str = row.values.map { |x| "'#{x}'" }.join(',')
    str = "INSERT INTO #{name} (#{col_str}) VALUES (#{val_str});"
    res << str
  end
  res
end