connectivity/source/drivers/file/FStringFunctions.cxx

   1 /*************************************************************************
   2  *
   3  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
   4  *
   5  * Copyright 2008 by Sun Microsystems, Inc.
   6  *
   7  * OpenOffice.org - a multi-platform office productivity suite
   8  *
   9  * $RCSfile: FStringFunctions.cxx,v $
  10  * $Revision: 1.6 $
  11  *
  12  * This file is part of OpenOffice.org.
  13  *
  14  * OpenOffice.org is free software: you can redistribute it and/or modify
  15  * it under the terms of the GNU Lesser General Public License version 3
  16  * only, as published by the Free Software Foundation.
  17  *
  18  * OpenOffice.org is distributed in the hope that it will be useful,
  19  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  20  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  21  * GNU Lesser General Public License version 3 for more details
  22  * (a copy is included in the LICENSE file that accompanied this code).
  23  *
  24  * You should have received a copy of the GNU Lesser General Public License
  25  * version 3 along with OpenOffice.org.  If not, see
  26  * <http://www.openoffice.org/license.html>
  27  * for a copy of the LGPLv3 License.
  28  *
  29  ************************************************************************/
  30
  31 // MARKER(update_precomp.py): autogen include statement, do not remove
  32 #include "precompiled_connectivity.hxx"
  33
  34 #include "file/FStringFunctions.hxx"
  35 #include <rtl/ustrbuf.hxx>
  36 #include <rtl/logfile.hxx>
  37
  38 using namespace connectivity;
  39 using namespace connectivity::file;
  40 //------------------------------------------------------------------
  41 ORowSetValue OOp_Upper::operate(const ORowSetValue& lhs) const
  42 {
  43     RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OOp_Upper::operate" );
  44     if ( lhs.isNull() )
  45         return lhs;
  46
  47     return lhs.getString().toAsciiUpperCase();
  48 }
  49 //------------------------------------------------------------------
  50 ORowSetValue OOp_Lower::operate(const ORowSetValue& lhs) const
  51 {
  52     RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OOp_Lower::operate" );
  53     if ( lhs.isNull() )
  54         return lhs;
  55
  56     return lhs.getString().toAsciiLowerCase();
  57 }
  58 //------------------------------------------------------------------
  59 ORowSetValue OOp_Ascii::operate(const ORowSetValue& lhs) const
  60 {
  61     RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OOp_Ascii::operate" );
  62     if ( lhs.isNull() )
  63         return lhs;
  64     ::rtl::OString sStr(::rtl::OUStringToOString(lhs,RTL_TEXTENCODING_ASCII_US));
  65     sal_Int32 nAscii = sStr.toChar();
  66     return nAscii;
  67 }
  68 //------------------------------------------------------------------
  69 ORowSetValue OOp_CharLength::operate(const ORowSetValue& lhs) const
  70 {
  71     RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OOp_CharLength::operate" );
  72     if ( lhs.isNull() )
  73         return lhs;
  74
  75     return lhs.getString().getLength();
  76 }
  77 //------------------------------------------------------------------
  78 ORowSetValue OOp_Char::operate(const ::std::vector<ORowSetValue>& lhs) const
  79 {
  80     RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OOp_Char::operate" );
  81     if ( lhs.empty() )
  82         return ORowSetValue();
  83
  84     ::rtl::OUString sRet;
  85     ::std::vector<ORowSetValue>::const_reverse_iterator aIter = lhs.rbegin();
  86     ::std::vector<ORowSetValue>::const_reverse_iterator aEnd = lhs.rend();
  87     for (; aIter != aEnd; ++aIter)
  88     {
  89         if ( !aIter->isNull() )
  90         {
  91             sal_Char c = static_cast<sal_Char>(static_cast<sal_Int32>(*aIter));
  92
  93             sRet += ::rtl::OUString(&c,1,RTL_TEXTENCODING_ASCII_US);
  94         }
  95     }
  96
  97     return sRet;
  98 }
  99 //------------------------------------------------------------------
 100 ORowSetValue OOp_Concat::operate(const ::std::vector<ORowSetValue>& lhs) const
 101 {
 102     RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OOp_Concat::operate" );
 103     if ( lhs.empty() )
 104         return ORowSetValue();
 105
 106     ::rtl::OUStringBuffer sRet;
 107     ::std::vector<ORowSetValue>::const_reverse_iterator aIter = lhs.rbegin();
 108     ::std::vector<ORowSetValue>::const_reverse_iterator aEnd = lhs.rend();
 109     for (; aIter != aEnd; ++aIter)
 110     {
 111         if ( aIter->isNull() )
 112             return ORowSetValue();
 113
 114         sRet.append(aIter->operator ::rtl::OUString());
 115     }
 116
 117     return sRet.makeStringAndClear();
 118 }
 119 //------------------------------------------------------------------
 120 ORowSetValue OOp_Locate::operate(const ::std::vector<ORowSetValue>& lhs) const
 121 {
 122     RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OOp_Locate::operate" );
 123     ::std::vector<ORowSetValue>::const_iterator aIter = lhs.begin();
 124     ::std::vector<ORowSetValue>::const_iterator aEnd = lhs.end();
 125     for (; aIter != aEnd; ++aIter)
 126     {
 127         if ( aIter->isNull() )
 128             return ORowSetValue();
 129     }
 130     if ( lhs.size() == 2 )
 131         return ::rtl::OUString::valueOf(lhs[0].getString().indexOf(lhs[1].getString())+1);
 132
 133     else if ( lhs.size() != 3 )
 134         return ORowSetValue();
 135
 136     return lhs[1].getString().indexOf(lhs[2].getString(),lhs[0]) + 1;
 137 }
 138 //------------------------------------------------------------------
 139 ORowSetValue OOp_SubString::operate(const ::std::vector<ORowSetValue>& lhs) const
 140 {
 141     RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OOp_SubString::operate" );
 142     ::std::vector<ORowSetValue>::const_iterator aIter = lhs.begin();
 143     ::std::vector<ORowSetValue>::const_iterator aEnd = lhs.end();
 144     for (; aIter != aEnd; ++aIter)
 145     {
 146         if ( aIter->isNull() )
 147             return ORowSetValue();
 148     }
 149     if ( lhs.size() == 2 && static_cast<sal_Int32>(lhs[0]) >= sal_Int32(0) )
 150         return lhs[1].getString().copy(static_cast<sal_Int32>(lhs[0])-1);
 151
 152     else if ( lhs.size() != 3 || static_cast<sal_Int32>(lhs[1]) < sal_Int32(0))
 153         return ORowSetValue();
 154
 155     return lhs[2].getString().copy(static_cast<sal_Int32>(lhs[1])-1,lhs[0]);
 156 }
 157 //------------------------------------------------------------------
 158 ORowSetValue OOp_LTrim::operate(const ORowSetValue& lhs) const
 159 {
 160     RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OOp_LTrim::operate" );
 161     if ( lhs.isNull() )
 162         return lhs;
 163
 164     ::rtl::OUString sRet = lhs;
 165     ::rtl::OUString sNew = sRet.trim();
 166     return sRet.copy(sRet.indexOf(sNew));
 167 }
 168 //------------------------------------------------------------------
 169 ORowSetValue OOp_RTrim::operate(const ORowSetValue& lhs) const
 170 {
 171     RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OOp_RTrim::operate" );
 172     if ( lhs.isNull() )
 173         return lhs;
 174
 175     ::rtl::OUString sRet = lhs;
 176     ::rtl::OUString sNew = sRet.trim();
 177     return sRet.copy(0,sRet.lastIndexOf(sNew.getStr()[sNew.getLength()-1])+1);
 178 }
 179 //------------------------------------------------------------------
 180 ORowSetValue OOp_Space::operate(const ORowSetValue& lhs) const
 181 {
 182     RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OOp_Space::operate" );
 183     if ( lhs.isNull() )
 184         return lhs;
 185
 186     const sal_Char c = ' ';
 187     ::rtl::OUStringBuffer sRet;
 188     sal_Int32 nCount = lhs;
 189     for (sal_Int32 i=0; i < nCount; ++i)
 190     {
 191         sRet.appendAscii(&c,1);
 192     }
 193     return sRet.makeStringAndClear();
 194 }
 195 //------------------------------------------------------------------
 196 ORowSetValue OOp_Replace::operate(const ::std::vector<ORowSetValue>& lhs) const
 197 {
 198     RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OOp_Replace::operate" );
 199     if ( lhs.size() != 3 )
 200         return ORowSetValue();
 201
 202     ::rtl::OUString sStr  = lhs[2];
 203     ::rtl::OUString sFrom = lhs[1];
 204     ::rtl::OUString sTo   = lhs[0];
 205     sal_Int32 nIndexOf = sStr.indexOf(sFrom);
 206     while( nIndexOf != -1 )
 207     {
 208         sStr = sStr.replaceAt(nIndexOf,sFrom.getLength(),sTo);
 209         nIndexOf = sStr.indexOf(sFrom,nIndexOf + sTo.getLength());
 210     }
 211
 212     return sStr;
 213 }
 214 //------------------------------------------------------------------
 215 ORowSetValue OOp_Repeat::operate(const ORowSetValue& lhs,const ORowSetValue& rhs) const
 216 {
 217     RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OOp_Repeat::operate" );
 218     if ( lhs.isNull() || rhs.isNull() )
 219         return lhs;
 220
 221     ::rtl::OUString sRet;
 222     sal_Int32 nCount = rhs;
 223     for (sal_Int32 i=0; i < nCount; ++i)
 224     {
 225         sRet += lhs;
 226     }
 227     return sRet;
 228 }
 229 //------------------------------------------------------------------
 230 ORowSetValue OOp_Insert::operate(const ::std::vector<ORowSetValue>& lhs) const
 231 {
 232     RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OOp_Insert::operate" );
 233     if ( lhs.size() != 4 )
 234         return ORowSetValue();
 235
 236     ::rtl::OUString sStr = lhs[3];
 237
 238     sal_Int32 nStart = static_cast<sal_Int32>(lhs[2]);
 239     if ( nStart < 1 )
 240         nStart = 1;
 241     return sStr.replaceAt(nStart-1,static_cast<sal_Int32>(lhs[1]),lhs[0]);
 242 }
 243 //------------------------------------------------------------------
 244 ORowSetValue OOp_Left::operate(const ORowSetValue& lhs,const ORowSetValue& rhs) const
 245 {
 246     RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OOp_Left::operate" );
 247     if ( lhs.isNull() || rhs.isNull() )
 248         return lhs;
 249
 250     ::rtl::OUString sRet = lhs;
 251     sal_Int32 nCount = rhs;
 252     if ( nCount < 0 )
 253         return ORowSetValue();
 254     return sRet.copy(0,nCount);
 255 }
 256 //------------------------------------------------------------------
 257 ORowSetValue OOp_Right::operate(const ORowSetValue& lhs,const ORowSetValue& rhs) const
 258 {
 259     RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "file", "Ocke.Janssen@sun.com", "OOp_Right::operate" );
 260     if ( lhs.isNull() || rhs.isNull() )
 261         return lhs;
 262
 263     sal_Int32 nCount = rhs;
 264     ::rtl::OUString sRet = lhs;
 265     if ( nCount < 0 || nCount >= sRet.getLength() )
 266         return ORowSetValue();
 267
 268     return sRet.copy(sRet.getLength()-nCount,nCount);
 269 }
 270