1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
|
<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html><head>
<meta http-equiv="Content-Type" content="application/xhtml+xml; charset=UTF-8" />
<meta http-equiv="Content-Script-Type" content="text/javascript"/>
<title>
File: alog-facilities-pgsql.ads
</title>
<link rel='stylesheet' href='support/docgen.css' type='text/css'/>
<script src='support/docgen.js' type='text/javascript' charset='utf-8'></script>
</head>
<body onload="onloadDoc();">
<div id='leftSide'>
<div id='leftSideInside'>
<div id='header'>
<h2 class="button">Documentation</h2>
<a href='index.html'><div class="button2">Table of Contents</div></a>
<a href='tree.html'><div class="button2">Class Inheritance Tree</div></a>
</div>
</div>
</div> <!-- leftSide -->
<div class='subprograms'>
<div class='details'><ol><li id="l1"><pre><span class="comment">--</span> </pre></li>
<li id="l2"><pre><span class="comment">-- Copyright (c) 2008-2009,</span> </pre></li>
<li id="l3"><pre><span class="comment">-- Reto Buerki, Adrian-Ken Rueegsegger</span> </pre></li>
<li id="l4"><pre><span class="comment">-- secunet SwissIT AG</span> </pre></li>
<li id="l5"><pre><span class="comment">--</span> </pre></li>
<li id="l6"><pre><span class="comment">-- This file is part of Alog.</span> </pre></li>
<li id="l7"><pre><span class="comment">--</span> </pre></li>
<li id="l8"><pre><span class="comment">-- Alog is free software; you can redistribute it and/or modify</span> </pre></li>
<li id="l9"><pre><span class="comment">-- it under the terms of the GNU Lesser General Public License as published</span> </pre></li>
<li id="l10"><pre><span class="comment">-- by the Free Software Foundation; either version 2.1 of the License, or</span> </pre></li>
<li id="l11"><pre><span class="comment">-- (at your option) any later version.</span> </pre></li>
<li id="l12"><pre><span class="comment">--</span> </pre></li>
<li id="l13"><pre><span class="comment">-- Alog is distributed in the hope that it will be useful,</span> </pre></li>
<li id="l14"><pre><span class="comment">-- but WITHOUT ANY WARRANTY; without even the implied warranty of</span> </pre></li>
<li id="l15"><pre><span class="comment">-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the</span> </pre></li>
<li id="l16"><pre><span class="comment">-- GNU Lesser General Public License for more details.</span> </pre></li>
<li id="l17"><pre><span class="comment">--</span> </pre></li>
<li id="l18"><pre><span class="comment">-- You should have received a copy of the GNU Lesser General Public License</span> </pre></li>
<li id="l19"><pre><span class="comment">-- along with Alog; if not, write to the Free Software</span> </pre></li>
<li id="l20"><pre><span class="comment">-- Foundation, Inc., 51 Franklin St, Fifth Floor, Boston,</span> </pre></li>
<li id="l21"><pre><span class="comment">-- MA 02110-1301 USA</span> </pre></li>
<li id="l22"><pre><span class="comment">--</span> </pre></li>
<li id="l23"><pre> </pre></li>
<li id="l24"><pre><span class="keyword">with</span> APQ.PostgreSQL.Client; </pre></li>
<li id="l25"><pre> </pre></li>
<li id="l26"><pre><span class="comment">-- PGSQL facility. Used to log to a Postgresql database.</span> </pre></li>
<li id="l27"><pre><span class="keyword">package</span> <span class="droplink">Alog.Facilities.Pgsql<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:27:25" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.ads.html#l27" title="To spec">To spec</a></li><li><a href="src_alog-facilities-pgsql.adb.html#l24" title="To body">To body</a></li></ul></span> <span class="keyword">is</span> </pre></li>
<li id="l28"><pre> </pre></li>
<li id="l29"><pre> <span class="keyword">type</span> <span class="droplink">Instance<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:29:9" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.ads.html#l136" title="To body">To body</a></li></ul></span> <span class="keyword">is</span> <span class="keyword">new</span> <span class="droplink">Alog.Facilities.Instance<ul><li><a href="alog-facilities.ads.html#alog-facilities.ads:38:9" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities.ads.html#l38" title="To spec">To spec</a></li><li><a href="src_alog-facilities.ads.html#l127" title="To body">To body</a></li></ul></span> <span class="keyword">with</span> <span class="keyword">private</span>; </pre></li>
<li id="l30"><pre> <span class="comment">-- PGSQL logging facility.</span> </pre></li>
<li id="l31"><pre> </pre></li>
<li id="l32"><pre> <span class="keyword">type</span> <a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:32:9" title="defined at alog-facilities-pgsql.ads:32:9">Handle</a> <span class="keyword">is</span> <span class="keyword">access</span> <span class="keyword">all</span> <span class="droplink">Instance<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:29:9" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.ads.html#l29" title="To spec">To spec</a></li><li><a href="src_alog-facilities-pgsql.ads.html#l136" title="To body">To body</a></li></ul></span>; </pre></li>
<li id="l33"><pre> </pre></li>
<li id="l34"><pre> <span class="keyword">overriding</span> </pre></li>
<li id="l35"><pre> <span class="keyword">procedure</span> <span class="droplink">Setup<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:35:14" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.adb.html#l198" title="To body">To body</a></li></ul></span> (<span class="droplink">Facility<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:35:21" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.adb.html#l198" title="To body">To body</a></li></ul></span> : <span class="keyword">in</span> <span class="keyword">out</span> <span class="droplink">Instance<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:29:9" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.ads.html#l29" title="To spec">To spec</a></li><li><a href="src_alog-facilities-pgsql.ads.html#l136" title="To body">To body</a></li></ul></span>); </pre></li>
<li id="l36"><pre> <span class="comment">-- Implementation of Setup-procedure.</span> </pre></li>
<li id="l37"><pre> </pre></li>
<li id="l38"><pre> <span class="keyword">overriding</span> </pre></li>
<li id="l39"><pre> <span class="keyword">procedure</span> <span class="droplink">Teardown<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:39:14" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.adb.html#l205" title="To body">To body</a></li></ul></span> (<span class="droplink">Facility<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:39:24" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.adb.html#l205" title="To body">To body</a></li></ul></span> : <span class="keyword">in</span> <span class="keyword">out</span> <span class="droplink">Instance<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:29:9" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.ads.html#l29" title="To spec">To spec</a></li><li><a href="src_alog-facilities-pgsql.ads.html#l136" title="To body">To body</a></li></ul></span>); </pre></li>
<li id="l40"><pre> <span class="comment">-- Implementation of Teardown-procedure.</span> </pre></li>
<li id="l41"><pre> </pre></li>
<li id="l42"><pre> <span class="keyword">procedure</span> <span class="droplink">Set_Host_Name<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:42:14" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.adb.html#l129" title="To body">To body</a></li></ul></span> (<span class="droplink">Facility<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:42:29" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.adb.html#l129" title="To body">To body</a></li></ul></span> : <span class="keyword">in</span> <span class="keyword">out</span> <span class="droplink">Instance<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:29:9" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.ads.html#l29" title="To spec">To spec</a></li><li><a href="src_alog-facilities-pgsql.ads.html#l136" title="To body">To body</a></li></ul></span>; <a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:42:57" title="defined at alog-facilities-pgsql.ads:42:57">Hostname</a> : String); </pre></li>
<li id="l43"><pre> <span class="comment">-- Set hostname of database server.</span> </pre></li>
<li id="l44"><pre> </pre></li>
<li id="l45"><pre> <span class="keyword">function</span> <span class="droplink">Get_Host_Name<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:45:13" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.adb.html#l49" title="To body">To body</a></li></ul></span> (<span class="droplink">Facility<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:45:28" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.adb.html#l49" title="To body">To body</a></li></ul></span> : <span class="droplink">Instance<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:29:9" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.ads.html#l29" title="To spec">To spec</a></li><li><a href="src_alog-facilities-pgsql.ads.html#l136" title="To body">To body</a></li></ul></span>) <span class="keyword">return</span> String; </pre></li>
<li id="l46"><pre> <span class="comment">-- Get hostname of database server.</span> </pre></li>
<li id="l47"><pre> </pre></li>
<li id="l48"><pre> <span class="keyword">procedure</span> <span class="droplink">Set_Host_Address<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:48:14" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.adb.html#l119" title="To body">To body</a></li></ul></span> (<span class="droplink">Facility<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:48:32" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.adb.html#l120" title="To body">To body</a></li></ul></span> : <span class="keyword">in</span> <span class="keyword">out</span> <span class="droplink">Instance<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:29:9" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.ads.html#l29" title="To spec">To spec</a></li><li><a href="src_alog-facilities-pgsql.ads.html#l136" title="To body">To body</a></li></ul></span>; <a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:48:60" title="defined at alog-facilities-pgsql.ads:48:60">Address</a> : String); </pre></li>
<li id="l49"><pre> <span class="comment">-- Set ip address of database server.</span> </pre></li>
<li id="l50"><pre> </pre></li>
<li id="l51"><pre> <span class="keyword">procedure</span> <span class="droplink">Set_Host_Port<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:51:14" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.adb.html#l136" title="To body">To body</a></li></ul></span> (<span class="droplink">Facility<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:51:29" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.adb.html#l136" title="To body">To body</a></li></ul></span> : <span class="keyword">in</span> <span class="keyword">out</span> <span class="droplink">Instance<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:29:9" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.ads.html#l29" title="To spec">To spec</a></li><li><a href="src_alog-facilities-pgsql.ads.html#l136" title="To body">To body</a></li></ul></span>; <a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:51:57" title="defined at alog-facilities-pgsql.ads:51:57">Port</a> : Natural); </pre></li>
<li id="l52"><pre> <span class="comment">-- Set port of database server.</span> </pre></li>
<li id="l53"><pre> </pre></li>
<li id="l54"><pre> <span class="keyword">function</span> <span class="droplink">Get_Host_Port<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:54:13" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.adb.html#l56" title="To body">To body</a></li></ul></span> (<span class="droplink">Facility<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:54:28" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.adb.html#l56" title="To body">To body</a></li></ul></span> : <span class="droplink">Instance<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:29:9" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.ads.html#l29" title="To spec">To spec</a></li><li><a href="src_alog-facilities-pgsql.ads.html#l136" title="To body">To body</a></li></ul></span>) <span class="keyword">return</span> Natural; </pre></li>
<li id="l55"><pre> <span class="comment">-- Get port of database server.</span> </pre></li>
<li id="l56"><pre> </pre></li>
<li id="l57"><pre> <span class="keyword">procedure</span> <span class="droplink">Set_SQL_Trace<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:57:14" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.adb.html#l165" title="To body">To body</a></li></ul></span> </pre></li>
<li id="l58"><pre> (<span class="droplink">Facility<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:58:7" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.adb.html#l166" title="To body">To body</a></li></ul></span> : <span class="keyword">in</span> <span class="keyword">out</span> <span class="droplink">Instance<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:29:9" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.ads.html#l29" title="To spec">To spec</a></li><li><a href="src_alog-facilities-pgsql.ads.html#l136" title="To body">To body</a></li></ul></span>; </pre></li>
<li id="l59"><pre> <a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:59:7" title="defined at alog-facilities-pgsql.ads:59:7">Filename</a> : String; </pre></li>
<li id="l60"><pre> <span class="droplink">Mode<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:60:7" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.adb.html#l168" title="To body">To body</a></li></ul></span> : APQ.Trace_Mode_Type); </pre></li>
<li id="l61"><pre> <span class="comment">-- Set SQL trace parameters.</span> </pre></li>
<li id="l62"><pre> </pre></li>
<li id="l63"><pre> <span class="keyword">procedure</span> <span class="droplink">Toggle_SQL_Trace<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:63:14" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.adb.html#l213" title="To body">To body</a></li></ul></span> </pre></li>
<li id="l64"><pre> (<span class="droplink">Facility<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:64:7" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.adb.html#l214" title="To body">To body</a></li></ul></span> : <span class="keyword">in</span> <span class="keyword">out</span> <span class="droplink">Instance<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:29:9" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.ads.html#l29" title="To spec">To spec</a></li><li><a href="src_alog-facilities-pgsql.ads.html#l136" title="To body">To body</a></li></ul></span>; </pre></li>
<li id="l65"><pre> <a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:65:7" title="defined at alog-facilities-pgsql.ads:65:7">State</a> : Boolean); </pre></li>
<li id="l66"><pre> <span class="comment">-- Toggles tracing of SQL statements.</span> </pre></li>
<li id="l67"><pre> </pre></li>
<li id="l68"><pre> <span class="keyword">function</span> <span class="droplink">Is_SQL_Trace<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:68:13" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.adb.html#l92" title="To body">To body</a></li></ul></span> (<span class="droplink">Facility<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:68:27" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.adb.html#l92" title="To body">To body</a></li></ul></span> : <span class="droplink">Instance<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:29:9" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.ads.html#l29" title="To spec">To spec</a></li><li><a href="src_alog-facilities-pgsql.ads.html#l136" title="To body">To body</a></li></ul></span>) <span class="keyword">return</span> Boolean; </pre></li>
<li id="l69"><pre> <span class="comment">-- Tells whether sql tracing is enabled.</span> </pre></li>
<li id="l70"><pre> </pre></li>
<li id="l71"><pre> <span class="keyword">procedure</span> <span class="droplink">Set_DB_Name<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:71:14" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.adb.html#l112" title="To body">To body</a></li></ul></span> (<span class="droplink">Facility<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:71:27" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.adb.html#l112" title="To body">To body</a></li></ul></span> : <span class="keyword">in</span> <span class="keyword">out</span> <span class="droplink">Instance<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:29:9" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.ads.html#l29" title="To spec">To spec</a></li><li><a href="src_alog-facilities-pgsql.ads.html#l136" title="To body">To body</a></li></ul></span>; <a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:71:55" title="defined at alog-facilities-pgsql.ads:71:55">DB_Name</a> : String); </pre></li>
<li id="l72"><pre> <span class="comment">-- Set name of database.</span> </pre></li>
<li id="l73"><pre> </pre></li>
<li id="l74"><pre> <span class="keyword">function</span> <span class="droplink">Get_DB_Name<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:74:13" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.adb.html#l42" title="To body">To body</a></li></ul></span> (<span class="droplink">Facility<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:74:26" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.adb.html#l42" title="To body">To body</a></li></ul></span> : <span class="droplink">Instance<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:29:9" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.ads.html#l29" title="To spec">To spec</a></li><li><a href="src_alog-facilities-pgsql.ads.html#l136" title="To body">To body</a></li></ul></span>) <span class="keyword">return</span> String; </pre></li>
<li id="l75"><pre> <span class="comment">-- Get name of database.</span> </pre></li>
<li id="l76"><pre> </pre></li>
<li id="l77"><pre> <span class="keyword">procedure</span> <span class="droplink">Set_Table_Name<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:77:14" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.adb.html#l177" title="To body">To body</a></li></ul></span> (<span class="droplink">Facility<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:77:30" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.adb.html#l178" title="To body">To body</a></li></ul></span> : <span class="keyword">in</span> <span class="keyword">out</span> <span class="droplink">Instance<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:29:9" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.ads.html#l29" title="To spec">To spec</a></li><li><a href="src_alog-facilities-pgsql.ads.html#l136" title="To body">To body</a></li></ul></span>; <a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:77:58" title="defined at alog-facilities-pgsql.ads:77:58">Table_Name</a> : String); </pre></li>
<li id="l78"><pre> <span class="comment">-- Set name of database table.</span> </pre></li>
<li id="l79"><pre> </pre></li>
<li id="l80"><pre> <span class="keyword">function</span> <span class="droplink">Get_Table_Name<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:80:13" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.adb.html#l78" title="To body">To body</a></li></ul></span> (<span class="droplink">Facility<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:80:29" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.adb.html#l78" title="To body">To body</a></li></ul></span> : <span class="droplink">Instance<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:29:9" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.ads.html#l29" title="To spec">To spec</a></li><li><a href="src_alog-facilities-pgsql.ads.html#l136" title="To body">To body</a></li></ul></span>) <span class="keyword">return</span> String; </pre></li>
<li id="l81"><pre> <span class="comment">-- Get name of database table.</span> </pre></li>
<li id="l82"><pre> </pre></li>
<li id="l83"><pre> <span class="keyword">procedure</span> <span class="droplink">Set_Level_Column_Name<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:83:14" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.adb.html#l143" title="To body">To body</a></li></ul></span> </pre></li>
<li id="l84"><pre> (<span class="droplink">Facility<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:84:7" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.adb.html#l144" title="To body">To body</a></li></ul></span> : <span class="keyword">in</span> <span class="keyword">out</span> <span class="droplink">Instance<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:29:9" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.ads.html#l29" title="To spec">To spec</a></li><li><a href="src_alog-facilities-pgsql.ads.html#l136" title="To body">To body</a></li></ul></span>; </pre></li>
<li id="l85"><pre> <a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:85:7" title="defined at alog-facilities-pgsql.ads:85:7">Column_Name</a> : String); </pre></li>
<li id="l86"><pre> <span class="comment">-- Set name of log level column.</span> </pre></li>
<li id="l87"><pre> </pre></li>
<li id="l88"><pre> <span class="keyword">function</span> <span class="droplink">Get_Level_Column_Name<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:88:13" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.adb.html#l64" title="To body">To body</a></li></ul></span> (<span class="droplink">Facility<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:88:36" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.adb.html#l64" title="To body">To body</a></li></ul></span> : <span class="droplink">Instance<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:29:9" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.ads.html#l29" title="To spec">To spec</a></li><li><a href="src_alog-facilities-pgsql.ads.html#l136" title="To body">To body</a></li></ul></span>) <span class="keyword">return</span> String; </pre></li>
<li id="l89"><pre> <span class="comment">-- Get name of log level column.</span> </pre></li>
<li id="l90"><pre> </pre></li>
<li id="l91"><pre> <span class="keyword">procedure</span> <span class="droplink">Set_Timestamp_Column_Name<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:91:14" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.adb.html#l187" title="To body">To body</a></li></ul></span> </pre></li>
<li id="l92"><pre> (<span class="droplink">Facility<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:92:7" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.adb.html#l188" title="To body">To body</a></li></ul></span> : <span class="keyword">in</span> <span class="keyword">out</span> <span class="droplink">Instance<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:29:9" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.ads.html#l29" title="To spec">To spec</a></li><li><a href="src_alog-facilities-pgsql.ads.html#l136" title="To body">To body</a></li></ul></span>; </pre></li>
<li id="l93"><pre> <a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:93:7" title="defined at alog-facilities-pgsql.ads:93:7">Column_Name</a> : String); </pre></li>
<li id="l94"><pre> <span class="comment">-- Set name of log level column.</span> </pre></li>
<li id="l95"><pre> </pre></li>
<li id="l96"><pre> <span class="keyword">function</span> <span class="droplink">Get_Timestamp_Column_Name<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:96:13" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.adb.html#l85" title="To body">To body</a></li></ul></span> (<span class="droplink">Facility<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:96:40" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.adb.html#l85" title="To body">To body</a></li></ul></span> : <span class="droplink">Instance<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:29:9" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.ads.html#l29" title="To spec">To spec</a></li><li><a href="src_alog-facilities-pgsql.ads.html#l136" title="To body">To body</a></li></ul></span>) <span class="keyword">return</span> String; </pre></li>
<li id="l97"><pre> <span class="comment">-- Get name of timestamp column.</span> </pre></li>
<li id="l98"><pre> </pre></li>
<li id="l99"><pre> <span class="keyword">procedure</span> <span class="droplink">Set_Message_Column_Name<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:99:14" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.adb.html#l154" title="To body">To body</a></li></ul></span> </pre></li>
<li id="l100"><pre> (<span class="droplink">Facility<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:100:7" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.adb.html#l155" title="To body">To body</a></li></ul></span> : <span class="keyword">in</span> <span class="keyword">out</span> <span class="droplink">Instance<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:29:9" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.ads.html#l29" title="To spec">To spec</a></li><li><a href="src_alog-facilities-pgsql.ads.html#l136" title="To body">To body</a></li></ul></span>; </pre></li>
<li id="l101"><pre> <a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:101:7" title="defined at alog-facilities-pgsql.ads:101:7">Column_Name</a> : String); </pre></li>
<li id="l102"><pre> <span class="comment">-- Set name of log message column.</span> </pre></li>
<li id="l103"><pre> </pre></li>
<li id="l104"><pre> <span class="keyword">function</span> <span class="droplink">Get_Message_Column_Name<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:104:13" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.adb.html#l71" title="To body">To body</a></li></ul></span> (<span class="droplink">Facility<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:104:38" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.adb.html#l71" title="To body">To body</a></li></ul></span> : <span class="droplink">Instance<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:29:9" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.ads.html#l29" title="To spec">To spec</a></li><li><a href="src_alog-facilities-pgsql.ads.html#l136" title="To body">To body</a></li></ul></span>) <span class="keyword">return</span> String; </pre></li>
<li id="l105"><pre> <span class="comment">-- Get name of log message column.</span> </pre></li>
<li id="l106"><pre> </pre></li>
<li id="l107"><pre> <span class="keyword">procedure</span> <span class="droplink">Set_Credentials<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:107:14" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.adb.html#l99" title="To body">To body</a></li></ul></span> </pre></li>
<li id="l108"><pre> (<span class="droplink">Facility<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:108:7" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.adb.html#l100" title="To body">To body</a></li></ul></span> : <span class="keyword">in</span> <span class="keyword">out</span> <span class="droplink">Instance<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:29:9" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.ads.html#l29" title="To spec">To spec</a></li><li><a href="src_alog-facilities-pgsql.ads.html#l136" title="To body">To body</a></li></ul></span>; </pre></li>
<li id="l109"><pre> <a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:109:7" title="defined at alog-facilities-pgsql.ads:109:7">Username</a> : String; </pre></li>
<li id="l110"><pre> <a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:110:7" title="defined at alog-facilities-pgsql.ads:110:7">Password</a> : String); </pre></li>
<li id="l111"><pre> <span class="comment">-- Set credentials for the database connection.</span> </pre></li>
<li id="l112"><pre> </pre></li>
<li id="l113"><pre> <span class="keyword">function</span> <span class="droplink">Get_Credentials<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:113:13" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.adb.html#l35" title="To body">To body</a></li></ul></span> (<span class="droplink">Facility<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:113:30" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.adb.html#l35" title="To body">To body</a></li></ul></span> : <span class="droplink">Instance<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:29:9" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.ads.html#l29" title="To spec">To spec</a></li><li><a href="src_alog-facilities-pgsql.ads.html#l136" title="To body">To body</a></li></ul></span>) <span class="keyword">return</span> String; </pre></li>
<li id="l114"><pre> <span class="comment">-- Get credentials of database connection. Only the username is returned.</span> </pre></li>
<li id="l115"><pre> </pre></li>
<li id="l116"><pre> <span class="keyword">procedure</span> <span class="droplink">Close_Connection<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:116:14" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.adb.html#l28" title="To body">To body</a></li></ul></span> (<span class="droplink">Facility<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:116:32" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.adb.html#l28" title="To body">To body</a></li></ul></span> : <span class="keyword">in</span> <span class="keyword">out</span> <span class="droplink">Instance<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:29:9" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.ads.html#l29" title="To spec">To spec</a></li><li><a href="src_alog-facilities-pgsql.ads.html#l136" title="To body">To body</a></li></ul></span>); </pre></li>
<li id="l117"><pre> <span class="comment">-- Close open database connection.</span> </pre></li>
<li id="l118"><pre> </pre></li>
<li id="l119"><pre><span class="keyword">private</span> </pre></li>
<li id="l120"><pre> </pre></li>
<li id="l121"><pre> <span class="keyword">overriding</span> </pre></li>
<li id="l122"><pre> <span class="keyword">procedure</span> Write </pre></li>
<li id="l123"><pre> (Facility : <span class="droplink">Instance<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:29:9" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.ads.html#l29" title="To spec">To spec</a></li><li><a href="src_alog-facilities-pgsql.ads.html#l136" title="To body">To body</a></li></ul></span>; </pre></li>
<li id="l124"><pre> Level : <span class="droplink">Log_Level<ul><li><a href="alog.ads.html#alog.ads:32:9" title="To API doc">To API doc</a></li><li><a href="src_alog.ads.html#l32" title="To spec">To spec</a></li></ul></span> := Info; </pre></li>
<li id="l125"><pre> Msg : String); </pre></li>
<li id="l126"><pre> <span class="comment">-- Implementation of the Write procedure for PGSQL.</span> </pre></li>
<li id="l127"><pre> </pre></li>
<li id="l128"><pre> <span class="keyword">type</span> Log_SQL_Table <span class="keyword">is</span> <span class="keyword">tagged</span> <span class="keyword">record</span> </pre></li>
<li id="l129"><pre> Name : Unbounded_String := To_Unbounded_String (<span class="string">"alog"</span>); </pre></li>
<li id="l130"><pre> Level_Column : Unbounded_String := To_Unbounded_String (<span class="string">"level"</span>); </pre></li>
<li id="l131"><pre> Timestamp_Column : Unbounded_String := To_Unbounded_String (<span class="string">"timestamp"</span>); </pre></li>
<li id="l132"><pre> Message_Column : Unbounded_String := To_Unbounded_String (<span class="string">"message"</span>); </pre></li>
<li id="l133"><pre> <span class="keyword">end</span> <span class="keyword">record</span>; </pre></li>
<li id="l134"><pre> <span class="comment">-- Holds Table/Column name information.</span> </pre></li>
<li id="l135"><pre> </pre></li>
<li id="l136"><pre> <span class="keyword">type</span> <span class="droplink">Instance<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:29:9" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.ads.html#l29" title="To spec">To spec</a></li></ul></span> <span class="keyword">is</span> <span class="keyword">new</span> <span class="droplink">Alog.Facilities.Instance<ul><li><a href="alog-facilities.ads.html#alog-facilities.ads:38:9" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities.ads.html#l38" title="To spec">To spec</a></li><li><a href="src_alog-facilities.ads.html#l127" title="To body">To body</a></li></ul></span> <span class="keyword">with</span> <span class="keyword">record</span> </pre></li>
<li id="l137"><pre> Log_Connection : APQ.PostgreSQL.Client.Connection_Type; </pre></li>
<li id="l138"><pre> <span class="comment">-- Database connection used for logging.</span> </pre></li>
<li id="l139"><pre> </pre></li>
<li id="l140"><pre> Trace_Filename : Unbounded_String := </pre></li>
<li id="l141"><pre> To_Unbounded_String (<span class="string">"./trace.sql"</span>); </pre></li>
<li id="l142"><pre> Trace_Mode : APQ.Trace_Mode_Type := APQ.Trace_APQ; </pre></li>
<li id="l143"><pre> <span class="comment">-- SQL trace parameters</span> </pre></li>
<li id="l144"><pre> </pre></li>
<li id="l145"><pre> Log_Table : Log_SQL_Table; </pre></li>
<li id="l146"><pre> <span class="comment">-- Table to insert messages</span> </pre></li>
<li id="l147"><pre> <span class="keyword">end</span> <span class="keyword">record</span>; </pre></li>
<li id="l148"><pre> </pre></li>
<li id="l149"><pre><span class="keyword">end</span> <span class="droplink">Alog.Facilities.Pgsql<ul><li><a href="alog-facilities-pgsql.ads.html#alog-facilities-pgsql.ads:27:25" title="To API doc">To API doc</a></li><li><a href="src_alog-facilities-pgsql.ads.html#l27" title="To spec">To spec</a></li><li><a href="src_alog-facilities-pgsql.adb.html#l24" title="To body">To body</a></li></ul></span>; </pre></li>
</ol></div>
</div>
</body>
</html>
|
