#include <MySql/MySql.h>

using namespace Upp;

struct DBData {
	String username;
	String password;
	String database;
	String host;
	String collate;
	String lockId;
	int port;
	DBData() : port(3306) { }
	DBData(const String& username, const String& password, const String& database, const String& host,
		const String& collate, const String& lockId, int port = 3306) : username(username),
		password(password), database(database), host(host), collate(collate), lockId(lockId), port(port) { }
};

class DBConnection {
protected:
	MySqlSession session;
	DBData data;
public:
	// DBConnection() { }
	DBConnection(const DBData& data) : data(data) { }
	~DBConnection()               { Disconnect(); ReleaseLock(); }
	MySqlSession& GetSession()    { return session; }
	const DBData& GetData()       { return data; }
	void SetData(const DBData& d) { data = d; }
	bool Connect(bool prompt = true);
	void Disconnect();
	bool GetLock(const String& name);
	bool ReleaseLock();
};
// TODO: implement
bool DBConnection::Connect(bool prompt)
{
	return true;
}
// TODO: implement
void DBConnection::Disconnect()
{
}
// TODO: implement
bool DBConnection::GetLock(const String& name)
{
	return true;
}
// TODO: implement
bool DBConnection::ReleaseLock()
{
	return true;
}

CONSOLE_APP_MAIN
{
	DBData data("username", "password", "database", "host", "collate", "lockId");
	DBConnection ctn(data);
	if (!ctn.Connect())
		return;
	SQL = ctn.GetSession();
/*	// Doing some query:
	Sql sql;
	sql * Select(SqlAll()).From(TABLE);
	while(sql.Fetch()) { }
*/
}