Functions wikifmt: Difference between revisions

From NEOSYS Dev Wiki
Jump to navigationJump to search
No edit summary
No edit summary
Line 1: Line 1:
==== Complete List of Functions ====
==== Complete List of Functions ====


Generated by cli/gendoc from var.h 05 FEB 2025 15:35:25
Generated by cli/gendoc from var.h 06 FEB 2025 21:16:50


===== String Creation =====
===== String Creation =====
Line 8: Line 8:
!Usage!!Function!!Description
!Usage!!Function!!Description
|-
|-
|var=||num.<em>round</em>(ndecimals = 0)||Round decimal numbers to a desired number of decimal places<br>
|var=||num.<em>round</em>(ndecimals = 0)||<em>Returns:</em> A string representation of a decimal number rounded to a desired number of decimal places</p>
<em>Returns:</em> A var ASCII string with exact decimal places requested.<br>
<em>Returns:</em> A var ASCII string with exact decimal places requested.</p>
.5 always rounds away from zero.
.5 always rounds away from zero.
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 20: Line 20:
var v4 = round(-1.295, 2); // "-1.30"</syntaxhighlight>
var v4 = round(-1.295, 2); // "-1.30"</syntaxhighlight>
|-
|-
|var=||var().<em>chr</em>(num)||Create a string of a single char (byte) given an integer 0-255.<br>
|var=||var().<em>chr</em>(num)||<em>Returns:</em> A string containing a single char (byte) given an integer 0-255.</p>
0-127 -> ASCII, 128-255 -> invalid UTF-8 so cannot be written to database or used various exodus string operations
0-127 -> ASCII, 128-255 -> invalid UTF-8 so cannot be written to database or used various exodus string operations
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 27: Line 27:
let v2 = chr(0x61);</syntaxhighlight>
let v2 = chr(0x61);</syntaxhighlight>
|-
|-
|var=||var().<em>textchr</em>(num)||Create a string of a single unicode code point in utf8 encoding.<br>
|var=||var().<em>textchr</em>(num)||<em>Returns:</em> A string of a single unicode code point in utf8 encoding.</p>
To get utf codepoints > 2^63 you must provide negative ints<br>
To get utf codepoints > 2^63 you must provide negative ints</p>
Not providing implicit constructor from var to unsigned int due to getting ambigious conversions<br>
Not providing implicit constructor from var to unsigned int due to getting ambigious conversions</p>
since int and unsigned int are parallel priority in c++ implicit conversions
since int and unsigned int are parallel priority in c++ implicit conversions
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 36: Line 36:
let v2 = textchr(171416);</syntaxhighlight>
let v2 = textchr(171416);</syntaxhighlight>
|-
|-
|var=||var().<em>str</em>(num)||Create a string by repeating a given character or string
|var=||var().<em>str</em>(num)||<em>Returns:</em> A string of repeating characters or strings
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
let v1 = "ab"_var.str(3); // "ababab"
let v1 = "ab"_var.str(3); // "ababab"
Line 42: Line 42:
let v2 = str("ab", 3);</syntaxhighlight>
let v2 = str("ab", 3);</syntaxhighlight>
|-
|-
|var=||num.<em>space</em>()||Create string of space characters.
|var=||num.<em>space</em>()||Returns A string of space characters.
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
let v1 = var(3).space(); // "␣␣␣"
let v1 = var(3).space(); // "␣␣␣"
Line 48: Line 48:
let v2 = space(3);</syntaxhighlight>
let v2 = space(3);</syntaxhighlight>
|-
|-
|var=||num.<em>numberinwords</em>(languagename_or_locale_id = "")||Create a string describing a given number in words<br>
|var=||num.<em>numberinwords</em>(languagename_or_locale_id = "")||<em>Returns:</em> A string representing a given number written in words instead of digits.
<br>
ein hundert drei und zwanzig Komma vier fünf
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
let softhyphen = "\xc2\xad";
let softhyphen = "\xc2\xad";
Line 78: Line 76:
let v2 = len("abc");</syntaxhighlight>
let v2 = len("abc");</syntaxhighlight>
|-
|-
|var=||strvar.<em>textwidth</em>()||<em>Returns:</em> The number of output columns.<br>
|var=||strvar.<em>textwidth</em>()||<em>Returns:</em> The number of output columns.</p>
Allows multi column unicode and reduces combining characters etc. like e followed by grave accent<br>
Allows multi column unicode and reduces combining characters etc. like e followed by grave accent</p>
Possibly does not properly calculate combining sequences of graphemes e.g. face followed by colour
Possibly does not properly calculate combining sequences of graphemes e.g. face followed by colour
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 92: Line 90:
let v2 = textlen("Γιάννης");</syntaxhighlight>
let v2 = textlen("Γιάννης");</syntaxhighlight>
|-
|-
|var=||strvar.<em>fcount</em>(sepstr)||<em>Returns:</em> The number of fields determined by presence of sepstr.<br>
|var=||strvar.<em>fcount</em>(sepstr)||<em>Returns:</em> The count of the number of fields separated by a given sepstr.</p>
It is the same as var.count(sepstr) + 1 except that fcount returns 0 for an empty string.
It is the same as var.count(sepstr) + 1 except that it returns 0 for an empty string.
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
let v1 = "aa**cc"_var.fcount("*"); // 3
let v1 = "aa**cc"_var.fcount("*"); // 3
Line 99: Line 97:
let v2 = fcount("aa**cc", "*");</syntaxhighlight>
let v2 = fcount("aa**cc", "*");</syntaxhighlight>
|-
|-
|var=||strvar.<em>count</em>(sepstr)||<em>Returns</em> the number of sepstr found
|var=||strvar.<em>count</em>(sepstr)||<em>Returns:</em> The count of the number of sepstr found.
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
let v1 = "aa**cc"_var.count("*"); // 2
let v1 = "aa**cc"_var.count("*"); // 2
Line 123: Line 121:
if (contains("abcd", "bc")) ... true</syntaxhighlight>
if (contains("abcd", "bc")) ... true</syntaxhighlight>
|-
|-
|var=||strvar.<em>index</em>(substr, startchar1 = 1)||<em>Returns:</em> Char no if found or 0 if not. startchar1 is byte no to start at.
|var=||strvar.<em>index</em>(substr, startchar1 = 1)||<em>Returns:</em> The index (1 based position) of a given substr on or after a given starting char number if present</p>
<em>Returns:</em> 0 if not present.
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
let v1 = "abcd"_var.index("bc"); // 2
let v1 = "abcd"_var.index("bc"); // 2
Line 129: Line 128:
let v2 = index("abcd", "bc");</syntaxhighlight>
let v2 = index("abcd", "bc");</syntaxhighlight>
|-
|-
|var=||strvar.<em>indexn</em>(substr, occurrence)||ditto. Occurrence 1 = find first occurrence
|var=||strvar.<em>indexn</em>(substr, occurrence)||<em>Returns:</em> The index (1 based position) of the nth occurrence of a given substr if present</p>
<em>Returns:</em> 0 if not present.
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
let v1 = "abcabc"_var.index("bc", 2); // 2
let v1 = "abcabc"_var.index("bc", 2); // 2
Line 135: Line 135:
let v2 = index("abcabc", "bc", 2);</syntaxhighlight>
let v2 = index("abcabc", "bc", 2);</syntaxhighlight>
|-
|-
|var=||strvar.<em>indexr</em>(substr, startchar1 = -1)||ditto. Reverse search.<br>
|var=||strvar.<em>indexr</em>(substr, startchar1 = -1)||Reverse substr search.</p>
startchar1 defaults to -1 meaning start searching from the last byte (towards the first byte).
<em>Returns:</em> The index (1 based position) of the substr on or before a given starting char number if present</p>
startchar1 defaults to -1 meaning start searching from the last char (towards the first char).
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
let v1 = "abcabc"_var.indexr("bc"); // 5
let v1 = "abcabc"_var.indexr("bc"); // 5
Line 142: Line 143:
let v2 = indexr("abcabc", "bc");</syntaxhighlight>
let v2 = indexr("abcabc", "bc");</syntaxhighlight>
|-
|-
|var=||strvar.<em>match</em>(regex_str, regex_options = "")||<em>Returns:</em> All results of regex matching<br>
|var=||strvar.<em>match</em>(regex_str, regex_options = "")||<em>Returns:</em> All results of regex matching</p>
Multiple matches are in fields. Groups are in values
Multiple matches are returns in fields. Groups are in values
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
let v1 = "abc1abc2"_var.match("BC(\\d)", "i"); // "bc1]1^bc2]2"_var
let v1 = "abc1abc2"_var.match("BC(\\d)", "i"); // "bc1]1^bc2]2"_var
// or
// or
let v2 = match("abc1abc2", "BC(\\d)", "i");</syntaxhighlight>
let v2 = match("abc1abc2", "BC(\\d)", "i");</syntaxhighlight>
regex_options:<br>
regex_options:</p>
<br>
</p>
l - Literal (any regex chars are treated as normal chars)<br>
l - Literal (any regex chars are treated as normal chars)</p>
<br>
</p>
i - Case insensitive<br>
i - Case insensitive</p>
<br>
</p>
p - ECMAScript/Perl (the default)<br>
p - ECMAScript/Perl (the default)</p>
b - Basic POSIX (same as sed)<br>
b - Basic POSIX (same as sed)</p>
e - Extended POSIX<br>
e - Extended POSIX</p>
a - awk<br>
a - awk</p>
g - grep<br>
g - grep</p>
eg - egrep or grep -E<br>
eg - egrep or grep -E</p>
<br>
</p>
char ranges like a-z are locale sensitive if ECMAScript<br>
char ranges like a-z are locale sensitive if ECMAScript</p>
<br>
</p>
m - Multiline. Default in boost (and therefore exodus)<br>
m - Multiline. Default in boost (and therefore exodus)</p>
s - Single line. Default in std::regex<br>
s - Single line. Default in std::regex</p>
<br>
</p>
f - First only. Only for replace() (not match() or search())<br>
f - First only. Only for replace() (not match() or search())</p>
<br>
</p>
w - Wildcard glob style (e.g. *.cfg) not regex style. Only for match() and search(). Not replace().
w - Wildcard glob style (e.g. *.cfg) not regex style. Only for match() and search(). Not replace().
|-
|-
|var=||strvar.<em>match</em>(regex)||Ditto
|var=||strvar.<em>match</em>(regex)||Ditto
|-
|-
|var=||strvar.<em>search</em>(regex_str, io startchar1, regex_options = "")||Search for first match of a regular expression starting at startchar1<br>
|var=||strvar.<em>search</em>(regex_str, io startchar1, regex_options = "")||Search for first match of a regular expression starting at startchar1</p>
Updates startchar1 ready to search for the next match<br>
Updates startchar1 ready to search for the next match</p>
regex_options as for match()
regex_options as for match()
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 390: Line 391:
let v2 = replace("Abc Abc", "bc", "X");</syntaxhighlight>
let v2 = replace("Abc Abc", "bc", "X");</syntaxhighlight>
|-
|-
|var=||strvar.<em>replace</em>(regex, tostr)||Replace substring(s) using a regular expression.<br>
|var=||strvar.<em>replace</em>(regex, tostr)||Replace substring(s) using a regular expression.</p>
Use $0, $1, $2 in tostr to refer to groups defined in the regex.
Use $0, $1, $2 in tostr to refer to groups defined in the regex.
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 403: Line 404:
let v2 = unique("a1^b2^a1^c2"_var);</syntaxhighlight>
let v2 = unique("a1^b2^a1^c2"_var);</syntaxhighlight>
|-
|-
|var=||strvar.<em>sort</em>(sepchar = FM)||Reorder fields in an FM or VM etc. separated list in ascending order<br>
|var=||strvar.<em>sort</em>(sepchar = FM)||Reorder fields in an FM or VM etc. separated list in ascending order</p>
Numerical
Numerical
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 438: Line 439:
!Usage!!Function!!Description
!Usage!!Function!!Description
|-
|-
|cmd||strvar.<em>ucaser</em>()||Upper case<br>
|cmd||strvar.<em>ucaser</em>()||Upper case</p>
All string mutators follow the same pattern as ucaser. See the non-mutating functions for details.
All string mutators follow the same pattern as ucaser. See the non-mutating functions for details.
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 523: Line 524:
!Usage!!Function!!Description
!Usage!!Function!!Description
|-
|-
|var=||strvar.<em>hash</em>(std::uint64_t modulus = 0)||Hash by default returns a 64 bit signed integer as a var.<br>
|var=||strvar.<em>hash</em>(std::uint64_t modulus = 0)||Hash by default returns a 64 bit signed integer as a var.</p>
If a modulus is provided then the result is limited to [0, modulus)<br>
If a modulus is provided then the result is limited to [0, modulus)</p>
MurmurHash3 is used.
MurmurHash3 is used.
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 531: Line 532:
let v2 = hash("abc");</syntaxhighlight>
let v2 = hash("abc");</syntaxhighlight>
|-
|-
|var=||strvar.<em>substr</em>(pos1, delimiterchars, io pos2)||substr version 3.<br>
|var=||strvar.<em>substr</em>(pos1, delimiterchars, io pos2)||substr version 3.</p>
Extract a substr starting from pos1 up to any one of some given delimiter chars<br>
Extract a substr starting from pos1 up to any one of some given delimiter chars</p>
Also returns in pos2 the pos of the following delimiter or one past the end of the string if not found.<br>
Also returns in pos2 the pos of the following delimiter or one past the end of the string if not found.</p>
Add 1 to pos2 start the next search if continuing.
Add 1 to pos2 start the next search if continuing.
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 544: Line 545:
|var=||strvar.<em>b</em>(pos1, delimiterchars, io pos2)||Alias of substr version 3.
|var=||strvar.<em>b</em>(pos1, delimiterchars, io pos2)||Alias of substr version 3.
|-
|-
|var=||strvar.<em>substr2</em>(io pos1, out delimiterno)||substr version 4.<br>
|var=||strvar.<em>substr2</em>(io pos1, out delimiterno)||substr version 4.</p>
<em>Returns:</em> A substr from a given pos1 up to the next RM/FM/VM/SM/TM/ST delimiter char.<br>
<em>Returns:</em> A substr from a given pos1 up to the next RM/FM/VM/SM/TM/ST delimiter char.</p>
Also returns the next index/offset and the delimiter no. found (1-6) or 0 if not found.
Also returns the next index/offset and the delimiter no. found (1-6) or 0 if not found.
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 562: Line 563:
let v2 = field("aa*bb*cc", "*", 2);</syntaxhighlight>
let v2 = field("aa*bb*cc", "*", 2);</syntaxhighlight>
|-
|-
|var=||strvar.<em>field2</em>(separator, fieldno, nfields = 1)||field2 is a version that treats fieldn -1 as the last field, -2 the penultimate field etc. -<br>
|var=||strvar.<em>field2</em>(separator, fieldno, nfields = 1)||field2 is a version that treats fieldn -1 as the last field, -2 the penultimate field etc. -</p>
TODO Should probably make field() do this (since -1 is basically an erroneous call) and remove field2<br>
TODO Should probably make field() do this (since -1 is basically an erroneous call) and remove field2</p>
Same as var.field() but negative fieldnos work backwards from the last field.
Same as var.field() but negative fieldnos work backwards from the last field.
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 575: Line 576:
!Usage!!Function!!Description
!Usage!!Function!!Description
|-
|-
|var=||var.<em>oconv</em>(convstr)||Converts internal data to output external display format according to a given conversion code or pattern<br>
|var=||var.<em>oconv</em>(convstr)||Converts internal data to output external display format according to a given conversion code or pattern</p>
If the internal data is invalid and cannot be converted then most conversions return the ORIGINAL data unconverted<br>
If the internal data is invalid and cannot be converted then most conversions return the ORIGINAL data unconverted</p>
Throws a runtime error VarNotImplemented if convstr is invalid<br>
Throws a runtime error VarNotImplemented if convstr is invalid</p>
See [[#ICONV/OCONV PATTERNS]]
See [[#ICONV/OCONV PATTERNS]]
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 584: Line 585:
let v2 = oconv(30123, "D/E");</syntaxhighlight>
let v2 = oconv(30123, "D/E");</syntaxhighlight>
|-
|-
|var=||var.<em>iconv</em>(convstr)||Converts external data to internal format according to a given conversion code or pattern<br>
|var=||var.<em>iconv</em>(convstr)||Converts external data to internal format according to a given conversion code or pattern</p>
If the external data is invalid and cannot be converted then most conversions return the EMPTY STRING ""<br>
If the external data is invalid and cannot be converted then most conversions return the EMPTY STRING ""</p>
Throws a runtime error VarNotImplemented if convstr is invalid<br>
Throws a runtime error VarNotImplemented if convstr is invalid</p>
See [[#ICONV/OCONV PATTERNS]]
See [[#ICONV/OCONV PATTERNS]]
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 593: Line 594:
let v2 = iconv("21 JUN 2050", "D/E");</syntaxhighlight>
let v2 = iconv("21 JUN 2050", "D/E");</syntaxhighlight>
|-
|-
|var=||var.<em>format</em>(fmt_str, Args&&... args)||Classic format function in printf style<br>
|var=||var.<em>format</em>(fmt_str, Args&&... args)||Classic format function in printf style</p>
vars can be formatted either with C++ format codes e.g. {:_>8.2f}<br>
vars can be formatted either with C++ format codes e.g. {:_>8.2f}</p>
or with exodus oconv codes e.g. {::MD20P|R(_)#8} as in the below example.
or with exodus oconv codes e.g. {::MD20P|R(_)#8} as in the below example.
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 603: Line 604:
var v4 = format("'{::MD20P|R(_)#8}'", var(12.345));</syntaxhighlight>
var v4 = format("'{::MD20P|R(_)#8}'", var(12.345));</syntaxhighlight>
|-
|-
|var=||strvar.<em>from_codepage</em>(codepage)||Converts from codepage encoded text to UTF-8 encoded text<br>
|var=||strvar.<em>from_codepage</em>(codepage)||Converts from codepage encoded text to UTF-8 encoded text</p>
e.g. Codepage "CP1124" (Ukrainian).<br>
e.g. Codepage "CP1124" (Ukrainian).</p>
Use Linux command "iconv -l" for complete list of code pages and encodings.
Use Linux command "iconv -l" for complete list of code pages and encodings.
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 623: Line 624:
!Usage!!Function!!Description
!Usage!!Function!!Description
|-
|-
|var=||strvar.<em>f</em>(fieldno, valueno = 0, subvalueno = 0)||f() is a highly abbreviated alias for the PICK OS field/value/subvalue extract() function.<br>
|var=||strvar.<em>f</em>(fieldno, valueno = 0, subvalueno = 0)||f() is a highly abbreviated alias for the PICK OS field/value/subvalue extract() function.</p>
"f()" can be thought of as "field" although the function can extract values and subvalues as well.<br>
"f()" can be thought of as "field" although the function can extract values and subvalues as well.</p>
The convenient PICK OS angle bracket syntax for field extraction (e.g. xxx<20>) is not available in C++.<br>
The convenient PICK OS angle bracket syntax for field extraction (e.g. xxx<20>) is not available in C++.</p>
The abbreviated exodus field extraction function (e.g. xxx.f(20)) is provided instead since field access is extremely heavily used in source code.
The abbreviated exodus field extraction function (e.g. xxx.f(20)) is provided instead since field access is extremely heavily used in source code.
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 651: Line 652:
|var=||strvar.<em>insert</em>(fieldno, insertion)||Ditto for a specific field
|var=||strvar.<em>insert</em>(fieldno, insertion)||Ditto for a specific field
|-
|-
|var=||strvar.<em>remove</em>(fieldno, valueno = 0, subvalueno = 0)||Same as var.remover() function but returns a new string instead of updating a variable in place.<br>
|var=||strvar.<em>remove</em>(fieldno, valueno = 0, subvalueno = 0)||Same as var.remover() function but returns a new string instead of updating a variable in place.</p>
"remove" was called "delete" in Pick OS.
"remove" was called "delete" in Pick OS.
|}
|}
Line 734: Line 735:
!Usage!!Function!!Description
!Usage!!Function!!Description
|-
|-
|if||strvar.<em>locate</em>(target)||locate() with only the target substr argument provided searches unordered values separated by VM chars.<br>
|if||strvar.<em>locate</em>(target)||locate() with only the target substr argument provided searches unordered values separated by VM chars.</p>
<em>Returns:</em> True if found and false if not.
<em>Returns:</em> True if found and false if not.
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 741: Line 742:
if (locate("US", "UK]US]UA"_var)) ... ok</syntaxhighlight>
if (locate("US", "UK]US]UA"_var)) ... ok</syntaxhighlight>
|-
|-
|if||strvar.<em>locate</em>(target, out valueno)||locate() with only the target substr and valueno arguments provided searches unordered values separated by VM chars.<br>
|if||strvar.<em>locate</em>(target, out valueno)||locate() with only the target substr and valueno arguments provided searches unordered values separated by VM chars.</p>
<em>Returns:</em> True if found and with the value number in valueno.<br>
<em>Returns:</em> True if found and with the value number in valueno.</p>
<em>Returns:</em> False if not found and with the max value number + 1 in setting. Suitable for additiom of new values
<em>Returns:</em> False if not found and with the max value number + 1 in setting. Suitable for additiom of new values
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 748: Line 749:
if ("UK]US]UA"_var.locate("US", valueno)) ... ok // valueno -> 2</syntaxhighlight>
if ("UK]US]UA"_var.locate("US", valueno)) ... ok // valueno -> 2</syntaxhighlight>
|-
|-
|if||strvar.<em>locate</em>(target, out setting, fieldno, valueno = 0)||locate() the target in unordered fields if fieldno is 0, or values if a fieldno is specified, or subvalues if the valueno argument is provided.<br>
|if||strvar.<em>locate</em>(target, out setting, fieldno, valueno = 0)||locate() the target in unordered fields if fieldno is 0, or values if a fieldno is specified, or subvalues if the valueno argument is provided.</p>
<em>Returns:</em> True if found and with the field, value or subvalue number in setting.<br>
<em>Returns:</em> True if found and with the field, value or subvalue number in setting.</p>
<em>Returns:</em> False if not found and with the max field, value or subvalue number found + 1 in setting. Suitable for replacement of new fields, values or subvalues.
<em>Returns:</em> False if not found and with the max field, value or subvalue number found + 1 in setting. Suitable for replacement of new fields, values or subvalues.
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 755: Line 756:
if ("f1^f2v1]f2v2]s1}s2}s3}s4^f3^f4"_var.locate("s4", setting, 2, 3)) ... ok // setting -> 4 // returns true</syntaxhighlight>
if ("f1^f2v1]f2v2]s1}s2}s3}s4^f3^f4"_var.locate("s4", setting, 2, 3)) ... ok // setting -> 4 // returns true</syntaxhighlight>
|-
|-
|if||strvar.<em>locateby</em>(ordercode, target, out valueno)||locateby() without fieldno or valueno arguments searches ordered values separated by VM chars.<br>
|if||strvar.<em>locateby</em>(ordercode, target, out valueno)||locateby() without fieldno or valueno arguments searches ordered values separated by VM chars.</p>
The order code can be AL, DL, AR, DR meaning Ascending Left, Descending Right, Ascending Right, Ascending Left.<br>
The order code can be AL, DL, AR, DR meaning Ascending Left, Descending Right, Ascending Right, Ascending Left.</p>
Left is used to indicate alphabetic order where 10 < 2.<br>
Left is used to indicate alphabetic order where 10 < 2.</p>
Right is used to indicate numeric order where 10 > 2.<br>
Right is used to indicate numeric order where 10 > 2.</p>
Data must be in the correct order for searching to work properly.<br>
Data must be in the correct order for searching to work properly.</p>
<em>Returns:</em> True if found.<br>
<em>Returns:</em> True if found.</p>
In case the target is not exactly found then the correct value no for inserting the target is returned in setting.
In case the target is not exactly found then the correct value no for inserting the target is returned in setting.
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 774: Line 775:
if ("AB,EF,CD"_var.locateusing(",", "EF")) ... ok</syntaxhighlight>
if ("AB,EF,CD"_var.locateusing(",", "EF")) ... ok</syntaxhighlight>
|-
|-
|if||strvar.<em>locateusing</em>(usingchar, target, out setting, fieldno = 0, valueno = 0, subvalueno = 0)||locate() the target in a specific field, value or subvalue using a specified delimiter and unordered data<br>
|if||strvar.<em>locateusing</em>(usingchar, target, out setting, fieldno = 0, valueno = 0, subvalueno = 0)||locate() the target in a specific field, value or subvalue using a specified delimiter and unordered data</p>
<em>Returns:</em> True If found and returns in setting the number of the delimited field found.<br>
<em>Returns:</em> True If found and returns in setting the number of the delimited field found.</p>
<em>Returns:</em> False if not found and returns in setting the maximum number of delimited fields + 1 if not found.<br>
<em>Returns:</em> False if not found and returns in setting the maximum number of delimited fields + 1 if not found.</p>
This is similar to the main locate command but the delimiter char can be specified e.g. a comma or TM etc.
This is similar to the main locate command but the delimiter char can be specified e.g. a comma or TM etc.
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 782: Line 783:
if ("f1^f2^f3c1,f3c2,f3c3^f4"_var.locateusing(",", "f3c2", setting, 3)) ... ok // setting -> 2 // returns true</syntaxhighlight>
if ("f1^f2^f3c1,f3c2,f3c3^f4"_var.locateusing(",", "f3c2", setting, 3)) ... ok // setting -> 2 // returns true</syntaxhighlight>
|-
|-
|if||strvar.<em>locatebyusing</em>(ordercode, usingchar, target, out setting, fieldno = 0, valueno = 0, subvalueno = 0)||locatebyusing() supports all the above features in a single function.<br>
|if||strvar.<em>locatebyusing</em>(ordercode, usingchar, target, out setting, fieldno = 0, valueno = 0, subvalueno = 0)||locatebyusing() supports all the above features in a single function.</p>
<em>Returns:</em> True if found.
<em>Returns:</em> True if found.
|}
|}
Line 790: Line 791:
!Usage!!Function!!Description
!Usage!!Function!!Description
|-
|-
|if||conn.<em>connect</em>(conninfo = "")||For all db operations, the operative var can either be a db connection created with dbconnect() or be any var and a default connection will be established on the fly.<br>
|if||conn.<em>connect</em>(conninfo = "")||For all db operations, the operative var can either be a db connection created with dbconnect() or be any var and a default connection will be established on the fly.</p>
The db connection string (conninfo) parameters are merged from the following places in descending priority.<br>
The db connection string (conninfo) parameters are merged from the following places in descending priority.</p>
1. Provided in connect()'s conninfo argument. See 4. for the complete list of parameters.<br>
1. Provided in connect()'s conninfo argument. See 4. for the complete list of parameters.</p>
2. Any environment variables EXO_HOST EXO_PORT EXO_USER EXO_DATA EXO_PASS EXO_TIME<br>
2. Any environment variables EXO_HOST EXO_PORT EXO_USER EXO_DATA EXO_PASS EXO_TIME</p>
3. Any parameters found in a configuration file at ~/.config/exodus/exodus.cfg<br>
3. Any parameters found in a configuration file at ~/.config/exodus/exodus.cfg</p>
4. The default conninfo is "host=127.0.0.1 port=5432 dbname=exodus user=exodus password=somesillysecret connect_timeout=10"<br>
4. The default conninfo is "host=127.0.0.1 port=5432 dbname=exodus user=exodus password=somesillysecret connect_timeout=10"</p>
Setting environment variable EXO_DBTRACE=1 will cause tracing of db interface including SQL commands.
Setting environment variable EXO_DBTRACE=1 will cause tracing of db interface including SQL commands.
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 805: Line 806:
if (not connect("exodus")) ...</syntaxhighlight>
if (not connect("exodus")) ...</syntaxhighlight>
|-
|-
|if||conn.<em>attach</em>(filenames)||Attach (connect) specific files by name to specific connections.<br>
|if||conn.<em>attach</em>(filenames)||Attach (connect) specific files by name to specific connections.</p>
It is not necessary to attach files before opening them. Attach is meant to control the defaults.<br>
It is not necessary to attach files before opening them. Attach is meant to control the defaults.</p>
For the remainder of the session, opening the db file by name without specifying a connection will automatically use the specified connection applies during the attach command.<br>
For the remainder of the session, opening the db file by name without specifying a connection will automatically use the specified connection applies during the attach command.</p>
If conn is not specified then filename will be attached to the default connection.<br>
If conn is not specified then filename will be attached to the default connection.</p>
Multiple file names must be separated by FM
Multiple file names must be separated by FM
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 836: Line 837:
if (rollbacktrans()) ... ok</syntaxhighlight>
if (rollbacktrans()) ... ok</syntaxhighlight>
|-
|-
|if||conn.<em>committrans</em>()||Commit a db transaction.<br>
|if||conn.<em>committrans</em>()||Commit a db transaction.</p>
<em>Returns:</em> True if successfully committed or if there was no transaction in progress, otherwise false.
<em>Returns:</em> True if successfully committed or if there was no transaction in progress, otherwise false.
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 843: Line 844:
if (committrans()) ... ok</syntaxhighlight>
if (committrans()) ... ok</syntaxhighlight>
|-
|-
|if||conn.<em>sqlexec</em>(sqlcmd)||Execute an sql command.<br>
|if||conn.<em>sqlexec</em>(sqlcmd)||Execute an sql command.</p>
<em>Returns:</em> True if there was no sql error otherwise lasterror() returns a detailed error message.
<em>Returns:</em> True if there was no sql error otherwise lasterror() returns a detailed error message.
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 850: Line 851:
if (sqlexec("vacuum")) ... ok</syntaxhighlight>
if (sqlexec("vacuum")) ... ok</syntaxhighlight>
|-
|-
|if||conn.<em>sqlexec</em>(sqlcmd, io response)||Execute an SQL command and capture the response.<br>
|if||conn.<em>sqlexec</em>(sqlcmd, io response)||Execute an SQL command and capture the response.</p>
<em>Returns:</em> True if there was no sql error otherwise ''response'' contains a detailed error message.<br>
<em>Returns:</em> True if there was no sql error otherwise response contains a detailed error message.</p>
response: Any rows and columns returned are separated by RM and FM respectively. The first row is the column names.<br>
response: Any rows and columns returned are separated by RM and FM respectively. The first row is the column names.</p>
Recommended: Don't use sql directly unless you must to manage or configure a database.
Recommended: Don't use sql directly unless you must to manage or configure a database.
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 867: Line 868:
disconnect();</syntaxhighlight>
disconnect();</syntaxhighlight>
|-
|-
|cmd||conn.<em>disconnectall</em>()||Closes all connections and frees process resources both locally and in the database server(s).<br>
|cmd||conn.<em>disconnectall</em>()||Closes all connections and frees process resources both locally and in the database server(s).</p>
All connections are closed automatically when a process terminates.
All connections are closed automatically when a process terminates.
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 874: Line 875:
disconnectall();</syntaxhighlight>
disconnectall();</syntaxhighlight>
|-
|-
|var=||conn.<em>lasterror</em>()||Get the last os or db error message.
|var=||conn.<em>lasterror</em>()||<em>Returns:</em> The last os or db error message.
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
var v1 = var().lasterror();
var v1 = var().lasterror();
Line 880: Line 881:
var v2 = lasterror();</syntaxhighlight>
var v2 = lasterror();</syntaxhighlight>
|-
|-
|var=||conn.<em>loglasterror</em>(source = "")||Log the last os or db error message.<br>
|var=||conn.<em>loglasterror</em>(source = "")||Log the last os or db error message.</p>
Output: to stdlog<br>
Output: to stdlog</p>
Prefixes the output with ''source'' if provided.
Prefixes the output with source if provided.
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
var().loglasterror("main:");
var().loglasterror("main:");
Line 893: Line 894:
!Usage!!Function!!Description
!Usage!!Function!!Description
|-
|-
|if||conn.<em>dbcreate</em>(new_dbname, old_dbname = "")||Create a named database on a particular connection.<br>
|if||conn.<em>dbcreate</em>(new_dbname, old_dbname = "")||Create a named database on a particular connection.</p>
The target database cannot already exist.<br>
The target database cannot already exist.</p>
Optionally copies an existing database from the same connection and which cannot have any current connections.
Optionally copies an existing database from the same connection and which cannot have any current connections.
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 903: Line 904:
if (dbcreate("xo_gendoc_testdb")) ...</syntaxhighlight>
if (dbcreate("xo_gendoc_testdb")) ...</syntaxhighlight>
|-
|-
|if||conn.<em>dbcopy</em>(from_dbname, to_dbname)||Create a named database as a copy of an existing database.<br>
|if||conn.<em>dbcopy</em>(from_dbname, to_dbname)||Create a named database as a copy of an existing database.</p>
The target database cannot already exist.<br>
The target database cannot already exist.</p>
The source database must exist on the same connection and cannot have any current connections.
The source database must exist on the same connection and cannot have any current connections.
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 919: Line 920:
let v2 = dblist();</syntaxhighlight>
let v2 = dblist();</syntaxhighlight>
|-
|-
|if||conn.<em>dbdelete</em>(dbname)||Delete (drop) a named database.<br>
|if||conn.<em>dbdelete</em>(dbname)||Delete (drop) a named database.</p>
The target database must exist and cannot have any current connections.
The target database must exist and cannot have any current connections.
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 969: Line 970:
var nrecs2 = reccount(filename);</syntaxhighlight>
var nrecs2 = reccount(filename);</syntaxhighlight>
|-
|-
|if||conn_or_file.<em>flushindex</em>(filename = "")||Calls db maintenance function (vacuum)<br>
|if||conn_or_file.<em>flushindex</em>(filename = "")||Calls db maintenance function (vacuum)</p>
This doesnt actually flush any indexes but does make sure that reccount() function is reasonably accurate.
This doesnt actually flush any indexes but does make sure that reccount() function is reasonably accurate.
|}
|}
Line 984: Line 985:
if (not open(filename to file)) ...</syntaxhighlight>
if (not open(filename to file)) ...</syntaxhighlight>
|-
|-
|cmd||file.<em>close</em>()||Closes db file var<br>
|cmd||file.<em>close</em>()||Closes db file var</p>
Does nothing currently since database file vars consume no resources
Does nothing currently since database file vars consume no resources
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 992: Line 993:
close(file);</syntaxhighlight>
close(file);</syntaxhighlight>
|-
|-
|if||file.<em>createindex</em>(fieldname, dictfile = "")||Creates a secondary index for a given db file and field name.<br>
|if||file.<em>createindex</em>(fieldname, dictfile = "")||Creates a secondary index for a given db file and field name.</p>
The fieldname must exist in a dictionary file. The default dictionary is "dict." ^ filename.<br>
The fieldname must exist in a dictionary file. The default dictionary is "dict." ^ filename.</p>
<em>Returns:</em> False if the index cannot be created for any reason.<br>
<em>Returns:</em> False if the index cannot be created for any reason.</p>
* Index already exists<br>
* Index already exists</p>
* File does not exist<br>
* File does not exist</p>
* The dictionary file does not have a record with a key of the given field name.<br>
* The dictionary file does not have a record with a key of the given field name.</p>
* The dictionary file does not exist. Default is "dict." ^ filename.<br>
* The dictionary file does not exist. Default is "dict." ^ filename.</p>
* The dictionary field defines a calculated field that uses an exodus function. Using a psql function is OK.
* The dictionary field defines a calculated field that uses an exodus function. Using a psql function is OK.
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 1,007: Line 1,008:
if (createindex(filename, fieldname)) ...</syntaxhighlight>
if (createindex(filename, fieldname)) ...</syntaxhighlight>
|-
|-
|var=||file|conn.<em>listindex</em>(file_or_filename = "", fieldname = "")||Lists secondary indexes in a database or for a db file<br>
|var=||file|conn.<em>listindex</em>(file_or_filename = "", fieldname = "")||Lists secondary indexes in a database or for a db file</p>
<em>Returns:</em> False if the db file or fieldname are given and do not exist
<em>Returns:</em> False if the db file or fieldname are given and do not exist
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 1,015: Line 1,016:
if (listindex()) ... ok</syntaxhighlight>
if (listindex()) ... ok</syntaxhighlight>
|-
|-
|if||file.<em>deleteindex</em>(fieldname)||Deletes a secondary index for a db file and field name.<br>
|if||file.<em>deleteindex</em>(fieldname)||Deletes a secondary index for a db file and field name.</p>
<em>Returns:</em> False if the index cannot be deleted for any reason<br>
<em>Returns:</em> False if the index cannot be deleted for any reason</p>
* File does not exist<br>
* File does not exist</p>
* Index does not already exists
* Index does not already exists
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 1,025: Line 1,026:
if (deleteindex(file, fieldname)) ...</syntaxhighlight>
if (deleteindex(file, fieldname)) ...</syntaxhighlight>
|-
|-
|var=||file.<em>lock</em>(key)||Places a metaphorical db lock on a particular record given a db file and key.<br>
|var=||file.<em>lock</em>(key)||Places a metaphorical db lock on a particular record given a db file and key.</p>
This is a advisory lock, not a physical lock, since it makes no restriction on the access or modification of data by other connections.<br>
This is a advisory lock, not a physical lock, since it makes no restriction on the access or modification of data by other connections.</p>
Neither the db file nor the record key need to actually exist since a lock is just a hash of the db file name and key combined.<br>
Neither the db file nor the record key need to actually exist since a lock is just a hash of the db file name and key combined.</p>
If another connection attempts to place an identical lock on the same database it will be denied.<br>
If another connection attempts to place an identical lock on the same database it will be denied.</p>
Locks can be removed by unlock() or unlockall() or will be automatically removed at the end of a transaction or when the connection is closed.<br>
Locks can be removed by unlock() or unlockall() or will be automatically removed at the end of a transaction or when the connection is closed.</p>
If the same process attempts to place an identical lock more than once it may be denied (if not in a transaction) or succeed but be ignored (if in a transaction).<br>
If the same process attempts to place an identical lock more than once it may be denied (if not in a transaction) or succeed but be ignored (if in a transaction).</p>
Locks can be used to avoid processing a transaction simultaneously with another connection only to have one of them fail due to mutually updating the same records.<br>
Locks can be used to avoid processing a transaction simultaneously with another connection only to have one of them fail due to mutually updating the same records.</p>
<em>Returns:</em>:<br>
<em>Returns:</em>:</p>
* 0: Failure: Another connection has already placed the same lock.<br>
* 0: Failure: Another connection has already placed the same lock.</p>
* "" Failure: The lock has already been placed.<br>
* "" Failure: The lock has already been placed.</p>
* 1: Success: A new lock has been placed.<br>
* 1: Success: A new lock has been placed.</p>
* 2: Success: The lock has already been placed and the connection is in a transaction.
* 2: Success: The lock has already been placed and the connection is in a transaction.
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 1,043: Line 1,044:
if (lock(file, key)) ...</syntaxhighlight>
if (lock(file, key)) ...</syntaxhighlight>
|-
|-
|if||file.<em>unlock</em>(key)||Removes a db lock placed by the lock function.<br>
|if||file.<em>unlock</em>(key)||Removes a db lock placed by the lock function.</p>
Only locks placed on the specified connection can be removed.<br>
Only locks placed on the specified connection can be removed.</p>
Locks cannot be removed while a connection is in a transaction.<br>
Locks cannot be removed while a connection is in a transaction.</p>
<em>Returns:</em> False if the lock is not present in a connection.
<em>Returns:</em> False if the lock is not present in a connection.
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 1,053: Line 1,054:
if (unlock(file, key)) ...</syntaxhighlight>
if (unlock(file, key)) ...</syntaxhighlight>
|-
|-
|if||file.<em>unlockall</em>()||Removes all db locks placed by the lock function in the specified connection.<br>
|if||file.<em>unlockall</em>()||Removes all db locks placed by the lock function in the specified connection.</p>
Locks cannot be removed while in a transaction.
Locks cannot be removed while in a transaction.
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 1,061: Line 1,062:
if (not unlockall(conn)) ...</syntaxhighlight>
if (not unlockall(conn)) ...</syntaxhighlight>
|-
|-
|cmd||rec.<em>write</em>(file, key)||Writes a record into a db file given a unique primary key.<br>
|cmd||rec.<em>write</em>(file, key)||Writes a record into a db file given a unique primary key.</p>
Either inserts a new record or updates an existing record.<br>
Either inserts a new record or updates an existing record.</p>
It always succeeds so no result code is returned.<br>
It always succeeds so no result code is returned.</p>
Any memory cached record is deleted.
Any memory cached record is deleted.
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 1,073: Line 1,074:
write(rec on file, key);</syntaxhighlight>
write(rec on file, key);</syntaxhighlight>
|-
|-
|if||rec.<em>read</em>(file, key)||Reads a record from a db file for a given key.<br>
|if||rec.<em>read</em>(file, key)||Reads a record from a db file for a given key.</p>
<em>Returns:</em> False if the key doesnt exist
<em>Returns:</em> False if the key doesnt exist
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 1,082: Line 1,083:
if (not read(rec from file, key)) ...</syntaxhighlight>
if (not read(rec from file, key)) ...</syntaxhighlight>
|-
|-
|if||file.<em>deleterecord</em>(key)||Deletes a record from a db file given a key.<br>
|if||file.<em>deleterecord</em>(key)||Deletes a record from a db file given a key.</p>
<em>Returns:</em> False if the key doesnt exist<br>
<em>Returns:</em> False if the key doesnt exist</p>
Any memory cached record is deleted.
Any memory cached record is deleted.
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 1,091: Line 1,092:
if (deleterecord(file, key)) ...</syntaxhighlight>
if (deleterecord(file, key)) ...</syntaxhighlight>
|-
|-
|if||rec.<em>insertrecord</em>(file, key)||Inserts a new record in a db file.<br>
|if||rec.<em>insertrecord</em>(file, key)||Inserts a new record in a db file.</p>
<em>Returns:</em> False if the key already exists<br>
<em>Returns:</em> False if the key already exists</p>
Any memory cached record is deleted.
Any memory cached record is deleted.
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 1,101: Line 1,102:
if (insertrecord(rec on file, key)) ...</syntaxhighlight>
if (insertrecord(rec on file, key)) ...</syntaxhighlight>
|-
|-
|if||rec.<em>updaterecord</em>(file, key)||Updates an existing record in a db file.<br>
|if||rec.<em>updaterecord</em>(file, key)||Updates an existing record in a db file.</p>
<em>Returns:</em> False if the key doesnt already exist<br>
<em>Returns:</em> False if the key doesnt already exist</p>
Any memory cached record is deleted.
Any memory cached record is deleted.
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 1,125: Line 1,126:
writef(field on file, key, fieldno);</syntaxhighlight>
writef(field on file, key, fieldno);</syntaxhighlight>
|-
|-
|cmd||rec.<em>writec</em>(file, key)||"Write cache" Writes a record and key into a memory cached "db file".<br>
|cmd||rec.<em>writec</em>(file, key)||"Write cache" Writes a record and key into a memory cached "db file".</p>
The actual file is NOT updated.<br>
The actual file is NOT updated.</p>
writec() either updates an existing cache record if the key already exists or otherwise inserts a new record into the cache.<br>
writec() either updates an existing cache record if the key already exists or otherwise inserts a new record into the cache.</p>
It always succeeds so no result code is returned.<br>
It always succeeds so no result code is returned.</p>
Neither the db file nor the record key need to actually exist in the actual db.
Neither the db file nor the record key need to actually exist in the actual db.
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 1,137: Line 1,138:
writec(rec on file, key);</syntaxhighlight>
writec(rec on file, key);</syntaxhighlight>
|-
|-
|if||rec.<em>readc</em>(file, key)||"Read cache" Same as "read() but first reads from a memory cache.<br>
|if||rec.<em>readc</em>(file, key)||"Read cache" Same as "read() but first reads from a memory cache.</p>
1. Tries to read from a memory cache. Returns true if successful.<br>
1. Tries to read from a memory cache. Returns true if successful.</p>
2a. Tries to read from the actual db file and returns false if unsuccessful.<br>
2a. Tries to read from the actual db file and returns false if unsuccessful.</p>
2b. Writes the record and key to the memory cache and returns true.<br>
2b. Writes the record and key to the memory cache and returns true.</p>
Cached db file data lives in exodus process memory and is lost when the process terminates or cleardbcache() is called.
Cached db file data lives in exodus process memory and is lost when the process terminates or cleardbcache() is called.
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 1,152: Line 1,153:
if (read(rec from file, key)) abort("Error: " ^ key ^ " should not be in the actual file"); // error</syntaxhighlight>
if (read(rec from file, key)) abort("Error: " ^ key ^ " should not be in the actual file"); // error</syntaxhighlight>
|-
|-
|if||dbfile.<em>deletec</em>(key)||Deletes a record and key from a memory cached "file".<br>
|if||dbfile.<em>deletec</em>(key)||Deletes a record and key from a memory cached "file".</p>
The actual file is NOT updated.<br>
The actual file is NOT updated.</p>
<em>Returns:</em> False if the key doesnt exist
<em>Returns:</em> False if the key doesnt exist
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 1,161: Line 1,162:
if (deletec(file, key)) ...</syntaxhighlight>
if (deletec(file, key)) ...</syntaxhighlight>
|-
|-
|cmd||conn.<em>cleardbcache</em>()||Clears the memory cache of all records for the given connection<br>
|cmd||conn.<em>cleardbcache</em>()||Clears the memory cache of all records for the given connection</p>
All future cache readc() function calls will be forced to obtain records from the actual database and refresh the cache.
All future cache readc() function calls will be forced to obtain records from the actual database and refresh the cache.
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 1,168: Line 1,169:
cleardbcache(conn);</syntaxhighlight>
cleardbcache(conn);</syntaxhighlight>
|-
|-
|var=||strvar.<em>xlate</em>(filename, fieldno, mode)||The xlate ("translate") function is similar to readf() but, when called as an exodus program member function, it can be used efficiently with exodus file dictionaries using column names and functions and multivalued data.<br>
|var=||strvar.<em>xlate</em>(filename, fieldno, mode)||The xlate ("translate") function is similar to readf() but, when called as an exodus program member function, it can be used efficiently with exodus file dictionaries using column names and functions and multivalued data.</p>
''Arguments:''<br>
Arguments:</p>
'''str:''' Used as the primary key to lookup a field in a given file and field no or field name.<br>
str: Used as the primary key to lookup a field in a given file and field no or field name.</p>
'''filename:''' The db file in which to look up data.<br>
filename: The db file in which to look up data.</p>
If var key is multivalued then a multivalued field is returned.<br>
If var key is multivalued then a multivalued field is returned.</p>
'''fieldno:''' Determines which field of the record is returned.<br>
fieldno: Determines which field of the record is returned.</p>
* Integer returns that field number<br>
* Integer returns that field number</p>
* 0 means return the key unchanged.<br>
* 0 means return the key unchanged.</p>
* "" means return the whole record.<br>
* "" means return the whole record.</p>
'''mode:''' Determines what is returned if the record does not exist for the given key and file.<br>
mode: Determines what is returned if the record does not exist for the given key and file.</p>
* "X" returns ""<br>
* "X" returns ""</p>
* "C" returns the key unconverted.
* "C" returns the key unconverted.
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
let key = "SB001";
let key = "SB001";
let client_name = key.xlate("xo_clients", 1, "X"); assert(client_name == "Client AAA");
let client_name = key.xlate("xo_clients", 1, "X"); // "Client AAA"
// or
// or
let name_and_type = xlate("xo_clients", key, "NAME_AND_TYPE", "X"); assert("Client AAA (A)");</syntaxhighlight>
let name_and_type = xlate("xo_clients", key, "NAME_AND_TYPE", "X"); // "Client AAA (A)"</syntaxhighlight>
|}
|}
===== Database Sort/Select =====
===== Database Sort/Select =====
Line 1,218: Line 1,219:
!Usage!!Function!!Description
!Usage!!Function!!Description
|-
|-
|var=||var().<em>date</em>()||
|var=||var().<em>date</em>()||Number of whole days since pick epoch 1967-12-31 00:00:00 UTC. Negative for dates before.</p>
e.g. was 20821 from 2025-01-01 00:00:00 UTC for 24 hours
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
let today1 = var().date();
let today1 = var().date();
Line 1,224: Line 1,226:
let today2 = date();</syntaxhighlight>
let today2 = date();</syntaxhighlight>
|-
|-
|var=||var().<em>time</em>()||Number of whole seconds since last 00:00:00 (UTC).<br>
|var=||var().<em>time</em>()||Number of whole seconds since last 00:00:00 (UTC).</p>
e.g. 43200 if time is 12:00<br>
e.g. 43200 if time is 12:00</p>
Range 0 - 86399 since there are 24*60*60 (86400) seconds in a day.
Range 0 - 86399 since there are 24*60*60 (86400) seconds in a day.
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 1,232: Line 1,234:
let now2 = time();</syntaxhighlight>
let now2 = time();</syntaxhighlight>
|-
|-
|var=||var().<em>ostime</em>()||Number of fractional seconds since last 00:00:00 (UTC).<br>
|var=||var().<em>ostime</em>()||Number of fractional seconds since last 00:00:00 (UTC).</p>
A floating point with approx. nanosecond resolution depending on hardware.<br>
A floating point with approx. nanosecond resolution depending on hardware.</p>
e.g. 23343.704387955 approx. 06:29:03 UTC
e.g. 23343.704387955 approx. 06:29:03 UTC
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 1,240: Line 1,242:
let now2 = ostime();</syntaxhighlight>
let now2 = ostime();</syntaxhighlight>
|-
|-
|var=||var().<em>timestamp</em>()||Number of fractional days since pick epoch 1967-12-31 00:00:00 UTC. Negative for dates before.<br>
|var=||var().<em>timestamp</em>()||Number of fractional days since pick epoch 1967-12-31 00:00:00 UTC. Negative for dates before.</p>
A floating point with approx. nanosecond resolution depending on hardware.<br>
A floating point with approx. nanosecond resolution depending on hardware.</p>
e.g. Was 20821.99998842593 around 2025-01-01 23:59:59 UTC
e.g. Was 20821.99998842593 around 2025-01-01 23:59:59 UTC
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 1,250: Line 1,252:
|var=||var().<em>timestamp</em>(ostime)||Construct a timestamp from a date and time
|var=||var().<em>timestamp</em>(ostime)||Construct a timestamp from a date and time
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
var idate = iconv("2025-01-01", "D"), itime = iconv("23:59:59", "MT");
let idate = iconv("2025-01-01", "D"), itime = iconv("23:59:59", "MT");
let ts1 = idate.timestamp(itime); // 20821.99998842593
let ts1 = idate.timestamp(itime); // 20821.99998842593
// or
// or
let ts2 = timestamp(idate, itime);</syntaxhighlight>
let ts2 = timestamp(idate, itime);</syntaxhighlight>
|-
|-
|cmd||var().<em>ossleep</em>(milliseconds)||Sleep/pause/wait for a number of milliseconds
|cmd||var().<em>ossleep</em>(milliseconds)||Sleep/pause/wait for a number of milliseconds</p>
Releases the processor if not needed for a period of time or a delay is required.
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
var().ossleep(500); // sleep for 500ms
var().ossleep(500); // sleep for 500ms
Line 1,261: Line 1,264:
ossleep(500);</syntaxhighlight>
ossleep(500);</syntaxhighlight>
|-
|-
|var=||file_dir_list.<em>oswait</em>(milliseconds)||Sleep/pause/wait up to a given number of milliseconds or until any changes occur in an FM delimited list of directories and/or files.<br>
|var=||file_dir_list.<em>oswait</em>(milliseconds)||Sleep/pause/wait up to a given number of milliseconds or until any changes occur in an FM delimited list of directories and/or files.</p>
Any terminal input (e.g. a key press) will also terminate the wait.<br>
Any terminal input (e.g. a key press) will also terminate the wait.</p>
An FM array of event information is returned. See below.<br>
An FM array of event information is returned. See below.</p>
Multiple events are returned in multivalues.
Multiple events are returned in multivalues.
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 1,269: Line 1,272:
// or
// or
let v2 = oswait(".^/etc/hosts"_var, 500);</syntaxhighlight>
let v2 = oswait(".^/etc/hosts"_var, 500);</syntaxhighlight>
Returned array fields<br>
Returned array fields</p>
1. Event type codes<br>
1. Event type codes</p>
2. dirpaths<br>
2. dirpaths</p>
3. filenames<br>
3. filenames</p>
4. d=dir, f=file<br>
4. d=dir, f=file</p>
<br>
</p>
Possible event type codes are as follows:<br>
Possible event type codes are as follows:</p>
* IN_CLOSE_WRITE - A file opened for writing was closed<br>
* IN_CLOSE_WRITE - A file opened for writing was closed</p>
* IN_ACCESS - Data was read from file<br>
* IN_ACCESS - Data was read from file</p>
* IN_MODIFY - Data was written to file<br>
* IN_MODIFY - Data was written to file</p>
* IN_ATTRIB - File attributes changed<br>
* IN_ATTRIB - File attributes changed</p>
* IN_CLOSE - File was closed (read or write)<br>
* IN_CLOSE - File was closed (read or write)</p>
* IN_MOVED_FROM - File was moved away from watched directory<br>
* IN_MOVED_FROM - File was moved away from watched directory</p>
* IN_MOVED_TO - File was moved into watched directory<br>
* IN_MOVED_TO - File was moved into watched directory</p>
* IN_MOVE - File was moved (in or out of directory)<br>
* IN_MOVE - File was moved (in or out of directory)</p>
* IN_CREATE - A file was created in the directory<br>
* IN_CREATE - A file was created in the directory</p>
* IN_DELETE - A file was deleted from the directory<br>
* IN_DELETE - A file was deleted from the directory</p>
* IN_DELETE_SELF - Directory or file under observation was deleted<br>
* IN_DELETE_SELF - Directory or file under observation was deleted</p>
* IN_MOVE_SELF - Directory or file under observation was moved
* IN_MOVE_SELF - Directory or file under observation was moved
|}
|}
Line 1,294: Line 1,297:
!Usage!!Function!!Description
!Usage!!Function!!Description
|-
|-
|if||osfilevar.<em>osopen</em>(osfilename, utf8 = true)||Given the name of an existing os file name including path, initialises an os file handle var that can be used in random access osbread and osbwrite functions.<br>
|if||osfilevar.<em>osopen</em>(osfilename, utf8 = true)||Given the name of an existing os file name including path, initialises an os file handle var that can be used in random access osbread and osbwrite functions.</p>
The utf8 option defaults to true which causes trimming of partial utf-8 unicode byte sequences from the end of osbreads. For raw untrimmed osbreads pass utf8 = false;<br>
The utf8 option defaults to true which causes trimming of partial utf-8 unicode byte sequences from the end of osbreads. For raw untrimmed osbreads pass utf8 = false;</p>
File will be opened for writing if possible otherwise for reading.<br>
File will be opened for writing if possible otherwise for reading.</p>
<em>Returns:</em> True if successful or false if not possible for any reason.<br>
<em>Returns:</em> True if successful or false if not possible for any reason.</p>
e.g. Target doesnt exist, permissions etc.
e.g. Target doesnt exist, permissions etc.
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 1,307: Line 1,310:
if (osopen(osfilename to ostempfile)) ... ok</syntaxhighlight>
if (osopen(osfilename to ostempfile)) ... ok</syntaxhighlight>
|-
|-
|if||osfilevar.<em>osbwrite</em>(osfilevar, io offset)||Writes data to an existing os file starting at a given byte offset (0 based).<br>
|if||osfilevar.<em>osbwrite</em>(osfilevar, io offset)||Writes data to an existing os file starting at a given byte offset (0 based).</p>
See osbread for more info.
See osbread for more info.
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 1,317: Line 1,320:
if (not osbwrite(text on osfilename, offset)) ...</syntaxhighlight>
if (not osbwrite(text on osfilename, offset)) ...</syntaxhighlight>
|-
|-
|if||osfilevar.<em>osbread</em>(osfilevar, io offset, length)||Reads length bytes from an existing os file starting at a given byte offset (0 based).<br>
|if||osfilevar.<em>osbread</em>(osfilevar, io offset, length)||Reads length bytes from an existing os file starting at a given byte offset (0 based).</p>
The osfilevar file handle may either be initialised by osopen or be just be a normal string variable holding the path and name of the os file.<br>
The osfilevar file handle may either be initialised by osopen or be just be a normal string variable holding the path and name of the os file.</p>
After reading, the offset is updated to point to the correct offset for a subsequent sequential read.<br>
After reading, the offset is updated to point to the correct offset for a subsequent sequential read.</p>
If reading utf8 data (the default) then the length of data actually returned may be a few bytes shorter than requested in order to be a complete number of UTF-8 code points.
If reading utf8 data (the default) then the length of data actually returned may be a few bytes shorter than requested in order to be a complete number of UTF-8 code points.
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 1,328: Line 1,331:
if (osbread(text from osfilename, offset, 8)) ... ok // text -> "bbb=456\n" // offset -> 16</syntaxhighlight>
if (osbread(text from osfilename, offset, 8)) ... ok // text -> "bbb=456\n" // offset -> 16</syntaxhighlight>
|-
|-
|cmd||osfilevar.<em>osclose</em>()||Removes an osfilevar handle from the internal memory cache of os file handles. This frees up both exodus process memory and operating system resources.<br>
|cmd||osfilevar.<em>osclose</em>()||Removes an osfilevar handle from the internal memory cache of os file handles. This frees up both exodus process memory and operating system resources.</p>
It is advisable to osclose any file handles after use, regardless of whether they were specifically opened using osopen or not, especially in long running programs. Exodus performs caching of internal os file handles per thread and os file. If not closed, then the operating system will probably not flush deleted files from storage until the process is terminated. This can potentially create an memory issue or file system resource issue especially if osopening/osreading/oswriting many perhaps temporary files in a long running process.
It is advisable to osclose any file handles after use, regardless of whether they were specifically opened using osopen or not, especially in long running programs. Exodus performs caching of internal os file handles per thread and os file. If not closed, then the operating system will probably not flush deleted files from storage until the process is terminated. This can potentially create an memory issue or file system resource issue especially if osopening/osreading/oswriting many perhaps temporary files in a long running process.
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 1,335: Line 1,338:
osclose(osfilevar);</syntaxhighlight>
osclose(osfilevar);</syntaxhighlight>
|-
|-
|if||strvar.<em>oswrite</em>(osfilename, codepage = "")||Create a complete os file from a var.<br>
|if||strvar.<em>oswrite</em>(osfilename, codepage = "")||Create a complete os file from a var.</p>
Any existing os file is removed first.<br>
Any existing os file is removed first.</p>
<em>Returns:</em> True if successful or false if not possible for any reason.<br>
<em>Returns:</em> True if successful or false if not possible for any reason.</p>
e.g. Path is not writeable, permissions etc.<br>
e.g. Path is not writeable, permissions etc.</p>
If codepage is specified then output is converted from utf-8 to that codepage. Otherwise no conversion is done.
If codepage is specified then output is converted from utf-8 to that codepage. Otherwise no conversion is done.
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 1,347: Line 1,350:
if (oswrite(text on osfilename)) ... ok</syntaxhighlight>
if (oswrite(text on osfilename)) ... ok</syntaxhighlight>
|-
|-
|if||strvar.<em>osread</em>(osfilename, codepage = "")||Read a complete os file into a var.<br>
|if||strvar.<em>osread</em>(osfilename, codepage = "")||Read a complete os file into a var.</p>
If codepage is specified then input is converted from that codepage to utf-8 otherwise no conversion is done.<br>
If codepage is specified then input is converted from that codepage to utf-8 otherwise no conversion is done.</p>
<em>Returns:</em> True if successful or false if not possible for any reason.<br>
<em>Returns:</em> True if successful or false if not possible for any reason.</p>
e.g. File doesnt exist, permissions etc.
e.g. File doesnt exist, permissions etc.
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 1,358: Line 1,361:
if (osread(text from osfilename)) ... ok</syntaxhighlight>
if (osread(text from osfilename)) ... ok</syntaxhighlight>
|-
|-
|if||osfile_or_dirname.<em>osrename</em>(new_dirpath_or_filepath)||Renames an os file or dir in the OS file system.<br>
|if||osfile_or_dirname.<em>osrename</em>(new_dirpath_or_filepath)||Renames an os file or dir in the OS file system.</p>
Will not overwrite an existing os file or dir.<br>
Will not overwrite an existing os file or dir.</p>
Source and target must exist in the same storage device.<br>
Source and target must exist in the same storage device.</p>
<em>Returns:</em> True if successful or false if not possible for any reason.<br>
<em>Returns:</em> True if successful or false if not possible for any reason.</p>
e.g. Target already exists, path is not writeable, permissions etc.<br>
e.g. Target already exists, path is not writeable, permissions etc.</p>
Uses std::filesystem::rename internally.
Uses std::filesystem::rename internally.
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 1,373: Line 1,376:
if (osrename(from_osfilename, to_osfilename)) ...</syntaxhighlight>
if (osrename(from_osfilename, to_osfilename)) ...</syntaxhighlight>
|-
|-
|if||osfile_or_dirname.<em>osmove</em>(to_osfilename)||"Moves" an os file or dir within the os file system.<br>
|if||osfile_or_dirname.<em>osmove</em>(to_osfilename)||"Moves" an os file or dir within the os file system.</p>
Will not overwrite an existing os file or dir.<br>
Will not overwrite an existing os file or dir.</p>
<em>Returns:</em> True if successful or false if not possible for any reason.<br>
<em>Returns:</em> True if successful or false if not possible for any reason.</p>
e.g. Source doesnt exist or cannot be accessed, target already exists, source or target is not writeable, permissions etc.<br>
e.g. Source doesnt exist or cannot be accessed, target already exists, source or target is not writeable, permissions etc.</p>
Attempts osrename first then oscopy followed by osremove original.
Attempts osrename first then oscopy followed by osremove original.
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 1,387: Line 1,390:
if (osmove(from_osfilename, to_osfilename)) ...</syntaxhighlight>
if (osmove(from_osfilename, to_osfilename)) ...</syntaxhighlight>
|-
|-
|if||osfile_or_dirname.<em>oscopy</em>(to_osfilename)||Copies an os file or directory recursively within the os file system.<br>
|if||osfile_or_dirname.<em>oscopy</em>(to_osfilename)||Copies an os file or directory recursively within the os file system.</p>
Will overwrite an existing os file or dir.<br>
Will overwrite an existing os file or dir.</p>
Uses std::filesystem::copy internally with recursive and overwrite options
Uses std::filesystem::copy internally with recursive and overwrite options
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 1,398: Line 1,401:
if (oscopy(from_osfilename, to_osfilename)) ... ok</syntaxhighlight>
if (oscopy(from_osfilename, to_osfilename)) ... ok</syntaxhighlight>
|-
|-
|if||osfilename.<em>osremove</em>()||Removes/deletes an os file from the OS file system given path and name.<br>
|if||osfilename.<em>osremove</em>()||Removes/deletes an os file from the OS file system given path and name.</p>
Will not remove directories. Use osrmdir() to remove directories<br>
Will not remove directories. Use osrmdir() to remove directories</p>
<em>Returns:</em> True if successful or false if not possible for any reason.<br>
<em>Returns:</em> True if successful or false if not possible for any reason.</p>
e.g. Target doesnt exist, path is not writeable, permissions etc.
e.g. Target doesnt exist, path is not writeable, permissions etc.
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 1,413: Line 1,416:
!Usage!!Function!!Description
!Usage!!Function!!Description
|-
|-
|var=||dirpath.<em>oslist</em>(globpattern = "", mode = 0)||<em>Returns:</em> A FM delimited string containing all matching dir entries given a dir path<br>
|var=||dirpath.<em>oslist</em>(globpattern = "", mode = 0)||<em>Returns:</em> A FM delimited string containing all matching dir entries given a dir path</p>
A glob pattern (e.g. *.conf) can be appended to the path or passed as argument.
A glob pattern (e.g. *.conf) can be appended to the path or passed as argument.
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
var entries1 = "/etc/"_var.oslist("*.cfg"); /// e.g. "adduser.conf^ca-certificates.conf^ ..."
var entries1 = "/etc/"_var.oslist("*.cfg"); /// e.g. "adduser.conf^ca-certificates.con^... etc."
// or
// or
var entries2 = oslist("/etc/" "*.conf");</syntaxhighlight>
var entries2 = oslist("/etc/" "*.conf");</syntaxhighlight>
Line 1,424: Line 1,427:
|var=||dirpath.<em>oslistd</em>(globpattern = "")||Same as oslist for files only
|var=||dirpath.<em>oslistd</em>(globpattern = "")||Same as oslist for files only
|-
|-
|var=||osfile_or_dirpath.<em>osinfo</em>(mode = 0)||<em>Returns:</em> Dir info for any dir entry or "" if it doesnt exist<br>
|var=||osfile_or_dirpath.<em>osinfo</em>(mode = 0)||<em>Returns:</em> Dir info for any dir entry or "" if it doesnt exist</p>
A short string containing size ^ FM ^ modified_time ^ FM ^ modified_time<br>
A short string containing size ^ FM ^ modified_time ^ FM ^ modified_time</p>
mode 0 default<br>
mode 0 default</p>
mode 1 returns "" if not an os file<br>
mode 1 returns "" if not an os file</p>
mode 2 returns "" if not an os dir<br>
mode 2 returns "" if not an os dir</p>
See also osfile() and osdir()
See also osfile() and osdir()
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 1,435: Line 1,438:
var info2 = osinfo("/etc/hosts");</syntaxhighlight>
var info2 = osinfo("/etc/hosts");</syntaxhighlight>
|-
|-
|var=||osfilename.<em>osfile</em>()||<em>Returns:</em> Dir info for a os file<br>
|var=||osfilename.<em>osfile</em>()||<em>Returns:</em> Dir info for a os file</p>
A short string containing size ^ FM ^ modified_time ^ FM ^ modified_time<br>
A short string containing size ^ FM ^ modified_time ^ FM ^ modified_time</p>
Alias for osinfo(1)
Alias for osinfo(1)
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 1,443: Line 1,446:
var fileinfo2 = osfile("/etc/hosts");</syntaxhighlight>
var fileinfo2 = osfile("/etc/hosts");</syntaxhighlight>
|-
|-
|var=||dirpath.<em>osdir</em>()||<em>Returns:</em> Dir info for a dir.<br>
|var=||dirpath.<em>osdir</em>()||<em>Returns:</em> Dir info for a dir.</p>
A short string containing FM ^ modified_time ^ FM ^ modified_time<br>
A short string containing FM ^ modified_time ^ FM ^ modified_time</p>
Alias for osinfo(2)
Alias for osinfo(2)
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 1,451: Line 1,454:
var dirinfo2 = osfile("/etc/");</syntaxhighlight>
var dirinfo2 = osfile("/etc/");</syntaxhighlight>
|-
|-
|if||dirpath.<em>osmkdir</em>()||Makes a new directory and returns true if successful.<br>
|if||dirpath.<em>osmkdir</em>()||Makes a new directory and returns true if successful.</p>
Including parent dirs if necessary.
Including parent dirs if necessary.
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 1,467: Line 1,470:
if (oscwd(osdirname)) ... ok</syntaxhighlight>
if (oscwd(osdirname)) ... ok</syntaxhighlight>
|-
|-
|var=||dirpath.<em>oscwd</em>()||<em>Returns:</em> The current working directory<br>
|var=||dirpath.<em>oscwd</em>()||<em>Returns:</em> The current working directory</p>
e.g. "/root/exodus/cli/src/xo_test/aaa"
e.g. "/root/exodus/cli/src/xo_test/aaa"
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 1,474: Line 1,477:
var cwd2 = oscwd();</syntaxhighlight>
var cwd2 = oscwd();</syntaxhighlight>
|-
|-
|if||dirpath.<em>osrmdir</em>(evenifnotempty = false)||Removes a os dir and returns true if successful.<br>
|if||dirpath.<em>osrmdir</em>(evenifnotempty = false)||Removes a os dir and returns true if successful.</p>
Optionally even if not empty. Including subdirs.
Optionally even if not empty. Including subdirs.
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 1,488: Line 1,491:
!Usage!!Function!!Description
!Usage!!Function!!Description
|-
|-
|if||command.<em>osshell</em>()||Execute a shell command.<br>
|if||command.<em>osshell</em>()||Execute a shell command.</p>
<em>Returns:</em> True if the process terminates with error status 0 and false otherwise.<br>
<em>Returns:</em> True if the process terminates with error status 0 and false otherwise.</p>
Append "&>/dev/null" to the command to suppress terminal output.
Append "&>/dev/null" to the command to suppress terminal output.
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 1,497: Line 1,500:
if (osshell(cmd)) ... ok</syntaxhighlight>
if (osshell(cmd)) ... ok</syntaxhighlight>
|-
|-
|if||instr.<em>osshellread</em>(oscmd)||Same as osshell but captures and returns stdout<br>
|if||instr.<em>osshellread</em>(oscmd)||Same as osshell but captures and returns stdout</p>
<em>Returns:</em> The stout of the shell command.<br>
<em>Returns:</em> The stout of the shell command.</p>
Append "2>&1" to the command to capture stderr/stdlog output as well.
Append "2>&1" to the command to capture stderr/stdlog output as well.
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 1,508: Line 1,511:
text = osshellread(cmd);</syntaxhighlight>
text = osshellread(cmd);</syntaxhighlight>
|-
|-
|if||outstr.<em>osshellwrite</em>(oscmd)||Same as osshell but provides stdin to the process<br>
|if||outstr.<em>osshellwrite</em>(oscmd)||Same as osshell but provides stdin to the process</p>
<em>Returns:</em> True if the process terminates with error status 0 and false otherwise.<br>
<em>Returns:</em> True if the process terminates with error status 0 and false otherwise.</p>
Append "&> somefile" to the command to suppress and/or capture output.
Append "&> somefile" to the command to suppress and/or capture output.
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 1,517: Line 1,520:
if (osshellwrite(outtext, "grep xyz")) ... ok</syntaxhighlight>
if (osshellwrite(outtext, "grep xyz")) ... ok</syntaxhighlight>
|-
|-
|var=||var().<em>ostempdirpath</em>()||<em>Returns:</em> The path of the tmp dir<br>
|var=||var().<em>ostempdirpath</em>()||<em>Returns:</em> The path of the tmp dir</p>
e.g. "/tmp/"
e.g. "/tmp/"
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 1,524: Line 1,527:
let v2 = ostempdirpath();</syntaxhighlight>
let v2 = ostempdirpath();</syntaxhighlight>
|-
|-
|var=||var().<em>ostempfilename</em>()||<em>Returns:</em> The name of a new temporary file<br>
|var=||var().<em>ostempfilename</em>()||<em>Returns:</em> The name of a new temporary file</p>
e.g. Something like "/tmp/~exoEcLj3C"
e.g. Something like "/tmp/~exoEcLj3C"
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 1,561: Line 1,564:
let v1 = var().version(); /// e.g. "29 JAN 2025 14:56:52"</syntaxhighlight>
let v1 = var().version(); /// e.g. "29 JAN 2025 14:56:52"</syntaxhighlight>
|-
|-
|if||strvar.<em>setxlocale</em>()||Sets the current thread's default locale codepage code<br>
|if||strvar.<em>setxlocale</em>()||Sets the current thread's default locale codepage code</p>
true if successful
True if successful
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
if ("en_US.utf8"_var.setxlocale()) ... ok
if ("en_US.utf8"_var.setxlocale()) ... ok
Line 1,568: Line 1,571:
if (setxlocale("en_US.utf8")) ... ok</syntaxhighlight>
if (setxlocale("en_US.utf8")) ... ok</syntaxhighlight>
|-
|-
|expr||var.<em>getxlocale</em>()||Gets the current thread's default locale codepage code
|expr||var.<em>getxlocale</em>()||<em>Returns:</em> The current thread's default locale codepage code
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
let v1 = var().getxlocale(); // "en_US.utf8"
let v1 = var().getxlocale(); // "en_US.utf8"
Line 1,626: Line 1,629:
|expr||var.<em>inputn</em>(nchars)||Wait for nbytes from stdin
|expr||var.<em>inputn</em>(nchars)||Wait for nbytes from stdin
|-
|-
|if||var.<em>isterminal</em>()||true if terminal is available
|if||var.<em>isterminal</em>()||True if terminal is available
|-
|-
|if||var.<em>hasinput</em>(milliseconds = 0)||true if stdin bytes available within milliseconds
|if||var.<em>hasinput</em>(milliseconds = 0)||True if stdin bytes available within milliseconds
|-
|-
|if||var.<em>eof</em>()||true if stdin is at end of file
|if||var.<em>eof</em>()||True if stdin is at end of file
|-
|-
|if||var.<em>echo</em>(on_off)||Reflect all stdin to stdout if terminal available
|if||var.<em>echo</em>(on_off)||Reflect all stdin to stdout if terminal available
Line 1,655: Line 1,658:
let v2 = pwr(2, 8);</syntaxhighlight>
let v2 = pwr(2, 8);</syntaxhighlight>
|-
|-
|cmd||num.<em>initrnd</em>()||Initialise the seed for rnd()<br>
|cmd||num.<em>initrnd</em>()||Initialise the seed for rnd()</p>
Allows the stream of pseudo random numbers generated by rnd() to be reproduced.<br>
Allows the stream of pseudo random numbers generated by rnd() to be reproduced.</p>
Seeded from std::chrono::high_resolution_clock::now() if the argument is 0;
Seeded from std::chrono::high_resolution_clock::now() if the argument is 0;
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 1,663: Line 1,666:
initrnd(123);</syntaxhighlight>
initrnd(123);</syntaxhighlight>
|-
|-
|var=||num.<em>rnd</em>()||Pseudo random number generator<br>
|var=||num.<em>rnd</em>()||Pseudo random number generator</p>
<em>Returns:</em> a pseudo random integer between 0 and the provided maximum minus 1.<br>
<em>Returns:</em> a pseudo random integer between 0 and the provided maximum minus 1.</p>
Uses std::mt19937 and std::uniform_int_distribution<int>
Uses std::mt19937 and std::uniform_int_distribution<int>
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 1,707: Line 1,710:
let v2 = atan(1);</syntaxhighlight>
let v2 = atan(1);</syntaxhighlight>
|-
|-
|var=||num.<em>loge</em>()||Natural logarithm<br>
|var=||num.<em>loge</em>()||Natural logarithm</p>
<em>Returns:</em> Floating point ver (double)
<em>Returns:</em> Floating point ver (double)
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 1,714: Line 1,717:
let v2 = loge(2.718281828459045);</syntaxhighlight>
let v2 = loge(2.718281828459045);</syntaxhighlight>
|-
|-
|var=||num.<em>integer</em>()||Truncate decimal numbers towards zero<br>
|var=||num.<em>integer</em>()||Truncate decimal numbers towards zero</p>
<em>Returns:</em> A var integer
<em>Returns:</em> A var integer
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 1,725: Line 1,728:
var v4 = integer(-2.9);</syntaxhighlight>
var v4 = integer(-2.9);</syntaxhighlight>
|-
|-
|var=||num.<em>floor</em>()||Truncate decimal numbers towards negative<br>
|var=||num.<em>floor</em>()||Truncate decimal numbers towards negative</p>
<em>Returns:</em> A var integer
<em>Returns:</em> A var integer
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">
Line 1,736: Line 1,739:
var v4 = floor(-2.9);</syntaxhighlight>
var v4 = floor(-2.9);</syntaxhighlight>
|-
|-
|var=||num.<em>mod</em>(modulus)||Modulus function<br>
|var=||num.<em>mod</em>(modulus)||Modulus function</p>
Identical to C++ % operator only for positive numbers and modulus<br>
Identical to C++ % operator only for positive numbers and modulus</p>
Negative denominators are considered as periodic with positiive numbers<br>
Negative denominators are considered as periodic with positiive numbers</p>
Result is between [0 , modulus) if modulus is positive<br>
Result is between [0 , modulus) if modulus is positive</p>
Result is between (modulus, 0] if modulus is negative (symmetric)<br>
Result is between (modulus, 0] if modulus is negative (symmetric)</p>
mod(11, 5); // 1<br>
mod(11, 5); // 1</p>
mod(-11, 5); // 4<br>
mod(-11, 5); // 4</p>
mod(11, -5); // -4<br>
mod(11, -5); // -4</p>
mod(-11, -5); // -1
mod(-11, -5); // -1
<syntaxhighlight lang="c++">
<syntaxhighlight lang="c++">

Revision as of 21:20, 6 February 2025

Complete List of Functions

Generated by cli/gendoc from var.h 06 FEB 2025 21:16:50

String Creation
Usage Function Description
var= num.round(ndecimals = 0) Returns: A string representation of a decimal number rounded to a desired number of decimal places

Returns: A var ASCII string with exact decimal places requested.

.5 always rounds away from zero.

let v1 = var(0.295).round(2); // "0.30"
// or
let v2 = round(1.295, 2); // "1.30"

var v3 = var(-0.295).round(2); // "-0.30"
// or
var v4 = round(-1.295, 2); // "-1.30"
var= var().chr(num) Returns: A string containing a single char (byte) given an integer 0-255.

0-127 -> ASCII, 128-255 -> invalid UTF-8 so cannot be written to database or used various exodus string operations

let v1 = var().chr(0x61); // "a"
// or
let v2 = chr(0x61);
var= var().textchr(num) Returns: A string of a single unicode code point in utf8 encoding.

To get utf codepoints > 2^63 you must provide negative ints

Not providing implicit constructor from var to unsigned int due to getting ambigious conversions

since int and unsigned int are parallel priority in c++ implicit conversions

let v1 = var().textchr(171416); // "𩶘" // or "\xF0A9B698"
// or
let v2 = textchr(171416);
var= var().str(num) Returns: A string of repeating characters or strings
let v1 = "ab"_var.str(3); // "ababab"
// or
let v2 = str("ab", 3);
var= num.space() Returns A string of space characters.
let v1 = var(3).space(); // "␣␣␣"
// or
let v2 = space(3);
var= num.numberinwords(languagename_or_locale_id = "") Returns: A string representing a given number written in words instead of digits.
let softhyphen = "\xc2\xad";
let v1 = var(123.45).numberinwords("de_DE").replace(softhyphen, " "); // "ein␣hundert␣drei␣und␣zwanzig␣Komma␣vier␣fünf"
String Scanning
Usage Function Description
var= strvar.seq() Returns: The character number of the first char.
let v1 = "abc"_var.seq(); // 0x61 // decimal 97
// or
let v2 = seq("abc");
var= strvar.textseq() Returns: The Unicode character number of the first unicode code point.
let v1 = "Γ"_var.textseq(); // 915 // U+0393: Greek Capital Letter Gamma (Unicode Character)
// or
let v2 = textseq("Γ");
var= strvar.len() Returns: The length of a string in number of chars
let v1 = "abc"_var.len(); // 3
// or
let v2 = len("abc");
var= strvar.textwidth() Returns: The number of output columns.

Allows multi column unicode and reduces combining characters etc. like e followed by grave accent

Possibly does not properly calculate combining sequences of graphemes e.g. face followed by colour

let v1 = "🤡x🤡"_var.textwidth(); // 5
// or
let v2 = textwidth("🤡x🤡");
var= strvar.textlen() Returns: The number of Unicode code points
let v1 = "Γιάννης"_var.textlen(); // 7
// or
let v2 = textlen("Γιάννης");
var= strvar.fcount(sepstr) Returns: The count of the number of fields separated by a given sepstr.

It is the same as var.count(sepstr) + 1 except that it returns 0 for an empty string.

let v1 = "aa**cc"_var.fcount("*"); // 3
// or
let v2 = fcount("aa**cc", "*");
var= strvar.count(sepstr) Returns: The count of the number of sepstr found.
let v1 = "aa**cc"_var.count("*"); // 2
// or
let v2 = count("aa**cc", "*");
if strvar.starts(prefix) Returns: True if starts with prefix
if ("abc"_var.starts("ab")) ... true
// or
if (starts("abc", "ab")) ... true
if strvar.ends(suffix) Returns: True if ends with suffix
if ("abc"_var.ends("bc")) ... true
// or
if (ends("abc", "bc")) ... true
if strvar.contains(substr) Returns: True if starts, ends or contains substr
if ("abcd"_var.contains("bc")) ... true
// or
if (contains("abcd", "bc")) ... true
var= strvar.index(substr, startchar1 = 1) Returns: The index (1 based position) of a given substr on or after a given starting char number if present

Returns: 0 if not present.

let v1 = "abcd"_var.index("bc"); // 2
// or
let v2 = index("abcd", "bc");
var= strvar.indexn(substr, occurrence) Returns: The index (1 based position) of the nth occurrence of a given substr if present

Returns: 0 if not present.

let v1 = "abcabc"_var.index("bc", 2); // 2
// or
let v2 = index("abcabc", "bc", 2);
var= strvar.indexr(substr, startchar1 = -1) Reverse substr search.

Returns: The index (1 based position) of the substr on or before a given starting char number if present

startchar1 defaults to -1 meaning start searching from the last char (towards the first char).

let v1 = "abcabc"_var.indexr("bc"); // 5
// or
let v2 = indexr("abcabc", "bc");
var= strvar.match(regex_str, regex_options = "") Returns: All results of regex matching

Multiple matches are returns in fields. Groups are in values

let v1 = "abc1abc2"_var.match("BC(\\d)", "i"); // "bc1]1^bc2]2"_var
// or
let v2 = match("abc1abc2", "BC(\\d)", "i");
regex_options:

l - Literal (any regex chars are treated as normal chars)

i - Case insensitive

p - ECMAScript/Perl (the default)

b - Basic POSIX (same as sed)

e - Extended POSIX

a - awk

g - grep

eg - egrep or grep -E

char ranges like a-z are locale sensitive if ECMAScript

m - Multiline. Default in boost (and therefore exodus)

s - Single line. Default in std::regex

f - First only. Only for replace() (not match() or search())

w - Wildcard glob style (e.g. *.cfg) not regex style. Only for match() and search(). Not replace().

var= strvar.match(regex) Ditto
var= strvar.search(regex_str, io startchar1, regex_options = "") Search for first match of a regular expression starting at startchar1

Updates startchar1 ready to search for the next match

regex_options as for match()

var startchar1 = 1;
let v1 = "abc1abc2"_var.search("BC(\\d)", startchar1, "i"); // "bc1]1"_var // startchar1.outputl() -> 5 /// Ready for the next search
// or
startchar1 = 1;
let v2 = search("abc1abc2", "BC(\\d)", startchar1, "i");
var= strvar.search(regex_str) Ditto starting from first char
var= strvar.search(regex, io startchar1) Ditto given a rex
var= strvar.search(regex) Ditto starting from first char.
String Conversion - Non-Mutating - Chainable
Usage Function Description
var= strvar.ucase() Upper case
let v1 = "Γιάννης"_var.ucase(); // "ΓΙΆΝΝΗΣ"
// or
let v2 = ucase("Γιάννης");
var= strvar.lcase() Lower case
let v1 = "ΓΙΆΝΝΗΣ"_var.lcase(); // "γιάννης"
// or
let v2 = lcase("ΓΙΆΝΝΗΣ");
var= strvar.tcase() Title case (first letters)
let v1 = "γιάννης"_var.tcase(); // "Γιάννης"
// or
let v2 = tcase("γιάννης");
var= strvar.fcase() Fold case (lower case and remove accents for indexing)
var= strvar.normalize() Normalise Unicode to NFC to eliminate different code combinations of the same character
var= strvar.invert() Simple reversible disguising of text
let v1 = "abc"_var.invert(); // "\xC2" "\x9E" "\xC2" "\x9D" "\xC2" "\x9C"
// or
let v2 = invert("abc");
var= strvar.lower() Convert all FM to VM, VM to SM etc.
let v1 = "a1^b2^c3"_var.lower(); // "a1]b2]c3"_var
// or
let v2 = lower("a1^b2^c3"_var);
var= strvar.raise() Convert all VM to FM, SM to VM etc.
let v1 = "a1]b2]c3"_var.raise(); // "a1^b2^c3"_var
// or
let v2 = "a1]b2]c3"_var;
var= strvar.crop() Remove any redundant FM, VM etc. characters (Trailing FM; VM before FM etc.)
let v1 = "a1^b2]]^c3^^"_var.crop(); // "a1^b2^c3"_var
// or
let v2 = crop("a1^b2]]^c3^^"_var);
var= strvar.quote() Wrap in double quotes
let v1 = "abc"_var.quote(); // "\"abc\""
// or
let v2 = quote("abc");
var= strvar.squote() Wrap in single quotes
let v1 = "abc"_var.squote(); // "'abc'"
// or
let v2 = squote("abc");
var= strvar.unquote() Remove one pair of double or single quotes
let v1 = "'abc'"_var.unquote(); // "abc"
// or
let v2 = unquote("'abc'");
var= strvar.trim(trimchars = " ") Remove leading, trailing and excessive inner bytes
let v1 = "␣␣a1␣␣b2␣c3␣␣"_var.trim(); // "a1␣b2␣c3"
// or
let v2 = trim("␣␣a1␣␣b2␣c3␣␣");
var= strvar.trimfirst(trimchars = " ") Ditto leading
let v1 = "␣␣a1␣␣b2␣c3␣␣"_var.trimfirst(); // "a1␣␣b2␣c3␣␣"
// or
let v2 = trimfirst("␣␣a1␣␣b2␣c3␣␣");
var= strvar.trimlast(trimchars = " ") Ditto trailing
let v1 = "␣␣a1␣␣b2␣c3␣␣"_var.trimlast(); // "␣␣a1␣␣b2␣c3"
// or
let v2 = trimlast("␣␣a1␣␣b2␣c3␣␣");
var= strvar.trimboth(trimchars = " ") Ditto leading, trailing but not inner
let v1 = "␣␣a1␣␣b2␣c3␣␣"_var.trimboth(); // "a1␣␣b2␣c3"
// or
let v2 = trimboth("␣␣a1␣␣b2␣c3␣␣");
var= strvar.first() Extract first char or "" if empty
let v1 = "abc"_var.first(); // "a"
// or
let v2 = first("abc");
var= strvar.last() Extract last char or "" if empty
let v1 = "abc"_var.last(); // "c"
// or
let v2 = last("abc");
var= strvar.first(std::size_t length) Extract up to length leading chars
let v1 = "abc"_var.first(2); // "ab"
// or
let v2 = first("abc", 2);
var= strvar.last(std::size_t length) Extract up to length trailing chars
let v1 = "abc"_var.last(2); // "bc"
// or
let v2 = last("abc", 2);
var= strvar.cut(length) Remove length leading chars
let v1 = "abcd"_var.cut(2); // "cd"
// or
let v2 = cut("abcd", 2);
var= strvar.paste(pos1, length, insertstr) Insert text at char position overwriting length chars
let v1 = "abcd"_var.paste(2, 2, "XYZ"); // "aXYZd"
// or
let v2 = paste("abcd", 2, 2, "XYZ");
var= strvar.paste(pos1, insertstr) Insert text at char position without overwriting any following characters
let v1 = "abcd"_var.paste(2, "XYZ"); // "aXYZbcd"
// or
let v2 = paste("abcd", 2, "XYZ");
var= strvar.prefix(insertstr) Insert text at the beginning
let v1 = "abc"_var.prefix("XYZ"); // "XYZabc"
// or
let v2 = prefix("abc", "XYZ");
var= strvar.pop() Remove one trailing char
let v1 = "abc"_var.pop(); // "ab"
// or
let v2 = pop("abc");
var= strvar.fieldstore(separator, fieldno, nfields, replacement) fieldstore() replaces n fields of subfield(s) in a string.
let v1 = "aa*bb*cc*dd"_var.fieldstore("*", 2, 3, "X*Y"); // "aa*X*Y*"
// or
let v2 = fieldstore("aa*bb*cc*dd", "*", 2, 3, "X*Y");

If nfields is 0 then insert fields before fieldno

let v1 = "a1*b2*c3*d4"_var.fieldstore("*", 2, 0, "X*Y"); // "a1*X*Y*b2*c3*d4"
// or
let v2 = fieldstore("a1*b2*c3*d4", "*", 2, 0, "X*Y");

If nfields is negative then delete abs(n) fields before inserting.

let v1 = "a1*b2*c3*d4"_var.fieldstore("*", 2, -3, "X*Y"); // "a1*X*Y"
// or
let v2 = fieldstore("a1*b2*c3*d4", "*", 2, -3, "X*Y");
var= strvar.substr(pos1, length) substr version 1. Extract length chars starting at pos1
let v1 = "abcd"_var.substr(2, 2); // "bc"
// or
let v2 = substr("abcd", 2, 2);

If length is negative then work backwards and return chars reversed

let v1 = "abcd"_var.substr(3, -2); // "cb"
// or
let v2 = substr("abcd", 3, -2);
var= strvar.substr(pos1) substr version 2. Extract all chars from pos1 up to the end
let v1 = "abcd"_var.substr(2); // "bcd"
// or
let v2 = substr("abcd", 2);
var= strvar.b(pos1, length) Same as substr version 1.
var= strvar.b(pos1) Same as substr version 2.
var= strvar.convert(fromchars, tochars) Convert chars to other chars one for one or delete where tochars is shorter.
let v1 = "abcde"_var.convert("aZd", "XY"); // "Xbce" // a is replaced and d is removed
// or
let v2 = convert("abcde", "aZd", "XY");
var= strvar.textconvert(fromchars, tochars) Ditto for Unicode code points.
let v1 = "a🤡b😀c🌍d"_var.textconvert("🤡😀", "👋"); // "a👋bc🌍d"
// or
let v2 = textconvert("a🤡b😀c🌍d", "🤡😀", "👋");
var= strvar.replace(fromstr, tostr) Replace all occurrences of a substr with another. Case sensitive
let v1 = "Abc.Abc"_var.replace("bc", "X"); // "AX.AX"
// or
let v2 = replace("Abc Abc", "bc", "X");
var= strvar.replace(regex, tostr) Replace substring(s) using a regular expression.

Use $0, $1, $2 in tostr to refer to groups defined in the regex.

let v1 = "A a B b"_var.replace("[A-Z]"_rex, "'$0'"); // "'A' a 'B' b"
// or
let v2 = replace("A a B b", "[A-Z]"_rex, "'$0'");
var= strvar.unique() Remove duplicate fields in an FM or VM etc. separated list
let v1 = "a1^b2^a1^c2"_var.unique(); // "a1^b2^c2"_var
// or
let v2 = unique("a1^b2^a1^c2"_var);
var= strvar.sort(sepchar = FM) Reorder fields in an FM or VM etc. separated list in ascending order

Numerical

let v1 = "20^10^2^1^1.1"_var.sort(); // "1^1.1^2^10^20"_var
// or
let v2 = sort("20^10^2^1^1.1"_var);

Alphabetical

let v1 = "b1^a1^c20^c10^c2^c1^b2"_var.sort(); // "a1^b1^b2^c1^c10^c2^c20"_var
// or
let v2 = sort("b1^a1^c20^c10^c2^c1^b2"_var);
var= strvar.reverse(sepchar = FM) Reorder fields in an FM or VM etc. separated list in descending order
let v1 = "20^10^2^1^1.1"_var.reverse(); // "1.1^1^2^10^20"_var
// or
let v2 = reverse("20^10^2^1^1.1"_var);
var= strvar.shuffle(sepchar = FM) Randomise the order of fields in an FM, VM separated list
let v1 = "20^10^2^1^1.1"_var.shuffle(); /// e.g. "2^1^20^1.1^10" (random order depending on initrand())
// or
let v2 = shuffle("20^10^2^1^1.1"_var);
var= strvar.parse(char sepchar = ' ') Replace separator characters with FM char except inside double or single quotes ignoring escaped quotes \" \'
let v1 = "abc,\"def,\"123\" fgh\",12.34"_var.parse(','); // "abc^\"def,\"123\" fgh\"^12.34"_var
// or
let v2 = parse("abc,\"def,\"123\" fgh\",12.34", ',');
String Conversion - Mutating - Standalone Commands
Usage Function Description
cmd strvar.ucaser() Upper case

All string mutators follow the same pattern as ucaser. See the non-mutating functions for details.

var v1 = "abc";
v1.ucaser(); // "ABC"
// or
ucaser(v1);
cmd strvar.lcaser()
cmd strvar.tcaser()
cmd strvar.fcaser()
cmd strvar.normalizer()
cmd strvar.inverter()
cmd strvar.quoter()
cmd strvar.squoter()
cmd strvar.unquoter()
cmd strvar.lowerer()
cmd strvar.raiser()
cmd strvar.cropper()
cmd strvar.trimmer(trimchars = " ")
cmd strvar.trimmerfirst(trimchars = " ")
cmd strvar.trimmerlast(trimchars = " ")
cmd strvar.trimmerboth(trimchars = " ")
cmd strvar.firster()
cmd strvar.laster()
cmd strvar.firster(std::size_t length)
cmd strvar.laster(std::size_t length)
cmd strvar.cutter(length)
cmd strvar.paster(pos1, length, insertstr)
cmd strvar.paster(pos1, insertstr)
cmd strvar.prefixer(insertstr)
cmd strvar.popper()
cmd strvar.fieldstorer(sepchar, fieldno, nfields, replacement)
cmd strvar.substrer(pos1, length)
cmd strvar.substrer(pos1)
cmd strvar.converter(fromchars, tochars)
cmd strvar.textconverter(fromchars, tochars)
cmd strvar.replacer(regex, tostr)
cmd strvar.replacer(fromstr, tostr)
cmd strvar.uniquer()
cmd strvar.sorter(sepchar = FM)
cmd strvar.reverser(sepchar = FM)
cmd strvar.shuffler(sepchar = FM)
cmd strvar.parser(char sepchar = ' ')
Other String Access
Usage Function Description
var= strvar.hash(std::uint64_t modulus = 0) Hash by default returns a 64 bit signed integer as a var.

If a modulus is provided then the result is limited to [0, modulus)

MurmurHash3 is used.

let v1 = "abc"_var.hash(); assert(v1 == var(6'715'211'243'465'481'821));
// or
let v2 = hash("abc");
var= strvar.substr(pos1, delimiterchars, io pos2) substr version 3.

Extract a substr starting from pos1 up to any one of some given delimiter chars

Also returns in pos2 the pos of the following delimiter or one past the end of the string if not found.

Add 1 to pos2 start the next search if continuing.

var pos1a = 4, pos2a;
let v1 = "aa,bb,cc"_var.substr(pos1a, ",", pos2a); // "bb" // pos2a -> 6
// or
var pos1b = 4, pos2b;
let v2 = substr("aa,bb,cc", pos1b, ",", pos2b);
var= strvar.b(pos1, delimiterchars, io pos2) Alias of substr version 3.
var= strvar.substr2(io pos1, out delimiterno) substr version 4.

Returns: A substr from a given pos1 up to the next RM/FM/VM/SM/TM/ST delimiter char.

Also returns the next index/offset and the delimiter no. found (1-6) or 0 if not found.

var pos1a = 4, delim1;
let v1 = "aa^bb^cc"_var.substr2(pos1a, delim1); // "bb" // pos1a -> 7 // delim1 -> 2
// or
var pos1b = 4, delim2;
let v2 = substr2("aa^bb^cc"_var, pos1b, delim2);
var= strvar.b2(io pos1, out delimiterno) Alias of substr version 4
var= strvar.field(strx, fieldnx = 1, nfieldsx = 1) Extract one or more consecutive fields given a delimiter char or substr.
let v1 = "aa*bb*cc"_var.field("*", 2); // "bb"
// or
let v2 = field("aa*bb*cc", "*", 2);
var= strvar.field2(separator, fieldno, nfields = 1) field2 is a version that treats fieldn -1 as the last field, -2 the penultimate field etc. -

TODO Should probably make field() do this (since -1 is basically an erroneous call) and remove field2

Same as var.field() but negative fieldnos work backwards from the last field.

let v1 = "aa*bb*cc"_var.field2("*", -1); // "cc"
// or
let v2 = field2("aa*bb*cc", "*", -1);
I/O Conversion
Usage Function Description
var= var.oconv(convstr) Converts internal data to output external display format according to a given conversion code or pattern

If the internal data is invalid and cannot be converted then most conversions return the ORIGINAL data unconverted

Throws a runtime error VarNotImplemented if convstr is invalid

See #ICONV/OCONV PATTERNS

let v1 = var(30123).oconv("D/E"); // "21/06/2050"
// or
let v2 = oconv(30123, "D/E");
var= var.iconv(convstr) Converts external data to internal format according to a given conversion code or pattern

If the external data is invalid and cannot be converted then most conversions return the EMPTY STRING ""

Throws a runtime error VarNotImplemented if convstr is invalid

See #ICONV/OCONV PATTERNS

let v1 = "21 JUN 2050"_var.iconv("D/E"); // 30123
// or
let v2 = iconv("21 JUN 2050", "D/E");
var= var.format(fmt_str, Args&&... args) Classic format function in printf style

vars can be formatted either with C++ format codes e.g. {:_>8.2f}

or with exodus oconv codes e.g. {::MD20P|R(_)#8} as in the below example.

let v1 = var(12.345).format("'{:_>8.2f}'"); // "'___12.35'"
let v2 = var(12.345).format("'{::MD20P|R(_)#8}'");
// or
var v3 = format("'{:_>8.2f}'", var(12.345)); // "'___12.35'"
var v4 = format("'{::MD20P|R(_)#8}'", var(12.345));
var= strvar.from_codepage(codepage) Converts from codepage encoded text to UTF-8 encoded text

e.g. Codepage "CP1124" (Ukrainian).

Use Linux command "iconv -l" for complete list of code pages and encodings.

let v1 = "\xa4"_var.from_codepage("CP1124"); // "Є"
// or
let v2 = from_codepage("\xa4", "CP1124");
// U+0404 Cyrillic Capital Letter Ukrainian Ie Unicode Character
var= strvar.to_codepage(codepage) Converts to codepage encoded text from UTF-8 encoded text
let v1 = "Є"_var.to_codepage("CP1124").oconv("HEX"); // "A4"
// or
let v2 = to_codepage("Є", "CP1124").oconv("HEX");
Basic Dynamic Array Functions
Usage Function Description
var= strvar.f(fieldno, valueno = 0, subvalueno = 0) f() is a highly abbreviated alias for the PICK OS field/value/subvalue extract() function.

"f()" can be thought of as "field" although the function can extract values and subvalues as well.

The convenient PICK OS angle bracket syntax for field extraction (e.g. xxx<20>) is not available in C++.

The abbreviated exodus field extraction function (e.g. xxx.f(20)) is provided instead since field access is extremely heavily used in source code.

let v1 = "f1^f2v1]f2v2]f2v3^f2"_var;
let v2 = v1.f(2, 2); // "f2v2"
var= strvar.extract(fieldno, valueno = 0, subvalueno = 0) Extract a specific field, value or subvalue from a dynamic array.
let v1 = "f1^f2v1]f2v2]f2v3^f2"_var;
let v2 = v1.extract(2, 2); // "f2v2"
//
// For brevity the function alias "f()" (standing for "field") is normally used instead of "extract()" as follows:
var v3 = v1.f(2, 2);
var= strvar.pickreplace(fieldno, valueno, subvalueno, replacement) Same as var.r() function but returns a new string instead of updating a variable in place.
Rarely used.
var= strvar.pickreplace(fieldno, valueno, replacement) Ditto for a specific multivalue
var= strvar.pickreplace(fieldno, replacement) Ditto for a specific field
var= strvar.insert(fieldno, valueno, subvalueno, insertion) Same as var.inserter() function but returns a new string instead of updating a variable in place.
var= strvar.insert(fieldno, valueno, insertion) Ditto for a specific multivalue
var= strvar.insert(fieldno, insertion) Ditto for a specific field
var= strvar.remove(fieldno, valueno = 0, subvalueno = 0) Same as var.remover() function but returns a new string instead of updating a variable in place.

"remove" was called "delete" in Pick OS.

Dynamic Array Filters
Usage Function Description
var= strvar.sum() Sum up multiple values into one higher level
let v1 = "1]2]3^4]5]6"_var.sum(); // "6^15"_var
// or
let v2 = sum("1]2]3^4]5]6"_var);
var= strvar.sumall() Sum up all levels into a single figure
let v1 = "1]2]3^4]5]6"_var.sumall(); // 21
// or
let v2 = sumall("1]2]3^4]5]6"_var);
var= strvar.sum(sepchar) Ditto allowing commas etc.
let v1 = "10,20,30"_var.sum(","); // 60
// or
let v2 = sum("10,20,30", ",");
var= strvar.mv(opcode, var2) Binary ops (+, -, *, /) in parallel on multiple values
let v1 = "10]20]30"_var.mv("+","2]3]4"_var); // "12]23]34"_var
Dynamic Array Mutators Standalone Commands
Usage Function Description
cmd strvar.r(fieldno, replacement) Replaces a specific field in a dynamic array
var v1 = "f1^v1]v2}s2}s3^f3"_var;
v1.r(2, "X"); // "f1^X^f3"_var
cmd strvar.r(fieldno, valueno, replacement) Ditto for specific value in a specific field.
var v1 = "f1^v1]v2}s2}s3^f3"_var;
v1.r(2, 2, "X"); // "f1^v1]X^f3"_var
cmd strvar.r(fieldno, valueno, subvalueno, replacement) Ditto for a specific subvalue in a specific value of a specific field
var v1 = "f1^v1]v2}s2}s3^f3"_var;
v1.r(2, 2, 2, "X"); // "f1^v1]v2}X}s3^f3"_var
cmd strvar.inserter(fieldno, insertion) Insert a specific field in a dynamic array, moving all other fields up.
var v1 = "f1^v1]v2}s2}s3^f3"_var;
v1.inserter(2, "X"); // "f1^X^v1]v2}s2}s3^f3"_var
// or
inserter(v1, 2, "X");
cmd strvar.inserter(fieldno, valueno, insertion) Ditto for a specific value in a specific field, moving all other values up.
var v1 = "f1^v1]v2}s2}s3^f3"_var;
v1.inserter(2, 2, "X"); // "f1^v1]X]v2}s2}s3^f3"_var
// or
inserter(v1, 2, 2, "X");
cmd strvar.inserter(fieldno, valueno, subvalueno, insertion) Ditto for a specific subvalue in a dynamic array, moving all other subvalues up.
var v1 = "f1^v1]v2}s2}s3^f3"_var;
v1.inserter(2, 2, 2, "X"); // "f1^v1]v2}X}s2}s3^f3"_var
// or
v1.inserter(2, 2, 2, "X");
cmd strvar.remover(fieldno, valueno = 0, subvalueno = 0) Remove a specific field (or value, or subvalue) from a dynamic array, moving all other fields (or values, or subvalues) down.
var v1 = "f1^v1]v2}s2}s3^f3"_var;
v1.remover(2, 2); // "f1^v1^f3"_var
// or
remover(v1, 2, 2);
Dynamic Array Search
Usage Function Description
if strvar.locate(target) locate() with only the target substr argument provided searches unordered values separated by VM chars.

Returns: True if found and false if not.

if ("UK]US]UA"_var.locate("US")) ... ok
// or
if (locate("US", "UK]US]UA"_var)) ... ok
if strvar.locate(target, out valueno) locate() with only the target substr and valueno arguments provided searches unordered values separated by VM chars.

Returns: True if found and with the value number in valueno.

Returns: False if not found and with the max value number + 1 in setting. Suitable for additiom of new values

var valueno;
if ("UK]US]UA"_var.locate("US", valueno)) ... ok // valueno -> 2
if strvar.locate(target, out setting, fieldno, valueno = 0) locate() the target in unordered fields if fieldno is 0, or values if a fieldno is specified, or subvalues if the valueno argument is provided.

Returns: True if found and with the field, value or subvalue number in setting.

Returns: False if not found and with the max field, value or subvalue number found + 1 in setting. Suitable for replacement of new fields, values or subvalues.

var setting;
if ("f1^f2v1]f2v2]s1}s2}s3}s4^f3^f4"_var.locate("s4", setting, 2, 3)) ... ok // setting -> 4 // returns true
if strvar.locateby(ordercode, target, out valueno) locateby() without fieldno or valueno arguments searches ordered values separated by VM chars.

The order code can be AL, DL, AR, DR meaning Ascending Left, Descending Right, Ascending Right, Ascending Left.

Left is used to indicate alphabetic order where 10 < 2.

Right is used to indicate numeric order where 10 > 2.

Data must be in the correct order for searching to work properly.

Returns: True if found.

In case the target is not exactly found then the correct value no for inserting the target is returned in setting.

var valueno; if ("aaa]bbb]ccc"_var.locateby("AL", "bb", valueno)) ... // valueno -> 2 // returns false and valueno = where it could be correctly inserted.
if strvar.locateby(ordercode, target, out setting, fieldno, valueno = 0) locateby() ordered as above but in fields if fieldno is 0, or values in a specific fieldno, or subvalues in a specific valueno.
var setting;
if ("f1^f2^aaa]bbb]ccc^f4"_var.locateby("AL", "bb", setting, 3)) ... // setting -> 2 // return false and where it could be correctly inserted.
if strvar.locateusing(usingchar, target) locate() a target substr in the whole unordered string using a given delimiter char returning true if found.
if ("AB,EF,CD"_var.locateusing(",", "EF")) ... ok
if strvar.locateusing(usingchar, target, out setting, fieldno = 0, valueno = 0, subvalueno = 0) locate() the target in a specific field, value or subvalue using a specified delimiter and unordered data

Returns: True If found and returns in setting the number of the delimited field found.

Returns: False if not found and returns in setting the maximum number of delimited fields + 1 if not found.

This is similar to the main locate command but the delimiter char can be specified e.g. a comma or TM etc.

var setting;
if ("f1^f2^f3c1,f3c2,f3c3^f4"_var.locateusing(",", "f3c2", setting, 3)) ... ok // setting -> 2 // returns true
if strvar.locatebyusing(ordercode, usingchar, target, out setting, fieldno = 0, valueno = 0, subvalueno = 0) locatebyusing() supports all the above features in a single function.

Returns: True if found.

Database Access
Usage Function Description
if conn.connect(conninfo = "") For all db operations, the operative var can either be a db connection created with dbconnect() or be any var and a default connection will be established on the fly.

The db connection string (conninfo) parameters are merged from the following places in descending priority.

1. Provided in connect()'s conninfo argument. See 4. for the complete list of parameters.

2. Any environment variables EXO_HOST EXO_PORT EXO_USER EXO_DATA EXO_PASS EXO_TIME

3. Any parameters found in a configuration file at ~/.config/exodus/exodus.cfg

4. The default conninfo is "host=127.0.0.1 port=5432 dbname=exodus user=exodus password=somesillysecret connect_timeout=10"

Setting environment variable EXO_DBTRACE=1 will cause tracing of db interface including SQL commands.

let conninfo = "dbname=exodus user=exodus password=somesillysecret";
if (not conn.connect(conninfo)) ...;
// or
if (not connect()) ...
// or
if (not connect("exodus")) ...
if conn.attach(filenames) Attach (connect) specific files by name to specific connections.

It is not necessary to attach files before opening them. Attach is meant to control the defaults.

For the remainder of the session, opening the db file by name without specifying a connection will automatically use the specified connection applies during the attach command.

If conn is not specified then filename will be attached to the default connection.

Multiple file names must be separated by FM

let filenames = "definitions^dict.definitions"_var, conn = "exodus";
if (conn.attach(filenames)) ... ok
// or
if (attach(filenames)) ... ok
cmd conn.detach(filenames) Detach (disconnect) files that have been attached using attach().
if conn.begintrans() Begin a db transaction.
if (not conn.begintrans()) ...
// or
if (not begintrans()) ...
if conn.statustrans() Check if a db transaction is in progress.
if (conn.statustrans()) ... ok
// or
if (statustrans()) ... ok
if conn.rollbacktrans() Rollback a db transaction.
if (conn.rollbacktrans()) ... ok
// or
if (rollbacktrans()) ... ok
if conn.committrans() Commit a db transaction.

Returns: True if successfully committed or if there was no transaction in progress, otherwise false.

if (conn.committrans()) ... ok
// or
if (committrans()) ... ok
if conn.sqlexec(sqlcmd) Execute an sql command.

Returns: True if there was no sql error otherwise lasterror() returns a detailed error message.

if (conn.sqlexec("vacuum")) ... ok
// or
if (sqlexec("vacuum")) ... ok
if conn.sqlexec(sqlcmd, io response) Execute an SQL command and capture the response.

Returns: True if there was no sql error otherwise response contains a detailed error message.

response: Any rows and columns returned are separated by RM and FM respectively. The first row is the column names.

Recommended: Don't use sql directly unless you must to manage or configure a database.

let sqlcmd = "select 'xxx' as col1, 'yyy' as col2";
var response;
if (conn.sqlexec(sqlcmd, response)) ... ok // response -> "col1^col2\x1fxxx^yyy"_var /// \x1f is the Record Mark (RM) character. The backtick character is used here by gendoc to deliminate source code.
// or
if (sqlexec(sqlcmd, response)) ... ok
cmd conn.disconnect() Closes db connection and frees process resources both locally and in the database server.
conn.disconnect();
// or
disconnect();
cmd conn.disconnectall() Closes all connections and frees process resources both locally and in the database server(s).

All connections are closed automatically when a process terminates.

conn.disconnectall();
// or
disconnectall();
var= conn.lasterror() Returns: The last os or db error message.
var v1 = var().lasterror();
// or
var v2 = lasterror();
var= conn.loglasterror(source = "") Log the last os or db error message.

Output: to stdlog

Prefixes the output with source if provided.

var().loglasterror("main:");
// or
loglasterror("main:");
Database Management
Usage Function Description
if conn.dbcreate(new_dbname, old_dbname = "") Create a named database on a particular connection.

The target database cannot already exist.

Optionally copies an existing database from the same connection and which cannot have any current connections.

var conn = "exodus";
if (not dbdelete("xo_gendoc_testdb")) {}; // Cleanup first
if (conn.dbcreate("xo_gendoc_testdb")) ... ok
// or
if (dbcreate("xo_gendoc_testdb")) ...
if conn.dbcopy(from_dbname, to_dbname) Create a named database as a copy of an existing database.

The target database cannot already exist.

The source database must exist on the same connection and cannot have any current connections.

var conn = "exodus";
if (not dbdelete("xo_gendoc_testdb2")) {}; // Cleanup first
if (conn.dbcopy("xo_gendoc_testdb", "xo_gendoc_testdb2")) ... ok
// or
if (dbcopy("xo_gendoc_testdb", "xo_gendoc_testdb2")) ...
var= conn.dblist() Returns: A list of available databases on a particular connection.
let v1 = conn.dblist();
// or
let v2 = dblist();
if conn.dbdelete(dbname) Delete (drop) a named database.

The target database must exist and cannot have any current connections.

var conn = "exodus";
if (conn.dbdelete("xo_gendoc_testdb2")) ... ok
// or
if (dbdelete("xo_gendoc_testdb2")) ...
if conn.createfile(filename) Create a named db file.
let filename = "xo_gendoc_temp", conn = "exodus";
if (conn.createfile(filename)) ... ok
// or
if (createfile(filename)) ...
if conn.renamefile(filename, newfilename) Rename a db file.
let conn = "exodus", filename = "xo_gendoc_temp", new_filename = "xo_gendoc_temp2";
if (conn.renamefile(filename, new_filename)) ... ok
// or
if (renamefile(filename, new_filename)) ...
var= conn.listfiles() Returns: A list of all files in a database
var conn = "exodus";
if (not conn.listfiles()) ...
// or
if (not listfiles()) ...
if conn.clearfile(filename) Delete all records in a db file
let conn = "exodus", filename = "xo_gendoc_temp2";
if (not conn.clearfile(filename)) ...
// or
if (not clearfile(filename)) ...
if conn.deletefile(filename) Delete a db file
let conn = "exodus", filename = "xo_gendoc_temp2";
if (conn.deletefile(filename)) ... ok
// or
if (deletefile(filename)) ...
var= conn_or_file.reccount(filename = "") Returns: The approx. number of records in a db file
let conn = "exodus", filename = "xo_clients";
var nrecs1 = conn.reccount(filename);
// or
var nrecs2 = reccount(filename);
if conn_or_file.flushindex(filename = "") Calls db maintenance function (vacuum)

This doesnt actually flush any indexes but does make sure that reccount() function is reasonably accurate.

Database File I/O
Usage Function Description
if file.open(dbfilename, connection = "") Opens a db file to a var which can be used in subsequent functions to work on the specified file and database connection.
var file, filename = "definitions";
if (not file.open(filename)) ...
// or
if (not open(filename to file)) ...
cmd file.close() Closes db file var

Does nothing currently since database file vars consume no resources

var file = "definitions";
file.close();
// or
close(file);
if file.createindex(fieldname, dictfile = "") Creates a secondary index for a given db file and field name.

The fieldname must exist in a dictionary file. The default dictionary is "dict." ^ filename.

Returns: False if the index cannot be created for any reason.

  • Index already exists

  • File does not exist

  • The dictionary file does not have a record with a key of the given field name.

  • The dictionary file does not exist. Default is "dict." ^ filename.

  • The dictionary field defines a calculated field that uses an exodus function. Using a psql function is OK.
var filename = "definitions", fieldname = "DATE_TIME";
if (not deleteindex("definitions", "DATE_TIME")) {}; // Cleanup first
if (filename.createindex(fieldname)) ... ok
// or
if (createindex(filename, fieldname)) ...
var= conn.listindex(file_or_filename = "", fieldname = "") Lists secondary indexes in a database or for a db file

Returns: False if the db file or fieldname are given and do not exist

var conn = "exodus";
if (conn.listindex()) ... ok // includes "xo_clients__date_time"
// or
if (listindex()) ... ok
if file.deleteindex(fieldname) Deletes a secondary index for a db file and field name.

Returns: False if the index cannot be deleted for any reason

  • File does not exist

  • Index does not already exists
var file = "definitions", fieldname = "DATE_TIME";
if (file.deleteindex(fieldname)) ... ok
// or
if (deleteindex(file, fieldname)) ...
var= file.lock(key) Places a metaphorical db lock on a particular record given a db file and key.

This is a advisory lock, not a physical lock, since it makes no restriction on the access or modification of data by other connections.

Neither the db file nor the record key need to actually exist since a lock is just a hash of the db file name and key combined.

If another connection attempts to place an identical lock on the same database it will be denied.

Locks can be removed by unlock() or unlockall() or will be automatically removed at the end of a transaction or when the connection is closed.

If the same process attempts to place an identical lock more than once it may be denied (if not in a transaction) or succeed but be ignored (if in a transaction).

Locks can be used to avoid processing a transaction simultaneously with another connection only to have one of them fail due to mutually updating the same records.

Returns::

  • 0: Failure: Another connection has already placed the same lock.

  • "" Failure: The lock has already been placed.

  • 1: Success: A new lock has been placed.

  • 2: Success: The lock has already been placed and the connection is in a transaction.
var file = "xo_clients", key = "1000";
if (file.lock(key)) ... ok
// or
if (lock(file, key)) ...
if file.unlock(key) Removes a db lock placed by the lock function.

Only locks placed on the specified connection can be removed.

Locks cannot be removed while a connection is in a transaction.

Returns: False if the lock is not present in a connection.

var file = "xo_clients", key = "1000";
if (file.unlock(key)) ... ok
// or
if (unlock(file, key)) ...
if file.unlockall() Removes all db locks placed by the lock function in the specified connection.

Locks cannot be removed while in a transaction.

var conn = "exodus";
if (not conn.unlockall()) ...
// or
if (not unlockall(conn)) ...
cmd rec.write(file, key) Writes a record into a db file given a unique primary key.

Either inserts a new record or updates an existing record.

It always succeeds so no result code is returned.

Any memory cached record is deleted.

let rec = "Client GD^G^20855^30000^1001.00^20855.76539"_var;
let file = "xo_clients", key = "GD001";
if (not deleterecord("xo_clients", "GD001")) {}; // Cleanup first
rec.write(file, key);
// or
write(rec on file, key);
if rec.read(file, key) Reads a record from a db file for a given key.

Returns: False if the key doesnt exist

var rec;
let file = "xo_clients", key = "GD001";
if (not rec.read(file, key)) ... // rec -> "Client GD^G^20855^30000^1001.00^20855.76539"_var
// or
if (not read(rec from file, key)) ...
if file.deleterecord(key) Deletes a record from a db file given a key.

Returns: False if the key doesnt exist

Any memory cached record is deleted.

let file = "xo_clients", key = "GD001";
if (file.deleterecord(key)) ... ok
// or
if (deleterecord(file, key)) ...
if rec.insertrecord(file, key) Inserts a new record in a db file.

Returns: False if the key already exists

Any memory cached record is deleted.

let rec = "Client GD^G^20855^30000^1001.00^20855.76539"_var;
let file = "xo_clients", key = "GD001";
if (rec.insertrecord(file, key)) ... ok
// or
if (insertrecord(rec on file, key)) ...
if rec.updaterecord(file, key) Updates an existing record in a db file.

Returns: False if the key doesnt already exist

Any memory cached record is deleted.

let rec = "Client GD^G^20855^30000^1001.00^20855.76539"_var;
let file = "xo_clients", key = "GD001";
if (not rec.updaterecord(file, key)) ...
// or
if (not updaterecord(rec on file, key)) ...
if strvar.readf(file, key, fieldno) "Read field" Same as read() but only returns a specific field from the record
var field, file = "xo_clients", key = "GD001", fieldno = 2;
if (not field.readf(file, key, fieldno)) ... // field -> "G"
// or
if (not readf(field from file, key, fieldno)) ...
cmd strvar.writef(file, key, fieldno) "write field" Same as write() but only writes to a specific field in the record
var field = "f3", file = "definitions", key = "1000", fieldno = 3;
field.writef(file, key, fieldno);
// or
writef(field on file, key, fieldno);
cmd rec.writec(file, key) "Write cache" Writes a record and key into a memory cached "db file".

The actual file is NOT updated.

writec() either updates an existing cache record if the key already exists or otherwise inserts a new record into the cache.

It always succeeds so no result code is returned.

Neither the db file nor the record key need to actually exist in the actual db.

let rec = "Client XD^X^20855^30000^1001.00^20855.76539"_var;
let file = "xo_clients", key = "XD001";
rec.writec(file, key);
// or
writec(rec on file, key);
if rec.readc(file, key) "Read cache" Same as "read() but first reads from a memory cache.

1. Tries to read from a memory cache. Returns true if successful.

2a. Tries to read from the actual db file and returns false if unsuccessful.

2b. Writes the record and key to the memory cache and returns true.

Cached db file data lives in exodus process memory and is lost when the process terminates or cleardbcache() is called.

var rec;
let file = "xo_clients", key = "XD001";
if (rec.readc(file, key)) ... ok
// or
if (readc(rec from file, key)) ... ok

// Verify not in actual file by using read() not readc()
if (read(rec from file, key)) abort("Error: " ^ key ^ " should not be in the actual file"); // error
if dbfile.deletec(key) Deletes a record and key from a memory cached "file".

The actual file is NOT updated.

Returns: False if the key doesnt exist

var file = "xo_clients", key = "XD001";
if (file.deletec(key)) ... ok
// or
if (deletec(file, key)) ...
cmd conn.cleardbcache() Clears the memory cache of all records for the given connection

All future cache readc() function calls will be forced to obtain records from the actual database and refresh the cache.

conn.cleardbcache();
// or
cleardbcache(conn);
var= strvar.xlate(filename, fieldno, mode) The xlate ("translate") function is similar to readf() but, when called as an exodus program member function, it can be used efficiently with exodus file dictionaries using column names and functions and multivalued data.

Arguments:

str: Used as the primary key to lookup a field in a given file and field no or field name.

filename: The db file in which to look up data.

If var key is multivalued then a multivalued field is returned.

fieldno: Determines which field of the record is returned.

  • Integer returns that field number

  • 0 means return the key unchanged.

  • "" means return the whole record.

mode: Determines what is returned if the record does not exist for the given key and file.

  • "X" returns ""

  • "C" returns the key unconverted.
let key = "SB001";
let client_name = key.xlate("xo_clients", 1, "X"); // "Client AAA"
// or
let name_and_type = xlate("xo_clients", key, "NAME_AND_TYPE", "X"); // "Client AAA (A)"
Database Sort/Select
Usage Function Description
if file.select(sortselectclause = "")
cmd file.clearselect()
if file.hasnext()
if file.readnext(out key)
if file.readnext(out key, out valueno)
if file.readnext(out record, out key, out valueno)
if file.savelist(listname)
if file.getlist(listname)
if file.makelist(listname, keys)
if file.deletelist(listname)
if file.formlist(keys, fieldno = 0)
OS Time/Date
Usage Function Description
var= var().date() Number of whole days since pick epoch 1967-12-31 00:00:00 UTC. Negative for dates before.

e.g. was 20821 from 2025-01-01 00:00:00 UTC for 24 hours

let today1 = var().date();
// or
let today2 = date();
var= var().time() Number of whole seconds since last 00:00:00 (UTC).

e.g. 43200 if time is 12:00

Range 0 - 86399 since there are 24*60*60 (86400) seconds in a day.

let now1 = var().time();
// or
let now2 = time();
var= var().ostime() Number of fractional seconds since last 00:00:00 (UTC).

A floating point with approx. nanosecond resolution depending on hardware.

e.g. 23343.704387955 approx. 06:29:03 UTC

let now1 = var().ostime();
// or
let now2 = ostime();
var= var().timestamp() Number of fractional days since pick epoch 1967-12-31 00:00:00 UTC. Negative for dates before.

A floating point with approx. nanosecond resolution depending on hardware.

e.g. Was 20821.99998842593 around 2025-01-01 23:59:59 UTC

let now1 = var().timestamp();
// or
let now2 = timestamp();
var= var().timestamp(ostime) Construct a timestamp from a date and time
let idate = iconv("2025-01-01", "D"), itime = iconv("23:59:59", "MT");
let ts1 = idate.timestamp(itime); // 20821.99998842593
// or
let ts2 = timestamp(idate, itime);
cmd var().ossleep(milliseconds) Sleep/pause/wait for a number of milliseconds

Releases the processor if not needed for a period of time or a delay is required.

var().ossleep(500); // sleep for 500ms
// or
ossleep(500);
var= file_dir_list.oswait(milliseconds) Sleep/pause/wait up to a given number of milliseconds or until any changes occur in an FM delimited list of directories and/or files.

Any terminal input (e.g. a key press) will also terminate the wait.

An FM array of event information is returned. See below.

Multiple events are returned in multivalues.

let v1 = ".^/etc/hosts"_var.oswait(500); /// e.g. "IN_CLOSE_WRITE^/etc^hosts^f"_var
// or
let v2 = oswait(".^/etc/hosts"_var, 500);
Returned array fields

1. Event type codes

2. dirpaths

3. filenames

4. d=dir, f=file

Possible event type codes are as follows:

  • IN_CLOSE_WRITE - A file opened for writing was closed

  • IN_ACCESS - Data was read from file

  • IN_MODIFY - Data was written to file

  • IN_ATTRIB - File attributes changed

  • IN_CLOSE - File was closed (read or write)

  • IN_MOVED_FROM - File was moved away from watched directory

  • IN_MOVED_TO - File was moved into watched directory

  • IN_MOVE - File was moved (in or out of directory)

  • IN_CREATE - A file was created in the directory

  • IN_DELETE - A file was deleted from the directory

  • IN_DELETE_SELF - Directory or file under observation was deleted

  • IN_MOVE_SELF - Directory or file under observation was moved
OS File I/O
Usage Function Description
if osfilevar.osopen(osfilename, utf8 = true) Given the name of an existing os file name including path, initialises an os file handle var that can be used in random access osbread and osbwrite functions.

The utf8 option defaults to true which causes trimming of partial utf-8 unicode byte sequences from the end of osbreads. For raw untrimmed osbreads pass utf8 = false;

File will be opened for writing if possible otherwise for reading.

Returns: True if successful or false if not possible for any reason.

e.g. Target doesnt exist, permissions etc.

let osfilename = ostempdirpath() ^ "xo_gendoc_test.conf";
if (oswrite("" on osfilename)) ... ok /// Create an empty os file
var ostempfile;
if (ostempfile.osopen(osfilename)) ... ok
// or
if (osopen(osfilename to ostempfile)) ... ok
if osfilevar.osbwrite(osfilevar, io offset) Writes data to an existing os file starting at a given byte offset (0 based).

See osbread for more info.

let osfilename = ostempdirpath() ^ "xo_gendoc_test.conf";
let text = "aaa=123\nbbb=456\n";
var offset = osfile(osfilename).f(1); /// Size of file therefore append
if (text.osbwrite(osfilename, offset)) ... ok // offset -> 16
// or
if (not osbwrite(text on osfilename, offset)) ...
if osfilevar.osbread(osfilevar, io offset, length) Reads length bytes from an existing os file starting at a given byte offset (0 based).

The osfilevar file handle may either be initialised by osopen or be just be a normal string variable holding the path and name of the os file.

After reading, the offset is updated to point to the correct offset for a subsequent sequential read.

If reading utf8 data (the default) then the length of data actually returned may be a few bytes shorter than requested in order to be a complete number of UTF-8 code points.

let osfilename = ostempdirpath() ^ "xo_gendoc_test.conf";
var text, offset = 0;
if (text.osbread(osfilename, offset, 8)) ... ok // text -> "aaa=123\n" // offset -> 8
// or
if (osbread(text from osfilename, offset, 8)) ... ok // text -> "bbb=456\n" // offset -> 16
cmd osfilevar.osclose() Removes an osfilevar handle from the internal memory cache of os file handles. This frees up both exodus process memory and operating system resources.

It is advisable to osclose any file handles after use, regardless of whether they were specifically opened using osopen or not, especially in long running programs. Exodus performs caching of internal os file handles per thread and os file. If not closed, then the operating system will probably not flush deleted files from storage until the process is terminated. This can potentially create an memory issue or file system resource issue especially if osopening/osreading/oswriting many perhaps temporary files in a long running process.

osfilevar.osclose();
// or
osclose(osfilevar);
if strvar.oswrite(osfilename, codepage = "") Create a complete os file from a var.

Any existing os file is removed first.

Returns: True if successful or false if not possible for any reason.

e.g. Path is not writeable, permissions etc.

If codepage is specified then output is converted from utf-8 to that codepage. Otherwise no conversion is done.

let text = "aaa = 123\nbbb = 456";
let osfilename = ostempdirpath() ^ "xo_gendoc_test.conf";
if (text.oswrite(osfilename)) ... ok
// or
if (oswrite(text on osfilename)) ... ok
if strvar.osread(osfilename, codepage = "") Read a complete os file into a var.

If codepage is specified then input is converted from that codepage to utf-8 otherwise no conversion is done.

Returns: True if successful or false if not possible for any reason.

e.g. File doesnt exist, permissions etc.

var text;
let osfilename = ostempdirpath() ^ "xo_gendoc_test.conf";
if (text.osread(osfilename)) ... ok // text -> "aaa = 123\nbbb = 456"
// or
if (osread(text from osfilename)) ... ok
if osfile_or_dirname.osrename(new_dirpath_or_filepath) Renames an os file or dir in the OS file system.

Will not overwrite an existing os file or dir.

Source and target must exist in the same storage device.

Returns: True if successful or false if not possible for any reason.

e.g. Target already exists, path is not writeable, permissions etc.

Uses std::filesystem::rename internally.

let from_osfilename = ostempdirpath() ^ "xo_gendoc_test.conf";
let to_osfilename = from_osfilename ^ ".bak";
if (not osremove(ostempdirpath() ^ "xo_gendoc_test.conf.bak")) {}; // Cleanup first

if (from_osfilename.osrename(to_osfilename)) ... ok
// or
if (osrename(from_osfilename, to_osfilename)) ...
if osfile_or_dirname.osmove(to_osfilename) "Moves" an os file or dir within the os file system.

Will not overwrite an existing os file or dir.

Returns: True if successful or false if not possible for any reason.

e.g. Source doesnt exist or cannot be accessed, target already exists, source or target is not writeable, permissions etc.

Attempts osrename first then oscopy followed by osremove original.

let from_osfilename = ostempdirpath() ^ "xo_gendoc_test.conf.bak";
let to_osfilename = from_osfilename.cut(-4);

if (not osremove(ostempdirpath() ^ "xo_gendoc_test.conf")) {}; // Cleanup first
if (from_osfilename.osmove(to_osfilename)) ... ok
// or
if (osmove(from_osfilename, to_osfilename)) ...
if osfile_or_dirname.oscopy(to_osfilename) Copies an os file or directory recursively within the os file system.

Will overwrite an existing os file or dir.

Uses std::filesystem::copy internally with recursive and overwrite options

let from_osfilename = ostempdirpath() ^ "xo_gendoc_test.conf";
let to_osfilename = from_osfilename ^ ".bak";

if (from_osfilename.oscopy(to_osfilename)) ... ok;
// or
if (oscopy(from_osfilename, to_osfilename)) ... ok
if osfilename.osremove() Removes/deletes an os file from the OS file system given path and name.

Will not remove directories. Use osrmdir() to remove directories

Returns: True if successful or false if not possible for any reason.

e.g. Target doesnt exist, path is not writeable, permissions etc.

let osfilename = ostempdirpath() ^ "xo_gendoc_test.conf";
if (osfilename.osremove()) ... ok
// or
if (osremove(osfilename)) ...
OS Directories
Usage Function Description
var= dirpath.oslist(globpattern = "", mode = 0) Returns: A FM delimited string containing all matching dir entries given a dir path

A glob pattern (e.g. *.conf) can be appended to the path or passed as argument.

var entries1 = "/etc/"_var.oslist("*.cfg"); /// e.g. "adduser.conf^ca-certificates.con^... etc."
// or
var entries2 = oslist("/etc/" "*.conf");
var= dirpath.oslistf(globpattern = "") Same as oslist for files only
var= dirpath.oslistd(globpattern = "") Same as oslist for files only
var= osfile_or_dirpath.osinfo(mode = 0) Returns: Dir info for any dir entry or "" if it doesnt exist

A short string containing size ^ FM ^ modified_time ^ FM ^ modified_time

mode 0 default

mode 1 returns "" if not an os file

mode 2 returns "" if not an os dir

See also osfile() and osdir()

var info1 = "/etc/hosts"_var.osinfo(); /// e.g. "221^20597^78309"_var
// or
var info2 = osinfo("/etc/hosts");
var= osfilename.osfile() Returns: Dir info for a os file

A short string containing size ^ FM ^ modified_time ^ FM ^ modified_time

Alias for osinfo(1)

var fileinfo1 = "/etc/hosts"_var.osfile(); /// e.g. "221^20597^78309"_var
// or
var fileinfo2 = osfile("/etc/hosts");
var= dirpath.osdir() Returns: Dir info for a dir.

A short string containing FM ^ modified_time ^ FM ^ modified_time

Alias for osinfo(2)

var dirinfo1 = "/etc/"_var.osdir(); /// e.g. "^20848^44464"_var
// or
var dirinfo2 = osfile("/etc/");
if dirpath.osmkdir() Makes a new directory and returns true if successful.

Including parent dirs if necessary.

let osdirname = "xo_test/aaa";
if (osrmdir("xo_test/aaa")) {}; // Cleanup first
if (osdirname.osmkdir()) ... ok
// or
if (osmkdir(osdirname)) ...
if dirpath.oscwd(newpath) Changes the current working dir and returns true if successful.
let osdirname = "xo_test/aaa";
if (osdirname.oscwd()) ... ok
// or
if (oscwd(osdirname)) ... ok
var= dirpath.oscwd() Returns: The current working directory

e.g. "/root/exodus/cli/src/xo_test/aaa"

var cwd1 = var().oscwd();
// or
var cwd2 = oscwd();
if dirpath.osrmdir(evenifnotempty = false) Removes a os dir and returns true if successful.

Optionally even if not empty. Including subdirs.

let osdirname = "xo_test/aaa";
if (oscwd("../..")) ... ok /// Change up before removing because cannot remove dir while it is current
if (osdirname.osrmdir()) ... ok
// or
if (osrmdir(osdirname)) ...
OS Shell/Environment
Usage Function Description
if command.osshell() Execute a shell command.

Returns: True if the process terminates with error status 0 and false otherwise.

Append "&>/dev/null" to the command to suppress terminal output.

let cmd = "echo $HOME";
if (cmd.osshell()) ... ok
// or
if (osshell(cmd)) ... ok
if instr.osshellread(oscmd) Same as osshell but captures and returns stdout

Returns: The stout of the shell command.

Append "2>&1" to the command to capture stderr/stdlog output as well.

let cmd = "echo $HOME";
var text;
if (text.osshellread(cmd)) ... ok

// or capturing stdout but ignoring exit status
text = osshellread(cmd);
if outstr.osshellwrite(oscmd) Same as osshell but provides stdin to the process

Returns: True if the process terminates with error status 0 and false otherwise.

Append "&> somefile" to the command to suppress and/or capture output.

let outtext = "abc xyz";
if (outtext.osshellwrite("grep xyz")) ... ok
// or
if (osshellwrite(outtext, "grep xyz")) ... ok
var= var().ostempdirpath() Returns: The path of the tmp dir

e.g. "/tmp/"

let v1 = var().ostempdirpath();
// or
let v2 = ostempdirpath();
var= var().ostempfilename() Returns: The name of a new temporary file

e.g. Something like "/tmp/~exoEcLj3C"

var temposfilename1 = var().ostempfilename();
// or
var temposfilename2 = ostempfilename();
cmd envvalue.ossetenv(envcode) Set the value of an environment variable code
let envcode = "EXO_ABC", envvalue = "XYZ";
envvalue.ossetenv(envcode);
// or
ossetenv(envcode, envvalue);
if envvalue.osgetenv(envcode) Get the value of an environment variable
var envvalue1;
if (envvalue1.osgetenv("HOME")) ... ok // e.g. "/home/exodus"
// or
var envvalue2 = osgetenv("EXO_ABC"); // "XYZ"
var= var().ospid() Get the os process id
let pid1 = var().ospid(); /// e.g. 663237
// or
let pid2 = ospid();
var= var().ostid() Get the os thread process id
let tid1 = var().ostid(); /// e.g. 663237
// or
let tid2 = ostid();
var= var().version() Get the libexodus build date and time
let v1 = var().version(); /// e.g. "29 JAN 2025 14:56:52"
if strvar.setxlocale() Sets the current thread's default locale codepage code

True if successful

if ("en_US.utf8"_var.setxlocale()) ... ok
// or
if (setxlocale("en_US.utf8")) ... ok
expr var.getxlocale() Returns: The current thread's default locale codepage code
let v1 = var().getxlocale(); // "en_US.utf8"
// or
let v2 = getxlocale();
Output
Usage Function Description
expr var.output() To stdout. No new line. Buffered.
expr var.outputl() To stdout. Starts a new line. Flushed.
expr var.outputt() To stdout. Adds a tab. Buffered.
expr var.logput() To stdlog. No new line. Buffered.
expr var.logputl() To stdlog. Starts a new line. Flushed.
expr var.errput() To stderr. No new line. Flushed.
expr var.errputl() To stderr. Starts a new line. Flushed.
expr var.output(prefix) To stdout. With a prefix. No new line. Buffered.
expr var.outputl(prefix) To stdout. With a prefix. Starts a new line. Flushed.
expr var.outputt(prefix) To stdout. With a prefix. Adds a tab. Buffered.
expr var.logput(prefix) To stdlog. With a prefix. No new line. Buffered.
expr var.logputl(prefix) To stdlog. With a prefix. Starts a new line. Flushed.
expr var.errput(prefix) To stderr. With a prefix. No new line. Flushed.
expr var.errputl(prefix) To stderr. With a prefix. Starts a new line. Flushed.
expr var.put(std::ostream& ostream1) Output to a given stream
cmd var().osflush() Flushes any buffered output to stdout/cout
var().osflush();
// or
osflush();
Standard Input
Usage Function Description
expr var.input() Wait for stdin until cr or eof
expr var.input(prompt) Ditto after outputting prompt to stdout
expr var.inputn(nchars) Wait for nbytes from stdin
if var.isterminal() True if terminal is available
if var.hasinput(milliseconds = 0) True if stdin bytes available within milliseconds
if var.eof() True if stdin is at end of file
if var.echo(on_off) Reflect all stdin to stdout if terminal available
cmd var.breakon() Allow interrupt Ctrl+C
cmd var.breakoff() Prevent interrupt Ctr+C
Math/Boolean
Usage Function Description
var= num.abs() Absolute value
let v1 = var(-12.34).abs(); // 12.34
// or
let v2 = abs(-12.34);
var= num.pwr(exponent) Power
let v1 = var(2).pwr(8); // 256
// or
let v2 = pwr(2, 8);
cmd num.initrnd() Initialise the seed for rnd()

Allows the stream of pseudo random numbers generated by rnd() to be reproduced.

Seeded from std::chrono::high_resolution_clock::now() if the argument is 0;

var(123).initrnd(); /// Set seed to 123
// or
initrnd(123);
var= num.rnd() Pseudo random number generator

Returns: a pseudo random integer between 0 and the provided maximum minus 1.

Uses std::mt19937 and std::uniform_int_distribution<int>

let v1 = var(100).rnd().outputl();
// or
let v2 = rnd(100);
var= num.exp() Power of e
let v1 = var(1).exp(); // 2.718281828459045
// or
let v2 = exp(1);
var= num.sqrt() Square root
let v1 = var(100).sqrt(); // 10
// or
let v2 = sqrt(100);
var= num.sin() Sine of degrees
let v1 = var(30).sin(); // 0.5
// or
let v2 = sin(30);
var= num.cos() Cosine of degrees
let v1 = var(60).cos(); // 0.5
// or
let v2 = cos(60);
var= num.tan() Tangent of degrees
let v1 = var(45).tan(); // 1
// or
let v2 = tan(45);
var= num.atan() Arctangent of degrees
let v1 = var(1).atan(); // 45
// or
let v2 = atan(1);
var= num.loge() Natural logarithm

Returns: Floating point ver (double)

let v1 = var(2.718281828459045).loge(); // 1
// or
let v2 = loge(2.718281828459045);
var= num.integer() Truncate decimal numbers towards zero

Returns: A var integer

let v1 = var(2.9).integer(); // 2
// or
let v2 = integer(2.9);

var v3 = var(-2.9).integer(); // -2
// or
var v4 = integer(-2.9);
var= num.floor() Truncate decimal numbers towards negative

Returns: A var integer

let v1 = var(2.9).floor(); // 2
// or
let v2 = floor(2.9);

var v3 = var(-2.9).floor(); // -3
// or
var v4 = floor(-2.9);
var= num.mod(modulus) Modulus function

Identical to C++ % operator only for positive numbers and modulus

Negative denominators are considered as periodic with positiive numbers

Result is between [0 , modulus) if modulus is positive

Result is between (modulus, 0] if modulus is negative (symmetric)

mod(11, 5); // 1

mod(-11, 5); // 4

mod(11, -5); // -4

mod(-11, -5); // -1

let v1 = var(11).mod(5); // 1
// or
let v2 = mod(11, 5);