Method: Spider::Model::Storage::Db::DbStorage#sql_insert

Defined in:
lib/spiderfw/model/storage/db/db_storage.rb

#sql_insert(insert) ⇒ Object

Returns SQL and values for an insert statement.



471
472
473
474
475
476
 
# File 'lib/spiderfw/model/storage/db/db_storage.rb', line 471

def sql_insert(insert)
    curr[:last_query_type] = :insert
    sql = "INSERT INTO #{insert[:table]} (#{insert[:values].keys.map{ |k| k.name }.join(', ')}) " +
          "VALUES (#{insert[:values].values.map{'?'}.join(', ')})"
    return [sql, insert[:values].values]
end