1*cdf0e10cSrcweir /************************************************************************* 2*cdf0e10cSrcweir * 3*cdf0e10cSrcweir * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. 4*cdf0e10cSrcweir * 5*cdf0e10cSrcweir * Copyright 2000, 2010 Oracle and/or its affiliates. 6*cdf0e10cSrcweir * 7*cdf0e10cSrcweir * OpenOffice.org - a multi-platform office productivity suite 8*cdf0e10cSrcweir * 9*cdf0e10cSrcweir * This file is part of OpenOffice.org. 10*cdf0e10cSrcweir * 11*cdf0e10cSrcweir * OpenOffice.org is free software: you can redistribute it and/or modify 12*cdf0e10cSrcweir * it under the terms of the GNU Lesser General Public License version 3 13*cdf0e10cSrcweir * only, as published by the Free Software Foundation. 14*cdf0e10cSrcweir * 15*cdf0e10cSrcweir * OpenOffice.org is distributed in the hope that it will be useful, 16*cdf0e10cSrcweir * but WITHOUT ANY WARRANTY; without even the implied warranty of 17*cdf0e10cSrcweir * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 18*cdf0e10cSrcweir * GNU Lesser General Public License version 3 for more details 19*cdf0e10cSrcweir * (a copy is included in the LICENSE file that accompanied this code). 20*cdf0e10cSrcweir * 21*cdf0e10cSrcweir * You should have received a copy of the GNU Lesser General Public License 22*cdf0e10cSrcweir * version 3 along with OpenOffice.org. If not, see 23*cdf0e10cSrcweir * <http://www.openoffice.org/license.html> 24*cdf0e10cSrcweir * for a copy of the LGPLv3 License. 25*cdf0e10cSrcweir * 26*cdf0e10cSrcweir ************************************************************************/ 27*cdf0e10cSrcweir 28*cdf0e10cSrcweir #ifndef _CONNECTIVITY_FILE_FCODE_HXX_ 29*cdf0e10cSrcweir #define _CONNECTIVITY_FILE_FCODE_HXX_ 30*cdf0e10cSrcweir 31*cdf0e10cSrcweir #include "connectivity/sqliterator.hxx" 32*cdf0e10cSrcweir #include <com/sun/star/sdbc/DataType.hpp> 33*cdf0e10cSrcweir #include "connectivity/CommonTools.hxx" 34*cdf0e10cSrcweir #include <tools/rtti.hxx> 35*cdf0e10cSrcweir #include <com/sun/star/container/XNameAccess.hpp> 36*cdf0e10cSrcweir #include <com/sun/star/container/XIndexAccess.hpp> 37*cdf0e10cSrcweir #include "connectivity/FValue.hxx" 38*cdf0e10cSrcweir #include "file/filedllapi.hxx" 39*cdf0e10cSrcweir 40*cdf0e10cSrcweir namespace connectivity 41*cdf0e10cSrcweir { 42*cdf0e10cSrcweir class OSQLParseNode; 43*cdf0e10cSrcweir namespace dbase 44*cdf0e10cSrcweir { 45*cdf0e10cSrcweir class ODbaseIndex; 46*cdf0e10cSrcweir } 47*cdf0e10cSrcweir namespace file 48*cdf0e10cSrcweir { 49*cdf0e10cSrcweir 50*cdf0e10cSrcweir class OOperand; 51*cdf0e10cSrcweir typedef ::std::stack<OOperand*> OCodeStack; 52*cdf0e10cSrcweir class OBoolOperator; 53*cdf0e10cSrcweir typedef ::std::map<sal_Int32,sal_Int32> OEvaluateSet; 54*cdf0e10cSrcweir 55*cdf0e10cSrcweir typedef ::com::sun::star::uno::Reference< ::com::sun::star::container::XNameAccess> OFileColumns; 56*cdf0e10cSrcweir 57*cdf0e10cSrcweir 58*cdf0e10cSrcweir class OOO_DLLPUBLIC_FILE OCode 59*cdf0e10cSrcweir { 60*cdf0e10cSrcweir public: 61*cdf0e10cSrcweir OCode(); 62*cdf0e10cSrcweir virtual ~OCode(); 63*cdf0e10cSrcweir 64*cdf0e10cSrcweir inline static void * SAL_CALL operator new( size_t nSize ) SAL_THROW( () ) 65*cdf0e10cSrcweir { return ::rtl_allocateMemory( nSize ); } 66*cdf0e10cSrcweir inline static void * SAL_CALL operator new( size_t /*nSize*/,void* _pHint ) SAL_THROW( () ) 67*cdf0e10cSrcweir { return _pHint; } 68*cdf0e10cSrcweir inline static void SAL_CALL operator delete( void * pMem ) SAL_THROW( () ) 69*cdf0e10cSrcweir { ::rtl_freeMemory( pMem ); } 70*cdf0e10cSrcweir inline static void SAL_CALL operator delete( void * /*pMem*/,void* /*_pHint*/ ) SAL_THROW( () ) 71*cdf0e10cSrcweir { } 72*cdf0e10cSrcweir 73*cdf0e10cSrcweir TYPEINFO(); 74*cdf0e10cSrcweir }; 75*cdf0e10cSrcweir 76*cdf0e10cSrcweir 77*cdf0e10cSrcweir // operands that the parsetree generate 78*cdf0e10cSrcweir class OOO_DLLPUBLIC_FILE OOperand : public OCode 79*cdf0e10cSrcweir { 80*cdf0e10cSrcweir protected: 81*cdf0e10cSrcweir sal_Int32 m_eDBType; 82*cdf0e10cSrcweir 83*cdf0e10cSrcweir OOperand(const sal_Int32& _rType) : m_eDBType(_rType){} 84*cdf0e10cSrcweir OOperand() : m_eDBType(::com::sun::star::sdbc::DataType::OTHER){} 85*cdf0e10cSrcweir 86*cdf0e10cSrcweir public: 87*cdf0e10cSrcweir virtual const ORowSetValue& getValue() const = 0; 88*cdf0e10cSrcweir virtual void setValue(const ORowSetValue& _rVal) = 0; 89*cdf0e10cSrcweir 90*cdf0e10cSrcweir virtual sal_Int32 getDBType() const {return m_eDBType;} 91*cdf0e10cSrcweir virtual OEvaluateSet* preProcess(OBoolOperator* pOp, OOperand* pRight = 0); 92*cdf0e10cSrcweir inline sal_Bool isValid() const; 93*cdf0e10cSrcweir 94*cdf0e10cSrcweir TYPEINFO(); 95*cdf0e10cSrcweir }; 96*cdf0e10cSrcweir 97*cdf0e10cSrcweir class OOO_DLLPUBLIC_FILE OOperandRow : public OOperand 98*cdf0e10cSrcweir { 99*cdf0e10cSrcweir sal_uInt16 m_nRowPos; 100*cdf0e10cSrcweir protected: 101*cdf0e10cSrcweir OValueRefRow m_pRow; 102*cdf0e10cSrcweir 103*cdf0e10cSrcweir OOperandRow(sal_uInt16 _nPos, sal_Int32 _rType); 104*cdf0e10cSrcweir public: 105*cdf0e10cSrcweir sal_uInt16 getRowPos() const {return m_nRowPos;} 106*cdf0e10cSrcweir virtual const ORowSetValue& getValue() const; 107*cdf0e10cSrcweir virtual void setValue(const ORowSetValue& _rVal); 108*cdf0e10cSrcweir void bindValue(const OValueRefRow& _pRow); // Bindung an den Wert, den der Operand repraesentiert 109*cdf0e10cSrcweir 110*cdf0e10cSrcweir TYPEINFO(); 111*cdf0e10cSrcweir }; 112*cdf0e10cSrcweir 113*cdf0e10cSrcweir // Attribute aus einer Ergebniszeile 114*cdf0e10cSrcweir class OOO_DLLPUBLIC_FILE OOperandAttr : public OOperandRow 115*cdf0e10cSrcweir { 116*cdf0e10cSrcweir protected: 117*cdf0e10cSrcweir ::com::sun::star::uno::Reference< ::com::sun::star::beans::XPropertySet> m_xColumn; 118*cdf0e10cSrcweir 119*cdf0e10cSrcweir public: 120*cdf0e10cSrcweir OOperandAttr(sal_uInt16 _nPos, 121*cdf0e10cSrcweir const ::com::sun::star::uno::Reference< ::com::sun::star::beans::XPropertySet>& _xColumn); 122*cdf0e10cSrcweir 123*cdf0e10cSrcweir virtual sal_Bool isIndexed() const; 124*cdf0e10cSrcweir virtual OEvaluateSet* preProcess(OBoolOperator* pOp, OOperand* pRight = 0); 125*cdf0e10cSrcweir TYPEINFO(); 126*cdf0e10cSrcweir }; 127*cdf0e10cSrcweir 128*cdf0e10cSrcweir // Parameter fuer ein Praedikat 129*cdf0e10cSrcweir class OOperandParam : public OOperandRow 130*cdf0e10cSrcweir { 131*cdf0e10cSrcweir public: 132*cdf0e10cSrcweir OOperandParam(connectivity::OSQLParseNode* pNode, sal_Int32 _nPos); 133*cdf0e10cSrcweir void describe(const ::com::sun::star::uno::Reference< ::com::sun::star::beans::XPropertySet>& _xColumn, ::vos::ORef<connectivity::OSQLColumns> _xParamColumns); 134*cdf0e10cSrcweir 135*cdf0e10cSrcweir TYPEINFO(); 136*cdf0e10cSrcweir }; 137*cdf0e10cSrcweir 138*cdf0e10cSrcweir // WerteOperanden 139*cdf0e10cSrcweir class OOperandValue : public OOperand 140*cdf0e10cSrcweir { 141*cdf0e10cSrcweir protected: 142*cdf0e10cSrcweir ORowSetValue m_aValue; 143*cdf0e10cSrcweir 144*cdf0e10cSrcweir protected: 145*cdf0e10cSrcweir OOperandValue(){} 146*cdf0e10cSrcweir OOperandValue(const ORowSetValue& _rVar, sal_Int32 eDbType) 147*cdf0e10cSrcweir : OOperand(eDbType) 148*cdf0e10cSrcweir , m_aValue(_rVar) 149*cdf0e10cSrcweir {} 150*cdf0e10cSrcweir 151*cdf0e10cSrcweir OOperandValue(sal_Int32 eDbType) :OOperand(eDbType){} 152*cdf0e10cSrcweir public: 153*cdf0e10cSrcweir virtual const ORowSetValue& getValue() const; 154*cdf0e10cSrcweir virtual void setValue(const ORowSetValue& _rVal); 155*cdf0e10cSrcweir 156*cdf0e10cSrcweir TYPEINFO(); 157*cdf0e10cSrcweir }; 158*cdf0e10cSrcweir 159*cdf0e10cSrcweir 160*cdf0e10cSrcweir // Konstanten 161*cdf0e10cSrcweir class OOperandConst : public OOperandValue 162*cdf0e10cSrcweir { 163*cdf0e10cSrcweir public: 164*cdf0e10cSrcweir OOperandConst(const connectivity::OSQLParseNode& rColumnRef, const rtl::OUString& aStrValue); 165*cdf0e10cSrcweir 166*cdf0e10cSrcweir TYPEINFO(); 167*cdf0e10cSrcweir }; 168*cdf0e10cSrcweir 169*cdf0e10cSrcweir 170*cdf0e10cSrcweir // Ergebnis Operanden 171*cdf0e10cSrcweir class OOperandResult : public OOperandValue 172*cdf0e10cSrcweir { 173*cdf0e10cSrcweir protected: 174*cdf0e10cSrcweir OOperandResult(const ORowSetValue& _rVar, sal_Int32 eDbType) 175*cdf0e10cSrcweir :OOperandValue(_rVar, eDbType) {} 176*cdf0e10cSrcweir OOperandResult(sal_Int32 eDbType) 177*cdf0e10cSrcweir :OOperandValue(eDbType) {} 178*cdf0e10cSrcweir public: 179*cdf0e10cSrcweir OOperandResult(const ORowSetValue& _rVar) 180*cdf0e10cSrcweir :OOperandValue(_rVar, _rVar.getTypeKind()) {} 181*cdf0e10cSrcweir TYPEINFO(); 182*cdf0e10cSrcweir }; 183*cdf0e10cSrcweir 184*cdf0e10cSrcweir 185*cdf0e10cSrcweir class OOperandResultBOOL : public OOperandResult 186*cdf0e10cSrcweir { 187*cdf0e10cSrcweir public: 188*cdf0e10cSrcweir OOperandResultBOOL(sal_Bool bResult) : OOperandResult(::com::sun::star::sdbc::DataType::BIT) 189*cdf0e10cSrcweir { 190*cdf0e10cSrcweir m_aValue = bResult ? 1.0 : 0.0; 191*cdf0e10cSrcweir m_aValue.setBound(sal_True); 192*cdf0e10cSrcweir } 193*cdf0e10cSrcweir }; 194*cdf0e10cSrcweir 195*cdf0e10cSrcweir class OOperandResultNUM : public OOperandResult 196*cdf0e10cSrcweir { 197*cdf0e10cSrcweir public: 198*cdf0e10cSrcweir OOperandResultNUM(double fNum) : OOperandResult(::com::sun::star::sdbc::DataType::DOUBLE) 199*cdf0e10cSrcweir { 200*cdf0e10cSrcweir m_aValue = fNum; 201*cdf0e10cSrcweir m_aValue.setBound(sal_True); 202*cdf0e10cSrcweir } 203*cdf0e10cSrcweir }; 204*cdf0e10cSrcweir 205*cdf0e10cSrcweir /** special stop operand 206*cdf0e10cSrcweir is appended when a list of arguments ends 207*cdf0e10cSrcweir */ 208*cdf0e10cSrcweir class OStopOperand : public OOperandValue 209*cdf0e10cSrcweir { 210*cdf0e10cSrcweir public: 211*cdf0e10cSrcweir OStopOperand(){} 212*cdf0e10cSrcweir TYPEINFO(); 213*cdf0e10cSrcweir }; 214*cdf0e10cSrcweir 215*cdf0e10cSrcweir // Operatoren 216*cdf0e10cSrcweir class OOO_DLLPUBLIC_FILE OOperator : public OCode 217*cdf0e10cSrcweir { 218*cdf0e10cSrcweir public: 219*cdf0e10cSrcweir virtual void Exec(OCodeStack&) = 0; 220*cdf0e10cSrcweir virtual sal_uInt16 getRequestedOperands() const; // Anzahl benoetigter Operanden 221*cdf0e10cSrcweir // Standard ist 2 222*cdf0e10cSrcweir TYPEINFO(); 223*cdf0e10cSrcweir }; 224*cdf0e10cSrcweir 225*cdf0e10cSrcweir 226*cdf0e10cSrcweir // boolsche Operatoren 227*cdf0e10cSrcweir 228*cdf0e10cSrcweir class OOO_DLLPUBLIC_FILE OBoolOperator : public OOperator 229*cdf0e10cSrcweir { 230*cdf0e10cSrcweir public: 231*cdf0e10cSrcweir TYPEINFO(); 232*cdf0e10cSrcweir virtual void Exec(OCodeStack&); 233*cdf0e10cSrcweir virtual sal_Bool operate(const OOperand*, const OOperand*) const; 234*cdf0e10cSrcweir }; 235*cdf0e10cSrcweir 236*cdf0e10cSrcweir class OOp_NOT : public OBoolOperator 237*cdf0e10cSrcweir { 238*cdf0e10cSrcweir public: 239*cdf0e10cSrcweir TYPEINFO(); 240*cdf0e10cSrcweir 241*cdf0e10cSrcweir protected: 242*cdf0e10cSrcweir virtual void Exec(OCodeStack&); 243*cdf0e10cSrcweir virtual sal_Bool operate(const OOperand*, const OOperand* = NULL) const; 244*cdf0e10cSrcweir virtual sal_uInt16 getRequestedOperands() const; 245*cdf0e10cSrcweir }; 246*cdf0e10cSrcweir 247*cdf0e10cSrcweir class OOp_AND : public OBoolOperator 248*cdf0e10cSrcweir { 249*cdf0e10cSrcweir public: 250*cdf0e10cSrcweir TYPEINFO(); 251*cdf0e10cSrcweir 252*cdf0e10cSrcweir protected: 253*cdf0e10cSrcweir virtual sal_Bool operate(const OOperand*, const OOperand*) const; 254*cdf0e10cSrcweir }; 255*cdf0e10cSrcweir 256*cdf0e10cSrcweir class OOp_OR : public OBoolOperator 257*cdf0e10cSrcweir { 258*cdf0e10cSrcweir public: 259*cdf0e10cSrcweir TYPEINFO(); 260*cdf0e10cSrcweir protected: 261*cdf0e10cSrcweir virtual sal_Bool operate(const OOperand*, const OOperand*) const; 262*cdf0e10cSrcweir }; 263*cdf0e10cSrcweir 264*cdf0e10cSrcweir class OOO_DLLPUBLIC_FILE OOp_ISNULL : public OBoolOperator 265*cdf0e10cSrcweir { 266*cdf0e10cSrcweir public: 267*cdf0e10cSrcweir TYPEINFO(); 268*cdf0e10cSrcweir public: 269*cdf0e10cSrcweir virtual void Exec(OCodeStack&); 270*cdf0e10cSrcweir virtual sal_uInt16 getRequestedOperands() const; 271*cdf0e10cSrcweir virtual sal_Bool operate(const OOperand*, const OOperand* = NULL) const; 272*cdf0e10cSrcweir }; 273*cdf0e10cSrcweir 274*cdf0e10cSrcweir class OOO_DLLPUBLIC_FILE OOp_ISNOTNULL : public OOp_ISNULL 275*cdf0e10cSrcweir { 276*cdf0e10cSrcweir public: 277*cdf0e10cSrcweir TYPEINFO(); 278*cdf0e10cSrcweir virtual sal_Bool operate(const OOperand*, const OOperand* = NULL) const; 279*cdf0e10cSrcweir }; 280*cdf0e10cSrcweir 281*cdf0e10cSrcweir class OOO_DLLPUBLIC_FILE OOp_LIKE : public OBoolOperator 282*cdf0e10cSrcweir { 283*cdf0e10cSrcweir public: 284*cdf0e10cSrcweir TYPEINFO(); 285*cdf0e10cSrcweir protected: 286*cdf0e10cSrcweir const sal_Unicode cEscape; 287*cdf0e10cSrcweir 288*cdf0e10cSrcweir public: 289*cdf0e10cSrcweir OOp_LIKE(const sal_Unicode cEsc = L'\0'):cEscape(cEsc){}; 290*cdf0e10cSrcweir 291*cdf0e10cSrcweir virtual sal_Bool operate(const OOperand*, const OOperand*) const; 292*cdf0e10cSrcweir }; 293*cdf0e10cSrcweir 294*cdf0e10cSrcweir class OOp_NOTLIKE : public OOp_LIKE 295*cdf0e10cSrcweir { 296*cdf0e10cSrcweir public: 297*cdf0e10cSrcweir TYPEINFO(); 298*cdf0e10cSrcweir public: 299*cdf0e10cSrcweir OOp_NOTLIKE(const sal_Unicode cEsc = L'\0'):OOp_LIKE(cEsc){}; 300*cdf0e10cSrcweir 301*cdf0e10cSrcweir virtual sal_Bool operate(const OOperand*, const OOperand*) const; 302*cdf0e10cSrcweir }; 303*cdf0e10cSrcweir 304*cdf0e10cSrcweir class OOO_DLLPUBLIC_FILE OOp_COMPARE : public OBoolOperator 305*cdf0e10cSrcweir { 306*cdf0e10cSrcweir sal_Int32 aPredicateType; 307*cdf0e10cSrcweir 308*cdf0e10cSrcweir public: 309*cdf0e10cSrcweir TYPEINFO(); 310*cdf0e10cSrcweir OOp_COMPARE(sal_Int32 aPType) 311*cdf0e10cSrcweir :aPredicateType(aPType) {} 312*cdf0e10cSrcweir 313*cdf0e10cSrcweir inline sal_Int32 getPredicateType() const { return aPredicateType; } 314*cdf0e10cSrcweir virtual sal_Bool operate(const OOperand*, const OOperand*) const; 315*cdf0e10cSrcweir }; 316*cdf0e10cSrcweir 317*cdf0e10cSrcweir // numerische Operatoren 318*cdf0e10cSrcweir 319*cdf0e10cSrcweir class ONumOperator : public OOperator 320*cdf0e10cSrcweir { 321*cdf0e10cSrcweir public: 322*cdf0e10cSrcweir virtual void Exec(OCodeStack&); 323*cdf0e10cSrcweir 324*cdf0e10cSrcweir TYPEINFO(); 325*cdf0e10cSrcweir 326*cdf0e10cSrcweir protected: 327*cdf0e10cSrcweir virtual double operate(const double& fLeft,const double& fRight) const = 0; 328*cdf0e10cSrcweir }; 329*cdf0e10cSrcweir 330*cdf0e10cSrcweir class OOp_ADD : public ONumOperator 331*cdf0e10cSrcweir { 332*cdf0e10cSrcweir protected: 333*cdf0e10cSrcweir virtual double operate(const double& fLeft,const double& fRight) const; 334*cdf0e10cSrcweir }; 335*cdf0e10cSrcweir 336*cdf0e10cSrcweir class OOp_SUB : public ONumOperator 337*cdf0e10cSrcweir { 338*cdf0e10cSrcweir protected: 339*cdf0e10cSrcweir virtual double operate(const double& fLeft,const double& fRight) const; 340*cdf0e10cSrcweir }; 341*cdf0e10cSrcweir 342*cdf0e10cSrcweir class OOp_MUL : public ONumOperator 343*cdf0e10cSrcweir { 344*cdf0e10cSrcweir protected: 345*cdf0e10cSrcweir virtual double operate(const double& fLeft,const double& fRight) const; 346*cdf0e10cSrcweir }; 347*cdf0e10cSrcweir 348*cdf0e10cSrcweir class OOp_DIV : public ONumOperator 349*cdf0e10cSrcweir { 350*cdf0e10cSrcweir protected: 351*cdf0e10cSrcweir virtual double operate(const double& fLeft,const double& fRight) const; 352*cdf0e10cSrcweir }; 353*cdf0e10cSrcweir 354*cdf0e10cSrcweir inline sal_Bool OOperand::isValid() const 355*cdf0e10cSrcweir { 356*cdf0e10cSrcweir return getValue().getDouble() != double(0.0); 357*cdf0e10cSrcweir } 358*cdf0e10cSrcweir 359*cdf0e10cSrcweir // operator 360*cdf0e10cSrcweir class ONthOperator : public OOperator 361*cdf0e10cSrcweir { 362*cdf0e10cSrcweir public: 363*cdf0e10cSrcweir virtual void Exec(OCodeStack&); 364*cdf0e10cSrcweir 365*cdf0e10cSrcweir TYPEINFO(); 366*cdf0e10cSrcweir 367*cdf0e10cSrcweir protected: 368*cdf0e10cSrcweir virtual ORowSetValue operate(const ::std::vector<ORowSetValue>& lhs) const = 0; 369*cdf0e10cSrcweir }; 370*cdf0e10cSrcweir 371*cdf0e10cSrcweir class OBinaryOperator : public OOperator 372*cdf0e10cSrcweir { 373*cdf0e10cSrcweir public: 374*cdf0e10cSrcweir virtual void Exec(OCodeStack&); 375*cdf0e10cSrcweir 376*cdf0e10cSrcweir TYPEINFO(); 377*cdf0e10cSrcweir 378*cdf0e10cSrcweir protected: 379*cdf0e10cSrcweir virtual ORowSetValue operate(const ORowSetValue& lhs,const ORowSetValue& rhs) const = 0; 380*cdf0e10cSrcweir }; 381*cdf0e10cSrcweir 382*cdf0e10cSrcweir class OUnaryOperator : public OOperator 383*cdf0e10cSrcweir { 384*cdf0e10cSrcweir public: 385*cdf0e10cSrcweir virtual void Exec(OCodeStack&); 386*cdf0e10cSrcweir virtual sal_uInt16 getRequestedOperands() const; 387*cdf0e10cSrcweir virtual ORowSetValue operate(const ORowSetValue& lhs) const = 0; 388*cdf0e10cSrcweir 389*cdf0e10cSrcweir TYPEINFO(); 390*cdf0e10cSrcweir 391*cdf0e10cSrcweir }; 392*cdf0e10cSrcweir } 393*cdf0e10cSrcweir } 394*cdf0e10cSrcweir 395*cdf0e10cSrcweir #endif // _CONNECTIVITY_FILE_FCODE_HXX_ 396*cdf0e10cSrcweir 397