56 |
|
while ResultSet.FetchNext do |
57 |
|
begin |
58 |
|
for i := 0 to ResultSet.getCount - 1 do |
59 |
< |
writeln(OutFile,ResultSet[i].Name,' = ',ResultSet[i].AsString); |
59 |
> |
writeln(OutFile,ResultSet[i].Name,' = ',Trim(ResultSet[i].AsString)); |
60 |
|
end; |
61 |
|
finally |
62 |
|
ResultSet.Close; |
73 |
|
writeln(outfile,'DB ODS Major Version = ',Attachment.GetODSMajorVersion); |
74 |
|
writeln(outfile,'DB ODS Minor Version = ',Attachment.GetODSMinorVersion); |
75 |
|
writeln(outfile,'User Authentication Method = ',Attachment.GetAuthenticationMethod); |
76 |
+ |
writeln(outfile,'Firebird Library Path = ',Attachment.getFirebirdAPI.GetFBLibrary.GetLibraryFilePath); |
77 |
+ |
writeln(outfile,'DB Client Implementation Version = ',Attachment.getFirebirdAPI.GetImplementationVersion); |
78 |
|
end; |
79 |
|
|
80 |
|
function TTest1.TestTitle: AnsiString; |
86 |
|
var DPB: IDPB; |
87 |
|
Attachment: IAttachment; |
88 |
|
createSQL: AnsiString; |
89 |
+ |
libpath: string; |
90 |
+ |
FBLibrary: IFirebirdLibrary; |
91 |
|
begin |
92 |
|
writeln(OutFile,'Creating a Database with empty parameters'); |
93 |
|
Attachment := FirebirdAPI.CreateDatabase('',nil,false); |
98 |
|
|
99 |
|
writeln(OutFile,'Creating a Database using an SQL Statement'); |
100 |
|
createSQL := Format('create database ''%s'' USER ''%s'' PASSWORD ''%s'' DEFAULT CHARACTER SET %s', |
101 |
< |
[Owner.GetNewDatabaseName, Owner.GetUserName, Owner.GetPassword, CharSet]); |
101 |
> |
[ExtractDBName(Owner.GetNewDatabaseName), Owner.GetUserName, Owner.GetPassword, CharSet]); |
102 |
|
Attachment := FirebirdAPI.CreateDatabase(createSQL,SQLDialect); |
103 |
|
WriteDBInfo(Attachment.GetDBInformation([isc_info_db_id,isc_info_db_SQL_Dialect])); |
104 |
|
WriteAttachmentInfo(Attachment); |
125 |
|
DPB.Add(isc_dpb_lc_ctype).setAsString(CharSet); |
126 |
|
DPB.Add(isc_dpb_set_db_SQL_dialect).setAsByte(SQLDialect); |
127 |
|
|
128 |
< |
Attachment := FirebirdAPI.CreateDatabase(Owner.GetNewDatabaseName,DPB); |
128 |
> |
Attachment := FirebirdAPI.CreateDatabase(ExtractDBName(Owner.GetNewDatabaseName),DPB); |
129 |
|
|
130 |
|
WriteAttachmentInfo(Attachment); |
131 |
|
|
137 |
|
|
138 |
|
PrintDPB(DPB); |
139 |
|
writeln(OutFile,'Creating a Database with a DPD'); |
140 |
< |
Attachment := FirebirdAPI.CreateDatabase(Owner.GetNewDatabaseName,DPB); |
140 |
> |
Attachment := FirebirdAPI.CreateDatabase(ExtractDBName(Owner.GetNewDatabaseName),DPB); |
141 |
|
if Attachment = nil then |
142 |
|
begin |
143 |
|
writeln(OutFile,'Create Database Failed'); |
151 |
|
|
152 |
|
writeln(OutFile,'Dropping Database'); |
153 |
|
Attachment.DropDatabase; |
154 |
+ |
|
155 |
+ |
libpath := GetEnvironmentVariable('TESTFIREBIRDLIBRARY'); |
156 |
+ |
if libpath <> '' then |
157 |
+ |
begin |
158 |
+ |
FBLibrary := LoadFBLibrary(libpath); |
159 |
+ |
|
160 |
+ |
writeln(OutFile,'Creating a Database with a DPD using Firebird Library in ',libpath); |
161 |
+ |
Attachment := FBLibrary.GetFirebirdAPI.CreateDatabase(ExtractDBName(Owner.GetNewDatabaseName),DPB); |
162 |
+ |
if Attachment = nil then |
163 |
+ |
begin |
164 |
+ |
writeln(OutFile,'Create Database Failed'); |
165 |
+ |
Exit; |
166 |
+ |
end; |
167 |
+ |
WriteDBInfo(Attachment.GetDBInformation([isc_info_db_id,isc_info_ods_version,isc_info_ods_minor_version])); |
168 |
+ |
WriteAttachmentInfo(Attachment); |
169 |
+ |
|
170 |
+ |
{Querying Database} |
171 |
+ |
DoQuery(Attachment); |
172 |
+ |
|
173 |
+ |
writeln(OutFile,'Dropping Database'); |
174 |
+ |
Attachment.DropDatabase; |
175 |
+ |
end; |
176 |
|
end; |
177 |
|
|
178 |
|
|