returns the name of driver. This is actually necessary for OpenXPKI::Server::Log::Appender::DBI.
initializes the database. If the parameter MODE is used and the value is DRYRUN then the function returns the SQL statements which are usually executed during an initialization.
initiates the database connection.
cuts the database connection.
get a new database handle for the object. This is called on the CTX(dbi_workflow) and CTX(dbi_backend) objects when they are forked (either in workflow instance forking or Net::Server forking)
commits an active transaction.
aborts an active transaction.
This function returns a new serial number for a requested objecttype. Usually you only specify the TABLE and get a new serial. If you need a serial for a CRL then you can simply count the CRLs to get the next serial. This function uses SQL sequence generators.
my $serial = $dbi->get_new_serial (TABLE => "CSR");
To insert, specify a hash reference so that the values corresponding to the hash keys are inserted. Please note that object oriented inserts are no longer available.
my $result = $dbi->insert (TABLE => "DATA", HASH => $data);
Specify a hash for DATA. Please note that you must specify the where clause for an update. The background is that the hash based interface supports mass updates. If the where clause is missing then we start an index scan on the parameter DATA.
This function maps directly to the SQL layer. So please check the documentation of OpenXPKI::Server::DBI::SQL for a desription of the delete function.
We have several functions which use the select function but hide some complexity from the user.
implements an access method to the SQL select operation. Please look at OpenXPKI::Server::DBI::SQL to get an overview about the available query options.
returns the result of a select. The important thing is that the SQL query only returns one row of the table. If the query uses a unique index then there can be only one result otherwise only the first result is returned. This means that the function has the exact same behaviour like first. It is only a psychological aspect that get usually includes a parameter for the SERIAL and first usually does not include a parameter with the serial.
returns the first result of a select. The important thing is that the SQL query only returns one row of the table.
returns the last result of a select. The important thing is that the SQL query only returns one row of the table.
returns the next result of a select. The important thing is that the SQL query only returns one row of the table.
returns the prev result of a select. The important thing is that the SQL query only returns one row of the table.
OpenXPKI::Server::DBI::Object, OpenXPKI::Server::DBI::Hash, OpenXPKI::Server::DBI::DBH and OpenXPKI::Server::DBI::Schema
|perl v5.20.3||OPENXPKI::SERVER::DBI (3)||2016-04-03|