Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help
OpenXPKI::Server::DataUser:Contributed:PerleDocumtabase::Role::MergeSupport(3)

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.

Required methods in the	consuming driver class
   merge_query
       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):

       o   $dbi	- the OpenXPKI::Server::Database instance

       o   $into - Table name (Str, required)

       o   $set	- Columns that are always set (INSERT or UPDATE). Hash with
	   column name / value pairs.

       o   $set_once - Columns that are	only set on INSERT (additional to
	   those in the	"where"	parameter. Hash	with column name / value
	   pairs.

       o   $where - WHERE clause specification that must contain the PRIMARY
	   KEY columns and only	allows "AND" and "equal" operators: "<{	col1
	   =" val1, col2 => val2 }>> (HashRef)

perl v5.24.1		     OpenXPKI::Server::Database::Role::MergeSupport(3)

Name | Description | Required methods in the consuming driver class

Want to link to this manual page? Use this URL:
<https://www.freebsd.org/cgi/man.cgi?query=OpenXPKI::Server::Database::Role::MergeSupport&sektion=3&manpath=FreeBSD+12.0-RELEASE+and+Ports>

home | help