/**
 * Relational pipes
 * Copyright © 2019 František Kučera (Frantovo.cz, GlobalCode.info)
 *
 * 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, version 3.
 *
 * 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, see <http://www.gnu.org/licenses/>.
 */
#pragma once

#include <codecvt>
#include <locale>

#include <relpipe/reader/typedefs.h>

#include "SqlException.h"
#include "PreparedStatement.h"

namespace relpipe {
namespace tr {
namespace sql {

class Connection {
private:
	void* connection;
	std::wstring_convert<std::codecvt_utf8<wchar_t>> convertor; // TODO: support also other encodings
public:
	Connection(void* connection);
	virtual ~Connection();
	PreparedStatement* prepareStatement(relpipe::reader::string_t sql);
	bool getAutoCommit();
	void setAutoCommit(bool autoCommit);
	void commit();
	void rollback();

	class TableMetaData {
	public:
		relpipe::reader::string_t catalog;
		relpipe::reader::string_t schema;
		relpipe::reader::string_t name;
		relpipe::reader::string_t type;
	};

	class TablePrivilege : public TableMetaData {
	public:
		relpipe::reader::string_t grantor;
		relpipe::reader::string_t grantee;
		relpipe::reader::string_t privilege;
		relpipe::reader::boolean_t isGrantable;

	};
	std::vector<TablePrivilege> getTablePrivileges();
	
	relpipe::reader::string_t getUserName();
};

}
}
}