diff options
Diffstat (limited to 'connectivity/source/inc/file/FStringFunctions.hxx')
| -rw-r--r-- | connectivity/source/inc/file/FStringFunctions.hxx | 475 |
1 files changed, 236 insertions, 239 deletions
diff --git a/connectivity/source/inc/file/FStringFunctions.hxx b/connectivity/source/inc/file/FStringFunctions.hxx index 70dabe3e1d92..a4f622293dc0 100644 --- a/connectivity/source/inc/file/FStringFunctions.hxx +++ b/connectivity/source/inc/file/FStringFunctions.hxx @@ -17,256 +17,253 @@ * the License at http://www.apache.org/licenses/LICENSE-2.0 . */ -#ifndef INCLUDED_CONNECTIVITY_SOURCE_INC_FILE_FSTRINGFUNCTIONS_HXX -#define INCLUDED_CONNECTIVITY_SOURCE_INC_FILE_FSTRINGFUNCTIONS_HXX +#pragma once #include <file/fcode.hxx> namespace connectivity::file +{ + /** UCASE(str) + UPPER(str) + Returns the string str with all characters changed to uppercase according to the current character set mapping (the default is ISO-8859-1 Latin1): + + > SELECT UCASE('Hej'); + -> 'HEJ' + + */ + class OOp_Upper : public OUnaryOperator { - /** UCASE(str) - UPPER(str) - Returns the string str with all characters changed to uppercase according to the current character set mapping (the default is ISO-8859-1 Latin1): - - > SELECT UCASE('Hej'); - -> 'HEJ' - - */ - class OOp_Upper : public OUnaryOperator - { - protected: - virtual ORowSetValue operate(const ORowSetValue& lhs) const override; - }; - - /** LCASE(str) - LOWER(str) - Returns the string str with all characters changed to lowercase according to the current character set mapping (the default is ISO-8859-1 Latin1): - - > SELECT LCASE('QUADRATICALLY'); - -> 'quadratically' - - */ - class OOp_Lower : public OUnaryOperator - { - protected: - virtual ORowSetValue operate(const ORowSetValue& lhs) const override; - }; - - /** ASCII(str) - Returns the ASCII code value of the leftmost character of the string str. Returns 0 if str is the empty string. Returns NULL if str is NULL: - - > SELECT ASCII('2'); - -> 50 - > SELECT ASCII(2); - -> 50 - > SELECT ASCII('dx'); - -> 100 - - */ - class OOp_Ascii : public OUnaryOperator - { - protected: - virtual ORowSetValue operate(const ORowSetValue& lhs) const override; - }; - - /** LENGTH(str) - OCTET_LENGTH(str) - CHAR_LENGTH(str) - CHARACTER_LENGTH(str) - Returns the length of the string str: - - > SELECT LENGTH('text'); - -> 4 - > SELECT OCTET_LENGTH('text'); - -> 4 - - */ - class OOp_CharLength : public OUnaryOperator - { - protected: - virtual ORowSetValue operate(const ORowSetValue& lhs) const override; - }; - - /** CHAR(N,...) - CHAR() interprets the arguments as integers and returns a string consisting of the characters given by the ASCII code values of those integers. NULL values are skipped: - - > SELECT CHAR(ascii('t'),ascii('e'),ascii('s'),ascii('t')); - -> 'test' - > SELECT CHAR(77,77.3,'77.3'); - -> 'MMM' - - */ - class OOp_Char : public ONthOperator - { - protected: - virtual ORowSetValue operate(const std::vector<ORowSetValue>& lhs) const override; - }; - - /** CONCAT(str1,str2,...) - Returns the string that results from concatenating the arguments. Returns NULL if any argument is NULL. May have more than 2 arguments. A numeric argument is converted to the equivalent string form: - - > SELECT CONCAT('OO', 'o', 'OO'); - -> 'OOoOO' - > SELECT CONCAT('OO', NULL, 'OO'); - -> NULL - > SELECT CONCAT(14.3); - -> '14.3' - - */ - class OOp_Concat : public ONthOperator - { - protected: - virtual ORowSetValue operate(const std::vector<ORowSetValue>& lhs) const override; - }; - - /** LOCATE(substr,str) - POSITION(substr IN str) - Returns the position of the first occurrence of substring substr in string str. Returns 0 if substr is not in str: - - > SELECT LOCATE('bar', 'foobarbar'); - -> 4 - > SELECT LOCATE('xbar', 'foobar'); - -> 0 - LOCATE(substr,str,pos) - Returns the position of the first occurrence of substring substr in string str, starting at position pos. Returns 0 if substr is not in str: - - > SELECT LOCATE('bar', 'foobarbar',5); - -> 7 - - */ - class OOp_Locate : public ONthOperator - { - protected: - virtual ORowSetValue operate(const std::vector<ORowSetValue>& lhs) const override; - }; - - /** SUBSTRING(str,pos) - SUBSTRING(str FROM pos) - Returns a substring from string str starting at position pos: - - > SELECT SUBSTRING('Quadratically',5); - -> 'ratically' - > SELECT SUBSTRING('foobarbar' FROM 4); - -> 'barbar' - SUBSTRING(str,pos,len) - SUBSTRING(str FROM pos FOR len) - Returns a substring len characters long from string str, starting at position pos. The variant form that uses FROM is SQL-92 syntax: - - > SELECT SUBSTRING('Quadratically',5,6); - -> 'ratica' - - */ - class OOp_SubString : public ONthOperator - { - protected: - virtual ORowSetValue operate(const std::vector<ORowSetValue>& lhs) const override; - }; - - /** LTRIM(str) - Returns the string str with leading space characters removed: - - > SELECT LTRIM(' barbar'); - -> 'barbar' + protected: + virtual ORowSetValue operate(const ORowSetValue& lhs) const override; + }; + + /** LCASE(str) + LOWER(str) + Returns the string str with all characters changed to lowercase according to the current character set mapping (the default is ISO-8859-1 Latin1): + + > SELECT LCASE('QUADRATICALLY'); + -> 'quadratically' + + */ + class OOp_Lower : public OUnaryOperator + { + protected: + virtual ORowSetValue operate(const ORowSetValue& lhs) const override; + }; + + /** ASCII(str) + Returns the ASCII code value of the leftmost character of the string str. Returns 0 if str is the empty string. Returns NULL if str is NULL: + + > SELECT ASCII('2'); + -> 50 + > SELECT ASCII(2); + -> 50 + > SELECT ASCII('dx'); + -> 100 + + */ + class OOp_Ascii : public OUnaryOperator + { + protected: + virtual ORowSetValue operate(const ORowSetValue& lhs) const override; + }; + + /** LENGTH(str) + OCTET_LENGTH(str) + CHAR_LENGTH(str) + CHARACTER_LENGTH(str) + Returns the length of the string str: + + > SELECT LENGTH('text'); + -> 4 + > SELECT OCTET_LENGTH('text'); + -> 4 + + */ + class OOp_CharLength : public OUnaryOperator + { + protected: + virtual ORowSetValue operate(const ORowSetValue& lhs) const override; + }; - */ - class OOp_LTrim : public OUnaryOperator - { - protected: - virtual ORowSetValue operate(const ORowSetValue& lhs) const override; - }; + /** CHAR(N,...) + CHAR() interprets the arguments as integers and returns a string consisting of the characters given by the ASCII code values of those integers. NULL values are skipped: + + > SELECT CHAR(ascii('t'),ascii('e'),ascii('s'),ascii('t')); + -> 'test' + > SELECT CHAR(77,77.3,'77.3'); + -> 'MMM' + + */ + class OOp_Char : public ONthOperator + { + protected: + virtual ORowSetValue operate(const std::vector<ORowSetValue>& lhs) const override; + }; + + /** CONCAT(str1,str2,...) + Returns the string that results from concatenating the arguments. Returns NULL if any argument is NULL. May have more than 2 arguments. A numeric argument is converted to the equivalent string form: + + > SELECT CONCAT('OO', 'o', 'OO'); + -> 'OOoOO' + > SELECT CONCAT('OO', NULL, 'OO'); + -> NULL + > SELECT CONCAT(14.3); + -> '14.3' + + */ + class OOp_Concat : public ONthOperator + { + protected: + virtual ORowSetValue operate(const std::vector<ORowSetValue>& lhs) const override; + }; + + /** LOCATE(substr,str) + POSITION(substr IN str) + Returns the position of the first occurrence of substring substr in string str. Returns 0 if substr is not in str: + + > SELECT LOCATE('bar', 'foobarbar'); + -> 4 + > SELECT LOCATE('xbar', 'foobar'); + -> 0 + LOCATE(substr,str,pos) + Returns the position of the first occurrence of substring substr in string str, starting at position pos. Returns 0 if substr is not in str: + + > SELECT LOCATE('bar', 'foobarbar',5); + -> 7 + + */ + class OOp_Locate : public ONthOperator + { + protected: + virtual ORowSetValue operate(const std::vector<ORowSetValue>& lhs) const override; + }; - /** RTRIM(str) - Returns the string str with trailing space characters removed: + /** SUBSTRING(str,pos) + SUBSTRING(str FROM pos) + Returns a substring from string str starting at position pos: - > SELECT RTRIM('barbar '); + > SELECT SUBSTRING('Quadratically',5); + -> 'ratically' + > SELECT SUBSTRING('foobarbar' FROM 4); -> 'barbar' + SUBSTRING(str,pos,len) + SUBSTRING(str FROM pos FOR len) + Returns a substring len characters long from string str, starting at position pos. The variant form that uses FROM is SQL-92 syntax: - */ - class OOp_RTrim : public OUnaryOperator - { - protected: - virtual ORowSetValue operate(const ORowSetValue& lhs) const override; - }; - - /** SPACE(N) - Returns a string consisting of N space characters: - - > SELECT SPACE(6); - -> ' ' - - */ - class OOp_Space : public OUnaryOperator - { - protected: - virtual ORowSetValue operate(const ORowSetValue& lhs) const override; - }; - - /** REPLACE(str,from_str,to_str) - Returns the string str with all occurrences of the string from_str replaced by the string to_str: - - > SELECT REPLACE('www.OOo.com', 'w', 'Ww'); - -> 'WwWwWw.OOo.com' - - */ - class OOp_Replace : public ONthOperator - { - protected: - virtual ORowSetValue operate(const std::vector<ORowSetValue>& lhs) const override; - }; - - /** REPEAT(str,count) - Returns a string consisting of the string str repeated count times. If count <= 0, returns an empty string. Returns NULL if str or count are NULL: - - > SELECT REPEAT('OOo', 3); - -> 'OOoOOoOOo' - - */ - class OOp_Repeat : public OBinaryOperator - { - protected: - virtual ORowSetValue operate(const ORowSetValue& lhs,const ORowSetValue& rhs) const override; - }; - - /** INSERT(str,pos,len,newstr) - Returns the string str, with the substring beginning at position pos and len characters long replaced by the string newstr: - - > SELECT INSERT('Quadratic', 3, 4, 'What'); - -> 'QuWhattic' - - */ - class OOp_Insert : public ONthOperator - { - protected: - virtual ORowSetValue operate(const std::vector<ORowSetValue>& lhs) const override; - }; - - /** LEFT(str,len) - Returns the leftmost len characters from the string str: - - > SELECT LEFT('foobarbar', 5); - -> 'fooba' - - */ - class OOp_Left : public OBinaryOperator - { - protected: - virtual ORowSetValue operate(const ORowSetValue& lhs,const ORowSetValue& rhs) const override; - }; - - /** RIGHT(str,len) - Returns the rightmost len characters from the string str: - - > SELECT RIGHT('foobarbar', 4); - -> 'rbar' - */ - class OOp_Right : public OBinaryOperator - { - protected: - virtual ORowSetValue operate(const ORowSetValue& lhs,const ORowSetValue& rhs) const override; - }; + > SELECT SUBSTRING('Quadratically',5,6); + -> 'ratica' -} + */ + class OOp_SubString : public ONthOperator + { + protected: + virtual ORowSetValue operate(const std::vector<ORowSetValue>& lhs) const override; + }; + + /** LTRIM(str) + Returns the string str with leading space characters removed: + + > SELECT LTRIM(' barbar'); + -> 'barbar' + + */ + class OOp_LTrim : public OUnaryOperator + { + protected: + virtual ORowSetValue operate(const ORowSetValue& lhs) const override; + }; + + /** RTRIM(str) + Returns the string str with trailing space characters removed: + + > SELECT RTRIM('barbar '); + -> 'barbar' + + */ + class OOp_RTrim : public OUnaryOperator + { + protected: + virtual ORowSetValue operate(const ORowSetValue& lhs) const override; + }; -#endif // INCLUDED_CONNECTIVITY_SOURCE_INC_FILE_FSTRINGFUNCTIONS_HXX + /** SPACE(N) + Returns a string consisting of N space characters: + + > SELECT SPACE(6); + -> ' ' + + */ + class OOp_Space : public OUnaryOperator + { + protected: + virtual ORowSetValue operate(const ORowSetValue& lhs) const override; + }; + + /** REPLACE(str,from_str,to_str) + Returns the string str with all occurrences of the string from_str replaced by the string to_str: + + > SELECT REPLACE('www.OOo.com', 'w', 'Ww'); + -> 'WwWwWw.OOo.com' + + */ + class OOp_Replace : public ONthOperator + { + protected: + virtual ORowSetValue operate(const std::vector<ORowSetValue>& lhs) const override; + }; + + /** REPEAT(str,count) + Returns a string consisting of the string str repeated count times. If count <= 0, returns an empty string. Returns NULL if str or count are NULL: + + > SELECT REPEAT('OOo', 3); + -> 'OOoOOoOOo' + + */ + class OOp_Repeat : public OBinaryOperator + { + protected: + virtual ORowSetValue operate(const ORowSetValue& lhs,const ORowSetValue& rhs) const override; + }; + + /** INSERT(str,pos,len,newstr) + Returns the string str, with the substring beginning at position pos and len characters long replaced by the string newstr: + + > SELECT INSERT('Quadratic', 3, 4, 'What'); + -> 'QuWhattic' + + */ + class OOp_Insert : public ONthOperator + { + protected: + virtual ORowSetValue operate(const std::vector<ORowSetValue>& lhs) const override; + }; + + /** LEFT(str,len) + Returns the leftmost len characters from the string str: + + > SELECT LEFT('foobarbar', 5); + -> 'fooba' + + */ + class OOp_Left : public OBinaryOperator + { + protected: + virtual ORowSetValue operate(const ORowSetValue& lhs,const ORowSetValue& rhs) const override; + }; + + /** RIGHT(str,len) + Returns the rightmost len characters from the string str: + + > SELECT RIGHT('foobarbar', 4); + -> 'rbar' + */ + class OOp_Right : public OBinaryOperator + { + protected: + virtual ORowSetValue operate(const ORowSetValue& lhs,const ORowSetValue& rhs) const override; + }; + +} /* vim:set shiftwidth=4 softtabstop=4 expandtab: */ |