---

Query.h

Go to the documentation of this file.

// /******************************************************************************\
// *
// * File:          Query.h
// * Creation date: May 17, 2001 14:24
// * Author:        ClassBuilder
// *                XXXX
// * Purpose:       Declaration of class 'DOQuery'
// *
// * Modifications: @INSERT_MODIFICATIONS(* )
// * May 18, 2001 10:12 WERS
// *     Updated interface of method 'ConstructorInclude'
// *     Updated interface of method 'FindQueryField'
// *     Updated interface of method 'DOQuery'
// *     Updated relation 'Connection(DOConnection) <>-->> Query(DOQuery)'
// *     Updated relation 'Query(DOQuery) <>-->> QueryField(DOQueryField)'
// *     Updated member 'm_row'
// *     Updated member 'm_query'
// *     Updated member 'm_pRes'
// * May 17, 2001 19:39 WERS
// *     Updated member 'm_query'
// * May 17, 2001 15:15 WERS
// *     Added method 'GetRow'
// *     Added method 'Seek'
// *     Added method 'Fetch'
// *     Added member 'm_row'
// * May 17, 2001 15:00 WERS
// *     Added method 'GetNumRows'
// * May 17, 2001 14:55 WERS
// *     Added method 'FindQueryField'
// *     Added method 'FindQueryField'
// * May 17, 2001 14:41 WERS
// *     Added method 'GetNumFields'
// *     Added relation 'Query(DOQuery) <>-->> QueryField(DOQueryField)'
// *     Updated interface of method 'ConstructorInclude'
// *     Updated interface of method 'Query'
// * May 17, 2001 14:24 WERS
// *     Added method 'DOQuery'
// * May 17, 2001 14:24 WERS
// *     Added method 'DestructorInclude'
// *     Added method 'ConstructorInclude'
// *     Added method 'Query'
// *     Added method '~DOQuery'
// *     Added relation 'Connection(DOConnection) <>-->> Query(DOQuery)'
// *     Added member 'm_query'
// *     Added member 'm_pRes'
// *
// *
// \******************************************************************************/
#ifndef _QUERY_H
#define _QUERY_H

//@START_USER1
/* --------------------------------------------------------------
Copyright (C) 2001 LifeLine Networks BV <soap2corba@lifeline.nl>

This program 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., 675 Mass Ave, Cambridge, MA 02139, USA.
-------------------------------------------------------------- */
//@END_USER1


class DOQuery
{
    // RELATION_MULTI_OWNED_ACTIVE(DOQuery, Query, DOQueryField, QueryField)
public:
    DOQueryField * _firstQueryField;
    DOQueryField * _lastQueryField;
    int _countQueryField;

protected:
    void AddQueryFieldFirst(DOQueryField* item);
    void AddQueryFieldLast(DOQueryField* item);
    void AddQueryFieldAfter(DOQueryField* item, DOQueryField* pos);
    void AddQueryFieldBefore(DOQueryField* item, DOQueryField* pos);
    void RemoveQueryField(DOQueryField* item);
    void ReplaceQueryField(DOQueryField* item, DOQueryField* newItem);

public:
    void DeleteAllQueryField();
    DOQueryField* GetFirstQueryField() const;
    DOQueryField* GetLastQueryField() const;
    DOQueryField* GetNextQueryField(DOQueryField* pos) const;
    DOQueryField* GetPrevQueryField(DOQueryField* pos) const;
    int GetQueryFieldCount() const;
    void MoveQueryFieldFirst(DOQueryField* item);
    void MoveQueryFieldLast(DOQueryField* item);
    void MoveQueryFieldAfter(DOQueryField* item, DOQueryField* pos);
    void MoveQueryFieldBefore(DOQueryField* item, DOQueryField* pos);
    void SortQueryField(int (*comp)(DOQueryField*, DOQueryField*));
    
    class  QueryFieldIterator
    {
    private:
        DOQueryField* _refQueryField;
        DOQueryField* _prevQueryField;
        DOQueryField* _nextQueryField;
        const DOQuery* _iterQuery;
        
        QueryFieldIterator* _prev;
        QueryFieldIterator* _next;
        
        int (DOQueryField::*_method)() const;
        
        static QueryFieldIterator* _first;
        static QueryFieldIterator* _last;
        
    public:
        QueryFieldIterator(const DOQuery* iterQuery,
                         int (DOQueryField::*method)() const = 0,
                         DOQueryField* refQueryField = 0);
        QueryFieldIterator(const DOQuery& iterQuery,
                         int (DOQueryField::*method)() const = 0,
                         DOQueryField* refQueryField = 0);
        QueryFieldIterator(const QueryFieldIterator& iterator,
                         int (DOQueryField::*method)() const = 0);
        ~QueryFieldIterator();
        
        QueryFieldIterator& operator= (const QueryFieldIterator& iterator)
        {
            _iterQuery = iterator._iterQuery;
            _refQueryField = iterator._refQueryField;
            _prevQueryField = iterator._prevQueryField;
            _nextQueryField = iterator._nextQueryField;
            _method = iterator._method;
            return *this;
        }
        DOQueryField* operator++ ()
        {
            _nextQueryField = _iterQuery->GetNextQueryField(_nextQueryField);
            if (_method != 0)
            {
                while (_nextQueryField && !(_nextQueryField->*_method)())
                    _nextQueryField = _iterQuery->GetNextQueryField(_nextQueryField);
            }
            _refQueryField = _prevQueryField = _nextQueryField;
            return _refQueryField;
        }
        DOQueryField* operator-- ()
        {
            _prevQueryField = _iterQuery->GetPrevQueryField(_prevQueryField);
            if (_method != 0)
            {
                while (_prevQueryField && !(_prevQueryField->*_method)())
                    _prevQueryField = _iterQuery->GetPrevQueryField(_prevQueryField);
            }
            _refQueryField = _nextQueryField = _prevQueryField;
            return _refQueryField;
        }
        operator DOQueryField*() { return _refQueryField; }
        DOQueryField* operator-> () { return _refQueryField; }
        DOQueryField* Get() { return _refQueryField; }
        void Reset() { _refQueryField = _prevQueryField = _nextQueryField = (DOQueryField*)0; }
        
        int IsLast() { return (_iterQuery->GetLastQueryField() == _refQueryField); }
        int IsFirst() { return (_iterQuery->GetFirstQueryField() == _refQueryField); }
        
        static void Check(DOQueryField* itemQueryField);
        static void Check(DOQueryField* itemQueryField, DOQueryField* newItemQueryField);
    };
    // RELATION_MULTI_OWNED_PASSIVE(DOConnection, Connection, DOQuery, Query)
    
public:
    DOConnection * _refConnection;
    DOQuery * _prevConnection;
    DOQuery * _nextConnection;

public:
    DOConnection* GetConnection() const { return _refConnection; };

//@START_USER2
//@END_USER2

// Members
private:
    MYSQL_RES* m_pRes;
    MYSQL_ROW m_row;

protected:
    CString m_query;

public:

// Methods
private:
    void ConstructorInclude(DOConnection* pConnection);
    void DestructorInclude();

protected:

public:
    DOQuery(DOConnection* pConnection);
    virtual ~DOQuery();
    bool Fetch();
    DOQueryField* FindQueryField(unsigned int number);
    DOQueryField* FindQueryField(const char* fldName);
    unsigned int GetNumFields();
    unsigned int GetNumRows();
    bool Query(const char* pszSQL);
    void Seek(unsigned int rownum);
    MYSQL_ROW GetRow();
};

#endif


#ifdef CB_INLINES
#ifndef _QUERY_H_INLINES
#define _QUERY_H_INLINES

inline unsigned int DOQuery::GetNumFields()
{//@CODE_241
    if (m_pRes) {
        return mysql_num_fields (m_pRes);
    }
    return 0;
    
}//@CODE_241



inline unsigned int DOQuery::GetNumRows()
{//@CODE_250
    if (m_pRes) {
        return (unsigned int) mysql_num_rows (m_pRes);
    }
    return 0;
    
}//@CODE_250



inline void DOQuery::Seek(unsigned int rownum)
{//@CODE_251
    if (m_pRes) {
        mysql_data_seek (m_pRes, rownum);
        Fetch ();
    }
}//@CODE_251



inline MYSQL_ROW DOQuery::GetRow()
{//@CODE_257
    return m_row;
}//@CODE_257



//@START_USER3
//@END_USER3

#endif
#endif

---