public void StartLogger()
{
Console.WriteLine("Creating new database instance...");
database = new SQLiteDatabase(filename);
if (!File.Exists(filename))
{
Console.WriteLine("Creating blank log file...");
SQLiteConnection.CreateFile(filename);
database.RunQueryNoResult(databaseSQL);
}
Console.WriteLine("Adding session...");
DataSet result = database.RunQuery(
"INSERT INTO Sessions VALUES (NULL,datetime('now','localtime'));" +
"SELECT last_insert_rowid();");
sessionID = Convert.ToInt32(result.Tables[0].Rows[0][0]);
}
