module Sequel::Dataset::Replace

Public Instance Methods

multi_replace(*values) click to toggle source

Replace multiple rows in a single query.

   # File lib/sequel/adapters/utils/replace.rb
18 def multi_replace(*values)
19   clone(:replace=>true).multi_insert(*values)
20 end
replace(*values) click to toggle source

Execute a REPLACE statement on the database (deletes any duplicate rows before inserting).

   # File lib/sequel/adapters/utils/replace.rb
 8 def replace(*values)
 9   execute_insert(replace_sql(*values))
10 end
replace_sql(*values) click to toggle source

SQL statement for REPLACE

   # File lib/sequel/adapters/utils/replace.rb
13 def replace_sql(*values)
14   clone(:replace=>true).insert_sql(*values)
15 end
supports_replace?() click to toggle source

Databases using this module support REPLACE.

   # File lib/sequel/adapters/utils/replace.rb
23 def supports_replace?
24   true
25 end

Private Instance Methods

insert_insert_sql(sql) click to toggle source

If this is an replace instead of an insert, use replace instead

   # File lib/sequel/adapters/utils/replace.rb
30 def insert_insert_sql(sql)
31   sql << (@opts[:replace] ? 'REPLACE' : 'INSERT')
32 end