dbpath = "mw-script";
dbname = "persist.db";

db = dbpath + "/" + dbname;
/* Escape a string for insertion into sqlite3 */
String.prototype.escapeSQL = function()
{
	return this.replace(/'/g,"''");
}

/**
 * Store obj identified by key.  Subsequent calls to load(key) will return this
 * object.
 */
function storedb(key, obj)
{
	var query = "INSERT OR REPLACE INTO objects (key, value) VALUES ('"+ key.escapeSQL() + "', '" + JSON.stringify(obj).escapeSQL() + "')";
	var err = dbquery(db, query);
	if(err.query_error != 0)
	{
		dbquery(db, "CREATE TABLE objects (key TEXT, value TEXT, PRIMARY KEY (key))");
		dbquery(db, query);
	}
}

/**
 * Load an object identified by the specified key.
 */
function loaddb(key, def)
{
	var  query = (db, "SELECT value FROM objects WHERE key='" + key.escapeSQL() + "'");
	var err = dbquery(db, query);
	var row = err.data[0];
	if(row)
	{
		return JSON.parse(row[0]);
	}
	else
	{
		return def;
	}
}

