private void writeHistoryEntry(FileBehavior file)
{
string datetime = file.sysTime.ToString("yyyy-MM-dd HH:mm:ss");
if(!(file is FileIgnored) && !(file is FileRenamed) && !(file is FileDeleted) && !(file is FileMissing)) {
object res = Init.Singleton.sqlite.SingleResult("SELECT filepath, datetime FROM history WHERE lower(filepath) = '" + file.fullPath.ToLower() + "'");
if(res != null) {
Init.Singleton.sqlite.ExecNoResult("UPDATE history SET datetime = '" + datetime + "', type = '"+ file.GetType().Name +"' WHERE lower(filepath) = '" + file.fullPath.ToLower() + "' ");
} else {
Init.Singleton.sqlite.ExecNoResult("INSERT INTO history(filepath, datetime, type) VALUES ('" + file.fullPath + "', '" + datetime + "', '"+ file.GetType().Name +"')");
}
} else if(file is FileRenamed) {
Init.Singleton.sqlite.ExecNoResult("UPDATE history SET filepath = '" + file.fullPath + "', type = '"+ ((FileRenamed)file).subtype.GetType().Name +"' WHERE lower(filepath) = '" + ((FileRenamed)file).oldPath.ToLower() + "' ");
} else if(file is FileDeleted) {
Init.Singleton.sqlite.ExecNoResult("DELETE FROM history WHERE lower(filepath) = '" + file.fullPath.ToLower() + "' ");
}
}
