Index

Package: Pgsql

Description

package Alog.Facilities.Pgsql is
PGSQL facility. Used to log to a Postgresql database.

Classes

Instance

type Instance is new Alog.Facilities.Instance with private;

Ancestors:

Primitive operations:

Close_Connection
Get_Credentials
Get_Host_Name
Get_Host_Port
Get_Level_Column_Name
Get_Message_Column_Name
Get_Table_Name
Get_Timestamp_Column_Name
Is_SQL_Trace
Set_Credentials
Set_Host_Address
Set_Host_Name
Set_Host_Port
Set_Level_Column_Name
Set_Message_Column_Name
Set_SQL_Trace
Set_Table_Name
Set_Timestamp_Column_Name
Toggle_SQL_Trace
Write (overriding Alog.Facilities.Write)
PGSQL logging facility.

Types

Handle

type Handle is access all Instance;

Subprograms & Entries

Setup

procedure Setup 
(Facility: in out Instance);
Implementation of Setup-procedure.

Teardown

procedure Teardown 
(Facility: in out Instance);
Implementation of Teardown-procedure.

Set_Host_Name

procedure Set_Host_Name 
(Facility: in out Instance;
Hostname: String);
Set hostname of database server.

Get_Host_Name

function Get_Host_Name 
(Facility: Instance) return String;
Get hostname of database server.

Set_Host_Address

procedure Set_Host_Address 
(Facility: in out Instance;
Address: String);
Set ip address of database server.

Set_Host_Port

procedure Set_Host_Port 
(Facility: in out Instance;
Port: Natural);
Set port of database server.

Get_Host_Port

function Get_Host_Port 
(Facility: Instance) return Natural;
Get port of database server.

Set_SQL_Trace

procedure Set_SQL_Trace 
(Facility: in out Instance;
Filename: String;
Mode: APQ.Trace_Mode_Type);
Set SQL trace parameters.

Toggle_SQL_Trace

procedure Toggle_SQL_Trace 
(Facility: in out Instance;
State: Boolean);
Toggles tracing of SQL statements.

Is_SQL_Trace

function Is_SQL_Trace 
(Facility: Instance) return Boolean;
Tells whether sql tracing is enabled.

Set_DB_Name

procedure Set_DB_Name 
(Facility: in out Instance;
DB_Name: String);
Set name of database.

Get_DB_Name

function Get_DB_Name 
(Facility: Instance) return String;
Get name of database.

Set_Table_Name

procedure Set_Table_Name 
(Facility: in out Instance;
Table_Name: String);
Set name of database table.

Get_Table_Name

function Get_Table_Name 
(Facility: Instance) return String;
Get name of database table.

Set_Level_Column_Name

procedure Set_Level_Column_Name 
(Facility: in out Instance;
Column_Name: String);
Set name of log level column.

Get_Level_Column_Name

function Get_Level_Column_Name 
(Facility: Instance) return String;
Get name of log level column.

Set_Timestamp_Column_Name

procedure Set_Timestamp_Column_Name 
(Facility: in out Instance;
Column_Name: String);
Set name of log level column.

Get_Timestamp_Column_Name

function Get_Timestamp_Column_Name 
(Facility: Instance) return String;
Get name of timestamp column.

Set_Message_Column_Name

procedure Set_Message_Column_Name 
(Facility: in out Instance;
Column_Name: String);
Set name of log message column.

Get_Message_Column_Name

function Get_Message_Column_Name 
(Facility: Instance) return String;
Get name of log message column.

Set_Credentials

procedure Set_Credentials 
(Facility: in out Instance;
Username: String;
Password: String);
Set credentials for the database connection.

Get_Credentials

function Get_Credentials 
(Facility: Instance) return String;
Get credentials of database connection. Only the username is returned.

Close_Connection

procedure Close_Connection 
(Facility: in out Instance);
Close open database connection.