Module Populator::Adapters::Sqlite
In: lib/populator/adapters/sqlite.rb

Methods

execute_batch   populate  

Public Instance methods

execute_batch(sql, name = nil)

Executes multiple SQL statements in one query when joined with ";"

[Source]

    # File lib/populator/adapters/sqlite.rb, line 5
 5:       def execute_batch(sql, name = nil)
 6:         catch_schema_changes do
 7:           log(sql, name) do
 8:             @connection.transaction { |db| db.execute_batch(sql) }
 9:           end
10:         end
11:       end
populate(table, columns, rows, name = nil)

[Source]

    # File lib/populator/adapters/sqlite.rb, line 13
13:       def populate(table, columns, rows, name = nil)
14:         queries = []
15:         rows.each do |row|
16:           queries << "INSERT INTO #{table} #{columns} VALUES #{row}"
17:         end
18:         execute_batch(queries.join(';'), name)
19:       end

[Validate]