private void ClearDatabase(string database, int surveyId = -1)
{
var sw = new Stopwatch();
Console.WriteLine($"Start Clear Database: {database}");
sw.Start();
var p = new DatabaseProcessor(_connection, _testMode);
try
{
p.ClearDatabase(database, surveyId);
}
catch (Exception ex)
{
var color = Console.ForegroundColor;
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine($"Something go wrong with db: {database}");
Console.WriteLine(ex);
Console.ForegroundColor = color;
}
sw.Stop();
Console.WriteLine($"End Clear Database {database}. Time: {sw.Elapsed}");
}
private void ClearAllDatabases()
{
var sw = new Stopwatch();
Console.WriteLine("Start Clear All Databases");
sw.Start();
var p = new DatabaseProcessor(_connection, _testMode);
var sw4Db = new Stopwatch();
foreach (var db in p.SearchDatabases(out _))
{
sw4Db.Start();
try
{
Console.WriteLine($"Start Clear Database: {db.Database}");
p.ClearDatabase(db.Database);
Console.WriteLine("Success!");
}
catch (Exception ex)
{
var color = Console.ForegroundColor;
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine($"Something go wrong with db: {db.Database}");
Console.WriteLine(ex);
Console.ForegroundColor = color;
}
finally
{
sw4Db.Stop();
Console.WriteLine($"End Clear Database: {db.Database}; Time: {sw4Db.Elapsed}");
sw4Db.Reset();
}
}
sw.Stop();
Console.WriteLine($"End Clear All Databases. Time: {sw.Elapsed}");
}
