269 lines
8.7 KiB
C++
269 lines
8.7 KiB
C++
/* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
|
|
/*
|
|
* This file is part of the LibreOffice project.
|
|
*
|
|
* This Source Code Form is subject to the terms of the Mozilla Public
|
|
* License, v. 2.0. If a copy of the MPL was not distributed with this
|
|
* file, You can obtain one at http://mozilla.org/MPL/2.0/.
|
|
*
|
|
* This file incorporates work covered by the following license notice:
|
|
*
|
|
* Licensed to the Apache Software Foundation (ASF) under one or more
|
|
* contributor license agreements. See the NOTICE file distributed
|
|
* with this work for additional information regarding copyright
|
|
* ownership. The ASF licenses this file to you under the Apache
|
|
* License, Version 2.0 (the "License"); you may not use this file
|
|
* except in compliance with the License. You may obtain a copy of
|
|
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
|
|
*/
|
|
|
|
#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
|
|
{
|
|
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'
|
|
|
|
*/
|
|
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;
|
|
};
|
|
|
|
/** 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: */
|