37 |
|
interface |
38 |
|
|
39 |
|
uses |
40 |
< |
Classes, SysUtils, FBAttachment, FB30ClientAPI, Firebird, IB, FBActivityMonitor, FBParamBlock; |
40 |
> |
Classes, SysUtils, FBAttachment, FBClientAPI, FB30ClientAPI, Firebird, IB, |
41 |
> |
FBActivityMonitor, FBParamBlock; |
42 |
|
|
43 |
|
type |
44 |
|
|
48 |
|
private |
49 |
|
FAttachmentIntf: Firebird.IAttachment; |
50 |
|
FFirebird30ClientAPI: TFB30ClientAPI; |
51 |
+ |
FTimeZoneServices: ITimeZoneServices; |
52 |
+ |
FUsingRemoteICU: boolean; |
53 |
+ |
procedure SetUseRemoteICU(aValue: boolean); |
54 |
|
protected |
55 |
|
procedure CheckHandle; override; |
56 |
|
public |
76 |
|
procedure ExecImmediate(transaction: ITransaction; sql: AnsiString; aSQLDialect: integer); override; |
77 |
|
function Prepare(transaction: ITransaction; sql: AnsiString; aSQLDialect: integer): IStatement; override; |
78 |
|
function PrepareWithNamedParameters(transaction: ITransaction; sql: AnsiString; |
79 |
< |
aSQLDialect: integer; GenerateParamNames: boolean=false): IStatement; override; |
79 |
> |
aSQLDialect: integer; GenerateParamNames: boolean=false; |
80 |
> |
CaseSensitiveParams: boolean=false): IStatement; override; |
81 |
|
|
82 |
|
{Events} |
83 |
|
function GetEventHandler(Events: TStrings): IEvents; override; |
84 |
|
|
85 |
|
{Blob - may use to open existing Blobs. However, ISQLData.AsBlob is preferred} |
86 |
|
|
87 |
< |
function CreateBlob(transaction: ITransaction; RelationName, ColumnName: AnsiString; BPB: IBPB=nil): IBlob; overload; |
83 |
< |
function CreateBlob(transaction: ITransaction; BlobMetaData: IBlobMetaData; BPB: IBPB=nil): IBlob; overload; |
87 |
> |
function CreateBlob(transaction: ITransaction; BlobMetaData: IBlobMetaData; BPB: IBPB=nil): IBlob; overload; override; |
88 |
|
function CreateBlob(transaction: ITransaction; SubType: integer; aCharSetID: cardinal=0; BPB: IBPB=nil): IBlob; overload; |
85 |
– |
function OpenBlob(transaction: ITransaction; RelationName, ColumnName: AnsiString; BlobID: TISC_QUAD; BPB: IBPB=nil): IBlob; overload; |
89 |
|
function OpenBlob(transaction: ITransaction; BlobMetaData: IBlobMetaData; BlobID: TISC_QUAD; BPB: IBPB=nil): IBlob; overload; override; |
90 |
|
|
91 |
|
{Array} |
92 |
< |
function OpenArray(transaction: ITransaction; RelationName, ColumnName: AnsiString; ArrayID: TISC_QUAD): IArray; |
93 |
< |
function CreateArray(transaction: ITransaction; RelationName, ColumnName: AnsiString): IArray; overload; |
91 |
< |
function CreateArray(transaction: ITransaction; ArrayMetaData: IArrayMetaData): IArray; overload; |
92 |
> |
function OpenArray(transaction: ITransaction; ArrayMetaData: IArrayMetaData; ArrayID: TISC_QUAD): IArray; overload; override; |
93 |
> |
function CreateArray(transaction: ITransaction; ArrayMetaData: IArrayMetaData): IArray; overload; override; |
94 |
|
function CreateArrayMetaData(SQLType: cardinal; tableName: AnsiString; |
95 |
|
columnName: AnsiString; Scale: integer; size: cardinal; aCharSetID: cardinal; |
96 |
|
dimensions: cardinal; bounds: TArrayBounds): IArrayMetaData; |
97 |
|
|
98 |
|
|
99 |
|
{Database Information} |
100 |
< |
function GetBlobMetaData(Transaction: ITransaction; tableName, columnName: AnsiString): IBlobMetaData; |
101 |
< |
function GetArrayMetaData(Transaction: ITransaction; tableName, columnName: AnsiString): IArrayMetaData; |
100 |
> |
function GetBlobMetaData(Transaction: ITransaction; tableName, columnName: AnsiString): IBlobMetaData; override; |
101 |
> |
function GetArrayMetaData(Transaction: ITransaction; tableName, columnName: AnsiString): IArrayMetaData; override; |
102 |
> |
procedure getFBVersion(version: TStrings); |
103 |
> |
function HasDecFloatSupport: boolean; override; |
104 |
> |
function HasBatchMode: boolean; override; |
105 |
> |
|
106 |
> |
{Time Zone Support} |
107 |
> |
function GetTimeZoneServices: ITimeZoneServices; override; |
108 |
> |
function HasTimeZoneSupport: boolean; override; |
109 |
|
end; |
110 |
|
|
111 |
|
implementation |
112 |
|
|
113 |
|
uses FB30Transaction, FB30Statement, FB30Array, FB30Blob, FBMessages, |
114 |
< |
FBOutputBlock, FB30Events, IBUtils; |
114 |
> |
FBOutputBlock, FB30Events, IBUtils, FB30TimeZoneServices; |
115 |
> |
|
116 |
> |
type |
117 |
> |
{ TVersionCallback } |
118 |
> |
|
119 |
> |
TVersionCallback = class(Firebird.IVersionCallbackImpl) |
120 |
> |
private |
121 |
> |
FOutput: TStrings; |
122 |
> |
FFirebirdClientAPI: TFBClientAPI; |
123 |
> |
public |
124 |
> |
constructor Create(FirebirdClientAPI: TFBClientAPI; output: TStrings); |
125 |
> |
procedure callback(status: Firebird.IStatus; text: PAnsiChar); override; |
126 |
> |
end; |
127 |
> |
|
128 |
> |
{ TVersionCallback } |
129 |
> |
|
130 |
> |
constructor TVersionCallback.Create(FirebirdClientAPI: TFBClientAPI; |
131 |
> |
output: TStrings); |
132 |
> |
begin |
133 |
> |
inherited Create; |
134 |
> |
FFirebirdClientAPI := FirebirdClientAPI; |
135 |
> |
FOutput := output; |
136 |
> |
end; |
137 |
> |
|
138 |
> |
procedure TVersionCallback.callback(status: Firebird.IStatus; text: PAnsiChar); |
139 |
> |
var StatusObj: TFB30StatusObject; |
140 |
> |
begin |
141 |
> |
if ((status.getState and status.STATE_ERRORS) <> 0) then |
142 |
> |
begin |
143 |
> |
StatusObj := TFB30StatusObject.Create(FFirebirdClientAPI,status); |
144 |
> |
try |
145 |
> |
raise EIBInterBaseError.Create(StatusObj); |
146 |
> |
finally |
147 |
> |
StatusObj.Free; |
148 |
> |
end; |
149 |
> |
end; |
150 |
> |
FOutput.Add(text); |
151 |
> |
end; |
152 |
> |
|
153 |
|
|
154 |
|
{ TFB30Attachment } |
155 |
|
|
156 |
+ |
procedure TFB30Attachment.SetUseRemoteICU(aValue: boolean); |
157 |
+ |
begin |
158 |
+ |
if (FUsingRemoteICU <> aValue) and (GetODSMajorVersion >= 13) then |
159 |
+ |
begin |
160 |
+ |
if aValue then |
161 |
+ |
ExecImmediate([isc_tpb_write,isc_tpb_wait,isc_tpb_concurrency],'SET BIND OF TIME ZONE TO EXTENDED') |
162 |
+ |
else |
163 |
+ |
ExecImmediate([isc_tpb_write,isc_tpb_wait,isc_tpb_concurrency],'SET BIND OF TIME ZONE TO NATIVE'); |
164 |
+ |
FUsingRemoteICU := aValue; |
165 |
+ |
end; |
166 |
+ |
end; |
167 |
+ |
|
168 |
|
procedure TFB30Attachment.CheckHandle; |
169 |
|
begin |
170 |
|
if FAttachmentIntf = nil then |
270 |
|
FAttachmentIntf := nil |
271 |
|
else |
272 |
|
GetODSAndConnectionInfo; |
273 |
+ |
|
274 |
|
end; |
275 |
|
end; |
276 |
|
|
287 |
|
FHasDefaultCharSet := false; |
288 |
|
FCodePage := CP_NONE; |
289 |
|
FCharSetID := 0; |
290 |
+ |
FTimeZoneServices := nil; |
291 |
|
end; |
292 |
|
end; |
293 |
|
|
342 |
|
end; |
343 |
|
|
344 |
|
function TFB30Attachment.PrepareWithNamedParameters(transaction: ITransaction; |
345 |
< |
sql: AnsiString; aSQLDialect: integer; GenerateParamNames: boolean): IStatement; |
345 |
> |
sql: AnsiString; aSQLDialect: integer; GenerateParamNames: boolean; |
346 |
> |
CaseSensitiveParams: boolean): IStatement; |
347 |
|
begin |
348 |
|
CheckHandle; |
349 |
|
Result := TFB30Statement.CreateWithParameterNames(self,transaction,sql,aSQLDialect, |
350 |
< |
GenerateParamNames); |
350 |
> |
GenerateParamNames,CaseSensitiveParams); |
351 |
|
end; |
352 |
|
|
353 |
|
function TFB30Attachment.GetEventHandler(Events: TStrings): IEvents; |
356 |
|
Result := TFB30Events.Create(self,Events); |
357 |
|
end; |
358 |
|
|
297 |
– |
function TFB30Attachment.CreateBlob(transaction: ITransaction; RelationName, |
298 |
– |
ColumnName: AnsiString; BPB: IBPB): IBlob; |
299 |
– |
begin |
300 |
– |
CheckHandle; |
301 |
– |
Result := TFB30Blob.Create(self,transaction as TFB30Transaction, |
302 |
– |
TFB30BlobMetaData.Create(self,Transaction as TFB30Transaction,RelationName,ColumnName),BPB); |
303 |
– |
end; |
304 |
– |
|
359 |
|
function TFB30Attachment.CreateBlob(transaction: ITransaction; |
360 |
|
BlobMetaData: IBlobMetaData; BPB: IBPB): IBlob; |
361 |
|
begin |
370 |
|
Result := TFB30Blob.Create(self,transaction as TFB30Transaction, SubType,aCharSetID,BPB); |
371 |
|
end; |
372 |
|
|
319 |
– |
function TFB30Attachment.OpenBlob(transaction: ITransaction; RelationName, |
320 |
– |
ColumnName: AnsiString; BlobID: TISC_QUAD; BPB: IBPB): IBlob; |
321 |
– |
begin |
322 |
– |
CheckHandle; |
323 |
– |
Result := TFB30Blob.Create(self,transaction as TFB30transaction, |
324 |
– |
TFB30BlobMetaData.Create(self,Transaction as TFB30Transaction,RelationName,ColumnName), |
325 |
– |
BlobID,BPB); |
326 |
– |
end; |
327 |
– |
|
373 |
|
function TFB30Attachment.OpenBlob(transaction: ITransaction; |
374 |
|
BlobMetaData: IBlobMetaData; BlobID: TISC_QUAD; BPB: IBPB): IBlob; |
375 |
|
begin |
377 |
|
Result := TFB30Blob.Create(self,transaction as TFB30transaction,BlobMetaData,BlobID,BPB); |
378 |
|
end; |
379 |
|
|
380 |
< |
function TFB30Attachment.OpenArray(transaction: ITransaction; RelationName, |
381 |
< |
ColumnName: AnsiString; ArrayID: TISC_QUAD): IArray; |
337 |
< |
begin |
338 |
< |
CheckHandle; |
339 |
< |
Result := TFB30Array.Create(self,transaction as TFB30Transaction, |
340 |
< |
GetArrayMetaData(transaction,RelationName,ColumnName),ArrayID); |
341 |
< |
end; |
342 |
< |
|
343 |
< |
function TFB30Attachment.CreateArray(transaction: ITransaction; RelationName, |
344 |
< |
ColumnName: AnsiString): IArray; |
380 |
> |
function TFB30Attachment.OpenArray(transaction: ITransaction; |
381 |
> |
ArrayMetaData: IArrayMetaData; ArrayID: TISC_QUAD): IArray; |
382 |
|
begin |
383 |
|
CheckHandle; |
384 |
|
Result := TFB30Array.Create(self,transaction as TFB30Transaction, |
385 |
< |
GetArrayMetaData(transaction,RelationName,ColumnName)); |
385 |
> |
ArrayMetaData,ArrayID); |
386 |
|
end; |
387 |
|
|
388 |
|
function TFB30Attachment.CreateArray(transaction: ITransaction; |
413 |
|
Result := TFB30ArrayMetaData.Create(self,Transaction as TFB30Transaction,tableName,columnName); |
414 |
|
end; |
415 |
|
|
416 |
+ |
procedure TFB30Attachment.getFBVersion(version: TStrings); |
417 |
+ |
var bufferObj: TVersionCallback; |
418 |
+ |
begin |
419 |
+ |
version.Clear; |
420 |
+ |
bufferObj := TVersionCallback.Create(Firebird30ClientAPI,version); |
421 |
+ |
try |
422 |
+ |
with FFirebird30ClientAPI do |
423 |
+ |
begin |
424 |
+ |
UtilIntf.getFbVersion(StatusIntf,FAttachmentIntf,bufferObj); |
425 |
+ |
Check4DataBaseError; |
426 |
+ |
end; |
427 |
+ |
finally |
428 |
+ |
bufferObj.Free; |
429 |
+ |
end; |
430 |
+ |
end; |
431 |
+ |
|
432 |
+ |
function TFB30Attachment.HasDecFloatSupport: boolean; |
433 |
+ |
begin |
434 |
+ |
Result := (FFirebird30ClientAPI.GetClientMajor >= 4) and |
435 |
+ |
(GetODSMajorVersion >= 13); |
436 |
+ |
end; |
437 |
+ |
|
438 |
+ |
function TFB30Attachment.HasBatchMode: boolean; |
439 |
+ |
begin |
440 |
+ |
Result := FFirebird30ClientAPI.Firebird4orLater and |
441 |
+ |
(GetODSMajorVersion >= 13); |
442 |
+ |
end; |
443 |
+ |
|
444 |
+ |
function TFB30Attachment.GetTimeZoneServices: ITimeZoneServices; |
445 |
+ |
begin |
446 |
+ |
if not HasTimeZoneSupport then |
447 |
+ |
IBError(ibxeNotSupported,[]); |
448 |
+ |
|
449 |
+ |
if FTimeZoneServices = nil then |
450 |
+ |
FTimeZoneServices := TFB30TimeZoneServices.Create(self); |
451 |
+ |
Result := FTimeZoneServices; |
452 |
+ |
end; |
453 |
+ |
|
454 |
+ |
function TFB30Attachment.HasTimeZoneSupport: boolean; |
455 |
+ |
begin |
456 |
+ |
Result := (FFirebird30ClientAPI.GetClientMajor >= 4) and |
457 |
+ |
(GetODSMajorVersion >= 13); |
458 |
+ |
end; |
459 |
+ |
|
460 |
|
end. |
461 |
|
|