MAN page from OpenSuSE perl-OpenXPKI-Core-0.9.1389-6.362.CS.i586.rpm

OpenXPKI::Server::DBI::Driver::SQLite

Section: User Contributed Perl Documentation (3)
Updated: 2008-09-30
Index

Name

Description

This is the SQLite driver for OpenXPKI's database interface. Itimplements all SQLite specific stuff.

Driver specific stuff

BIGINT is "numeric(49,0)" in SQLite but this must be verified. I(michaelbell) am not sure about the size of this datatype in SQLite.

SQLite does not support sequence generators. Therefore we use the autoincrement feature for unique IDs in tables.

Functions

get_dsn

SQLite only needs the path to the database. Therefore this driverignores all parameters except of NAME which must be the path tothe database in the filesystem.

get_new_serial

SQLite does not support sequence generators. We use the autoincrement featureto emulate this. Sequence generators are implemented as tables.

sequence_exists

We try to detect an already existing squence by selecting the maximuminserted serial from the relating table.

create_sequence

creates a new table for the sequence emulation.

drop_sequence

deletes table for the sequence emulation. Must be called with MODE setto FORCE.

This document was created byman2html,using the manual pages.