#ifndef PQ_CONNECTION_H
#define PQ_CONNECTION_H

#include "../libdbpp/connection.h"
#include <libpq-fe.h>

namespace PQ {
	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;
			void execute(const std::string & sql) const override;
			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;

			PGresult * checkResult(PGresult * res, int expected, int alternative = -1) const;
			void checkResultFree(PGresult * res, int expected, int alternative = -1) const;

			PGconn * conn;

		private:
			static bool checkResultInt(PGresult * res, int expected, int alternative);

			mutable unsigned int txDepth;
			mutable unsigned int pstmntNo;
			mutable bool rolledback;
	};
}

#endif