---

dbquery.h

/* liblookdb: dbquery.h - A database query
    Copyright (C) 1998-2001 LOOK Systems

    This library is free software; you can redistribute it and/or
    modify it under the terms of the GNU Lesser General Public
    License as published by the Free Software Foundation; either
    version 2.1 of the License, or (at your option) any later version.

    This library 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
    Lesser General Public License for more details.

    You should have received a copy of the GNU Lesser General Public
    License along with this library; if not, write to the Free Software
    Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
*/
#ifndef LIBLOOKDB_DBQUERY_H
#define LIBLOOKDB_DBQUERY_H

// $Id: dbquery.h,v 1.8 2001/07/19 17:51:50 clive Exp $

#include "lookdblibrary.h"
#include "looktypebaselist.h"
#include "dbrowlist.h"
#include "lkstring.h"
#include "lookdbinterface.h"

namespace look {

class DbConnection;


class LOOKDBLIBRARY_DLL DbQuery
{
public:

        enum QueryState
        {
                Q_CREATED,
                Q_PREPARED,
                Q_EXECUTED,
                Q_CURSOR_OPEN,
                Q_FINISHED
        };

        DbQuery( const LookString& theQueryText = "",
                DbConnection* theConnection = NULL );
        virtual ~DbQuery();

        bool Prepare(void);
        bool Describe(void);
        bool Execute(void);

        long ColumnCount( void ) const;
        long RowCount( bool countNow = false );

        LookString GetColumnName( long theColumnNo );
        bool GetColumnNullable( long theColumnNo );

        // this returns the LookTypeBase id of the column
        // it's then up to the user to deal with it as they please
        long GetColumnTypeID( long theColumnNo );

        DbRow* Fetch();
        DbRow* GetRow(long theRowNumber);

        void Close(void);

        void AddParameter( LookTypeBase* theParameter, bool isLong = false );
        void ClearParameters( void );

        // need to call this if you ever want to use GetRow by number
        // rather than just fetch
        void UseRowCache( void )
        {
                itHasRowCache = true;
        }

        int GetNRowsAffected( void )
        {
                return itsRowsAffected;
        }

protected:
        void UploadParameters( void );

        void TidyCursor(void);

// state queries
        bool IsPrepared( void ) const
        {
                return (itsState >= Q_PREPARED);
        }

        bool IsExecuted( void ) const
        {
                return (itsState >= Q_EXECUTED);
        }

        bool CursorIsOpen( void ) const
        {
                return (itsState == Q_CURSOR_OPEN);
        }

        DbConnection* itsConnection;
#ifndef WIN32
        bool itOwnsConnection;
#endif

        LookString itsQueryText;

        QueryState itsState;

        long    itsCurrentRowNumber;
        long    itsRowCount;
        bool itHasRowCache;
        DbRow* itsLastFetchedRow;

        DbRowPtrList itsRows;
        LookTypePtrList itsParameters;
        long itsLongParameterIndex;

        LOOK_STMT       itsStmt;

        // the number of rows affected by an update or whatever
        int itsRowsAffected;

        static long itsNextStatementId;
};


} // end of "look" namespace
#endif 

---