Query.h

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

//Modificada LCPT.

/*
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 
  {
  private:
    Query(const Query& q) : m_db(q.GetDatabase()), res(NULL) {}
    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; 
  public:
    Query(Database& dbin);
    Query(Database& dbin,const std::string& sql);
    ~Query(void);

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

    bool execute(const std::string& sql);
    bool insert_blob1(const std::string &sql,const void *blobData,const size_t &numBytes);
    sqlite3_stmt *get_result(const std::string& sql);
    void free_result();
    bool fetch_row(void);
    sqlite_int64 insert_id();

    long num_rows(void) const;
    size_t num_columns(void) const;
    std::string field_names(void) const;
    inline int field_index(const std::string &str)
      { return (m_nmap[str] - 1); }

    std::string getError(void) const;
    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 void *getblob(const std::string& x);
    const void *getblob(int x);
    const void *getblob();

    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();
  };


#ifdef SQLITEW_NAMESPACE
} // namespace SQLITEW_NAMESPACE {
#endif

#endif // _QUERY_H