ViewVC Help
View File | Revision Log | Show Annotations | Download File | View Changeset | Root Listing
root/public/ibx/branches/journaling/fbintf/client/3.0/FB30Attachment.pas
(Generate patch)

Comparing ibx/trunk/fbintf/client/3.0/FB30Attachment.pas (file contents):
Revision 267 by tony, Fri Dec 28 10:44:23 2018 UTC vs.
Revision 345 by tony, Mon Aug 23 14:22:29 2021 UTC

# Line 37 | Line 37 | unit FB30Attachment;
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  
# Line 47 | Line 48 | type
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
# Line 72 | Line 76 | type
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 }
# Line 111 | Line 119 | type
119    TVersionCallback = class(Firebird.IVersionCallbackImpl)
120    private
121      FOutput: TStrings;
122 +    FFirebirdClientAPI: TFBClientAPI;
123    public
124 <    constructor Create(output: TStrings);
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(output: TStrings);
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
# Line 237 | Line 270 | begin
270        FAttachmentIntf := nil
271      else
272        GetODSAndConnectionInfo;
273 +
274    end;
275   end;
276  
# Line 253 | Line 287 | begin
287        FHasDefaultCharSet := false;
288        FCodePage := CP_NONE;
289        FCharSetID := 0;
290 +      FTimeZoneServices := nil;
291      end;
292   end;
293  
# Line 307 | Line 342 | begin
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;
# Line 320 | Line 356 | begin
356    Result := TFB30Events.Create(self,Events);
357   end;
358  
323 – function TFB30Attachment.CreateBlob(transaction: ITransaction; RelationName,
324 –  ColumnName: AnsiString; BPB: IBPB): IBlob;
325 – begin
326 –  CheckHandle;
327 –  Result := TFB30Blob.Create(self,transaction as TFB30Transaction,
328 –              TFB30BlobMetaData.Create(self,Transaction as TFB30Transaction,RelationName,ColumnName),BPB);
329 – end;
330 –
359   function TFB30Attachment.CreateBlob(transaction: ITransaction;
360    BlobMetaData: IBlobMetaData; BPB: IBPB): IBlob;
361   begin
# Line 342 | Line 370 | begin
370    Result := TFB30Blob.Create(self,transaction as TFB30Transaction, SubType,aCharSetID,BPB);
371   end;
372  
345 – function TFB30Attachment.OpenBlob(transaction: ITransaction; RelationName,
346 –  ColumnName: AnsiString; BlobID: TISC_QUAD; BPB: IBPB): IBlob;
347 – begin
348 –  CheckHandle;
349 –  Result := TFB30Blob.Create(self,transaction as TFB30transaction,
350 –                TFB30BlobMetaData.Create(self,Transaction as TFB30Transaction,RelationName,ColumnName),
351 –                BlobID,BPB);
352 – end;
353 –
373   function TFB30Attachment.OpenBlob(transaction: ITransaction;
374    BlobMetaData: IBlobMetaData; BlobID: TISC_QUAD; BPB: IBPB): IBlob;
375   begin
# Line 358 | Line 377 | 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;
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),ArrayID);
367 < end;
368 <
369 < function TFB30Attachment.CreateArray(transaction: ITransaction; RelationName,
370 <  ColumnName: AnsiString): IArray;
371 < begin
372 <  CheckHandle;
373 <  Result := TFB30Array.Create(self,transaction as TFB30Transaction,
374 <                    GetArrayMetaData(transaction,RelationName,ColumnName));
385 >                    ArrayMetaData,ArrayID);
386   end;
387  
388   function TFB30Attachment.CreateArray(transaction: ITransaction;
# Line 406 | Line 417 | procedure TFB30Attachment.getFBVersion(v
417   var bufferObj: TVersionCallback;
418   begin
419    version.Clear;
420 <  bufferObj := TVersionCallback.Create(version);
420 >  bufferObj := TVersionCallback.Create(Firebird30ClientAPI,version);
421    try
422      with FFirebird30ClientAPI do
423      begin
# Line 418 | Line 429 | begin
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  

Diff Legend

– Removed lines
+ Added lines
< Changed lines
> Changed lines