udr/testsuite/FBTestApp.pas

(*
 *  Firebird Interface (fbintf) Test suite. This program is used to
 *  test the Firebird Pascal Interface and provide a semi-automated
 *  pass/fail check for each test.
 *
 *  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-2020 Tony Whyman, MWA Software
 *  (http://www.mwasoftware.co.uk).
 *
 *  All Rights Reserved.
 *
 *  Contributor(s): ______________________________________.
 *
*)
unit FBTestApp;

{$IFDEF MSWINDOWS}
{$DEFINE WINDOWS}
{$ENDIF}

{$IFDEF FPC}
{$mode delphi}
{$codepage utf8}
{$ENDIF}

interface

uses
  Classes, SysUtils, TestApplication, IB;

type

  { TFBTestBase }

  TFBTestBase = class(TTestBase)
  protected
    function GetTestID: AnsiString; override;
    function GetTestTitle: AnsiString; override;
    function WriteServiceQueryResult(QueryResult: IServiceQueryResults): boolean;
    procedure writeLicence(Item: IServiceQueryResultItem);
    procedure WriteConfig(config: IServiceQueryResultItem);
    procedure WriteUsers(users: IServiceQueryResultItem);
    procedure WriteDBAttachments(att: IServiceQueryResultItem);
    procedure WriteLimboTransactions(limbo: IServiceQueryResultItem);
  end;

implementation

function TFBTestBase.GetTestID: AnsiString;
var s: AnsiString;
    i,j: integer;
begin
  i := 1;
  s := TestTitle;
  while not (s[i] in ['0'..'9']) and (i <= Length(s)) do inc(i);
  j := i + 1;
  while (s[j] in ['0'..'9']) and (i <= Length(s)) do inc(j);
  Result := system.copy(s,i,j-i);
  if Length(Result) = 1 then
    Result := '0' + Result;
end;

function TFBTestBase.GetTestTitle: AnsiString;
begin
  Result := '';
end;

function TFBTestBase.WriteServiceQueryResult(QueryResult: IServiceQueryResults): boolean;
var i: integer;
    line: AnsiString;
begin
  Result := true;
  for i := 0 to QueryResult.GetCount - 1 do
  with QueryResult[i] do
  case getItemType of
  isc_info_svc_version:
    writeln(OutFile,'Service Manager Version = ',getAsInteger);
  isc_info_svc_server_version:
    writeln(OutFile,'Server Version = ',getAsString);
  isc_info_svc_implementation:
    writeln(OutFile,'Implementation = ',getAsString);
  isc_info_svc_get_license:
    writeLicence(QueryResult[i]);
  isc_info_svc_get_license_mask:
    writeln(OutFile,'Licence Mask = ',getAsInteger);
  isc_info_svc_capabilities:
    writeln(OutFile,'Capabilities = ',getAsInteger);
  isc_info_svc_get_config:
    WriteConfig(QueryResult[i]);
  isc_info_svc_get_env:
    writeln(OutFile,'Root Directory = ',getAsString);
  isc_info_svc_get_env_lock:
    writeln(OutFile,'Lock Directory = ',getAsString);
  isc_info_svc_get_env_msg:
    writeln(OutFile,'Message File = ',getAsString);
  isc_info_svc_user_dbpath:
    writeln(OutFile,'Security File = ',getAsString);
  isc_info_svc_get_licensed_users:
    writeln(OutFile,'Max Licenced Users = ',getAsInteger);
  isc_info_svc_get_users:
    WriteUsers(QueryResult[i]);
  isc_info_svc_svr_db_info:
    WriteDBAttachments(QueryResult[i]);
  isc_info_svc_line:
    begin
      line := getAsString;
      writeln(OutFile,line);
      Result := line <> '';
    end;
  isc_info_svc_running:
    writeln(OutFile,'Is Running = ',getAsInteger);
  isc_info_svc_limbo_trans:
    WriteLimboTransactions(QueryResult[i]);
  isc_info_svc_to_eof,
  isc_info_svc_timeout,
  isc_info_truncated,
  isc_info_data_not_ready,
  isc_info_svc_stdin:
    {ignore};
  else
    writeln(OutFile,'Unknown Service Response Item ', getItemType);
  end;
  writeln(OutFile);
end;

procedure TFBTestBase.writeLicence(Item: IServiceQueryResultItem);
var i: integer;
begin
  for i := 0 to Item.getCount - 1 do
  with Item[i] do
  case getItemType of
    isc_spb_lic_id:
      writeln(OutFile,'Licence ID = ',GetAsString);
    isc_spb_lic_key:
      writeln(OutFile,'Licence Key = ',GetAsString);
  end;
end;

procedure TFBTestBase.WriteConfig(config: IServiceQueryResultItem);
var i: integer;
begin
  writeln(OutFile,'Firebird Configuration File');
  for i := 0 to config.getCount - 1 do
    writeln(OutFile,'Key = ',config[i].getItemType,', Value = ',config[i].getAsInteger);
  writeln(OutFile);
end;

procedure TFBTestBase.WriteUsers(users: IServiceQueryResultItem);
var i: integer;
begin
  writeln(OutFile,'Sec. Database User');
  for i := 0 to users.getCount - 1 do
  with users[i] do
  case getItemType of
    isc_spb_sec_username:
      writeln(OutFile,'User Name = ',getAsString);
    isc_spb_sec_firstname:
      writeln(OutFile,'First Name = ',getAsString);
    isc_spb_sec_middlename:
      writeln(OutFile,'Middle Name = ',getAsString);
    isc_spb_sec_lastname:
      writeln(OutFile,'Last Name = ',getAsString);
    isc_spb_sec_userid:
      writeln(OutFile,'User ID = ',getAsInteger);
    isc_spb_sec_groupid:
      writeln(OutFile,'Group ID = ',getAsInteger);
    else
      writeln(OutFile,'Unknown user info ', getItemType);
  end;
  writeln(OutFile);
end;

procedure TFBTestBase.WriteDBAttachments(att: IServiceQueryResultItem);
var i: integer;
begin
  writeln(OutFile,'DB Attachments');
  for i := 0 to att.getCount - 1 do
  with att[i] do
  case getItemType of
  isc_spb_num_att:
    writeln(OutFile,'No. of Attachments = ',getAsInteger);
  isc_spb_num_db:
    writeln(OutFile,'Databases In Use = ',getAsInteger);
  isc_spb_dbname:
    writeln(OutFile,'DB Name = ',getAsString);
  end;
end;

procedure TFBTestBase.WriteLimboTransactions(limbo: IServiceQueryResultItem);
var i: integer;
begin
  writeln(OutFile,'Limbo Transactions');
  for i := 0 to limbo.getCount - 1 do
  with limbo[i] do
  case getItemType of
  isc_spb_single_tra_id:
    writeln(OutFile,'Single DB Transaction = ',getAsInteger);
  isc_spb_multi_tra_id:
    writeln(OutFile,'Multi DB Transaction = ',getAsInteger);
  isc_spb_tra_host_site:
    writeln(OutFile,'Host Name = ',getAsString);
  isc_spb_tra_advise:
    writeln(OutFile,'Resolution Advisory = ',getAsInteger);
  isc_spb_tra_remote_site:
    writeln(OutFile,'Server Name = ',getAsString);
  isc_spb_tra_db_path:
    writeln(OutFile,'DB Primary File Name = ',getAsString);
  isc_spb_tra_state:
    begin
      write(OutFile,'State = ');
      case getAsInteger of
        isc_spb_tra_state_limbo:
          writeln(OutFile,'limbo');
        isc_spb_tra_state_commit:
          writeln(OutFile,'commit');
        isc_spb_tra_state_rollback:
          writeln(OutFile,'rollback');
        isc_spb_tra_state_unknown:
          writeln(OutFile,'Unknown');
      end;
    end;
  end;
end;

end.

Revision:	379
Committed:	Mon Jan 10 10:08:03 2022 UTC (2 years, 3 months ago) by tony
Content type:	text/x-pascal
File size:	6969 byte(s)
Log Message:	set line ending property
#	Content
1	(*
2	* Firebird Interface (fbintf) Test suite. This program is used to
3	* test the Firebird Pascal Interface and provide a semi-automated
4	* pass/fail check for each test.
5	*
6	* The contents of this file are subject to the Initial Developer's
7	* Public License Version 1.0 (the "License"); you may not use this
8	* file except in compliance with the License. You may obtain a copy
9	* of the License here:
10	*
11	* http://www.firebirdsql.org/index.php?op=doc&id=idpl
12	*
13	* Software distributed under the License is distributed on an "AS
14	* IS" basis, WITHOUT WARRANTY OF ANY KIND, either express or
15	* implied. See the License for the specific language governing rights
16	* and limitations under the License.
17	*
18	* The Initial Developer of the Original Code is Tony Whyman.
19	*
20	* The Original Code is (C) 2016-2020 Tony Whyman, MWA Software
21	* (http://www.mwasoftware.co.uk).
22	*
23	* All Rights Reserved.
24	*
25	* Contributor(s): ______________________________________.
26	*
27	*)
28	unit FBTestApp;
29
30	{$IFDEF MSWINDOWS}
31	{$DEFINE WINDOWS}
32	{$ENDIF}
33
34	{$IFDEF FPC}
35	{$mode delphi}
36	{$codepage utf8}
37	{$ENDIF}
38
39	interface
40
41	uses
42	Classes, SysUtils, TestApplication, IB;
43
44	type
45
46	{ TFBTestBase }
47
48	TFBTestBase = class(TTestBase)
49	protected
50	function GetTestID: AnsiString; override;
51	function GetTestTitle: AnsiString; override;
52	function WriteServiceQueryResult(QueryResult: IServiceQueryResults): boolean;
53	procedure writeLicence(Item: IServiceQueryResultItem);
54	procedure WriteConfig(config: IServiceQueryResultItem);
55	procedure WriteUsers(users: IServiceQueryResultItem);
56	procedure WriteDBAttachments(att: IServiceQueryResultItem);
57	procedure WriteLimboTransactions(limbo: IServiceQueryResultItem);
58	end;
59
60	implementation
61
62	function TFBTestBase.GetTestID: AnsiString;
63	var s: AnsiString;
64	i,j: integer;
65	begin
66	i := 1;
67	s := TestTitle;
68	while not (s[i] in ['0'..'9']) and (i <= Length(s)) do inc(i);
69	j := i + 1;
70	while (s[j] in ['0'..'9']) and (i <= Length(s)) do inc(j);
71	Result := system.copy(s,i,j-i);
72	if Length(Result) = 1 then
73	Result := '0' + Result;
74	end;
75
76	function TFBTestBase.GetTestTitle: AnsiString;
77	begin
78	Result := '';
79	end;
80
81	function TFBTestBase.WriteServiceQueryResult(QueryResult: IServiceQueryResults): boolean;
82	var i: integer;
83	line: AnsiString;
84	begin
85	Result := true;
86	for i := 0 to QueryResult.GetCount - 1 do
87	with QueryResult[i] do
88	case getItemType of
89	isc_info_svc_version:
90	writeln(OutFile,'Service Manager Version = ',getAsInteger);
91	isc_info_svc_server_version:
92	writeln(OutFile,'Server Version = ',getAsString);
93	isc_info_svc_implementation:
94	writeln(OutFile,'Implementation = ',getAsString);
95	isc_info_svc_get_license:
96	writeLicence(QueryResult[i]);
97	isc_info_svc_get_license_mask:
98	writeln(OutFile,'Licence Mask = ',getAsInteger);
99	isc_info_svc_capabilities:
100	writeln(OutFile,'Capabilities = ',getAsInteger);
101	isc_info_svc_get_config:
102	WriteConfig(QueryResult[i]);
103	isc_info_svc_get_env:
104	writeln(OutFile,'Root Directory = ',getAsString);
105	isc_info_svc_get_env_lock:
106	writeln(OutFile,'Lock Directory = ',getAsString);
107	isc_info_svc_get_env_msg:
108	writeln(OutFile,'Message File = ',getAsString);
109	isc_info_svc_user_dbpath:
110	writeln(OutFile,'Security File = ',getAsString);
111	isc_info_svc_get_licensed_users:
112	writeln(OutFile,'Max Licenced Users = ',getAsInteger);
113	isc_info_svc_get_users:
114	WriteUsers(QueryResult[i]);
115	isc_info_svc_svr_db_info:
116	WriteDBAttachments(QueryResult[i]);
117	isc_info_svc_line:
118	begin
119	line := getAsString;
120	writeln(OutFile,line);
121	Result := line <> '';
122	end;
123	isc_info_svc_running:
124	writeln(OutFile,'Is Running = ',getAsInteger);
125	isc_info_svc_limbo_trans:
126	WriteLimboTransactions(QueryResult[i]);
127	isc_info_svc_to_eof,
128	isc_info_svc_timeout,
129	isc_info_truncated,
130	isc_info_data_not_ready,
131	isc_info_svc_stdin:
132	{ignore};
133	else
134	writeln(OutFile,'Unknown Service Response Item ', getItemType);
135	end;
136	writeln(OutFile);
137	end;
138
139	procedure TFBTestBase.writeLicence(Item: IServiceQueryResultItem);
140	var i: integer;
141	begin
142	for i := 0 to Item.getCount - 1 do
143	with Item[i] do
144	case getItemType of
145	isc_spb_lic_id:
146	writeln(OutFile,'Licence ID = ',GetAsString);
147	isc_spb_lic_key:
148	writeln(OutFile,'Licence Key = ',GetAsString);
149	end;
150	end;
151
152	procedure TFBTestBase.WriteConfig(config: IServiceQueryResultItem);
153	var i: integer;
154	begin
155	writeln(OutFile,'Firebird Configuration File');
156	for i := 0 to config.getCount - 1 do
157	writeln(OutFile,'Key = ',config[i].getItemType,', Value = ',config[i].getAsInteger);
158	writeln(OutFile);
159	end;
160
161	procedure TFBTestBase.WriteUsers(users: IServiceQueryResultItem);
162	var i: integer;
163	begin
164	writeln(OutFile,'Sec. Database User');
165	for i := 0 to users.getCount - 1 do
166	with users[i] do
167	case getItemType of
168	isc_spb_sec_username:
169	writeln(OutFile,'User Name = ',getAsString);
170	isc_spb_sec_firstname:
171	writeln(OutFile,'First Name = ',getAsString);
172	isc_spb_sec_middlename:
173	writeln(OutFile,'Middle Name = ',getAsString);
174	isc_spb_sec_lastname:
175	writeln(OutFile,'Last Name = ',getAsString);
176	isc_spb_sec_userid:
177	writeln(OutFile,'User ID = ',getAsInteger);
178	isc_spb_sec_groupid:
179	writeln(OutFile,'Group ID = ',getAsInteger);
180	else
181	writeln(OutFile,'Unknown user info ', getItemType);
182	end;
183	writeln(OutFile);
184	end;
185
186	procedure TFBTestBase.WriteDBAttachments(att: IServiceQueryResultItem);
187	var i: integer;
188	begin
189	writeln(OutFile,'DB Attachments');
190	for i := 0 to att.getCount - 1 do
191	with att[i] do
192	case getItemType of
193	isc_spb_num_att:
194	writeln(OutFile,'No. of Attachments = ',getAsInteger);
195	isc_spb_num_db:
196	writeln(OutFile,'Databases In Use = ',getAsInteger);
197	isc_spb_dbname:
198	writeln(OutFile,'DB Name = ',getAsString);
199	end;
200	end;
201
202	procedure TFBTestBase.WriteLimboTransactions(limbo: IServiceQueryResultItem);
203	var i: integer;
204	begin
205	writeln(OutFile,'Limbo Transactions');
206	for i := 0 to limbo.getCount - 1 do
207	with limbo[i] do
208	case getItemType of
209	isc_spb_single_tra_id:
210	writeln(OutFile,'Single DB Transaction = ',getAsInteger);
211	isc_spb_multi_tra_id:
212	writeln(OutFile,'Multi DB Transaction = ',getAsInteger);
213	isc_spb_tra_host_site:
214	writeln(OutFile,'Host Name = ',getAsString);
215	isc_spb_tra_advise:
216	writeln(OutFile,'Resolution Advisory = ',getAsInteger);
217	isc_spb_tra_remote_site:
218	writeln(OutFile,'Server Name = ',getAsString);
219	isc_spb_tra_db_path:
220	writeln(OutFile,'DB Primary File Name = ',getAsString);
221	isc_spb_tra_state:
222	begin
223	write(OutFile,'State = ');
224	case getAsInteger of
225	isc_spb_tra_state_limbo:
226	writeln(OutFile,'limbo');
227	isc_spb_tra_state_commit:
228	writeln(OutFile,'commit');
229	isc_spb_tra_state_rollback:
230	writeln(OutFile,'rollback');
231	isc_spb_tra_state_unknown:
232	writeln(OutFile,'Unknown');
233	end;
234	end;
235	end;
236	end;
237
238	end.
239