src/DAL/Query.h

Go to the documentation of this file.

#ifdef _WIN32
#ifndef __MINGW32__
#pragma warning(disable:4786)
#endif
#endif
/*
 **     Query.h
 **
 **     Published / author: 2005-08-12 / grymse@alhem.net
 **/

/*
Copyright (C) 2001-2006  Anders Hedstrom

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 _QUERY_H_SQLITE
#define _QUERY_H_SQLITE

#include <string>
#include <map>
#ifdef WIN32
typedef unsigned __int64 uint64_t;
typedef __int64 int64_t;
#else
#include <stdint.h>
#endif


#ifdef SQLITEW_NAMESPACE
namespace SQLITEW_NAMESPACE {
#endif


class Query
{
public:
        Query(Database& dbin);
        Query(Database& dbin,const std::string& sql);
        ~Query();

        bool Connected();
        Database& GetDatabase() const;
        const std::string& GetLastQuery();

        bool execute(const std::string& sql);
        sqlite3_stmt *get_result(const std::string& sql);
        void free_result();
        bool fetch_row();
        sqlite_int64 insert_id();
        long num_rows();
        std::string GetError();
        int GetErrno();

        const char *get_string(const std::string& sql);
        long get_count(const std::string& sql);
        double get_num(const std::string& sql);

        bool is_null(int x);

        const char *getstr(const std::string& x);
        const char *getstr(int x);
        const char *getstr();

        long getval(const std::string& x);
        long getval(int x);
        long getval();

        unsigned long getuval(const std::string& x);
        unsigned long getuval(int x);
        unsigned long getuval();

        int64_t getbigint(const std::string& x);
        int64_t getbigint(int x);
        int64_t getbigint();

        uint64_t getubigint(const std::string& x);
        uint64_t getubigint(int x);
        uint64_t getubigint();

        double getnum(const std::string& x);
        double getnum(int x);
        double getnum();

private:
        Query(const Query& q) : m_db(q.GetDatabase()) {}
        Query& operator=(const Query& ) { return *this; }
        void ViewRes();
        void error(const std::string& );
        Database& m_db; 
        Database::OPENDB *odb; 
        sqlite3_stmt *res; 
        bool row; 
        short rowcount; 
        std::string m_tmpstr; 
        std::string m_last_query; 
        int cache_rc; 
        bool cache_rc_valid; 
        int m_row_count; 
        //
        std::map<std::string,int> m_nmap; 
        int m_num_cols; 
};


#ifdef SQLITEW_NAMESPACE
} // namespace SQLITEW_NAMESPACE {
#endif

#endif // _QUERY_H

---