public static void SetUp()
{
SQLiteConnection.CreateFile("blacklist.sqlite");
SQLiteConnection connection = new SQLiteConnection(setConnection);
SQLiteCommand command = new SQLiteCommand(createTable, connection);
connection.Open();
command.ExecuteNonQuery();
connection.Close();
BlacklistManager.OnChange();
}
public static void Delete(string address)
{
SQLiteConnection connection = new SQLiteConnection(setConnection);
connection.Open();
SQLiteCommand command = new SQLiteCommand(String.Format(removeItem, address), connection);
try {
command.ExecuteNonQuery();
BlacklistManager.OnChange();
}
catch (SQLiteException) {
connection.Close();
BlacklistManager.SetUp();
}
finally {
connection.Close();
}
}