/* 
ZLib license:
Copyright (c) 2011 Dirk de la Hunt

This software is provided 'as-is', without any express or implied warranty. In no event will the authors be held liable for any damages arising from the use of this software.

Permission is granted to anyone to use this software for any purpose, including commercial applications, and to alter it and redistribute it freely, subject to the following restrictions:

1. The origin of this software must not be misrepresented; you must not claim that you wrote the original software. If you use this software in a product, an acknowledgment in the product documentation would be appreciated but is not required.
2. Altered source versions must be plainly marked as such, and must not be misrepresented as being the original software.
3. This notice may not be removed or altered from any source distribution.
*/

/*
This abstracts the SQLite database a little, nothing major, just makes swapping out database engines easier.
*/
#ifndef __MONKEYDB_H_
#define __MONKEYDB_H_

#include "sqlite3.h"
#include "crappystring.h"

/* data callback */
typedef int (*MonkeyDatabaseOnData)(void *Parameters, int argc, char *argv[]);

class MonkeyDatabase
{
protected:
	sqlite3      *handle;
	CrappyString  status;
	int           lastId;

protected:
	bool setStatus(const char *Status);
	bool createTables();

	static int onData(void *Parameters, int argc, char *argv[], char *Columns[]);

public:
	MonkeyDatabase();
	~MonkeyDatabase();

	/* This tries to open the specified database, creating it and the tables within if necessary */
	bool Create(const char *Path, bool CreateIfNotFound);
	/* This closes the database, and always returns false to make it a convenient Create() failure exit point */
	bool Destroy();

	/* This executes the SQL provided, returning results to a callback if specified */
	bool Execute(const char *Sql, MonkeyDatabaseOnData Callback = 0, void *Parameters = 0);
	const char* Status();
	int LastId();

	static char* EscapeString(const char *Message);
};

#endif
