1 |
tony |
45 |
(*
|
2 |
|
|
* Firebird Interface (fbintf). The fbintf components provide a set of
|
3 |
|
|
* Pascal language bindings for the Firebird API.
|
4 |
|
|
*
|
5 |
|
|
* The contents of this file are subject to the Initial Developer's
|
6 |
|
|
* Public License Version 1.0 (the "License"); you may not use this
|
7 |
|
|
* file except in compliance with the License. You may obtain a copy
|
8 |
|
|
* of the License here:
|
9 |
|
|
*
|
10 |
|
|
* http://www.firebirdsql.org/index.php?op=doc&id=idpl
|
11 |
|
|
*
|
12 |
|
|
* Software distributed under the License is distributed on an "AS
|
13 |
|
|
* IS" basis, WITHOUT WARRANTY OF ANY KIND, either express or
|
14 |
|
|
* implied. See the License for the specific language governing rights
|
15 |
|
|
* and limitations under the License.
|
16 |
|
|
*
|
17 |
|
|
* The Initial Developer of the Original Code is Tony Whyman.
|
18 |
|
|
*
|
19 |
|
|
* The Original Code is (C) 2016 Tony Whyman, MWA Software
|
20 |
|
|
* (http://www.mwasoftware.co.uk).
|
21 |
|
|
*
|
22 |
|
|
* All Rights Reserved.
|
23 |
|
|
*
|
24 |
|
|
* Contributor(s): ______________________________________.
|
25 |
|
|
*
|
26 |
|
|
*)
|
27 |
|
|
unit FBParamBlock;
|
28 |
tony |
56 |
{$IFDEF MSWINDOWS}
|
29 |
|
|
{$DEFINE WINDOWS}
|
30 |
|
|
{$ENDIF}
|
31 |
tony |
45 |
|
32 |
|
|
{$IFDEF FPC}
|
33 |
tony |
56 |
{$mode delphi}
|
34 |
tony |
45 |
{$interfaces COM}
|
35 |
|
|
{$ENDIF}
|
36 |
|
|
|
37 |
|
|
interface
|
38 |
|
|
|
39 |
|
|
{Provides common handling for the DPB, TPB, SPB and Service Request Block (SRB)}
|
40 |
|
|
|
41 |
|
|
uses
|
42 |
|
|
Classes, SysUtils, IB, FBClientAPI, FBActivityMonitor;
|
43 |
|
|
|
44 |
|
|
type
|
45 |
|
|
TParamDataType = (dtString, dtString2, dtString0, dtByte, dtByte2, dtInteger, dtInteger1,
|
46 |
|
|
dtInteger2, dtShortInteger,dtTinyInteger,dtnone);
|
47 |
|
|
|
48 |
|
|
PParamBlockItemData = ^TParamBlockItemData;
|
49 |
|
|
TParamBlockItemData = record
|
50 |
|
|
{Describes a Clumplet in the buffer. FBufPtr always points to the clumplet id
|
51 |
|
|
the rest of the clumplet up to the FBufLength is data. The data format is
|
52 |
|
|
given by FDataType}
|
53 |
tony |
56 |
FBufPtr: PByte;
|
54 |
tony |
45 |
FBuflength: integer;
|
55 |
|
|
FDataType: TParamDataType;
|
56 |
|
|
end;
|
57 |
|
|
|
58 |
|
|
TParamBlockItem = class;
|
59 |
|
|
|
60 |
|
|
{ TParamBlock }
|
61 |
|
|
|
62 |
|
|
TParamBlock = class(TFBInterfacedObject)
|
63 |
|
|
private
|
64 |
|
|
FItems: array of PParamBlockItemData;
|
65 |
|
|
FBufferSize: integer;
|
66 |
tony |
263 |
FFirebirdClientAPI: TFBClientAPI;
|
67 |
tony |
45 |
procedure AdjustBuffer;
|
68 |
|
|
procedure MoveBy(Item: PParamBlockItemData; delta: integer);
|
69 |
|
|
procedure UpdateRequestItemSize(Item: TParamBlockItem; NewSize: integer);
|
70 |
|
|
protected
|
71 |
tony |
56 |
FBuffer: PByte;
|
72 |
tony |
45 |
FDataLength: integer;
|
73 |
|
|
function Add(ParamType: byte): PParamBlockItemData;
|
74 |
|
|
function Find(ParamType: byte): PParamBlockItemData;
|
75 |
|
|
function GetItems(index: integer): PParamBlockItemData;
|
76 |
tony |
315 |
function LookupItemType(ParamTypeName: AnsiString): byte; virtual;
|
77 |
tony |
45 |
public
|
78 |
tony |
263 |
constructor Create(api: TFBClientAPI);
|
79 |
tony |
45 |
destructor Destroy; override;
|
80 |
tony |
56 |
function getBuffer: PByte;
|
81 |
tony |
45 |
function getDataLength: integer;
|
82 |
|
|
function AvailableBufferSpace: integer;
|
83 |
|
|
|
84 |
|
|
public
|
85 |
|
|
function getCount: integer;
|
86 |
|
|
procedure Remove(ParamType: byte);
|
87 |
|
|
procedure PrintBuf;
|
88 |
|
|
end;
|
89 |
|
|
|
90 |
|
|
{ TParamBlockItem }
|
91 |
|
|
|
92 |
|
|
TParamBlockItem = class(TFBInterfacedObject)
|
93 |
|
|
private
|
94 |
|
|
FOwner: TParamBlock;
|
95 |
|
|
FOwnerIntf: IUnknown;
|
96 |
|
|
FParamData: PParamBlockItemData;
|
97 |
tony |
263 |
FFirebirdClientAPI: TFBClientAPI;
|
98 |
tony |
45 |
protected
|
99 |
|
|
property ParamData: PParamBlockItemData read FParamData;
|
100 |
|
|
public
|
101 |
|
|
constructor Create(AOwner: TParamBlock; Data: PParamBlockItemData);
|
102 |
|
|
public
|
103 |
|
|
function getAsInteger: integer;
|
104 |
|
|
function getParamType: byte;
|
105 |
tony |
315 |
function getParamTypeName: AnsiString; virtual;
|
106 |
tony |
56 |
function getAsString: AnsiString;
|
107 |
tony |
45 |
function getAsByte: byte;
|
108 |
|
|
procedure addByte(aValue: byte);
|
109 |
tony |
308 |
procedure addShortInt(aValue: ShortInt);
|
110 |
tony |
45 |
procedure addShortInteger(aValue: integer);
|
111 |
|
|
procedure setAsByte(aValue: byte);
|
112 |
|
|
procedure setAsByte2(aValue: byte);
|
113 |
|
|
procedure SetAsInteger(aValue: integer);
|
114 |
|
|
procedure SetAsInteger1(aValue: integer);
|
115 |
|
|
procedure SetAsInteger2(aValue: integer);
|
116 |
|
|
procedure SetAsShortInteger(aValue: integer);
|
117 |
|
|
procedure SetAsTinyInteger(aValue: integer);
|
118 |
tony |
56 |
procedure SetAsString(aValue: AnsiString);
|
119 |
|
|
procedure SetAsString2(aValue: AnsiString);
|
120 |
|
|
procedure SetAsString0(aValue: AnsiString);
|
121 |
tony |
45 |
end;
|
122 |
|
|
|
123 |
|
|
{ TSRBItem }
|
124 |
|
|
|
125 |
|
|
TSRBItem = class(TParamBlockItem,ISRBItem)
|
126 |
|
|
public
|
127 |
tony |
56 |
{$IFDEF FPC}
|
128 |
|
|
procedure ISRBItem.SetAsString = SetAsString2;
|
129 |
|
|
procedure ISRBItem.SetAsByte = SetAsByte2;
|
130 |
|
|
{$ELSE}
|
131 |
|
|
procedure SetAsString(aValue: AnsiString) ;
|
132 |
|
|
procedure SetAsByte(aValue: byte);
|
133 |
|
|
{$ENDIF}
|
134 |
tony |
45 |
end;
|
135 |
|
|
|
136 |
|
|
{ TSQPBItem }
|
137 |
|
|
|
138 |
|
|
TSQPBItem = class(TParamBlockItem,ISQPBItem)
|
139 |
|
|
public
|
140 |
|
|
function CopyFrom(source: TStream; count: integer): integer;
|
141 |
tony |
56 |
{$IFDEF FPC}
|
142 |
tony |
45 |
procedure ISQPBItem.SetAsInteger = SetAsInteger2;
|
143 |
|
|
procedure ISQPBItem.SetAsString = SetAsString2;
|
144 |
tony |
56 |
{$ELSE}
|
145 |
|
|
procedure SetAsString(aValue: AnsiString) ;
|
146 |
|
|
procedure SetAsInteger(aValue: integer);
|
147 |
|
|
{$ENDIF}
|
148 |
tony |
45 |
end;
|
149 |
|
|
|
150 |
|
|
{ TBPBItem }
|
151 |
|
|
|
152 |
|
|
TBPBItem = class(TParamBlockItem,IBPBItem)
|
153 |
|
|
public
|
154 |
tony |
56 |
{$IFDEF FPC}
|
155 |
tony |
45 |
procedure IBPBItem.SetAsInteger = SetAsInteger1;
|
156 |
tony |
56 |
{$ELSE}
|
157 |
|
|
procedure SetAsInteger(aValue: integer);
|
158 |
|
|
{$ENDIF}
|
159 |
tony |
45 |
end;
|
160 |
|
|
|
161 |
tony |
143 |
{ TDIRBItem }
|
162 |
|
|
|
163 |
|
|
TDIRBItem = class(TParamBlockItem,IDIRBItem)
|
164 |
|
|
public
|
165 |
|
|
{$IFDEF FPC}
|
166 |
|
|
procedure IDIRBItem.SetAsInteger = SetAsInteger2;
|
167 |
|
|
{$ELSE}
|
168 |
|
|
procedure SetAsInteger(aValue: integer);
|
169 |
|
|
{$ENDIF}
|
170 |
|
|
end;
|
171 |
|
|
|
172 |
tony |
56 |
{ TCustomParamBlock }
|
173 |
|
|
|
174 |
|
|
{$IFDEF FPC}
|
175 |
|
|
TCustomParamBlock<_TItem, _IItem> = class(TParamBlock)
|
176 |
|
|
{$ELSE}
|
177 |
|
|
TParamBlockItemClass = class of TParamBlockItem;
|
178 |
|
|
TCustomParamBlock<_TItem: TParamBlockItem; _IItem: IParameterBlockItem> = class(TParamBlock)
|
179 |
|
|
{$ENDIF}
|
180 |
|
|
public
|
181 |
|
|
function Add(ParamType: byte): _IItem;
|
182 |
tony |
315 |
function AddByTypeName(ParamTypeName: AnsiString): _IItem;
|
183 |
tony |
56 |
function Find(ParamType: byte): _IItem;
|
184 |
|
|
function GetItems(index: integer): _IItem;
|
185 |
|
|
end;
|
186 |
|
|
|
187 |
|
|
{ TSRB }
|
188 |
|
|
|
189 |
|
|
TSRB = class (TCustomParamBlock<TSRBItem,ISRBItem>, ISRB);
|
190 |
|
|
|
191 |
|
|
{ TSQPB }
|
192 |
|
|
|
193 |
|
|
TSQPB = class (TCustomParamBlock<TSQPBItem,ISQPBItem>, ISQPB);
|
194 |
|
|
|
195 |
tony |
45 |
{ TBPB }
|
196 |
|
|
|
197 |
tony |
56 |
TBPB = class (TCustomParamBlock<TBPBItem,IBPBItem>, IBPB)
|
198 |
tony |
45 |
public
|
199 |
tony |
263 |
constructor Create(api: TFBClientAPI);
|
200 |
tony |
45 |
end;
|
201 |
|
|
|
202 |
tony |
143 |
TDIRB = class (TCustomParamBlock<TDIRBItem,IDIRBItem>, IDIRB);
|
203 |
|
|
|
204 |
tony |
45 |
implementation
|
205 |
|
|
|
206 |
tony |
56 |
uses FBMessages {$IFNDEF FPC} , TypInfo {$ENDIF};
|
207 |
tony |
45 |
|
208 |
|
|
const
|
209 |
|
|
MaxBufferSize = 65535;
|
210 |
|
|
|
211 |
tony |
143 |
{ TDIRBItem }
|
212 |
|
|
{$IFNDEF FPC}
|
213 |
|
|
procedure TDIRBItem.SetAsInteger(aValue: integer);
|
214 |
|
|
begin
|
215 |
|
|
SetAsInteger2(aValue);
|
216 |
|
|
end;
|
217 |
|
|
{$ENDIF}
|
218 |
|
|
|
219 |
tony |
56 |
{ TBPBItem }
|
220 |
|
|
{$IFNDEF FPC}
|
221 |
|
|
procedure TBPBItem.SetAsInteger(aValue: integer);
|
222 |
tony |
45 |
begin
|
223 |
tony |
56 |
SetAsInteger1(aValue);
|
224 |
tony |
45 |
end;
|
225 |
tony |
56 |
{$ENDIF}
|
226 |
tony |
45 |
|
227 |
tony |
56 |
{ TSRBItem }
|
228 |
|
|
|
229 |
|
|
{$IFNDEF FPC}
|
230 |
|
|
procedure TSRBItem.SetAsString(aValue: AnsiString);
|
231 |
tony |
45 |
begin
|
232 |
tony |
56 |
SetAsString2(aValue);
|
233 |
tony |
45 |
end;
|
234 |
|
|
|
235 |
tony |
56 |
procedure TSRBItem.SetAsByte(aValue: byte);
|
236 |
tony |
45 |
begin
|
237 |
tony |
56 |
SetAsByte2(aValue);
|
238 |
tony |
45 |
end;
|
239 |
tony |
56 |
{$ENDIF}
|
240 |
tony |
45 |
|
241 |
|
|
{ TSQPBItem }
|
242 |
|
|
|
243 |
|
|
function TSQPBItem.CopyFrom(source: TStream; count: integer): integer;
|
244 |
|
|
begin
|
245 |
|
|
if count > (FOwner.AvailableBufferSpace - 4) then
|
246 |
|
|
count := FOwner.AvailableBufferSpace - 4;
|
247 |
|
|
with FParamData^ do
|
248 |
|
|
begin
|
249 |
|
|
FOwner.UpdateRequestItemSize(self,count + 4);
|
250 |
|
|
Result := source.Read((FBufPtr+3)^,count);
|
251 |
tony |
263 |
with FFirebirdClientAPI do
|
252 |
tony |
45 |
EncodeInteger(Result,2,FBufPtr+1);
|
253 |
tony |
56 |
(FBufPtr+Result + 3)^ := isc_info_end;
|
254 |
tony |
45 |
if Result <> count then
|
255 |
|
|
FOwner.UpdateRequestItemSize(self,Result + 4);
|
256 |
|
|
FDataType := dtString2;
|
257 |
|
|
end;
|
258 |
|
|
end;
|
259 |
|
|
|
260 |
tony |
56 |
{$IFNDEF FPC}
|
261 |
|
|
procedure TSQPBItem.SetAsString(aValue: AnsiString);
|
262 |
|
|
begin
|
263 |
|
|
SetAsString2(aValue);
|
264 |
|
|
end;
|
265 |
tony |
45 |
|
266 |
tony |
56 |
procedure TSQPBItem.SetAsInteger(aValue: integer);
|
267 |
tony |
45 |
begin
|
268 |
tony |
56 |
SetAsInteger2(aValue);
|
269 |
tony |
45 |
end;
|
270 |
tony |
56 |
{$ENDIF}
|
271 |
tony |
45 |
|
272 |
|
|
{ TParamBlockItem }
|
273 |
|
|
|
274 |
|
|
constructor TParamBlockItem.Create(AOwner: TParamBlock;
|
275 |
|
|
Data: PParamBlockItemData);
|
276 |
|
|
begin
|
277 |
|
|
inherited Create;
|
278 |
|
|
FOwner := AOwner;
|
279 |
tony |
263 |
FFirebirdClientAPI := AOwner.FFirebirdClientAPI;
|
280 |
tony |
45 |
FOwnerIntf := AOwner;
|
281 |
|
|
FParamData := Data;
|
282 |
|
|
end;
|
283 |
|
|
|
284 |
|
|
function TParamBlockItem.getAsInteger: integer;
|
285 |
|
|
begin
|
286 |
tony |
263 |
with FFirebirdClientAPI, FParamData^ do
|
287 |
tony |
45 |
case FDataType of
|
288 |
|
|
dtInteger:
|
289 |
|
|
Result := DecodeInteger(FBufPtr+1,4);
|
290 |
|
|
dtShortInteger:
|
291 |
|
|
Result := DecodeInteger(FBufPtr+1,2);
|
292 |
|
|
dtTinyInteger:
|
293 |
|
|
Result := DecodeInteger(FBufPtr+1,1);
|
294 |
|
|
dtInteger1:
|
295 |
|
|
Result := DecodeInteger(FBufPtr+2,2);
|
296 |
|
|
dtInteger2:
|
297 |
|
|
Result := DecodeInteger(FBufPtr+3,4);
|
298 |
|
|
else
|
299 |
|
|
IBError(ibxePBParamTypeError,[nil]);
|
300 |
|
|
end;
|
301 |
|
|
end;
|
302 |
|
|
|
303 |
|
|
function TParamBlockItem.getParamType: byte;
|
304 |
|
|
begin
|
305 |
|
|
Result := byte(FParamData^.FBufPtr^);
|
306 |
|
|
end;
|
307 |
|
|
|
308 |
tony |
315 |
function TParamBlockItem.getParamTypeName: AnsiString;
|
309 |
|
|
begin
|
310 |
|
|
Result := '';
|
311 |
|
|
end;
|
312 |
|
|
|
313 |
tony |
56 |
function TParamBlockItem.getAsString: AnsiString;
|
314 |
tony |
45 |
var len: byte;
|
315 |
|
|
begin
|
316 |
|
|
Result := '';
|
317 |
|
|
|
318 |
|
|
with FParamData^ do
|
319 |
|
|
case FDataType of
|
320 |
|
|
dtInteger,
|
321 |
|
|
dtInteger1,
|
322 |
|
|
dtInteger2,
|
323 |
|
|
dtShortInteger,
|
324 |
|
|
dtTinyInteger:
|
325 |
|
|
Result := IntToStr(getAsInteger);
|
326 |
|
|
dtByte,
|
327 |
|
|
dtByte2:
|
328 |
|
|
Result := IntToStr(getAsByte);
|
329 |
|
|
dtString:
|
330 |
|
|
begin
|
331 |
tony |
56 |
len := (FBufPtr+1)^;
|
332 |
|
|
SetString(Result,PAnsiChar(FBufPtr+2),len);
|
333 |
tony |
45 |
end;
|
334 |
|
|
dtString2:
|
335 |
|
|
begin
|
336 |
tony |
263 |
with FFirebirdClientAPI do
|
337 |
tony |
45 |
len := DecodeInteger(FBufPtr+1,2);
|
338 |
tony |
56 |
SetString(Result,PAnsiChar(FBufPtr+3),len);
|
339 |
tony |
45 |
end;
|
340 |
|
|
dtString0:
|
341 |
tony |
56 |
Result := strpas(PAnsiChar(FBufPtr+1));
|
342 |
tony |
315 |
dtNone:
|
343 |
|
|
Result := '';
|
344 |
|
|
else
|
345 |
|
|
IBError(ibxeOutputBlockTypeError,[nil]);
|
346 |
tony |
45 |
end;
|
347 |
|
|
end;
|
348 |
|
|
|
349 |
|
|
function TParamBlockItem.getAsByte: byte;
|
350 |
|
|
begin
|
351 |
|
|
with FParamData^ do
|
352 |
|
|
if FDataType = dtByte then
|
353 |
|
|
Result := byte((FBufPtr+2)^)
|
354 |
|
|
else
|
355 |
|
|
if FDataType = dtByte2 then
|
356 |
|
|
Result := byte((FBufPtr+1)^)
|
357 |
|
|
else
|
358 |
|
|
IBError(ibxePBParamTypeError,[nil]);
|
359 |
|
|
end;
|
360 |
|
|
|
361 |
|
|
procedure TParamBlockItem.addByte(aValue: byte);
|
362 |
|
|
var len: integer;
|
363 |
tony |
56 |
P: PByte;
|
364 |
tony |
45 |
begin
|
365 |
|
|
with FParamData^ do
|
366 |
|
|
begin
|
367 |
|
|
P := FBufPtr + FBufLength;
|
368 |
|
|
len := FBufLength + 1;
|
369 |
|
|
FOwner.UpdateRequestItemSize(self,len);
|
370 |
tony |
56 |
P^ := aValue;
|
371 |
tony |
45 |
end;
|
372 |
|
|
end;
|
373 |
|
|
|
374 |
tony |
308 |
procedure TParamBlockItem.addShortInt(aValue: ShortInt);
|
375 |
|
|
var len: integer;
|
376 |
|
|
P: PByte;
|
377 |
|
|
begin
|
378 |
|
|
with FParamData^ do
|
379 |
|
|
begin
|
380 |
|
|
P := FBufPtr + FBufLength;
|
381 |
|
|
len := FBufLength + 1;
|
382 |
|
|
FOwner.UpdateRequestItemSize(self,len);
|
383 |
|
|
PShortInt(P)^ := aValue;
|
384 |
|
|
end;
|
385 |
|
|
end;
|
386 |
|
|
|
387 |
tony |
45 |
procedure TParamBlockItem.addShortInteger(aValue: integer);
|
388 |
|
|
var len: integer;
|
389 |
tony |
56 |
P: PByte;
|
390 |
tony |
45 |
begin
|
391 |
|
|
with FParamData^ do
|
392 |
|
|
begin
|
393 |
|
|
P := FBufPtr + FBufLength;
|
394 |
|
|
len := FBufLength + 2;
|
395 |
|
|
FOwner.UpdateRequestItemSize(self,len);
|
396 |
tony |
263 |
with FFirebirdClientAPI do
|
397 |
tony |
45 |
EncodeInteger(aValue,2,P);
|
398 |
|
|
end;
|
399 |
|
|
end;
|
400 |
|
|
|
401 |
|
|
procedure TParamBlockItem.setAsByte(aValue: byte);
|
402 |
|
|
begin
|
403 |
|
|
with FParamData^ do
|
404 |
|
|
begin
|
405 |
|
|
if FBufLength <> 3 then
|
406 |
|
|
FOwner.UpdateRequestItemSize(self,3);
|
407 |
|
|
FDataType := dtByte;
|
408 |
tony |
56 |
(FBufPtr+1)^ := $1;
|
409 |
|
|
(FBufPtr+2)^ := aValue;
|
410 |
tony |
45 |
end;
|
411 |
|
|
end;
|
412 |
|
|
|
413 |
|
|
procedure TParamBlockItem.setAsByte2(aValue: byte);
|
414 |
|
|
begin
|
415 |
|
|
with FParamData^ do
|
416 |
|
|
begin
|
417 |
|
|
if FBufLength <> 2 then
|
418 |
|
|
FOwner.UpdateRequestItemSize(self,2);
|
419 |
|
|
FDataType := dtByte2;
|
420 |
tony |
56 |
(FBufPtr+1)^ := aValue;
|
421 |
tony |
45 |
end;
|
422 |
|
|
end;
|
423 |
|
|
|
424 |
|
|
{Four byte integer - no length}
|
425 |
|
|
|
426 |
|
|
procedure TParamBlockItem.SetAsInteger(aValue: integer);
|
427 |
|
|
begin
|
428 |
|
|
with FParamData^ do
|
429 |
|
|
begin
|
430 |
|
|
if FBufLength <> 5 then
|
431 |
|
|
FOwner.UpdateRequestItemSize(self,5);
|
432 |
tony |
263 |
with FFirebirdClientAPI do
|
433 |
tony |
45 |
EncodeInteger(aValue,4,FBufPtr+1);
|
434 |
|
|
FDataType := dtInteger;
|
435 |
|
|
end;
|
436 |
|
|
end;
|
437 |
|
|
|
438 |
|
|
{Four byte integer - length byte}
|
439 |
|
|
|
440 |
|
|
procedure TParamBlockItem.SetAsInteger1(aValue: integer);
|
441 |
|
|
begin
|
442 |
|
|
with FParamData^ do
|
443 |
|
|
begin
|
444 |
|
|
if FBufLength <> 6 then
|
445 |
|
|
FOwner.UpdateRequestItemSize(self,6);
|
446 |
tony |
56 |
(FBufPtr+1)^ := $4;
|
447 |
tony |
263 |
with FFirebirdClientAPI do
|
448 |
tony |
45 |
EncodeInteger(aValue,4,FBufPtr+2);
|
449 |
|
|
FDataType := dtInteger1;
|
450 |
|
|
end;
|
451 |
|
|
end;
|
452 |
|
|
|
453 |
|
|
{Four byte integer - 2 byte length}
|
454 |
|
|
|
455 |
|
|
procedure TParamBlockItem.SetAsInteger2(aValue: integer);
|
456 |
|
|
begin
|
457 |
|
|
with FParamData^ do
|
458 |
|
|
begin
|
459 |
|
|
if FBufLength <> 7 then
|
460 |
|
|
FOwner.UpdateRequestItemSize(self,7);
|
461 |
tony |
263 |
with FFirebirdClientAPI do
|
462 |
tony |
45 |
begin
|
463 |
|
|
EncodeInteger(4,2,FBufPtr+1); {Encode length as two bytes}
|
464 |
|
|
EncodeInteger(aValue,4,FBufPtr+3);
|
465 |
|
|
end;
|
466 |
|
|
FDataType := dtInteger2
|
467 |
|
|
end;
|
468 |
|
|
end;
|
469 |
|
|
|
470 |
|
|
procedure TParamBlockItem.SetAsShortInteger(aValue: integer);
|
471 |
|
|
begin
|
472 |
|
|
with FParamData^ do
|
473 |
|
|
begin
|
474 |
|
|
if FBufLength <> 3 then
|
475 |
|
|
FOwner.UpdateRequestItemSize(self,3);
|
476 |
tony |
263 |
with FFirebirdClientAPI do
|
477 |
tony |
45 |
EncodeInteger(aValue,2,FBufPtr+1);
|
478 |
|
|
FDataType := dtShortInteger;
|
479 |
|
|
end;
|
480 |
|
|
end;
|
481 |
|
|
|
482 |
|
|
procedure TParamBlockItem.SetAsTinyInteger(aValue: integer);
|
483 |
|
|
begin
|
484 |
|
|
with FParamData^ do
|
485 |
|
|
begin
|
486 |
|
|
if FBufLength <> 2 then
|
487 |
|
|
FOwner.UpdateRequestItemSize(self,2);
|
488 |
tony |
263 |
with FFirebirdClientAPI do
|
489 |
tony |
45 |
EncodeInteger(aValue,1,FBufPtr+1);
|
490 |
|
|
FDataType := dtTinyInteger;
|
491 |
|
|
end;
|
492 |
|
|
end;
|
493 |
|
|
|
494 |
|
|
{Short string encoding}
|
495 |
|
|
|
496 |
tony |
56 |
procedure TParamBlockItem.SetAsString(aValue: AnsiString);
|
497 |
tony |
45 |
var len: integer;
|
498 |
|
|
begin
|
499 |
|
|
with FParamData^ do
|
500 |
|
|
begin
|
501 |
|
|
len := Length(aValue);
|
502 |
|
|
if len > 255 then
|
503 |
|
|
IBError(ibxStringTooLong,[aValue,255]);
|
504 |
|
|
FOwner.UpdateRequestItemSize(self,len+2);
|
505 |
tony |
56 |
(FBufPtr+1)^ := len;
|
506 |
tony |
45 |
if len > 0 then
|
507 |
|
|
Move(aValue[1],(FBufPtr+2)^,len);
|
508 |
|
|
FDataType := dtString;
|
509 |
|
|
end;
|
510 |
|
|
end;
|
511 |
|
|
|
512 |
|
|
{Long string up to 65535 encoding}
|
513 |
|
|
|
514 |
tony |
56 |
procedure TParamBlockItem.SetAsString2(aValue: AnsiString);
|
515 |
tony |
45 |
var len: integer;
|
516 |
|
|
begin
|
517 |
|
|
with FParamData^ do
|
518 |
|
|
begin
|
519 |
|
|
len := Length(aValue);
|
520 |
|
|
if len > 65535 then
|
521 |
|
|
IBError(ibxStringTooLong,[aValue,65535]);
|
522 |
|
|
FOwner.UpdateRequestItemSize(self,len + 3);
|
523 |
tony |
263 |
with FFirebirdClientAPI do
|
524 |
tony |
45 |
EncodeInteger(len,2,FBufPtr+1);
|
525 |
|
|
if len > 0 then
|
526 |
|
|
Move(aValue[1],(FBufPtr+3)^,len);
|
527 |
|
|
FDataType := dtString2;
|
528 |
|
|
end;
|
529 |
|
|
end;
|
530 |
|
|
|
531 |
|
|
{Zero byte terminated string encoding}
|
532 |
|
|
|
533 |
tony |
56 |
procedure TParamBlockItem.SetAsString0(aValue: AnsiString);
|
534 |
tony |
45 |
var len: integer;
|
535 |
|
|
begin
|
536 |
|
|
with FParamData^ do
|
537 |
|
|
begin
|
538 |
|
|
len := Length(aValue);
|
539 |
|
|
FOwner.UpdateRequestItemSize(self,len+2);
|
540 |
|
|
if len > 0 then
|
541 |
|
|
Move(aValue[1],(FBufPtr+1)^,len);
|
542 |
tony |
56 |
(FBufPtr+len+1)^ := 0;
|
543 |
tony |
45 |
FDataType := dtString0;
|
544 |
|
|
end;
|
545 |
|
|
end;
|
546 |
|
|
|
547 |
|
|
{ TParamBlock }
|
548 |
|
|
|
549 |
|
|
procedure TParamBlock.AdjustBuffer;
|
550 |
tony |
56 |
var P: PByte;
|
551 |
tony |
45 |
i: integer;
|
552 |
|
|
headerLen: integer;
|
553 |
|
|
begin
|
554 |
|
|
if FDataLength > FBufferSize then
|
555 |
|
|
begin
|
556 |
|
|
if Length(FItems) > 0 then
|
557 |
|
|
headerLen := FItems[0]^.FBufPtr - FBuffer
|
558 |
|
|
else
|
559 |
|
|
headerLen := 0;
|
560 |
|
|
FBufferSize := 2*FDataLength;
|
561 |
|
|
ReallocMem(FBuffer,FBufferSize);
|
562 |
|
|
P := FBuffer + headerLen;
|
563 |
|
|
for i := 0 to Length(FItems) - 1 do
|
564 |
|
|
begin
|
565 |
|
|
FItems[i]^.FBufPtr := P;
|
566 |
|
|
Inc(P,FItems[i]^.FBuflength);
|
567 |
|
|
end;
|
568 |
|
|
end;
|
569 |
|
|
end;
|
570 |
|
|
|
571 |
|
|
procedure TParamBlock.MoveBy(Item: PParamBlockItemData; delta: integer);
|
572 |
tony |
56 |
var src, dest: PByte;
|
573 |
tony |
45 |
i: integer;
|
574 |
|
|
begin
|
575 |
|
|
with Item^ do
|
576 |
|
|
begin
|
577 |
|
|
src := FBufptr;
|
578 |
|
|
dest := FBufptr + delta ;
|
579 |
|
|
if delta > 0 then
|
580 |
|
|
begin
|
581 |
|
|
for i := FBufLength - 1 downto 0 do
|
582 |
|
|
(dest +i)^ := (src+i)^;
|
583 |
|
|
end
|
584 |
|
|
else
|
585 |
|
|
begin
|
586 |
|
|
for i := 0 to FBufLength - 1 do
|
587 |
|
|
(dest +i)^ := (src+i)^;
|
588 |
|
|
end;
|
589 |
tony |
56 |
FBufPtr := FBufPtr + delta;
|
590 |
tony |
45 |
end;
|
591 |
|
|
end;
|
592 |
|
|
|
593 |
|
|
procedure TParamBlock.UpdateRequestItemSize(Item: TParamBlockItem;
|
594 |
|
|
NewSize: integer);
|
595 |
|
|
var i, delta: integer;
|
596 |
|
|
begin
|
597 |
|
|
delta := NewSize - Item.FParamData^.FBufLength;
|
598 |
|
|
Item.FParamData^.FBufLength := NewSize;
|
599 |
|
|
if delta > 0 then
|
600 |
|
|
begin
|
601 |
|
|
if FDataLength + delta > MaxBufferSize then
|
602 |
|
|
IBError(ibxeParamBufferOverflow,[nil]);
|
603 |
tony |
56 |
FDataLength := FDataLength + delta;
|
604 |
tony |
45 |
AdjustBuffer;
|
605 |
|
|
i := Length(FItems) - 1;
|
606 |
|
|
while i >= 0 do
|
607 |
|
|
begin
|
608 |
|
|
if FItems[i] = Item.FParamData then
|
609 |
|
|
break; {we're done}
|
610 |
|
|
Moveby(FItems[i],delta);
|
611 |
|
|
Dec(i);
|
612 |
|
|
end;
|
613 |
|
|
end
|
614 |
|
|
else
|
615 |
|
|
begin
|
616 |
|
|
i := 0;
|
617 |
|
|
while i < Length(FItems) do
|
618 |
|
|
begin
|
619 |
|
|
if FItems[i] = Item.FParamData then
|
620 |
|
|
break; {we're done}
|
621 |
|
|
Inc(i);
|
622 |
|
|
end;
|
623 |
|
|
Inc(i);
|
624 |
|
|
while i < Length(FItems) do
|
625 |
|
|
begin
|
626 |
|
|
Moveby(FItems[i],delta);
|
627 |
|
|
Inc(i);
|
628 |
|
|
end;
|
629 |
tony |
56 |
FDataLength := FDataLength + delta;
|
630 |
tony |
45 |
end;
|
631 |
|
|
end;
|
632 |
|
|
|
633 |
tony |
263 |
constructor TParamBlock.Create(api: TFBClientAPI);
|
634 |
tony |
45 |
begin
|
635 |
|
|
inherited Create;
|
636 |
tony |
263 |
FFirebirdClientAPI := api;
|
637 |
tony |
45 |
GetMem(FBuffer,128);
|
638 |
|
|
if FBuffer = nil then
|
639 |
|
|
OutOfMemoryError;
|
640 |
|
|
FBufferSize := 128;
|
641 |
|
|
FDataLength := 0;
|
642 |
|
|
end;
|
643 |
|
|
|
644 |
|
|
destructor TParamBlock.Destroy;
|
645 |
|
|
var i: integer;
|
646 |
|
|
begin
|
647 |
|
|
for i := 0 to Length(FItems) -1 do
|
648 |
|
|
dispose(FItems[i]);
|
649 |
|
|
Freemem(FBuffer);
|
650 |
|
|
inherited Destroy;
|
651 |
|
|
end;
|
652 |
|
|
|
653 |
tony |
56 |
function TParamBlock.getBuffer: PByte;
|
654 |
tony |
45 |
begin
|
655 |
|
|
if FDataLength = 0 then
|
656 |
|
|
Result := nil
|
657 |
|
|
else
|
658 |
|
|
Result := FBuffer;
|
659 |
|
|
end;
|
660 |
|
|
|
661 |
|
|
function TParamBlock.getDataLength: integer;
|
662 |
|
|
begin
|
663 |
tony |
315 |
Result := FDataLength;
|
664 |
tony |
45 |
end;
|
665 |
|
|
|
666 |
|
|
function TParamBlock.AvailableBufferSpace: integer;
|
667 |
|
|
begin
|
668 |
|
|
Result := MaxBufferSize - FDataLength;
|
669 |
|
|
end;
|
670 |
|
|
|
671 |
|
|
function TParamBlock.Add(ParamType: byte): PParamBlockItemData;
|
672 |
|
|
begin
|
673 |
|
|
new(Result);
|
674 |
|
|
Result^.FBufPtr := FBuffer + FDataLength;
|
675 |
|
|
Result^.FBufLength := 1;
|
676 |
tony |
56 |
Result^.FBufPtr^ := ParamType;
|
677 |
tony |
45 |
Result^.FDataType := dtnone; {default}
|
678 |
|
|
Inc(FDataLength,1);
|
679 |
|
|
AdjustBuffer;
|
680 |
|
|
SetLength(FItems,Length(FItems)+1);
|
681 |
|
|
FItems[Length(FItems) - 1 ] := Result;
|
682 |
|
|
end;
|
683 |
|
|
|
684 |
|
|
function TParamBlock.Find(ParamType: byte): PParamBlockItemData;
|
685 |
|
|
var i: integer;
|
686 |
|
|
begin
|
687 |
|
|
Result := nil;
|
688 |
|
|
for i := 0 to getCount - 1 do
|
689 |
tony |
56 |
if byte(FItems[i]^.FBufPtr^) = ParamType then
|
690 |
tony |
45 |
begin
|
691 |
|
|
Result := FItems[i];
|
692 |
|
|
Exit;
|
693 |
|
|
end;
|
694 |
|
|
end;
|
695 |
|
|
|
696 |
|
|
function TParamBlock.GetItems(index: integer): PParamBlockItemData;
|
697 |
|
|
begin
|
698 |
|
|
if (index >= 0 ) and (index < Length(FItems)) then
|
699 |
|
|
Result := FItems[index]
|
700 |
|
|
else
|
701 |
|
|
IBError(ibxePBIndexError,[index]);
|
702 |
|
|
end;
|
703 |
|
|
|
704 |
tony |
315 |
function TParamBlock.LookupItemType(ParamTypeName: AnsiString): byte;
|
705 |
|
|
begin
|
706 |
|
|
IBError(ibxeNotSupported,[]);
|
707 |
|
|
end;
|
708 |
|
|
|
709 |
tony |
45 |
function TParamBlock.getCount: integer;
|
710 |
|
|
begin
|
711 |
|
|
Result := Length(FItems);
|
712 |
|
|
end;
|
713 |
|
|
|
714 |
|
|
procedure TParamBlock.Remove(ParamType: byte);
|
715 |
|
|
var P: PParamBlockItemData;
|
716 |
|
|
i, j: integer;
|
717 |
|
|
begin
|
718 |
|
|
P := nil;
|
719 |
|
|
for i := 0 to getCount - 1 do
|
720 |
tony |
56 |
if byte(FItems[i]^.FBufPtr^) = ParamType then
|
721 |
tony |
45 |
begin
|
722 |
|
|
P := FItems[i];
|
723 |
|
|
for j := i + 1 to getCount - 1 do
|
724 |
|
|
begin
|
725 |
|
|
MoveBy(FItems[j],-P^.FBufLength);
|
726 |
|
|
FItems[j - 1] := FItems[j];
|
727 |
|
|
end;
|
728 |
tony |
56 |
FDataLength := FDataLength - P^.FBufLength;
|
729 |
tony |
45 |
dispose(P);
|
730 |
|
|
SetLength(FItems,Length(FItems)-1);
|
731 |
|
|
Exit;
|
732 |
|
|
end;
|
733 |
|
|
end;
|
734 |
|
|
|
735 |
|
|
procedure TParamBlock.PrintBuf;
|
736 |
|
|
var i: integer;
|
737 |
|
|
begin
|
738 |
tony |
315 |
write(ClassName,': (',getDataLength,') ');
|
739 |
tony |
45 |
for i := 0 to getDataLength - 1 do
|
740 |
|
|
write(Format('%x ',[byte(FBuffer[i])]));
|
741 |
|
|
writeln
|
742 |
|
|
end;
|
743 |
|
|
|
744 |
tony |
56 |
{ TCustomParamBlock }
|
745 |
|
|
|
746 |
tony |
315 |
function TCustomParamBlock<_TItem, _IItem>.AddByTypeName(ParamTypeName: AnsiString
|
747 |
|
|
): _IItem;
|
748 |
|
|
var ParamType: byte;
|
749 |
|
|
begin
|
750 |
|
|
ParamType := LookupItemType(ParamTypeName);
|
751 |
|
|
if ParamType = 0 then
|
752 |
|
|
IBError(ibxeUnknownParamTypeName,[ClassName,ParamTypeName]);
|
753 |
|
|
Result := Add(ParamType);
|
754 |
|
|
end;
|
755 |
|
|
|
756 |
tony |
56 |
{$IFDEF FPC}
|
757 |
|
|
function TCustomParamBlock<_TItem, _IItem>.Add(ParamType: byte): _IItem;
|
758 |
|
|
var Item: PParamBlockItemData;
|
759 |
|
|
begin
|
760 |
|
|
Item := inherited Add(ParamType);
|
761 |
|
|
Result := _TItem.Create(self,Item);
|
762 |
|
|
end;
|
763 |
|
|
|
764 |
|
|
function TCustomParamBlock<_TItem, _IItem>.Find(ParamType: byte): _IItem;
|
765 |
|
|
var Item: PParamBlockItemData;
|
766 |
|
|
begin
|
767 |
|
|
Result := nil;
|
768 |
|
|
Item := inherited Find(ParamType);
|
769 |
|
|
if Item <> nil then
|
770 |
|
|
Result := _TItem.Create(self,Item);
|
771 |
|
|
end;
|
772 |
|
|
|
773 |
|
|
function TCustomParamBlock<_TItem, _IItem>.GetItems(index: integer): _IItem;
|
774 |
|
|
var Item: PParamBlockItemData;
|
775 |
|
|
begin
|
776 |
|
|
Item := inherited getItems(index);
|
777 |
|
|
Result := _TItem.Create(self,Item);
|
778 |
|
|
end;
|
779 |
tony |
315 |
|
780 |
tony |
56 |
{$ELSE}
|
781 |
|
|
function TCustomParamBlock<_TItem, _IItem>.Add(ParamType: byte): _IItem;
|
782 |
|
|
var Item: PParamBlockItemData;
|
783 |
|
|
Obj: TParamBlockItem;
|
784 |
|
|
begin
|
785 |
|
|
Item := inherited Add(ParamType);
|
786 |
|
|
Obj := TParamBlockItemClass(_TItem).Create(self,Item);
|
787 |
|
|
if Obj.QueryInterface(GetTypeData(TypeInfo(_IItem))^.Guid,Result) <> 0 then
|
788 |
|
|
IBError(ibxeInterfaceNotSupported,[GuidToString(GetTypeData(TypeInfo(_IItem))^.Guid)]);
|
789 |
|
|
end;
|
790 |
|
|
|
791 |
|
|
function TCustomParamBlock<_TItem, _IItem>.Find(ParamType: byte): _IItem;
|
792 |
|
|
var Item: PParamBlockItemData;
|
793 |
|
|
Obj: TParamBlockItem;
|
794 |
|
|
begin
|
795 |
|
|
FillChar(Result,sizeof(Result),0); {workaround for older versions of Delphi}
|
796 |
|
|
Item := inherited Find(ParamType);
|
797 |
|
|
if Item <> nil then
|
798 |
|
|
begin
|
799 |
|
|
Obj := TParamBlockItemClass(_TItem).Create(self,Item);
|
800 |
|
|
if Obj.QueryInterface(GetTypeData(TypeInfo(_IItem))^.Guid,Result) <> 0 then
|
801 |
|
|
IBError(ibxeInterfaceNotSupported,[GuidToString(GetTypeData(TypeInfo(_IItem))^.Guid)]);
|
802 |
|
|
end;
|
803 |
|
|
end;
|
804 |
|
|
|
805 |
|
|
function TCustomParamBlock<_TItem, _IItem>.GetItems(index: integer): _IItem;
|
806 |
|
|
var Item: PParamBlockItemData;
|
807 |
|
|
Obj: TParamBlockItem;
|
808 |
|
|
begin
|
809 |
|
|
Item := inherited getItems(index);
|
810 |
|
|
Obj := TParamBlockItemClass(_TItem).Create(self,Item);
|
811 |
|
|
if Obj.QueryInterface(GetTypeData(TypeInfo(_IItem))^.Guid,Result) <> 0 then
|
812 |
|
|
IBError(ibxeInterfaceNotSupported,[GuidToString(GetTypeData(TypeInfo(_IItem))^.Guid)]);
|
813 |
|
|
end;
|
814 |
|
|
{$ENDIF}
|
815 |
|
|
|
816 |
|
|
{ TBPB }
|
817 |
|
|
|
818 |
tony |
263 |
constructor TBPB.Create(api: TFBClientAPI);
|
819 |
tony |
56 |
begin
|
820 |
tony |
263 |
inherited Create(api);
|
821 |
tony |
56 |
FDataLength := 1;
|
822 |
|
|
FBuffer^ := isc_bpb_version1;
|
823 |
|
|
end;
|
824 |
|
|
|
825 |
tony |
45 |
end.
|
826 |
|
|
|