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

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

#sql_delete(delete, force = false) ⇒ Object

Returns SQL and bound values for a DELETE statement.



506
507
508
509
510
511
512
513
 
# File 'lib/spiderfw/model/storage/db/db_storage.rb', line 506

def sql_delete(delete, force=false)
    curr[:last_query_type] = :delete
    where, bind_vars = sql_condition(delete)
    where = "1=0" if !force && (!where || where.empty?)
    sql = "DELETE FROM #{delete[:table]}"
    sql += " WHERE #{where}" if where && !where.empty?
    return [sql, bind_vars]
end