client/3.0/FB30Transaction.pas

(*
 *  Firebird Interface (fbintf). The fbintf components provide a set of
 *  Pascal language bindings for the Firebird API.
 *
 *  The contents of this file are subject to the Initial Developer's
 *  Public License Version 1.0 (the "License"); you may not use this
 *  file except in compliance with the License. You may obtain a copy
 *  of the License here:
 *
 *    http://www.firebirdsql.org/index.php?op=doc&id=idpl
 *
 *  Software distributed under the License is distributed on an "AS
 *  IS" basis, WITHOUT WARRANTY OF ANY KIND, either express or
 *  implied. See the License for the specific language governing rights
 *  and limitations under the License.
 *
 *  The Initial Developer of the Original Code is Tony Whyman.
 *
 *  The Original Code is (C) 2016 Tony Whyman, MWA Software
 *  (http://www.mwasoftware.co.uk).
 *
 *  All Rights Reserved.
 *
 *  Contributor(s): ______________________________________.
 *
*)
unit FB30Transaction;
{$IFDEF MSWINDOWS} 
{$DEFINE WINDOWS} 
{$ENDIF}

{$IFDEF FPC}
{$mode delphi}
{$interfaces COM}
{$ENDIF}

interface

uses
  Classes, SysUtils, Firebird, IB, FBClientAPI, FB30ClientAPI,
  FB30Attachment, FBParamBlock, FBActivityMonitor, FBTransaction;

type

  { TFB30Transaction }

  TFB30Transaction = class(TFBTransaction,ITransaction, IActivityMonitor)
  private
    FTransactionIntf: Firebird.ITransaction;
    FFirebird30ClientAPI: TFB30ClientAPI;
    procedure FreeHandle(Force: boolean);
  protected
    function GetActivityIntf(att: IAttachment): IActivityMonitor; override;
    procedure SetInterface(api: TFBClientAPI); override;
    function GetTrInfo(ReqBuffer: PByte; ReqBufLen: integer): ITrInformation; override;
    procedure InternalStartSingle(attachment: IAttachment); override;
    procedure InternalStartMultiple; override;
    procedure InternalCommit(Force: boolean); override;
    procedure InternalCommitRetaining; override;
    procedure InternalRollback(Force: boolean); override;
    procedure InternalRollbackRetaining; override;
  public
    destructor Destroy; override;
    property TransactionIntf: Firebird.ITransaction read FTransactionIntf;
    {ITransaction}
    function GetInTransaction: boolean; override;
    procedure PrepareForCommit; override;
  end;


implementation

uses FBMessages;

{ TFB30Transaction }

procedure TFB30Transaction.FreeHandle(Force: boolean);
begin
  if assigned(FTransactionIntf) then
  try
    FTransactionIntf.release;
  except
    if not Force then raise;
    {else ignore if Force = true}
  end;
  FTransactionIntf := nil;
end;

function TFB30Transaction.GetActivityIntf(att: IAttachment): IActivityMonitor;
begin
  att.QueryInterface(IActivityMonitor,Result);
end;

procedure TFB30Transaction.SetInterface(api: TFBClientAPI);
begin
  inherited SetInterface(api);
  FFirebird30ClientAPI := api as TFB30ClientAPI;
end;

function TFB30Transaction.GetTrInfo(ReqBuffer: PByte; ReqBufLen: integer
  ): ITrInformation;
begin
  Result := TTrInformation.Create(FFirebird30ClientAPI);
  with FFirebird30ClientAPI, Result as TTrInformation do
  begin
    FTransactionIntf.getInfo(StatusIntf, ReqBufLen, BytePtr(ReqBuffer),
                               getBufSize, BytePtr(Buffer));
    Check4DataBaseError;
  end
end;

procedure TFB30Transaction.InternalStartSingle(attachment: IAttachment);
begin
  with FFirebird30ClientAPI do
  begin
    FTransactionIntf  := (attachment as TFB30Attachment).AttachmentIntf.startTransaction(StatusIntf,
             (FTPB as TTPB).getDataLength,BytePtr((FTPB as TTPB).getBuffer));
    Check4DataBaseError;
  end;
  SignalActivity;
end;

procedure TFB30Transaction.InternalStartMultiple;
var Dtc: IDtc;
    DtcStart: IDtcStart;
    i: integer;
begin
  with FFirebird30ClientAPI do
  begin
    Dtc := MasterIntf.getDtc;
    DtcStart := Dtc.startBuilder(StatusIntf);
    Check4DataBaseError;

    for i := 0 to Length(FAttachments) - 1 do
    if (FAttachments[i] <> nil)  then
    begin
      DTCStart.addWithTpb(StatusIntf,
                          (FAttachments[i] as TFB30Attachment).AttachmentIntf,
                          (FTPB as TTPB).getDataLength,
                          BytePtr((FTPB as TTPB).getBuffer));
      Check4DataBaseError;
    end;

    FTransactionIntf := DtcStart.start(StatusIntf);
    Check4DataBaseError;
    SignalActivity;
  end;
end;

procedure TFB30Transaction.InternalCommit(Force: boolean);
begin
  with FFirebird30ClientAPI do
  begin
    FTransactionIntf.commit(StatusIntf);
    if not Force and InErrorState then
       IBDataBaseError;
  end;
  SignalActivity;
  FreeHandle(Force);
end;

procedure TFB30Transaction.InternalCommitRetaining;
begin
  with FFirebird30ClientAPI do
  begin
    FTransactionIntf.commitRetaining(StatusIntf);
    Check4DataBaseError;
  end;
  SignalActivity;
end;

procedure TFB30Transaction.InternalRollback(Force: boolean);
begin
  with FFirebird30ClientAPI do
  begin
    FTransactionIntf.rollback(StatusIntf);
    if not Force and InErrorState then
       IBDataBaseError;
  end;
  SignalActivity;
  FreeHandle(Force);
end;

procedure TFB30Transaction.InternalRollbackRetaining;
begin
  with FFirebird30ClientAPI do
  begin
    FTransactionIntf.rollbackRetaining(StatusIntf);
    Check4DataBaseError;
  end;
  SignalActivity;
end;

destructor TFB30Transaction.Destroy;
begin
  inherited Destroy;
  FreeHandle(true);
end;

function TFB30Transaction.GetInTransaction: boolean;
begin
  Result := FTransactionIntf <> nil;
end;

procedure TFB30Transaction.PrepareForCommit;
begin
  if Length(FAttachments) < 2 then
    IBError(ibxeNotAMultiDatabaseTransaction,[nil]);
  if FTransactionIntf = nil then
    Exit;
  with FFirebird30ClientAPI do
  begin
    FTransactionIntf.prepare(StatusIntf,0,nil);
    Check4DataBaseError;
  end;
  SignalActivity;
end;


end.

Revision:	363
Committed:	Tue Dec 7 13:30:05 2021 UTC (2 years, 4 months ago) by tony
Content type:	text/x-pascal
File size:	5772 byte(s)
Log Message:	add fbintf
#	User	Rev	Content
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 FB30Transaction;
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			uses
40			Classes, SysUtils, Firebird, IB, FBClientAPI, FB30ClientAPI,
41			FB30Attachment, FBParamBlock, FBActivityMonitor, FBTransaction;
42
43			type
44
45			{ TFB30Transaction }
46
47			TFB30Transaction = class(TFBTransaction,ITransaction, IActivityMonitor)
48			private
49			FTransactionIntf: Firebird.ITransaction;
50	tony	263	FFirebird30ClientAPI: TFB30ClientAPI;
51	tony	359	procedure FreeHandle(Force: boolean);
52	tony	45	protected
53			function GetActivityIntf(att: IAttachment): IActivityMonitor; override;
54	tony	263	procedure SetInterface(api: TFBClientAPI); override;
55	tony	359	function GetTrInfo(ReqBuffer: PByte; ReqBufLen: integer): ITrInformation; override;
56	tony	363	procedure InternalStartSingle(attachment: IAttachment); override;
57			procedure InternalStartMultiple; override;
58			procedure InternalCommit(Force: boolean); override;
59			procedure InternalCommitRetaining; override;
60			procedure InternalRollback(Force: boolean); override;
61			procedure InternalRollbackRetaining; override;
62	tony	45	public
63			destructor Destroy; override;
64			property TransactionIntf: Firebird.ITransaction read FTransactionIntf;
65			{ITransaction}
66			function GetInTransaction: boolean; override;
67			procedure PrepareForCommit; override;
68			end;
69
70
71			implementation
72
73			uses FBMessages;
74
75			{ TFB30Transaction }
76
77	tony	359	procedure TFB30Transaction.FreeHandle(Force: boolean);
78	tony	45	begin
79			if assigned(FTransactionIntf) then
80	tony	359	try
81	tony	45	FTransactionIntf.release;
82	tony	359	except
83			if not Force then raise;
84			{else ignore if Force = true}
85			end;
86	tony	45	FTransactionIntf := nil;
87			end;
88
89			function TFB30Transaction.GetActivityIntf(att: IAttachment): IActivityMonitor;
90			begin
91	tony	315	att.QueryInterface(IActivityMonitor,Result);
92	tony	45	end;
93
94	tony	263	procedure TFB30Transaction.SetInterface(api: TFBClientAPI);
95			begin
96			inherited SetInterface(api);
97			FFirebird30ClientAPI := api as TFB30ClientAPI;
98			end;
99
100	tony	359	function TFB30Transaction.GetTrInfo(ReqBuffer: PByte; ReqBufLen: integer
101			): ITrInformation;
102			begin
103			Result := TTrInformation.Create(FFirebird30ClientAPI);
104			with FFirebird30ClientAPI, Result as TTrInformation do
105			begin
106			FTransactionIntf.getInfo(StatusIntf, ReqBufLen, BytePtr(ReqBuffer),
107			getBufSize, BytePtr(Buffer));
108			Check4DataBaseError;
109			end
110			end;
111
112	tony	363	procedure TFB30Transaction.InternalStartSingle(attachment: IAttachment);
113	tony	45	begin
114	tony	363	with FFirebird30ClientAPI do
115			begin
116			FTransactionIntf := (attachment as TFB30Attachment).AttachmentIntf.startTransaction(StatusIntf,
117			(FTPB as TTPB).getDataLength,BytePtr((FTPB as TTPB).getBuffer));
118			Check4DataBaseError;
119			end;
120			SignalActivity;
121	tony	45	end;
122
123	tony	363	procedure TFB30Transaction.InternalStartMultiple;
124			var Dtc: IDtc;
125			DtcStart: IDtcStart;
126			i: integer;
127	tony	45	begin
128	tony	263	with FFirebird30ClientAPI do
129	tony	45	begin
130	tony	363	Dtc := MasterIntf.getDtc;
131			DtcStart := Dtc.startBuilder(StatusIntf);
132	tony	45	Check4DataBaseError;
133	tony	363
134			for i := 0 to Length(FAttachments) - 1 do
135			if (FAttachments[i] <> nil) then
136			begin
137			DTCStart.addWithTpb(StatusIntf,
138			(FAttachments[i] as TFB30Attachment).AttachmentIntf,
139			(FTPB as TTPB).getDataLength,
140			BytePtr((FTPB as TTPB).getBuffer));
141			Check4DataBaseError;
142			end;
143
144			FTransactionIntf := DtcStart.start(StatusIntf);
145			Check4DataBaseError;
146			SignalActivity;
147	tony	45	end;
148			end;
149
150	tony	363	procedure TFB30Transaction.InternalCommit(Force: boolean);
151	tony	45	begin
152	tony	263	with FFirebird30ClientAPI do
153	tony	45	begin
154			FTransactionIntf.commit(StatusIntf);
155			if not Force and InErrorState then
156			IBDataBaseError;
157			end;
158			SignalActivity;
159	tony	359	FreeHandle(Force);
160	tony	45	end;
161
162	tony	363	procedure TFB30Transaction.InternalCommitRetaining;
163	tony	45	begin
164	tony	263	with FFirebird30ClientAPI do
165	tony	45	begin
166			FTransactionIntf.commitRetaining(StatusIntf);
167			Check4DataBaseError;
168			end;
169			SignalActivity;
170			end;
171
172	tony	363	procedure TFB30Transaction.InternalRollback(Force: boolean);
173	tony	45	begin
174	tony	263	with FFirebird30ClientAPI do
175	tony	45	begin
176			FTransactionIntf.rollback(StatusIntf);
177			if not Force and InErrorState then
178			IBDataBaseError;
179			end;
180			SignalActivity;
181	tony	359	FreeHandle(Force);
182	tony	45	end;
183
184	tony	363	procedure TFB30Transaction.InternalRollbackRetaining;
185	tony	45	begin
186	tony	363	with FFirebird30ClientAPI do
187			begin
188			FTransactionIntf.rollbackRetaining(StatusIntf);
189			Check4DataBaseError;
190			end;
191			SignalActivity;
192			end;
193
194			destructor TFB30Transaction.Destroy;
195			begin
196			inherited Destroy;
197			FreeHandle(true);
198			end;
199
200			function TFB30Transaction.GetInTransaction: boolean;
201			begin
202			Result := FTransactionIntf <> nil;
203			end;
204
205			procedure TFB30Transaction.PrepareForCommit;
206			begin
207			if Length(FAttachments) < 2 then
208			IBError(ibxeNotAMultiDatabaseTransaction,[nil]);
209	tony	45	if FTransactionIntf = nil then
210			Exit;
211	tony	263	with FFirebird30ClientAPI do
212	tony	45	begin
213	tony	363	FTransactionIntf.prepare(StatusIntf,0,nil);
214	tony	45	Check4DataBaseError;
215			end;
216			SignalActivity;
217			end;
218
219
220			end.
221