Method: DaruLite::IO.dataframe_write_sql

Defined in:
lib/daru_lite/io/io.rb

.dataframe_write_sql(ds, dbh, table) ⇒ Object 



136
137
138
139
140
141
142
 
# File 'lib/daru_lite/io/io.rb', line 136

def dataframe_write_sql(ds, dbh, table)
  require 'dbi'
  query = "INSERT INTO #{table} (#{ds.vectors.to_a.join(',')}) VALUES (#{(['?'] * ds.vectors.size).join(',')})"
  sth   = dbh.prepare(query)
  ds.each_row { |c| sth.execute(*c.to_a) }
  true
end