private void FindAllDatabases()
{
IList <DatabaseInfo> list = null;
int processed = 0;
var sw = new Stopwatch();
try
{
sw.Start();
var p = new DatabaseProcessor(_connection, _testMode);
list = p.SearchDatabases(out processed);
Console.WriteLine("Database list: ");
foreach (var db in list)
{
Console.WriteLine($"\t{db.Database} ---> affected rows: {db.AffectedRows}");
}
File.WriteAllLines("FoundedDbs", list.Select(l => $"{l.Database} ----> affected rows: {l.AffectedRows}"));
}
catch (Exception ex)
{
var color = Console.ForegroundColor;
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine($"Something go wrong when database try to find");
Console.WriteLine(ex);
Console.ForegroundColor = color;
}
finally
{
sw.Stop();
Console.WriteLine($"End database list. Processed: {processed}; Founded: {list?.Count ?? 0}; 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}");
}
