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 263 by tony, Thu Dec 6 15:55:01 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 }
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
# Line 211 | Line 270 | begin
270        FAttachmentIntf := nil
271      else
272        GetODSAndConnectionInfo;
273 +
274    end;
275   end;
276  
# Line 227 | Line 287 | begin
287        FHasDefaultCharSet := false;
288        FCodePage := CP_NONE;
289        FCharSetID := 0;
290 +      FTimeZoneServices := nil;
291      end;
292   end;
293  
# Line 281 | 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 294 | Line 356 | begin
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
# Line 316 | Line 370 | 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
# Line 332 | 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;
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;
# Line 376 | Line 413 | begin
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  

Diff Legend

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