Class: ROM::SQL::Postgres::Commands::Upsert

Inherits:
Commands::Create show all
Defined in:
lib/rom/sql/extensions/postgres/commands.rb

Overview

Upsert command

The command being called attempts to insert a record and if the inserted row would violate a unique constraint updates the conflicting row (or silently does nothing). A very important implementation detail is that the whole operation is serializable, i.e. aware of concurrent transactions, and doesn’t raise exceptions and doesn’t issue missing updates once used properly.

See PG’s docs in INSERT statement for details www.postgresql.org/docs/current/static/sql-insert.html

Normally, the command should be configured via class level settings. By default, that is without any setting provided, the command uses the ON CONFLICT DO NOTHING clause.

This implementation uses Sequel’s API underneath, the docs are available at sequel.jeremyevans.net/rdoc-adapters/classes/Sequel/Postgres/DatasetMethods.html#method-i-insert_conflict

Instance Attribute Summary collapse

Instance Method Summary collapse

Methods included from Commands::ErrorWrapper

#call

Instance Attribute Details

#conflict_target ⇒ Object (readonly)

Returns the column or expression to handle a violation on.

Returns:

  • (Object) —

    the column or expression to handle a violation on



96
 
# File 'lib/rom/sql/extensions/postgres/commands.rb', line 96

option :conflict_target, default: -> { self.class.conflict_target }

#conflict_where ⇒ Object (readonly)

Returns the index filter, when using a partial index to determine uniqueness.

Returns:

  • (Object) —

    the index filter, when using a partial index to determine uniqueness



100
 
# File 'lib/rom/sql/extensions/postgres/commands.rb', line 100

option :conflict_where, default: -> { self.class.conflict_where }

#constraint ⇒ Symbol (readonly)

Returns the name of the constraint expected to be violated.

Returns:

  • (Symbol) —

    the name of the constraint expected to be violated



92
 
# File 'lib/rom/sql/extensions/postgres/commands.rb', line 92

option :constraint, default: -> { self.class.constraint }

#update_statement ⇒ Object (readonly)

Returns the update statement which will be executed in case of a violation.

Returns:

  • (Object) —

    the update statement which will be executed in case of a violation



104
 
# File 'lib/rom/sql/extensions/postgres/commands.rb', line 104

option :update_statement, default: -> { self.class.update_statement }

#update_where ⇒ Object (readonly)

Returns the WHERE clause to be added to the update.

Returns:

  • (Object) —

    the WHERE clause to be added to the update



108
 
# File 'lib/rom/sql/extensions/postgres/commands.rb', line 108

option :update_where, default: -> { self.class.update_where }

Instance Method Details

#execute(tuples) ⇒ Array<Hash>

Tries to insert provided tuples and do an update (or nothing) when the inserted record violates a unique constraint and hence cannot be appended to the table

Returns:

  • (Array<Hash>) 


117
118
119
120
121
122
123
 
# File 'lib/rom/sql/extensions/postgres/commands.rb', line 117

def execute(tuples)
  inserted_tuples = with_input_tuples(tuples) do |tuple|
    upsert(input[tuple], upsert_options)
  end

  inserted_tuples.flatten(1)
end

#upsert_options ⇒ Object

This method is part of a private API. You should avoid using this method if possible, as it may be removed or be changed in the future. 



126
127
128
129
130
131
132
133
134
 
# File 'lib/rom/sql/extensions/postgres/commands.rb', line 126

def upsert_options
  @upsert_options ||= {
    constraint: constraint,
    target: conflict_target,
    conflict_where: conflict_where,
    update_where: update_where,
    update: update_statement
  }
end