Name

OpenXPKI::Server::Database::Role::MergeSupport - Moose role for database drivers to indicate native support for MERGE (= REPLACE = INSERT or UPDATE).

Description

This role indicates that the DBMS natively supports SQL MERGE (you could also call it REPLACE) in some form.

Must return the DBMS specific SQL query (OpenXPKI::Server::Database::Query) that does an SQL MERGE.

When called it gets passed the following parameter (additional to $self):

$dbi - the OpenXPKI::Server::Database instance
$into - Table name (Str, required)
$set - Columns that are always set (INSERT or UPDATE). Hash with column name / value pairs.
$set_once - Columns that are only set on INSERT (additional to those in the "where" parameter. Hash with column name / value pairs.
$where - WHERE clause specification that must contain the PRIMARY KEY columns and only allows "AND" and "equal" operators: "<{ col1 =" val1, col2 => val2 }>> (HashRef)