39 |
|
{$IFDEF FPC} |
40 |
|
{$Mode Delphi} |
41 |
|
{$codepage UTF8} |
42 |
– |
{$define HASREQEX} |
42 |
|
{$ENDIF} |
43 |
|
|
44 |
+ |
{ $IF declared(CompilerVersion) and (CompilerVersion >= 22)} |
45 |
+ |
{ $define HASDELPHIREQEX} |
46 |
+ |
{ $IFEND} |
47 |
|
|
48 |
|
interface |
49 |
|
|
636 |
|
var PortNo: AnsiString): boolean; |
637 |
|
function GetProtocol(ConnectString: AnsiString): TProtocolAll; |
638 |
|
|
639 |
+ |
{$IF declared(TFormatSettings)} |
640 |
+ |
function ParseDateTimeTZString(aDateTimeStr: Ansistring; var aDateTime: TDateTime; |
641 |
+ |
var aTimezone: AnsiString; aFormatSettings: TFormatSettings; TimeOnly: boolean=false): boolean; overload; |
642 |
+ |
{$IFEND} |
643 |
+ |
function ParseDateTimeTZString(aDateTimeStr: Ansistring; var aDateTime: TDateTime; |
644 |
+ |
var aTimezone: AnsiString; TimeOnly: boolean=false): boolean; overload; |
645 |
+ |
procedure FBDecodeTime(aTime: TDateTime; var Hour, Minute, Second: word; var DeciMillisecond: cardinal); |
646 |
+ |
function FBEncodeTime(Hour, Minute, Second, DeciMillisecond: cardinal): TDateTime; |
647 |
+ |
function FBFormatDateTime(fmt: AnsiString; aDateTime: TDateTime): AnsiString; |
648 |
+ |
function FormatTimeZoneOffset(EffectiveTimeOffsetMins: integer): AnsiString; |
649 |
+ |
function DecodeTimeZoneOffset(TZOffset: AnsiString; var dstOffset: integer): boolean; |
650 |
+ |
function StripLeadingZeros(Value: AnsiString): AnsiString; |
651 |
+ |
function TryStrToNumeric(S: Ansistring; out Value: int64; out scale: integer): boolean; |
652 |
+ |
function NumericToDouble(aValue: Int64; aScale: integer): double; |
653 |
+ |
|
654 |
+ |
|
655 |
|
implementation |
656 |
|
|
657 |
< |
uses FBMessages |
657 |
> |
uses FBMessages, Math |
658 |
|
|
659 |
< |
{$IFDEF HASREQEX} |
659 |
> |
{$IFDEF FPC} |
660 |
|
,RegExpr |
661 |
+ |
{$ELSE} |
662 |
+ |
{$IF declared(CompilerVersion) and (CompilerVersion >= 22)} |
663 |
+ |
, RegularExpressions |
664 |
+ |
{$IFEND} |
665 |
|
{$ENDIF}; |
666 |
|
|
667 |
+ |
|
668 |
|
function Max(n1, n2: Integer): Integer; |
669 |
|
begin |
670 |
|
if (n1 > n2) then |
782 |
|
Result := true; |
783 |
|
end; |
784 |
|
|
785 |
+ |
function SchemeToProtocol(scheme: AnsiString): TProtocolAll; |
786 |
+ |
begin |
787 |
+ |
scheme := AnsiUpperCase(scheme); |
788 |
+ |
if scheme = 'INET' then |
789 |
+ |
Result := inet |
790 |
+ |
else |
791 |
+ |
if scheme = 'INET4' then |
792 |
+ |
Result := inet4 |
793 |
+ |
else |
794 |
+ |
if scheme = 'INET6' then |
795 |
+ |
Result := inet6 |
796 |
+ |
else |
797 |
+ |
if scheme = 'XNET' then |
798 |
+ |
Result := xnet |
799 |
+ |
else |
800 |
+ |
if scheme = 'WNET' then |
801 |
+ |
Result := wnet |
802 |
+ |
end; |
803 |
+ |
|
804 |
|
{Extracts the Database Connect string from a Create Database Statement} |
805 |
|
|
806 |
< |
{$IFDEF HASREQEX} |
806 |
> |
{$IF declared(TRegexpr)} |
807 |
|
function ExtractConnectString(const CreateSQL: AnsiString; |
808 |
|
var ConnectString: AnsiString): boolean; |
809 |
|
var RegexObj: TRegExpr; |
826 |
|
DatabaseName: AnsiString; var Protocol: TProtocolAll; var PortNo: AnsiString |
827 |
|
): boolean; |
828 |
|
|
787 |
– |
function GetProtocol(scheme: AnsiString): TProtocolAll; |
788 |
– |
begin |
789 |
– |
scheme := AnsiUpperCase(scheme); |
790 |
– |
if scheme = 'INET' then |
791 |
– |
Result := inet |
792 |
– |
else |
793 |
– |
if scheme = 'INET4' then |
794 |
– |
Result := inet4 |
795 |
– |
else |
796 |
– |
if scheme = 'INET6' then |
797 |
– |
Result := inet6 |
798 |
– |
else |
799 |
– |
if scheme = 'XNET' then |
800 |
– |
Result := xnet |
801 |
– |
else |
802 |
– |
if scheme = 'WNET' then |
803 |
– |
Result := wnet |
804 |
– |
end; |
805 |
– |
|
829 |
|
var RegexObj: TRegExpr; |
830 |
|
begin |
831 |
|
ServerName := ''; |
841 |
|
if Result then |
842 |
|
begin |
843 |
|
{URL type connect string} |
844 |
< |
Protocol := GetProtocol(RegexObj.Match[1]); |
844 |
> |
Protocol := SchemeToProtocol(RegexObj.Match[1]); |
845 |
|
ServerName := RegexObj.Match[2]; |
846 |
|
if RegexObj.MatchLen[3] > 0 then |
847 |
|
PortNo := system.Copy(ConnectString,RegexObj.MatchPos[3]+1,RegexObj.MatchLen[3]-1); |
856 |
|
Result := RegexObj.Exec(ConnectString); |
857 |
|
if Result then |
858 |
|
begin |
859 |
< |
Protocol := GetProtocol(RegexObj.Match[1]); |
859 |
> |
Protocol := SchemeToProtocol(RegexObj.Match[1]); |
860 |
|
DatabaseName := RegexObj.Match[2]; |
861 |
|
end |
862 |
|
else |
905 |
|
end; |
906 |
|
end; |
907 |
|
|
908 |
< |
function GetProtocol(ConnectString: AnsiString): TProtocolAll; |
909 |
< |
var ServerName, |
910 |
< |
DatabaseName: AnsiString; |
911 |
< |
PortNo: AnsiString; |
908 |
> |
{$ELSE} |
909 |
> |
{$IF declared(TRegex)} |
910 |
> |
function ExtractConnectString(const CreateSQL: AnsiString; |
911 |
> |
var ConnectString: AnsiString): boolean; |
912 |
> |
var Regex: TRegEx; |
913 |
> |
Match: TMatch; |
914 |
|
begin |
915 |
< |
ParseConnectString(ConnectString,ServerName,DatabaseName,Result,PortNo); |
915 |
> |
Regex := TRegEx.Create('^ *CREATE +(DATABASE|SCHEMA) +''(.*)''',[roIgnoreCase]); |
916 |
> |
{extact database file spec} |
917 |
> |
Match := Regex.Match(CreateSQL); |
918 |
> |
Result := Match.Success and (Match.Groups.Count = 3); |
919 |
> |
if Result then |
920 |
> |
ConnectString := Match.Groups[2].Value; |
921 |
|
end; |
922 |
|
|
923 |
+ |
function ParseConnectString(ConnectString: AnsiString; var ServerName, |
924 |
+ |
DatabaseName: AnsiString; var Protocol: TProtocolAll; var PortNo: AnsiString |
925 |
+ |
): boolean; |
926 |
+ |
|
927 |
+ |
var Regex: TRegEx; |
928 |
+ |
Match: TMatch; |
929 |
+ |
begin |
930 |
+ |
ServerName := ''; |
931 |
+ |
DatabaseName := ConnectString; |
932 |
+ |
PortNo := ''; |
933 |
+ |
Protocol := unknownProtocol; |
934 |
+ |
{extact database file spec} |
935 |
+ |
Match := Regex.Match(ConnectString,'^([a-zA-Z46]+)://([a-zA-Z0-9\-\.]*)(|:[0-9a-zA-Z\-]+)/(.*)$',[roIgnoreCase]); |
936 |
+ |
Result := Match.Success and (Match.Groups.Count = 5); |
937 |
+ |
if Result then |
938 |
+ |
begin |
939 |
+ |
{URL type connect string} |
940 |
+ |
Protocol := SchemeToProtocol(Match.Groups[1].Value); |
941 |
+ |
ServerName := Match.Groups[2].Value; |
942 |
+ |
PortNo := Match.Groups[3].Value; |
943 |
+ |
DatabaseName := Match.Groups[4].Value; |
944 |
+ |
if ServerName = '' then |
945 |
+ |
DatabaseName := '/' + DatabaseName; |
946 |
+ |
end |
947 |
+ |
else |
948 |
+ |
begin |
949 |
+ |
{URL type connect string - local loop} |
950 |
+ |
Match := Regex.Match(ConnectString,'^([a-zA-Z46]+)://(.*)$',[roIgnoreCase]); |
951 |
+ |
Result := Match.Success and (Match.Groups.Count = 3); |
952 |
+ |
if Result then |
953 |
+ |
begin |
954 |
+ |
Protocol := SchemeToProtocol(Match.Groups[1].Value); |
955 |
+ |
DatabaseName := Match.Groups[2].Value; |
956 |
+ |
end |
957 |
+ |
else |
958 |
+ |
begin |
959 |
+ |
Match := Regex.Match(ConnectString,'^([a-zA-Z]:\\.*)',[roIgnoreCase]); |
960 |
+ |
Result := Match.Success; |
961 |
+ |
if Result then |
962 |
+ |
Protocol := Local {Windows with leading drive ID} |
963 |
+ |
else |
964 |
+ |
begin |
965 |
+ |
Match := Regex.Match(ConnectString,'^([a-zA-Z0-9\-\.]+)(|/[0-9a-zA-Z\-]+):(.*)$',[roIgnoreCase]); |
966 |
+ |
Result := Match.Success and (Match.Groups.Count = 4); |
967 |
+ |
if Result then |
968 |
+ |
begin |
969 |
+ |
{Legacy TCP Format} |
970 |
+ |
ServerName := Match.Groups[1].Value; |
971 |
+ |
PortNo := Match.Groups[2].Value; |
972 |
+ |
DatabaseName := Match.Groups[3].Value; |
973 |
+ |
Protocol := TCP; |
974 |
+ |
end |
975 |
+ |
else |
976 |
+ |
begin |
977 |
+ |
Match := Regex.Match(ConnectString,'^\\\\([a-zA-Z0-9\-\.]+)(|@[0-9a-zA-Z\-]+)\\(.*)$',[roIgnoreCase]); |
978 |
+ |
Result := Match.Success and (Match.Groups.Count = 4); |
979 |
+ |
if Result then |
980 |
+ |
begin |
981 |
+ |
{Netbui} |
982 |
+ |
ServerName := Match.Groups[1].Value; |
983 |
+ |
PortNo := Match.Groups[2].Value; |
984 |
+ |
DatabaseName := Match.Groups[3].Value; |
985 |
+ |
Protocol := NamedPipe |
986 |
+ |
end |
987 |
+ |
else |
988 |
+ |
begin |
989 |
+ |
Result := true; |
990 |
+ |
Protocol := Local; {Assume local} |
991 |
+ |
end; |
992 |
+ |
end; |
993 |
+ |
end; |
994 |
+ |
end; |
995 |
+ |
end; |
996 |
+ |
end; |
997 |
|
{$ELSE} |
998 |
< |
{cruder version of above for Delphi. Older versions lack regular expression |
998 |
> |
{cruder version of above for Delphi < XE. Older versions lack regular expression |
999 |
|
handling.} |
1000 |
|
function ExtractConnectString(const CreateSQL: AnsiString; |
1001 |
|
var ConnectString: AnsiString): boolean; |
1016 |
|
end; |
1017 |
|
end; |
1018 |
|
|
915 |
– |
function GetProtocol(ConnectString: AnsiString): TProtocolAll; |
916 |
– |
begin |
917 |
– |
Result := unknownProtocol; {not implemented for Delphi} |
918 |
– |
end; |
919 |
– |
|
1019 |
|
function ParseConnectString(ConnectString: AnsiString; |
1020 |
|
var ServerName, DatabaseName: AnsiString; var Protocol: TProtocolAll; |
1021 |
|
var PortNo: AnsiString): boolean; |
1023 |
|
Result := false; |
1024 |
|
end; |
1025 |
|
|
1026 |
< |
{$ENDIF} |
1026 |
> |
{$IFEND} |
1027 |
> |
{$IFEND} |
1028 |
> |
|
1029 |
> |
function GetProtocol(ConnectString: AnsiString): TProtocolAll; |
1030 |
> |
var ServerName, |
1031 |
> |
DatabaseName: AnsiString; |
1032 |
> |
PortNo: AnsiString; |
1033 |
> |
begin |
1034 |
> |
if not ParseConnectString(ConnectString,ServerName,DatabaseName,Result,PortNo) then |
1035 |
> |
Result := unknownProtocol; |
1036 |
> |
end; |
1037 |
|
|
1038 |
|
{Make a connect string in format appropriate protocol} |
1039 |
|
|
1049 |
|
end; |
1050 |
|
|
1051 |
|
begin |
1052 |
+ |
if ServerName = '' then ServerName := 'localhost'; |
1053 |
|
if PortNo <> '' then |
1054 |
|
case Protocol of |
1055 |
|
NamedPipe: |
1252 |
|
stInBlock: |
1253 |
|
begin |
1254 |
|
case token of |
1255 |
< |
sqltBegin: |
1255 |
> |
sqltBegin, |
1256 |
> |
sqltCase: |
1257 |
|
Inc(FNested); |
1258 |
|
|
1259 |
|
sqltEnd: |
1475 |
|
GetNext; |
1476 |
|
|
1477 |
|
repeat |
1478 |
+ |
if FSkipNext then |
1479 |
+ |
begin |
1480 |
+ |
FSkipNext := false; |
1481 |
+ |
GetNext; |
1482 |
+ |
end; |
1483 |
+ |
|
1484 |
|
Result := FNextToken; |
1485 |
|
C := FLastChar; |
1486 |
|
GetNext; |
1487 |
|
|
1488 |
< |
if FSkipNext then |
1488 |
> |
if (Result = sqltCR) and (FNextToken = sqltEOL) then |
1489 |
|
begin |
1490 |
< |
FSkipNext := false; |
1491 |
< |
continue; |
1490 |
> |
FSkipNext := true; |
1491 |
> |
Result := sqltEOL; |
1492 |
> |
C := LF; |
1493 |
|
end; |
1494 |
|
|
1495 |
|
case FState of |
1502 |
|
GetNext; |
1503 |
|
end |
1504 |
|
else |
1505 |
+ |
if Result = sqltEOL then |
1506 |
+ |
FString := FString + LineEnding |
1507 |
+ |
else |
1508 |
|
FString := FString + C; |
1509 |
|
end; |
1510 |
|
|
1517 |
|
Result := sqltCommentLine; |
1518 |
|
end; |
1519 |
|
|
1399 |
– |
sqltCR: {ignore}; |
1400 |
– |
|
1520 |
|
else |
1521 |
|
FString := FString + C; |
1522 |
|
end; |
1538 |
|
end; |
1539 |
|
end |
1540 |
|
else |
1541 |
+ |
if Result = sqltEOL then |
1542 |
+ |
FString := FString + LineEnding |
1543 |
+ |
else |
1544 |
|
FString := FString + C; |
1545 |
|
end; |
1546 |
|
|
1560 |
|
end; |
1561 |
|
end |
1562 |
|
else |
1563 |
+ |
if Result = sqltEOL then |
1564 |
+ |
FString := FString + LineEnding |
1565 |
+ |
else |
1566 |
|
FString := FString + C; |
1567 |
|
end; |
1568 |
|
|
1643 |
|
sqltNumberString: |
1644 |
|
if FNextToken in [sqltNumberString,sqltPeriod] then |
1645 |
|
FState := stInNumeric; |
1646 |
+ |
|
1647 |
+ |
sqltEOL: |
1648 |
+ |
FString := LineEnding; |
1649 |
|
end; |
1650 |
|
end; |
1651 |
|
end; |
1655 |
|
until TokenFound(Result) or EOF; |
1656 |
|
end; |
1657 |
|
|
1658 |
+ |
function ParseDateTimeTZString(aDateTimeStr: Ansistring; var aDateTime: TDateTime; |
1659 |
+ |
var aTimezone: AnsiString; TimeOnly: boolean): boolean; |
1660 |
+ |
{$IF declared(TFormatSettings)} |
1661 |
+ |
begin |
1662 |
+ |
{$IF declared(DefaultFormatSettings)} |
1663 |
+ |
Result := ParseDateTimeTZString(aDateTimeStr,aDateTime,aTimeZone,DefaultFormatSettings,TimeOnly); |
1664 |
+ |
{$ELSE} |
1665 |
+ |
{$IF declared(FormatSettings)} |
1666 |
+ |
Result := ParseDateTimeTZString(aDateTimeStr,aDateTime,aTimeZone,FormatSettings,TimeOnly); |
1667 |
+ |
{$IFEND} {$IFEND} |
1668 |
+ |
end; |
1669 |
+ |
|
1670 |
+ |
function ParseDateTimeTZString(aDateTimeStr: Ansistring; var aDateTime: TDateTime; |
1671 |
+ |
var aTimezone: AnsiString; aFormatSettings: TFormatSettings; TimeOnly: boolean=false): boolean; |
1672 |
+ |
{$IFEND} |
1673 |
+ |
const |
1674 |
+ |
whitespacechars = [' ',#$09,#$0A,#$0D]; |
1675 |
+ |
var i,j,l: integer; |
1676 |
+ |
aTime: TDateTime; |
1677 |
+ |
DMs: longint; |
1678 |
+ |
begin |
1679 |
+ |
Result := false; |
1680 |
+ |
aTimezone := ''; |
1681 |
+ |
if aDateTimeStr <> '' then |
1682 |
+ |
{$if declared(TFormatSettings)} |
1683 |
+ |
with aFormatSettings do |
1684 |
+ |
{$IFEND} |
1685 |
+ |
begin |
1686 |
+ |
aDateTime := 0; |
1687 |
+ |
{Parse to get time zone info} |
1688 |
+ |
i := 1; |
1689 |
+ |
while (i <= length(aDateTimeStr)) and (aDateTimeStr[i] in whitespacechars) do inc(i); {skip white space} |
1690 |
+ |
if not TimeOnly then |
1691 |
+ |
begin |
1692 |
+ |
{decode date} |
1693 |
+ |
j := i; |
1694 |
+ |
while (j <= length(aDateTimeStr)) and (aDateTimeStr[j] in ['0'..'9',DateSeparator]) do inc(j); |
1695 |
+ |
if TryStrToDate(system.copy(aDateTimeStr,i,j-i),aDateTime) then |
1696 |
+ |
i := j; {otherwise start again i.e. assume time only} |
1697 |
+ |
end; |
1698 |
+ |
|
1699 |
+ |
while (i <= length(aDateTimeStr)) and (aDateTimeStr[i] in whitespacechars) do inc(i); {skip white space} |
1700 |
+ |
{decode time} |
1701 |
+ |
j := i; |
1702 |
+ |
while (j <= length(aDateTimeStr)) and (aDateTimeStr[j] in ['0'..'9',TimeSeparator]) do inc(j); |
1703 |
+ |
Result := TryStrToTime(system.copy(aDateTimeStr,i,j-i),aTime); |
1704 |
+ |
if not Result then Exit; |
1705 |
+ |
aDateTime := aDateTime + aTime; |
1706 |
+ |
i := j; |
1707 |
+ |
|
1708 |
+ |
{is there a factional second part} |
1709 |
+ |
if (i <= length(aDateTimeStr)) and (aDateTimeStr[i] = '.') then |
1710 |
+ |
begin |
1711 |
+ |
inc(i); |
1712 |
+ |
inc(j); |
1713 |
+ |
while (j <= Length(aDateTimeStr)) and (aDateTimeStr[j] in ['0'..'9']) do inc(j); |
1714 |
+ |
if j > i then |
1715 |
+ |
begin |
1716 |
+ |
l := j-i; |
1717 |
+ |
if l > 4 then l := 4; |
1718 |
+ |
Result := TryStrToInt(system.copy(aDateTimeStr,i,l),DMs); |
1719 |
+ |
if not Result then Exit; |
1720 |
+ |
|
1721 |
+ |
{adjust for number of significant digits} |
1722 |
+ |
case l of |
1723 |
+ |
3: DMs := DMs * 10; |
1724 |
+ |
2: DMs := DMs * 100; |
1725 |
+ |
1: DMs := DMs * 1000; |
1726 |
+ |
end; |
1727 |
+ |
aDateTime := aDateTime + (DMs / (MsecsPerDay*10)); |
1728 |
+ |
end; |
1729 |
+ |
end; |
1730 |
+ |
i := j; |
1731 |
+ |
|
1732 |
+ |
while (i <= length(aDateTimeStr)) and (aDateTimeStr[i] in whitespacechars) do inc(i); {skip white space} |
1733 |
+ |
{decode time zone} |
1734 |
+ |
if i < length(aDateTimeStr) then |
1735 |
+ |
begin |
1736 |
+ |
j := i; |
1737 |
+ |
while (j <= length(aDateTimeStr)) and not (aDateTimeStr[j] in whitespacechars) do inc(j); |
1738 |
+ |
aTimezone := system.copy(aDateTimeStr,i,j-i); |
1739 |
+ |
end; |
1740 |
+ |
Result := true; |
1741 |
+ |
end |
1742 |
+ |
end; |
1743 |
+ |
|
1744 |
+ |
{The following is similar to FPC DecodeTime except that the Firebird standard |
1745 |
+ |
decimilliseconds is used instead of milliseconds for fractional seconds} |
1746 |
+ |
|
1747 |
+ |
procedure FBDecodeTime(aTime: TDateTime; var Hour, Minute, Second: word; |
1748 |
+ |
var DeciMillisecond: cardinal); |
1749 |
+ |
var D : Double; |
1750 |
+ |
l : cardinal; |
1751 |
+ |
begin |
1752 |
+ |
{conversion to decimilliseconds hacked from FPC DateTimeToTimeStamp} |
1753 |
+ |
D := aTime * MSecsPerDay *10; |
1754 |
+ |
if D < 0 then |
1755 |
+ |
D := D - 0.5 |
1756 |
+ |
else |
1757 |
+ |
D := D + 0.5; |
1758 |
+ |
{rest hacked from FPC DecodeTIme} |
1759 |
+ |
l := Abs(Trunc(D)) Mod (MSecsPerDay*10); |
1760 |
+ |
Hour := l div 36000000; |
1761 |
+ |
l := l mod 36000000; |
1762 |
+ |
Minute := l div 600000; |
1763 |
+ |
l := l mod 600000; |
1764 |
+ |
Second := l div 10000; |
1765 |
+ |
DeciMillisecond := l mod 10000; |
1766 |
+ |
end; |
1767 |
+ |
|
1768 |
+ |
{The following is similar to FPC EncodeTime except that the Firebird standard |
1769 |
+ |
decimilliseconds is used instead of milliseconds for fractional seconds} |
1770 |
+ |
|
1771 |
+ |
function FBEncodeTime(Hour, Minute, Second, DeciMillisecond: cardinal): TDateTime; |
1772 |
+ |
const DMSecsPerDay = MSecsPerDay*10; |
1773 |
+ |
var DMs: cardinal; |
1774 |
+ |
D: Double; |
1775 |
+ |
begin |
1776 |
+ |
if (Hour<24) and (Minute<60) and (Second<60) and (DeciMillisecond<10000) then |
1777 |
+ |
begin |
1778 |
+ |
DMs := Hour*36000000+Minute*600000+Second*10000+DeciMillisecond; |
1779 |
+ |
D := DMs/DMSecsPerDay; |
1780 |
+ |
Result:=TDateTime(d) |
1781 |
+ |
end |
1782 |
+ |
else |
1783 |
+ |
IBError(ibxeBadTimeSpecification,[Hour, Minute, Second, DeciMillisecond]); |
1784 |
+ |
end; |
1785 |
+ |
|
1786 |
+ |
{The following is similar to FPC FormatDateTime except that it additionally |
1787 |
+ |
allows the timstamp to have a fractional seconds component with a resolution |
1788 |
+ |
of four decimal places. This is appended to the result for FormatDateTime |
1789 |
+ |
if the format string contains a "zzzz' string.} |
1790 |
+ |
|
1791 |
+ |
function FBFormatDateTime(fmt: AnsiString; aDateTime: TDateTime): AnsiString; |
1792 |
+ |
var Hour, Minute, Second: word; |
1793 |
+ |
DeciMillisecond: cardinal; |
1794 |
+ |
begin |
1795 |
+ |
if Pos('zzzz',fmt) > 0 then |
1796 |
+ |
begin |
1797 |
+ |
FBDecodeTime(aDateTime, Hour, Minute, Second, DeciMillisecond); |
1798 |
+ |
fmt := StringReplace(fmt, 'zzzz', Format('%.4d',[DeciMillisecond]), [rfReplaceAll]); |
1799 |
+ |
end; |
1800 |
+ |
Result := FormatDateTime(fmt,aDateTime); |
1801 |
+ |
end; |
1802 |
+ |
|
1803 |
+ |
function FormatTimeZoneOffset(EffectiveTimeOffsetMins: integer): AnsiString; |
1804 |
+ |
begin |
1805 |
+ |
if EffectiveTimeOffsetMins > 0 then |
1806 |
+ |
Result := Format('+%.2d:%.2d',[EffectiveTimeOffsetMins div 60,abs(EffectiveTimeOffsetMins mod 60)]) |
1807 |
+ |
else |
1808 |
+ |
Result := Format('%.2d:%.2d',[EffectiveTimeOffsetMins div 60,abs(EffectiveTimeOffsetMins mod 60)]); |
1809 |
+ |
end; |
1810 |
+ |
|
1811 |
+ |
function DecodeTimeZoneOffset(TZOffset: AnsiString; var dstOffset: integer): boolean; |
1812 |
+ |
var i: integer; |
1813 |
+ |
begin |
1814 |
+ |
Result := false; |
1815 |
+ |
TZOffset := Trim(TZOffset); |
1816 |
+ |
for i := 1 to Length(TZOffset) do |
1817 |
+ |
if not (TZOffset[i] in ['0'..'9','-','+',':']) then Exit; |
1818 |
+ |
|
1819 |
+ |
Result := true; |
1820 |
+ |
i := Pos(':',TZOffset); |
1821 |
+ |
if i > 0 then |
1822 |
+ |
dstOffset := StrToInt(copy(TZOffset,1,i-1)) * 60 + StrToInt(copy(TZOffset,i + 1)) |
1823 |
+ |
else |
1824 |
+ |
dstOffset := StrToInt(TZOffset) * 60; |
1825 |
+ |
end; |
1826 |
+ |
|
1827 |
+ |
function StripLeadingZeros(Value: AnsiString): AnsiString; |
1828 |
+ |
var i: Integer; |
1829 |
+ |
start: integer; |
1830 |
+ |
begin |
1831 |
+ |
Result := ''; |
1832 |
+ |
start := 1; |
1833 |
+ |
if (Length(Value) > 0) and (Value[1] = '-') then |
1834 |
+ |
begin |
1835 |
+ |
Result := '-'; |
1836 |
+ |
start := 2; |
1837 |
+ |
end; |
1838 |
+ |
for i := start to Length(Value) do |
1839 |
+ |
if Value[i] <> '0' then |
1840 |
+ |
begin |
1841 |
+ |
Result := Result + system.copy(Value, i, MaxInt); |
1842 |
+ |
Exit; |
1843 |
+ |
end; |
1844 |
+ |
end; |
1845 |
+ |
|
1846 |
+ |
function TryStrToNumeric(S: Ansistring; out Value: int64; out scale: integer): boolean; |
1847 |
+ |
var i: integer; |
1848 |
+ |
ds: integer; |
1849 |
+ |
exponent: integer; |
1850 |
+ |
begin |
1851 |
+ |
Result := false; |
1852 |
+ |
ds := 0; |
1853 |
+ |
exponent := 0; |
1854 |
+ |
S := Trim(S); |
1855 |
+ |
Value := 0; |
1856 |
+ |
scale := 0; |
1857 |
+ |
if Length(S) = 0 then |
1858 |
+ |
Exit; |
1859 |
+ |
{$IF declared(DefaultFormatSettings)} |
1860 |
+ |
with DefaultFormatSettings do |
1861 |
+ |
{$ELSE} |
1862 |
+ |
{$IF declared(FormatSettings)} |
1863 |
+ |
with FormatSettings do |
1864 |
+ |
{$IFEND} |
1865 |
+ |
{$IFEND} |
1866 |
+ |
begin |
1867 |
+ |
{ThousandSeparator not allowed as by Delphi specs} |
1868 |
+ |
if (ThousandSeparator <> DecimalSeparator) and |
1869 |
+ |
(Pos(ThousandSeparator, S) <> 0) then |
1870 |
+ |
Exit; |
1871 |
+ |
|
1872 |
+ |
for i := length(S) downto 1 do |
1873 |
+ |
begin |
1874 |
+ |
if S[i] = AnsiChar(DecimalSeparator) then |
1875 |
+ |
begin |
1876 |
+ |
if ds <> 0 then Exit; {only one allowed} |
1877 |
+ |
ds := i-1; |
1878 |
+ |
dec(exponent); |
1879 |
+ |
system.Delete(S,i,1); |
1880 |
+ |
end |
1881 |
+ |
else |
1882 |
+ |
if (i > 1) and (S[i] in ['+','-']) and not (S[i-1] in ['e','E']) then |
1883 |
+ |
Exit {malformed} |
1884 |
+ |
else |
1885 |
+ |
if S[i] in ['e','E'] then {scientific notation} |
1886 |
+ |
begin |
1887 |
+ |
if ds <> 0 then Exit; {not permitted in exponent} |
1888 |
+ |
if exponent <> 0 then Exit; {only one allowed} |
1889 |
+ |
exponent := i; |
1890 |
+ |
end |
1891 |
+ |
else |
1892 |
+ |
if not (S[i] in ['0'..'9']) then |
1893 |
+ |
Exit; {bad character} |
1894 |
+ |
end; |
1895 |
+ |
|
1896 |
+ |
if exponent > 0 then |
1897 |
+ |
begin |
1898 |
+ |
Result := TryStrToInt(system.copy(S,exponent+1,maxint),Scale); |
1899 |
+ |
if Result then |
1900 |
+ |
begin |
1901 |
+ |
{adjust scale for decimal point} |
1902 |
+ |
Scale := Scale - (exponent - ds - 1); |
1903 |
+ |
Result := TryStrToInt64(system.copy(S,1,exponent-1),Value); |
1904 |
+ |
end; |
1905 |
+ |
end |
1906 |
+ |
else |
1907 |
+ |
begin |
1908 |
+ |
if ds <> 0 then |
1909 |
+ |
scale := ds - Length(S); |
1910 |
+ |
Result := TryStrToInt64(S,Value); |
1911 |
+ |
end; |
1912 |
+ |
end; |
1913 |
+ |
end; |
1914 |
+ |
|
1915 |
+ |
function NumericToDouble(aValue: Int64; aScale: integer): double; |
1916 |
+ |
begin |
1917 |
+ |
Result := aValue * IntPower(10,aScale) |
1918 |
+ |
end; |
1919 |
+ |
|
1920 |
|
end. |