Esempio n. 1
0
        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 }
                                   );
            }
        }
Esempio n. 2
0
        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);
        }