u_DBMS_Utils.pas

unit u_DBMS_Utils;

{$include i_DBMS.inc}

interface

uses
  Windows,
  SysUtils,
  t_types;

function AnsiStrToDB(const S: AnsiString): AnsiString;
function WideStrToDB(const S: WideString): WideString;

function DBMSStrToDB(const S: TDBMS_String): TDBMS_String; inline;

function GetModuleFileNameWithoutExt(
  const AInSqlSubFolder: Boolean;
  const AKeepFullPath: Boolean;
  const APrefixBefore: String;
  const ATailAfterDot: String
): String;

function NowUTC: TDateTime;

implementation

uses
  t_DBMS_Template;

function AnsiStrToDB(const S: AnsiString): AnsiString;
begin
  Result := QuotedStr(S);
end;

function WideStrToDB(const S: WideString): WideString;
var
  I: Integer;
begin
  Result := S;
  for I := Length(Result) downto 1 do
    if Result[I] = '''' then Insert('''', Result, I);
  Result := '''' + Result + '''';
end;

function DBMSStrToDB(const S: TDBMS_String): TDBMS_String; inline;
begin
{$if defined(USE_WIDESTRING_FOR_SQL)}
  Result := WideStrToDB(S);
{$else}
  Result := QuotedStr(S);
{$ifend}
end;

function GetModuleFileNameWithoutExt(
  const AInSqlSubFolder: Boolean;
  const AKeepFullPath: Boolean;
  const APrefixBefore: String;
  const ATailAfterDot: String
): String;
begin
  Result := GetModuleName(HInstance);

  if (not AKeepFullPath) then begin
    Result := ExtractFileName(Result);
  end;

  Result := ChangeFileExt(Result,'');
  if (0<Length(ATailAfterDot)) then begin
    Result := Result + '.' + ATailAfterDot;
  end;
  if (0<Length(APrefixBefore)) then begin
    Result := APrefixBefore + Result;
  end;
  if AInSqlSubFolder then begin
    Result := c_SQL_SubFolder + Result;
  end;
end;

function NowUTC: TDateTime;
var st: TSystemTime;
begin
  GetSystemTime(st);
  Result := SystemTimeToDateTime(st);
end;

end.