73 |
|
{$IFEND} |
74 |
|
{$ENDIF} |
75 |
|
|
76 |
+ |
{$IFNDEF LEGACYFIREBIRDAPIONLY} |
77 |
|
{$DEFINE USEFIREBIRD3API} |
78 |
+ |
{$ENDIF} |
79 |
+ |
{$IFNDEF FIREBIRD3APIONLY} |
80 |
|
{$DEFINE USELEGACYFIREBIRDAPI} |
81 |
+ |
{$ENDIF} |
82 |
|
|
83 |
|
{ |
84 |
|
This unit defines the interfaces used to provide the Pascal Language |
126 |
|
interface |
127 |
|
|
128 |
|
uses |
129 |
< |
Classes, SysUtils, DB, FBMessages, IBExternals; |
129 |
> |
Classes, |
130 |
> |
{$IFDEF WINDOWS}Windows, {$ENDIF} |
131 |
> |
{$IFDEF FPC} Dynlibs, {$ENDIF} |
132 |
> |
SysUtils, DB, FBMessages, IBExternals; |
133 |
|
|
134 |
|
const |
135 |
|
{Interface version information} |
136 |
|
FBIntf_Major = 1; |
137 |
|
FBIntf_Minor = 1; |
138 |
< |
FBIntf_Release = 1; |
139 |
< |
FBIntf_Version = '1.1.1'; |
138 |
> |
FBIntf_Release = 4; |
139 |
> |
FBIntf_Version = '1.1.4'; |
140 |
|
|
141 |
|
{These include files are converted from the 'C' originals in the Firebird API |
142 |
|
and define the various constants used by the API} |
180 |
|
PISC_QUAD = ^TISC_QUAD; |
181 |
|
|
182 |
|
{$IFNDEF FPC} |
183 |
+ |
{Delphi missing definitions} |
184 |
+ |
type |
185 |
+ |
TLibHandle = THandle; |
186 |
+ |
|
187 |
+ |
const |
188 |
+ |
NilHandle = 0; |
189 |
+ |
DirectorySeparator = '\'; |
190 |
+ |
|
191 |
|
{Delphi only seems to define CP_UTF8 and CP_UTF16} |
192 |
|
const |
193 |
|
CP_ACP = 0; // default to ANSI code page |
215 |
|
TFBStatusCode = cardinal; |
216 |
|
TByteArray = array of byte; |
217 |
|
|
218 |
+ |
IFirebirdAPI = interface; |
219 |
|
IAttachment = interface; |
220 |
|
ITransaction = interface; |
221 |
|
|
411 |
|
the output of an SQL Statement. |
412 |
|
} |
413 |
|
|
414 |
+ |
TIBDateTimeFormats = (dfTimestamp, {SQL TIMESTAMP} |
415 |
+ |
dfDateTime, {SQL DATETIME} |
416 |
+ |
dfTime); {SQL TIME} |
417 |
+ |
|
418 |
|
{ IColumnMetaData } |
419 |
|
|
420 |
|
IColumnMetaData = interface |
435 |
|
function GetSize: cardinal; |
436 |
|
function GetArrayMetaData: IArrayMetaData; {Valid only for Array SQL Type} |
437 |
|
function GetBlobMetaData: IBlobMetaData; {Valid only for Blob SQL Type} |
438 |
+ |
function GetDateTimeStrLength(DateTimeFormat: TIBDateTimeFormats): integer; |
439 |
|
property Name: AnsiString read GetName; |
440 |
|
property Size: cardinal read GetSize; |
441 |
|
property SQLType: cardinal read GetSQLType; |
667 |
|
function GetRowsAffected(var SelectCount, InsertCount, UpdateCount, DeleteCount: integer): boolean; |
668 |
|
function GetSQLStatementType: TIBSQLStatementTypes; |
669 |
|
function GetSQLText: AnsiString; |
670 |
+ |
function GetProcessedSQLText: AnsiString; |
671 |
|
function GetSQLDialect: integer; |
672 |
|
function IsPrepared: boolean; |
673 |
|
procedure Prepare(aTransaction: ITransaction=nil); |
884 |
|
|
885 |
|
IAttachment = interface |
886 |
|
['{466e9b67-9def-4807-b3e7-e08a35e7185c}'] |
887 |
+ |
function getFirebirdAPI: IFirebirdAPI; |
888 |
|
function getDPB: IDPB; |
889 |
|
function AllocateBPB: IBPB; |
890 |
|
function AllocateDIRB: IDIRB; |
920 |
|
function Prepare(transaction: ITransaction; sql: AnsiString; aSQLDialect: integer): IStatement; overload; |
921 |
|
function Prepare(transaction: ITransaction; sql: AnsiString): IStatement; overload; |
922 |
|
function PrepareWithNamedParameters(transaction: ITransaction; sql: AnsiString; |
923 |
< |
aSQLDialect: integer; GenerateParamNames: boolean=false): IStatement; overload; |
923 |
> |
aSQLDialect: integer; GenerateParamNames: boolean=false; |
924 |
> |
CaseSensitiveParams: boolean = false): IStatement; overload; |
925 |
|
function PrepareWithNamedParameters(transaction: ITransaction; sql: AnsiString; |
926 |
< |
GenerateParamNames: boolean=false): IStatement; overload; |
926 |
> |
GenerateParamNames: boolean=false; |
927 |
> |
CaseSensitiveParams: boolean = false): IStatement; overload; |
928 |
|
|
929 |
|
{Events} |
930 |
|
function GetEventHandler(Events: TStrings): IEvents; overload; |
959 |
|
function GetSecurityDatabase: AnsiString; |
960 |
|
function GetODSMajorVersion: integer; |
961 |
|
function GetODSMinorVersion: integer; |
962 |
+ |
procedure getFBVersion(version: TStrings); |
963 |
|
function HasActivity: boolean; |
964 |
|
|
965 |
|
{Character Sets} |
974 |
|
AllowReverseLookup:boolean; out CharSetID: integer); |
975 |
|
end; |
976 |
|
|
977 |
< |
TProtocolAll = (TCP, SPX, NamedPipe, Local, inet, wnet, xnet, unknownProtocol); |
977 |
> |
TProtocolAll = (TCP, SPX, NamedPipe, Local, inet, inet4, inet6, wnet, xnet, unknownProtocol); |
978 |
|
TProtocol = TCP..xnet; |
979 |
|
|
980 |
|
{Service Parameter Block (SPB). |
1080 |
|
property Count: integer read getCount; |
1081 |
|
end; |
1082 |
|
|
1083 |
+ |
IFirebirdLibrary = interface; |
1084 |
+ |
|
1085 |
|
{The IServiceManager interface provides access to a service manager. It can |
1086 |
|
used to Detach and re-attach to Service Manager, to start services and to |
1087 |
|
query the service manager. |
1093 |
|
|
1094 |
|
IServiceManager = interface |
1095 |
|
['{905b587d-1e1f-4e40-a3f8-a3519f852e48}'] |
1096 |
+ |
function getFirebirdAPI: IFirebirdAPI; |
1097 |
|
function getSPB: ISPB; |
1098 |
|
function getServerName: AnsiString; |
1099 |
|
function getProtocol: TProtocol; |
1108 |
|
function Query(Request: ISRB; RaiseExceptionOnError: boolean=true) :IServiceQueryResults; overload; |
1109 |
|
end; |
1110 |
|
|
1111 |
+ |
{Tbe Firebird Library API used to get information about the Firebird library} |
1112 |
+ |
|
1113 |
+ |
|
1114 |
+ |
IFirebirdLibrary = interface |
1115 |
+ |
['{3c04e0a1-12e0-428a-b2e1-bc6fcd97b79b}'] |
1116 |
+ |
function GetHandle: TLibHandle; |
1117 |
+ |
function GetLibraryName: string; |
1118 |
+ |
function GetLibraryFilePath: string; |
1119 |
+ |
function GetFirebirdAPI: IFirebirdAPI; |
1120 |
+ |
end; |
1121 |
+ |
|
1122 |
|
{The Firebird API. |
1123 |
|
|
1124 |
|
This is the base interface and is used to create/open a database connection, to |
1150 |
|
|
1151 |
|
{Information} |
1152 |
|
function GetStatus: IStatus; |
1113 |
– |
function GetLibraryName: string; |
1153 |
|
function HasRollbackRetaining: boolean; |
1154 |
|
function IsEmbeddedServer: boolean; |
1155 |
|
function GetImplementationVersion: AnsiString; |
1157 |
|
{Firebird 3 API} |
1158 |
|
function HasMasterIntf: boolean; |
1159 |
|
function GetIMaster: TObject; |
1160 |
+ |
function GetFBLibrary: IFirebirdLibrary; |
1161 |
|
end; |
1162 |
|
|
1163 |
|
type |
1210 |
|
function TryIBLoad: Boolean; |
1211 |
|
procedure CheckIBLoaded; |
1212 |
|
|
1213 |
+ |
{If you want to explicitly load the Firebird library from a |
1214 |
+ |
non-default location then use this function and its GetFirebirdAPI function |
1215 |
+ |
to get the API.} |
1216 |
+ |
|
1217 |
+ |
function LoadFBLibrary(aLibPathName: string): IFirebirdLibrary; |
1218 |
+ |
|
1219 |
|
implementation |
1220 |
|
|
1221 |
|
uses FBClientAPI |
1222 |
|
{$IFDEF USELEGACYFIREBIRDAPI}, FB25ClientAPI {$ENDIF} |
1223 |
|
{$IFDEF USEFIREBIRD3API}, FB30ClientAPI {$ENDIF}; |
1224 |
|
|
1225 |
< |
var FFirebirdAPI: IFirebirdAPI; |
1225 |
> |
var FDefaultFBLibrary: IFirebirdLibrary; |
1226 |
> |
|
1227 |
> |
type |
1228 |
> |
|
1229 |
> |
{ TFBLibrary } |
1230 |
> |
|
1231 |
> |
TFBLibraryImpl = class(TFBLibrary) |
1232 |
> |
protected |
1233 |
> |
function GetFirebird3API: IFirebirdAPI; override; |
1234 |
> |
function GetLegacyFirebirdAPI: IFirebirdAPI; override; |
1235 |
> |
end; |
1236 |
> |
|
1237 |
> |
function TFBLibraryImpl.GetFirebird3API: IFirebirdAPI; |
1238 |
> |
begin |
1239 |
> |
{$IFDEF USEFIREBIRD3API} |
1240 |
> |
Result := TFB30ClientAPI.Create(self); |
1241 |
> |
{$ELSE} |
1242 |
> |
Result := nil; |
1243 |
> |
{$ENDIF} |
1244 |
> |
end; |
1245 |
> |
|
1246 |
> |
function TFBLibraryImpl.GetLegacyFirebirdAPI: IFirebirdAPI; |
1247 |
> |
begin |
1248 |
> |
{$IFDEF USELEGACYFIREBIRDAPI} |
1249 |
> |
Result := TFB25ClientAPI.Create(self); |
1250 |
> |
{$ELSE} |
1251 |
> |
Result := nil; |
1252 |
> |
{$ENDIF} |
1253 |
> |
end; |
1254 |
|
|
1255 |
|
function FirebirdAPI: IFirebirdAPI; |
1256 |
|
begin |
1257 |
< |
if FFirebirdAPI = nil then |
1257 |
> |
if FDefaultFBLibrary = nil then |
1258 |
|
CheckIBLoaded; |
1259 |
< |
Result := FFirebirdAPI; |
1259 |
> |
Result := FDefaultFBLibrary.GetFirebirdAPI; |
1260 |
|
end; |
1261 |
|
|
1262 |
|
function TryIBLoad: Boolean; |
1263 |
+ |
var fblib: IFirebirdLibrary; |
1264 |
|
begin |
1265 |
< |
Result := FFirebirdAPI <> nil; |
1265 |
> |
Result := FDefaultFBLibrary <> nil; |
1266 |
|
try |
1192 |
– |
{$IFDEF USEFIREBIRD3API} |
1193 |
– |
if not Result then |
1194 |
– |
begin |
1195 |
– |
FFirebirdAPI := TFB30ClientAPI.Create; |
1196 |
– |
Result := FFirebirdAPI.HasMasterIntf; |
1197 |
– |
end; |
1198 |
– |
{$ENDIF} |
1199 |
– |
{$IFDEF USELEGACYFIREBIRDAPI} |
1267 |
|
if not Result then |
1268 |
|
begin |
1269 |
< |
FFirebirdAPI := nil; |
1270 |
< |
FFirebirdAPI := TFB25ClientAPI.Create; |
1271 |
< |
Result := true; |
1272 |
< |
end; |
1206 |
< |
{$ENDIF} |
1207 |
< |
if Result and not (FFirebirdAPI as TFBClientAPI).IsLibraryLoaded then |
1208 |
< |
begin |
1209 |
< |
Result := false; |
1210 |
< |
FFirebirdAPI := nil; |
1269 |
> |
fblib := TFBLibraryImpl.Create; |
1270 |
> |
if (fblib <> nil) and (fblib.GetFirebirdAPI <> nil) then |
1271 |
> |
FDefaultFBLibrary := fblib; |
1272 |
> |
Result := FDefaultFBLibrary <> nil; |
1273 |
|
end; |
1274 |
|
except |
1275 |
|
SysUtils.showexception(ExceptObject,ExceptAddr); |
1283 |
|
IBError(ibxeInterBaseMissing, [nil]); |
1284 |
|
end; |
1285 |
|
|
1286 |
+ |
function LoadFBLibrary(aLibPathName: string): IFirebirdLibrary; |
1287 |
+ |
var fblib: IFirebirdLibrary; |
1288 |
+ |
begin |
1289 |
+ |
if trim(aLibPathName) = '' then |
1290 |
+ |
begin |
1291 |
+ |
CheckIBLoaded; |
1292 |
+ |
Result := FDefaultFBLibrary; |
1293 |
+ |
end |
1294 |
+ |
else |
1295 |
+ |
begin |
1296 |
+ |
fblib := TFBLibraryImpl.GetFBLibrary(aLibPathName); |
1297 |
+ |
if (fblib = nil) or (fblib.GetFirebirdAPI = nil) then |
1298 |
+ |
IBError(ibxeInterBaseMissing, [nil]); |
1299 |
+ |
Result := fblib; |
1300 |
+ |
end; |
1301 |
+ |
end; |
1302 |
+ |
|
1303 |
|
{ EIBError } |
1304 |
|
|
1305 |
|
constructor EIBError.Create(ASQLCode: Long; Msg: AnsiString); |
1330 |
|
end; |
1331 |
|
|
1332 |
|
initialization |
1333 |
< |
FFirebirdAPI := nil; |
1333 |
> |
FDefaultFBLibrary := nil; |
1334 |
|
|
1335 |
|
finalization |
1336 |
< |
FFirebirdAPI := nil; |
1336 |
> |
FDefaultFBLibrary := nil; |
1337 |
|
|
1338 |
|
end. |
1339 |
|
|