sprint/odbc/odbc.h

Go to the documentation of this file.

/******************************************************************************
*   sprint::ODBC wrapper
*
*   Copyright (C) 2004-2011  Paolo Medici <www.pmx.it>
*
*  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., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301  USA
*
*******************************************************************************/


#ifndef _SPRINT_ODBC_H
#define _SPRINT_ODBC_H

/* @TODO: implement for UNIX*/

#ifdef WIN32
    #include <windows.h>
    #include <sql.h>
    #include <SQLEXT.H>
    #include <sprint/thread/mutex.h>
#endif

namespace sprint {

#ifdef WIN32

class odbc {
        HENV          henv;
        HDBC          hdbc;
        HSTMT         hstmt;
        bool          valid;
        sprint::mutex mutex;
        
        void dbError(LPCSTR lpszMsg);
        bool dbCheck(const char *fn, SQLRETURN err);

    template<class T, SQLSMALLINT type>
    bool _get(unsigned int col, T * value);
   
        public:
        odbc();
        ~odbc();

        bool connect(const char *provider, const char *username, const char *password); 
        
        bool connect(const char *InConnectionString);   
        
        bool disconnect();
        
        bool begin_query(const char *query);

        void end_query();       
        
    bool next();
  
    template<class T>
    bool get(unsigned int col, T * value);

    bool get(unsigned int col, char *buf, unsigned int buf_len);

    inline bool good() const { return valid; }
};
#endif

}

#endif