Module: Sequel::Dataset::Replace

Included in:
MySQL::DatasetMethods
Defined in:
lib/sequel/adapters/utils/replace.rb

Constant Summary collapse

INSERT = 
'INSERT'.freeze
REPLACE = 
'REPLACE'.freeze

Instance Method Summary collapse

Instance Method Details

#multi_replace(*values) ⇒ Object

Replace multiple rows in a single query.



23
24
25
 
# File 'lib/sequel/adapters/utils/replace.rb', line 23

def multi_replace(*values)
  clone(:replace=>true).multi_insert(*values)
end

#replace(*values) ⇒ Object

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



13
14
15
 
# File 'lib/sequel/adapters/utils/replace.rb', line 13

def replace(*values)
  execute_insert(replace_sql(*values))
end

#replace_sql(*values) ⇒ Object

SQL statement for REPLACE



18
19
20
 
# File 'lib/sequel/adapters/utils/replace.rb', line 18

def replace_sql(*values)
  clone(:replace=>true).insert_sql(*values)
end

#supports_replace? ⇒ Boolean

Databases using this module support REPLACE.

Returns:

  • (Boolean) 


28
29
30
 
# File 'lib/sequel/adapters/utils/replace.rb', line 28

def supports_replace?
  true
end