#ifndef MY_CONNECTION_H
#define MY_CONNECTION_H

#include "../libdbpp/connection.h"
#include "error.h"
#include <mysql.h>
#include <boost/shared_ptr.hpp>

namespace MySQL {
	class LoadContext;
	class Connection : public DB::Connection {
		public:
			Connection(const std::string & info);
			~Connection();

			void finish() const;
			int beginTx() const;
			int commitTx() const;
			int rollbackTx() const;
			bool inTx() const;
			void ping() const;
			DB::BulkDeleteStyle bulkDeleteStyle() const;
			DB::BulkUpdateStyle bulkUpdateStyle() const;

			DB::SelectCommand * newSelectCommand(const std::string & sql) const;
			DB::ModifyCommand * newModifyCommand(const std::string & sql) const;

			void	beginBulkUpload(const char *, const char *) const;
			void	endBulkUpload(const char *) const;
			size_t bulkUploadData(const char *, size_t) const;

			mutable MYSQL conn;

		private:
			my_bool my_true;

			mutable unsigned int txDepth;
			mutable bool rolledback;

			mutable boost::shared_ptr<LoadContext> ctx;
	};
}

#endif