---

dbobjgetstreamer.hpp

Go to the documentation of this file.

#if !defined(_DBOBJGetStreamer_HPP)
#define _DBOBJGetStreamer_HPP
//============================================================================= 
//
// XDFLengine library
//
//----------------------------------------------------------------------------- 
//  DBOBJGetStreamer.HPP
//----------------------------------------------------------------------------- 
//_____________________________________________________________________________
//
//  Copyright (C) 2003 Guillaume Baurand. All Rights Reserved.
//
//  This file is part of the XDFLengine project.
//
//  The XDFLengine is free software; you can redistribute it and/or modify
//  it under the terms of the GNU General Public License as published by
//  the Free Software Foundation; either version 2 of the License, or
//  (at your option) any later version.
//
//  This program is distributed in the hope that it will be useful,
//  but WITHOUT ANY WARRANTY; without even the implied warranty of
//  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
//  GNU General Public License for more details.
//
//  You should have received a copy of the GNU General Public License
//  along with this program; if not, write to the Free Software
//  Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307,
//  USA.
//
//  For more information, 
//      contact  : guillaume@baurand.net 
//      or visit : http://xdflengine.sourceforge.net
//
//=============================================================================

#   include "config/commonincs.hpp"
#   include "streamers/db/dbobject/dbobjstreamerfactory.hpp"
#   include "streamers/generic/saxstreamer.hpp"

BEGIN_XDFLENGINE_NS

class XMLProcessor;
class DBOBJDefinitionNode;
class DBOBJGetStatementNode;
class DBOBJGetStatementSAXBuilder;

//============================================================================= 
//  STRUCT OTL_STREAM_PEEK
//----------------------------------------------------------------------------- 
//~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
typedef struct otl_stream_peek
{
        otl_stream*         pOTLStream; 
        VAarray< char*>     vaPeeks;    
        unsigned int        pos;        
} otl_stream_peek;


//============================================================================= 
//  CLASS DBOBJGetStreamer
//----------------------------------------------------------------------------- 
//~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
class XDFLENGINE_EXPORT DBOBJGetStreamer : public SaxStreamer
{

    private: //~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

        char*                           m_pszConnName;
        bool                            m_boolFlat;                 
        char*                           m_pszMaxItems;              
        int                             m_intBufSize;               
        DBOBJGetStatementNode*          m_pDBOBJGetStatementRoot;   
        const DBOBJDefinitionNode*      m_pDBOBJDefinitionRoot;
        DBOBJDefinitionNode*            m_pDBOBJOwnedDefinitionRoot;

        VAarray< otl_stream_peek*>      m_vaNamedData;              
        otl_connect*                    m_pConnection;
        VAarray<char*>                  m_vaStatements;     

        unsigned int    m_uiStreamObjects;
        unsigned int    m_uiToStream;

    protected :

        //DBStreamerFactory*                m_pParent;
        //DBOBJGetStatementSAXBuilder*  m_pHandler;



    public: //~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


    // CONSTRUCTOR & DESTRUCTOR

        //_____________________________________________________________________
        //  DBOBJGetStreamer
        //---------------------------------------------------------------------
        DBOBJGetStreamer( const XMLStreamerFactory* p_pParent, StreamerParams* p_pParameters, XMLFlowContext* p_pContext, XMLStreamConsumer* p_pOutput, ContentHandler* p_pHandler,const DBOBJDefinitionNode* p_pDBOBJDefinitionRoot, DBOBJDefinitionNode* p_pDBOBJOwnedDefinitionRoot  );
        
        //_____________________________________________________________________
        //  ~DBOBJGetStreamer
        //---------------------------------------------------------------------     
        virtual ~DBOBJGetStreamer();

    // STREAMER

        //_____________________________________________________________________
        //  COMMITSTREAM
        //---------------------------------------------------------------------
        bool commitStream(bool p_fFinal=false);


    // STATEMENT BUILD AND EXEC

        //_____________________________________________________________________
        //  EXECUTESQL
        //---------------------------------------------------------------------
        //_____________________________________________________________________ 
        void executeSQL(); // overloaded


    // OUTPUT

        //_____________________________________________________________________
        //  makeXML
        //---------------------------------------------------------------------
        //_____________________________________________________________________ 
        void makeXML();

    
    private: //~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

    // PARAMS GETTERS

        //_____________________________________________________________________
        //  GETMAXITEMS
        //---------------------------------------------------------------------
        //_____________________________________________________________________ 
        int getMaxItems() const;

    // SQL BUILD

        //_____________________________________________________________________
        //  BUILDSELECTSTATEMENT
        //---------------------------------------------------------------------
        //_____________________________________________________________________ 
        void buildSELECTStatement ( const DBOBJDefinitionNode*  p_pDBOBJDefNode, 
                                    DBOBJGetStatementNode*  p_pDBOBJStmtNode, 
                                    unsigned int            p_uiDepth , 
                                    const char*             p_pszrParentFROM  , 
                                    const char*             p_pszParentJOIN, 
                                    const char*             p_pszParentWHERE , 
                                    const char*             p_pszParentORDER    );
        
        //_____________________________________________________________________
        //  BUILDSQLSELECT
        //---------------------------------------------------------------------
        //_____________________________________________________________________ 
        char* buildSQLSELECT (      const DBOBJDefinitionNode*  p_pDBOBJDefNode, 
                                    unsigned int            p_uiDepth   ) const;
        
        //_____________________________________________________________________
        //  BUILDSQLFROM
        //---------------------------------------------------------------------
        //
        //_____________________________________________________________________         
        char* buildSQLFROM  (       const DBOBJDefinitionNode*  p_pDBOBJDefNode, 
                                    unsigned int            p_uiDepth, 
                                    const char*             p_pszParentFROM ) const;
        
        //_____________________________________________________________________
        //  BUILDSQLJOIN
        //---------------------------------------------------------------------
        //
        //_____________________________________________________________________         
        char* buildSQLJOIN  (       const DBOBJDefinitionNode*  p_pDBOBJDefNode, 
                                    unsigned int            p_uiDepth , 
                                    const char*             p_pszParentJOIN ) const;   
        
        //_____________________________________________________________________
        //  BUILDSQLWHERE
        //---------------------------------------------------------------------
        //
        //_____________________________________________________________________         
        char* buildSQLWHERE (       const DBOBJDefinitionNode*  p_pDBOBJDefNode, 
                                    DBOBJGetStatementNode*  p_pDBOBJStmtNode, 
                                    unsigned int            p_uiDepth, 
                                    const char*             p_pszParentWHERE ) const; 
        
        //_____________________________________________________________________
        //  BUILDSQLJOINORDER
        //---------------------------------------------------------------------
        //
        //_____________________________________________________________________         
        char* buildSQLJOINORDER (   const DBOBJDefinitionNode*  p_pDBOBJDefNode, 
                                    unsigned int            p_uiDepth, 
                                    const char*             p_pszParentORDER ) const; 
        
        //_____________________________________________________________________
        //  BUILDSQLORDER
        //---------------------------------------------------------------------
        //
        //_____________________________________________________________________         
        char* buildSQLORDER (       const DBOBJDefinitionNode*  p_pDBOBJDefNode, 
                                    DBOBJGetStatementNode*  p_pDBOBJStmtNode, 
                                    unsigned int            p_uiDepth, 
                                    const char*             p_pszParentORDER ) const;


    // DATA GETTERS

        //_____________________________________________________________________
        //  PUSHSQLSTATEMENT
        //---------------------------------------------------------------------
        //_____________________________________________________________________
        void pushSQLStatement(const char* p_pszSQL);

        //_____________________________________________________________________
        //  GETDATASTREAM
        //---------------------------------------------------------------------
        //_____________________________________________________________________ 
        otl_stream* getDataStream ( const char* p_pszName) const;

        //_____________________________________________________________________
        //  PEEKDATA
        //---------------------------------------------------------------------
        //_____________________________________________________________________ 
        const char* peekData ( const char* p_pszName);

        //_____________________________________________________________________
        //  REWINDPEEKEDDATA
        //---------------------------------------------------------------------
        //_____________________________________________________________________ 
        void rewindPeekedData ( const char* p_pszName);

        //_____________________________________________________________________
        //  FLUSHPEEKEDDATA
        //---------------------------------------------------------------------
        //_____________________________________________________________________ 
        void flushPeekedData ( const char* p_pszName);

        //_____________________________________________________________________
        //  DELSTREAM
        //---------------------------------------------------------------------
        //_____________________________________________________________________ 
        void delStream ( otl_stream_peek* p_rsDataPeek);


    // XML BUILD

        //_____________________________________________________________________
        //  MAKEXML
        //---------------------------------------------------------------------
        //_____________________________________________________________________
        void makeXML ( const DBOBJDefinitionNode* p_pDBOBJDefNode , const char* p_pszParentKeys , unsigned int p_uiDepth);        

        //_____________________________________________________________________
        //  OPENXMLNODE
        //---------------------------------------------------------------------
        //_____________________________________________________________________ 
        void openXMLNode ( const DBOBJDefinitionNode* p_pDBOBJDefNode) ;

        //_____________________________________________________________________
        //  CLOSEXMLNODE
        //---------------------------------------------------------------------
        //_____________________________________________________________________ 
        void closeXMLNode ( const DBOBJDefinitionNode* p_pDBOBJDefNode) ;

};
//~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
//=============================================================================


//============================================================================= 
//  CLASS DBOBJGetStreamerFACTORY
//----------------------------------------------------------------------------- 
//~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
class XDFLENGINE_EXPORT DBOBJGetStreamerFactory:public DBOBJStreamerFactory
{

    public: //~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

        //_____________________________________________________________________
        //  GETSTREAMER
        //---------------------------------------------------------------------
        XMLStreamer* getStreamer(StreamerParams* p_pParameters, XMLFlowContext* p_pStreamContext, XMLStreamConsumer* p_pStreamConsumer) const;
};

//~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
//=============================================================================


END_XDFLENGINE_NS

#endif

---