client/2.5/FB25Services.pas

(*
 *  Firebird Interface (fbintf). The fbintf components provide a set of
 *  Pascal language bindings for the Firebird API. Although predominantly
 *  a new development they include source code taken from IBX and may be
 *  considered a derived product. This software thus also includes the copyright
 *  notice and license conditions from IBX.
 *
 *  Except for those parts dervied from IBX, 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): ______________________________________.
 *
*)
{************************************************************************}
{                                                                        }
{       Borland Delphi Visual Component Library                          }
{       InterBase Express core components                                }
{                                                                        }
{       Copyright (c) 1998-2000 Inprise Corporation                      }
{                                                                        }
{    InterBase Express is based in part on the product                   }
{    Free IB Components, written by Gregory H. Deatz for                 }
{    Hoagland, Longo, Moran, Dunst & Doukas Company.                     }
{    Free IB Components is used under license.                           }
{                                                                        }
{    The contents of this file are subject to the InterBase              }
{    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 at http://www.Inprise.com/IPL.html }
{    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 Original Code was created by InterBase Software Corporation     }
{       and its successors.                                              }
{    Portions created by Inprise Corporation are Copyright (C) Inprise   }
{       Corporation. All Rights Reserved.                                }
{    Contributor(s): Jeff Overcash                                       }
{                                                                        }
{    IBX For Lazarus (Firebird Express)                                  }
{    Contributor: Tony Whyman, MWA Software http://www.mwasoftware.co.uk }
{    Portions created by MWA Software are copyright McCallum Whyman      }
{    Associates Ltd 2011 - 2015                                                }
{                                                                        }
{************************************************************************}
unit FB25Services;
{$IFDEF MSWINDOWS} 
{$DEFINE WINDOWS} 
{$ENDIF}

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

interface

uses
  Classes, SysUtils, IB, FB25ClientAPI, IBHeader, FBParamBlock, FBOutputBlock,
    FBServices;

type
  { TFBServiceManager }

  { TFB25ServiceManager }

  TFB25ServiceManager = class(TFBServiceManager,IServiceManager)
  private
    FHandle: TISC_SVC_HANDLE;
    FFirebird25ClientAPI: TFB25ClientAPI;
    procedure CheckActive;
    procedure CheckInactive;
  protected
    procedure InternalAttach(ConnectString: AnsiString); override;
  public
    constructor Create(api: TFB25ClientAPI; ServerName: AnsiString; Protocol: TProtocol; SPB: ISPB; Port: AnsiString = '');
    property Handle: TISC_SVC_HANDLE read FHandle;

  public
    {IServiceManager}
    procedure Detach(Force: boolean=false); override;
    function IsAttached: boolean;
    function Start(Request: ISRB; RaiseExceptionOnError: boolean=true): boolean;
    function Query(SQPB: ISQPB; Request: ISRB; RaiseExceptionOnError: boolean=true): IServiceQueryResults; override;
  end;

implementation

uses FBMessages;

{ TFBServiceManager }

procedure TFB25ServiceManager.CheckActive;
begin
  if FHandle = nil then
    IBError(ibxeServiceActive, [nil]);
end;

procedure TFB25ServiceManager.CheckInactive;
begin
  if FHandle <> nil then
    IBError(ibxeServiceInActive, [nil]);
end;

procedure TFB25ServiceManager.InternalAttach(ConnectString: AnsiString);
begin
  with FFirebird25ClientAPI do
  if FSPB = nil then
  begin
    if isc_service_attach(StatusVector, Length(ConnectString),
                         PAnsiChar(ConnectString), @FHandle, 0, nil) > 0 then
      IBDataBaseError;
  end
  else
  begin
    if isc_service_attach(StatusVector, Length(ConnectString),
                           PAnsiChar(ConnectString), @FHandle,
                           (FSPB as TSPB).getDataLength,
                           (FSPB as TSPB).getBuffer) > 0 then
      IBDataBaseError;
  end;
end;

constructor TFB25ServiceManager.Create(api: TFB25ClientAPI;
  ServerName: AnsiString; Protocol: TProtocol; SPB: ISPB; Port: AnsiString);
begin
  FFirebird25ClientAPI := api;
  inherited Create(api,ServerName, Protocol, SPB, Port);
end;

procedure TFB25ServiceManager.Detach(Force: boolean);
begin
  if FHandle = nil then
    Exit;
  with FFirebird25ClientAPI do
  if isc_service_detach(StatusVector, @FHandle) > 0 then
  begin
    FHandle := nil;
    if not Force then
     IBDataBaseError;
  end
  else
    FHandle := nil;
end;

function TFB25ServiceManager.IsAttached: boolean;
begin
  Result := FHandle <> nil;
end;

function TFB25ServiceManager.Start(Request: ISRB; RaiseExceptionOnError: boolean
  ): boolean;
begin
  Result := true;
  CheckActive;
  with FFirebird25ClientAPI do
  begin
    Result := isc_service_start(StatusVector, @FHandle, nil,
                           (Request as TSRB).getDataLength,
                           (Request as TSRB).getBuffer) = 0;
    if not Result and RaiseExceptionOnError then
      IBDataBaseError;
  end;
end;

function TFB25ServiceManager.Query(SQPB: ISQPB; Request: ISRB;
  RaiseExceptionOnError: boolean): IServiceQueryResults;
var QueryResults: TServiceQueryResults;
begin
  CheckActive;
  QueryResults := TServiceQueryResults.Create(FFirebird25ClientAPI);
  Result := QueryResults;
  with FFirebird25ClientAPI do
    if SQPB = nil then
    begin
      if isc_service_query(StatusVector, @FHandle, nil,0,nil,
                         (Request as TSRB).getDataLength,
                         (Request as TSRB).getBuffer,
                         QueryResults.getBufSize,
                         QueryResults.Buffer) > 0 then
      begin
        if RaiseExceptionOnError then
          IBDataBaseError
        else
          Result := nil;
      end;
    end
    else
    if isc_service_query(StatusVector, @FHandle, nil,
                       (SQPB as TSQPB).getDataLength,
                       (SQPB as TSQPB).getBuffer,
                       (Request as TSRB).getDataLength,
                       (Request as TSRB).getBuffer,
                       QueryResults.getBufSize,
                       QueryResults.Buffer) > 0 then
    begin
      if RaiseExceptionOnError then
        IBDataBaseError
      else
        Result := nil;
    end;
end;

end.

Revision:	263
Committed:	Thu Dec 6 15:55:01 2018 UTC (5 years, 4 months ago) by tony
Content type:	text/x-pascal
File size:	7895 byte(s)
Log Message:	Release 2.3.2 committed
#	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. Although predominantly
4			* a new development they include source code taken from IBX and may be
5			* considered a derived product. This software thus also includes the copyright
6			* notice and license conditions from IBX.
7			*
8			* Except for those parts dervied from IBX, contents of this file are subject
9			* to the Initial Developer's Public License Version 1.0 (the "License"); you
10			* may not use this file except in compliance with the License. You may obtain a
11			* copy of the License here:
12			*
13			* http://www.firebirdsql.org/index.php?op=doc&id=idpl
14			*
15			* Software distributed under the License is distributed on an "AS
16			* IS" basis, WITHOUT WARRANTY OF ANY KIND, either express or
17			* implied. See the License for the specific language governing rights
18			* and limitations under the License.
19			*
20			* The Initial Developer of the Original Code is Tony Whyman.
21			*
22			* The Original Code is (C) 2016 Tony Whyman, MWA Software
23			* (http://www.mwasoftware.co.uk).
24			*
25			* All Rights Reserved.
26			*
27			* Contributor(s): ______________________________________.
28			*
29			*)
30			{************************************************************************}
31			{ }
32			{ Borland Delphi Visual Component Library }
33			{ InterBase Express core components }
34			{ }
35			{ Copyright (c) 1998-2000 Inprise Corporation }
36			{ }
37			{ InterBase Express is based in part on the product }
38			{ Free IB Components, written by Gregory H. Deatz for }
39			{ Hoagland, Longo, Moran, Dunst & Doukas Company. }
40			{ Free IB Components is used under license. }
41			{ }
42			{ The contents of this file are subject to the InterBase }
43			{ Public License Version 1.0 (the "License"); you may not }
44			{ use this file except in compliance with the License. You }
45			{ may obtain a copy of the License at http://www.Inprise.com/IPL.html }
46			{ Software distributed under the License is distributed on }
47			{ an "AS IS" basis, WITHOUT WARRANTY OF ANY KIND, either }
48			{ express or implied. See the License for the specific language }
49			{ governing rights and limitations under the License. }
50			{ The Original Code was created by InterBase Software Corporation }
51			{ and its successors. }
52			{ Portions created by Inprise Corporation are Copyright (C) Inprise }
53			{ Corporation. All Rights Reserved. }
54			{ Contributor(s): Jeff Overcash }
55			{ }
56			{ IBX For Lazarus (Firebird Express) }
57			{ Contributor: Tony Whyman, MWA Software http://www.mwasoftware.co.uk }
58			{ Portions created by MWA Software are copyright McCallum Whyman }
59			{ Associates Ltd 2011 - 2015 }
60			{ }
61			{************************************************************************}
62			unit FB25Services;
63	tony	56	{$IFDEF MSWINDOWS}
64			{$DEFINE WINDOWS}
65			{$ENDIF}
66	tony	45
67			{$IFDEF FPC}
68	tony	56	{$mode delphi}
69	tony	45	{$interfaces COM}
70			{$ENDIF}
71
72			interface
73
74			uses
75			Classes, SysUtils, IB, FB25ClientAPI, IBHeader, FBParamBlock, FBOutputBlock,
76			FBServices;
77
78			type
79			{ TFBServiceManager }
80
81	tony	209	{ TFB25ServiceManager }
82
83	tony	45	TFB25ServiceManager = class(TFBServiceManager,IServiceManager)
84			private
85			FHandle: TISC_SVC_HANDLE;
86	tony	263	FFirebird25ClientAPI: TFB25ClientAPI;
87	tony	45	procedure CheckActive;
88			procedure CheckInactive;
89			protected
90	tony	56	procedure InternalAttach(ConnectString: AnsiString); override;
91	tony	45	public
92	tony	263	constructor Create(api: TFB25ClientAPI; ServerName: AnsiString; Protocol: TProtocol; SPB: ISPB; Port: AnsiString = '');
93	tony	45	property Handle: TISC_SVC_HANDLE read FHandle;
94
95			public
96			{IServiceManager}
97			procedure Detach(Force: boolean=false); override;
98			function IsAttached: boolean;
99	tony	209	function Start(Request: ISRB; RaiseExceptionOnError: boolean=true): boolean;
100			function Query(SQPB: ISQPB; Request: ISRB; RaiseExceptionOnError: boolean=true): IServiceQueryResults; override;
101	tony	45	end;
102
103			implementation
104
105			uses FBMessages;
106
107			{ TFBServiceManager }
108
109			procedure TFB25ServiceManager.CheckActive;
110			begin
111			if FHandle = nil then
112			IBError(ibxeServiceActive, [nil]);
113			end;
114
115			procedure TFB25ServiceManager.CheckInactive;
116			begin
117			if FHandle <> nil then
118			IBError(ibxeServiceInActive, [nil]);
119			end;
120
121	tony	56	procedure TFB25ServiceManager.InternalAttach(ConnectString: AnsiString);
122	tony	45	begin
123	tony	263	with FFirebird25ClientAPI do
124	tony	45	if FSPB = nil then
125			begin
126			if isc_service_attach(StatusVector, Length(ConnectString),
127	tony	56	PAnsiChar(ConnectString), @FHandle, 0, nil) > 0 then
128	tony	45	IBDataBaseError;
129			end
130			else
131			begin
132			if isc_service_attach(StatusVector, Length(ConnectString),
133	tony	56	PAnsiChar(ConnectString), @FHandle,
134	tony	45	(FSPB as TSPB).getDataLength,
135			(FSPB as TSPB).getBuffer) > 0 then
136			IBDataBaseError;
137			end;
138			end;
139
140	tony	263	constructor TFB25ServiceManager.Create(api: TFB25ClientAPI;
141			ServerName: AnsiString; Protocol: TProtocol; SPB: ISPB; Port: AnsiString);
142			begin
143			FFirebird25ClientAPI := api;
144			inherited Create(api,ServerName, Protocol, SPB, Port);
145			end;
146
147	tony	45	procedure TFB25ServiceManager.Detach(Force: boolean);
148			begin
149			if FHandle = nil then
150			Exit;
151	tony	263	with FFirebird25ClientAPI do
152	tony	45	if isc_service_detach(StatusVector, @FHandle) > 0 then
153			begin
154			FHandle := nil;
155			if not Force then
156			IBDataBaseError;
157			end
158			else
159			FHandle := nil;
160			end;
161
162			function TFB25ServiceManager.IsAttached: boolean;
163			begin
164			Result := FHandle <> nil;
165			end;
166
167	tony	209	function TFB25ServiceManager.Start(Request: ISRB; RaiseExceptionOnError: boolean
168			): boolean;
169	tony	45	begin
170	tony	209	Result := true;
171	tony	45	CheckActive;
172	tony	263	with FFirebird25ClientAPI do
173	tony	209	begin
174			Result := isc_service_start(StatusVector, @FHandle, nil,
175	tony	45	(Request as TSRB).getDataLength,
176	tony	209	(Request as TSRB).getBuffer) = 0;
177			if not Result and RaiseExceptionOnError then
178			IBDataBaseError;
179			end;
180	tony	45	end;
181
182	tony	209	function TFB25ServiceManager.Query(SQPB: ISQPB; Request: ISRB;
183			RaiseExceptionOnError: boolean): IServiceQueryResults;
184	tony	45	var QueryResults: TServiceQueryResults;
185			begin
186			CheckActive;
187	tony	263	QueryResults := TServiceQueryResults.Create(FFirebird25ClientAPI);
188	tony	45	Result := QueryResults;
189	tony	263	with FFirebird25ClientAPI do
190	tony	45	if SQPB = nil then
191			begin
192			if isc_service_query(StatusVector, @FHandle, nil,0,nil,
193			(Request as TSRB).getDataLength,
194			(Request as TSRB).getBuffer,
195			QueryResults.getBufSize,
196			QueryResults.Buffer) > 0 then
197	tony	209	begin
198			if RaiseExceptionOnError then
199			IBDataBaseError
200			else
201			Result := nil;
202			end;
203	tony	45	end
204			else
205			if isc_service_query(StatusVector, @FHandle, nil,
206			(SQPB as TSQPB).getDataLength,
207			(SQPB as TSQPB).getBuffer,
208			(Request as TSRB).getDataLength,
209			(Request as TSRB).getBuffer,
210			QueryResults.getBufSize,
211			QueryResults.Buffer) > 0 then
212	tony	209	begin
213			if RaiseExceptionOnError then
214			IBDataBaseError
215			else
216			Result := nil;
217			end;
218	tony	45	end;
219
220			end.
221