private static void UpdateStatsTable(StatLocal stat, NpgsqlConnection connection)
{
if (!stat.Found)
{
return;
}
// Get Stat Model from database
var statModelList = connection.Query <StatDBModel>("SELECT * FROM stats_table WHERE input = @p", new { p = stat.Input }).ToList();
// Check if there is an entry already
if (statModelList.Count > 0)
{
// Check if there is a new best time
if (stat.LookupTime < statModelList[0].Best_time)
{
// Update Entry, Change Last Test, increment count
// Update besttime
connection.Execute("UPDATE stats_table SET last_test = @lt, best_time = @bt, test_count = @tc WHERE input = @i",
new { lt = stat.LastTest, bt = stat.LookupTime, tc = ++statModelList[0].Test_count, i = stat.Input }
);
}
else
{
// Update Entry, Change Last Test, increment count
connection.Execute("UPDATE stats_table SET last_test = @lt, test_count = @tc WHERE input = @i",
new { lt = stat.LastTest, tc = ++statModelList[0].Test_count, i = stat.Input }
);
}
}
else
{
// Create Stat Entry
connection.Execute("INSERT INTO stats_table VALUES (@i, @r, @ft, @lt, @bt, @c)",
new { i = stat.Input, r = stat.Result, ft = stat.LastTest, lt = stat.LastTest, bt = stat.LookupTime, c = 1 }
);
}
}
static void Main(string[] args)
{
// Config
Stopwatch stopwatch = new Stopwatch();
// Buid Connection String
var cConf = new ConnectionConfig();
// Connect to DB
using NpgsqlConnection connection = new NpgsqlConnection(cConf.ConnectionString);
connection.Open();
// Create Table
connection.Execute("CREATE TABLE IF NOT EXISTS stats_table (input int, result varchar(100), first_test timestamp, last_test timestamp, best_time int, test_count int)");
// Create Statistic Object
StatLocal stat = new StatLocal();
// Ask for number
Console.WriteLine("Please enter a number between 1 and 1.000.000: ");
do
{
try
{
stat.Input = int.Parse(Console.ReadLine());
break;
}
catch (FormatException e)
{
Console.WriteLine("Please provide valid input!");
}
} while (true);
// hash number
GenerateMD5 MD5Gen = new GenerateMD5();
stat.Result = MD5Gen.GetMd5Hash(MD5.Create(), stat.Input.ToString());
// lookup number & Stopwatch
stat.LastTest = DateTime.Now;
stopwatch.Start();
var dataList = connection.Query <HashData>("SELECT * FROM hashes WHERE hash = @p", new { p = stat.Result }).ToList();
stopwatch.Stop();
if (dataList.Count > 0)
{
// Found Match in Rainbow Table
stat.Found = true;
Console.WriteLine("Found value in Lookup Table!");
stat.LookupTime = Convert.ToInt32(stopwatch.Elapsed.TotalMilliseconds);
UpdateStatsTable(stat, connection);
}
else
{
stat.Found = false;
Console.WriteLine("Sorry, no match.");
}
TimeSpan ts = stopwatch.Elapsed;
string elapsedTime = String.Format("{0:00}:{1:00}:{2:00}.{3:00}",
ts.Hours, ts.Minutes, ts.Seconds,
ts.Milliseconds / 10);
Console.WriteLine("Lookup took this long: " + elapsedTime);
}
