GSP
Quick Navigator

Search Site

Unix VPS
A - Starter
B - Basic
C - Preferred
D - Commercial
MPS - Dedicated
Previous VPSs
* Sign Up! *

Support
Contact Us
Online Help
Handbooks
Domain Status
Man Pages

FAQ
Virtual Servers
Pricing
Billing
Technical

Network
Facilities
Connectivity
Topology Map

Miscellaneous
Server Agreement
Year 2038
Credits
 

USA Flag

 

 

Man Pages


Manual Reference Pages  -  OPENXPKI::SERVER::DBI::DBH (3)

.ds Aq ’

Name

OpenXPKI::Server::DBI::DBH

CONTENTS

Description

This module is the only module which uses Perl’s DBI. It manages all database interaction.

General Functions

    new

is the constructor. All parameters are identical with the ones of OpenXPKI::Server::DBI::Driver because OpenXPKI::Server::DBI::DBH instanciates the driver for the specific database. Please check the driver documentation (OpenXPKI::Server::DBI::Driver) for more informations.

You should add SERVER_ID and SERVER_SHIFT to the configuration.

DBI related Functions

    connect

has no parameters and starts a new database connection.

    disconnect

has no parameters and disconnects from the database.

    do_query

executes a query with the specified parameters. The query is defined in QUERY and the parameters must be as an array reference in the parameter BIND_VALUES. Please note that the value of QUERY is cached by the relating DBD driver. So please never put any dynamical parameters into the query.

    get_next_sth

returns the ID of the next statement handle. This cam be used to finish a statement handle explicitly via finish_sth.

    get_sth

get the last statement handle or the specified statement handle.

    finish_sth

finish the last statement or the specified statement. This is majorly a memory cleanup.

    rollback

rollbacks an open transaction. No parameters.

    commit

commits an open transaction. No parameters.

    get_new_serial

is directly mapped to OpenXPKI::Server::DBI::Driver->get_new_serial The serial is processed after it is returned from the driver via the configuration parameters SERVER_ID and SERVER_SHIFT.

    sequence_exists

is directly mapped to OpenXPKI::Server::DBI::Driver->sequence_exists

    create_sequence

is directly mapped to OpenXPKI::Server::DBI::Driver->create_sequence

    drop_sequence

is directly mapped to OpenXPKI::Server::DBI::Driver->drop_sequence

    Driver dependend schema infos

get_column_type

is directly mapped to OpenXPKI::Server::DBI::Driver->get_column_type

get_abstract_column_type

is directly mapped to OpenXPKI::Server::DBI::Driver->get_abstract_column_type

column_is_numeric

is directly mapped to OpenXPKI::Server::DBI::Driver->column_is_numeric

column_is_string

is directly mapped to OpenXPKI::Server::DBI::Driver->column_is_string

get_table_option

is directly mapped to OpenXPKI::Server::DBI::Driver->get_table_option

Desctructor DESTROY

rollbacks and finishs all open statement handles. Finally it disconnects from the database if a connection is still open.

See also

DBI, OpenXPKI::Server::DBI::Driver and OpenXPKI::Server::DBI::Schema
Search for    or go to Top of page |  Section 3 |  Main Index


perl v5.20.3 OPENXPKI::SERVER::DBI::DBH (3) 2016-04-03

Powered by GSP Visit the GSP FreeBSD Man Page Interface.
Output converted with manServer 1.07.