connection.h

/*
 * connection.h
 * This file is part of dbPager Classes Library (DCL)
 *
 * Copyright (c) 2008 Dennis Prochko <wolfsoft@mail.ru>
 *
 * DCL 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 version 3.
 *
 * DCL 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 DCL; if not, write to the Free Software
 * Foundation, Inc., 51 Franklin St, Fifth Floor,
 * Boston, MA  02110-1301  USA
 */

#ifndef _CONNECTION_H_
#define _CONNECTION_H_

#include <string>

#ifdef WIN32
#include <windows.h>
#include <odbcinst.h>
#endif

#include <sqltypes.h>
#include <sql.h>
#include <sqlext.h>

#include <dcl/exception.h>

namespace dbp {
namespace odbc {


class connection_exception: public dbp::exception {
public:
        connection_exception(const std::string &msg): exception(msg) { }
};


class connection {
        friend class query;
public:
        typedef enum {
                READ_UNCOMMITTED,
                READ_COMMITTED,
                REPEATABLE_READ,
                SERIALIZABLE
        } transaction_isolation;
        connection();
        virtual ~connection();

        void open(const std::string &dsn, const std::string &user_name,
          const std::string &password);

        void open(const std::string &connect_string);

        bool is_open() const;

        void close();

        void begin_transaction(transaction_isolation level = READ_COMMITTED);

        void commit();

        void rollback();
protected:
        std::string get_error() const;
private:
        SQLHENV henv;
        SQLHDBC hdbc;
        bool _is_open;
};

}} // namespace

#endif /*_CONNECTION_H_*/