sql.h

/***************************************************************************
 *   Copyright (C) 2006 by Graeme Foster                                   *
 *   email    foster.graeme@gmail.com                                      *
 *                                                                         *
 *   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.,                                       *
 *   59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.             *
 ***************************************************************************/
#ifndef __SQL
#define __SQL

#include <stdexcept>

#include <QtSql>

class sql
{
        public:  // static properties
                static QString * DefaultConnectionName; 
        private: // Singleton Instance
                static sql * _instance;        
        private: // properties
                QString      lastDBConnName;   
                QSqlQuery  * result;           
                QList<QSqlQuery *> queryList;  
                QSqlQuery  * activeQuery;      
                QList<QSqlQuery *> cursorList; 
        public:  // static methods
                static sql * Instance();       
        public:  // methods
                inline void setCursor() {cursorList.push_back(result);}
                inline void restoreCursor() {result = cursorList.takeLast();}
                void initConn(const QString & uName
                                                 ,const QString & dbName = "guest"
                                                 ,const QString & password =""
                                                 ,const QString & connName = "guestConn"
                                                 ,const QString & host="localhost"
                                                 ,const QString & connType= "QPSQL"
                                                 );
                int prepare(const QString & functionName
                           ,int paramCnt
                           ,const QString & connName="");
                
                int prepare(const QString & command
                           ,const QString & connName="");
                void bind(int posn
                         ,QVariant value
                         ,int qID=-1);
                bool query(int qID=-1);
                bool first();
                bool next ();
                bool last ();
                QVariant get(int index);
                QVariant getFirst(int index);
                QVariant getNext(int index);
                
                void dump();
        private: // methods
                sql ();
                sql (sql & clone);
        public:  // methods to be moved to a specialist class
                QString * useModuleConn() {return &lastDBConnName;}
};

class sqlE
{
        public:
                sqlE(const QSqlDatabase & dbConn
                         ,const QString & type = "Database Error");
                QString getErrorType() {return ErrorType;}
                QString getErrorMessage() {return ErrorMessage;}
        private:
                QString ErrorType;    
                QString ErrorMessage; 
};

#endif

---