Пример #1
0
        private void userLevelTimer_Tick(object sender, EventArgs e)
        {
            AsyncStoreHeatnInput();

            userLevelTimer.Enabled = false;
            sw.Reset();
            inputStopWatch.Reset();
            timer2.Stop();

            normalInputSW.Reset();

            if (autContrl.isOn)
            {
                DBUtils.OpenConection();
                int test  = DBUtils.ExecuteScalar(autContrl.lastRowIDQuery);
                int test2 = autContrl.begginingID;
                if (DBUtils.ExecuteScalar(autContrl.lastRowIDQuery) - autContrl.begginingID > 2500)
                {
                    timer2.Interval = autContrl.CalculateUserLevel();
                    //autContrl.isOn = false;
                }
                DBUtils.CloseConnection();
            }
        }
        private void MistakesSpeed()
        {
            mistakesSpeedDict.Clear();
            int average = DBUtils.ExecuteScalar(string.Format("SELECT AVG(timestamp) FROM InputsView WHERE timestamp > 5 {0}", whereAnd));

            for (int i = 0; i < 10000; i += 50)
            {
                string query           = string.Format("SELECT  AVG(true_typing_speed) FROM MistakesView WHERE typing_speed between {0} and {1} {2}", i + 1, i + 50, whereAnd);
                int    trueTypSpeedAvg = DBUtils.ExecuteScalar(query);
                if (trueTypSpeedAvg > 9)
                {
                    mistakesSpeedDict.Add(Math.Round(1000 / (double)(i + 50), 2), Math.Round(1000 / (double)trueTypSpeedAvg, 2));
                }
            }
            avgTypingSpeed = new double[mistakesSpeedDict.Count];
            int k = 0;

            foreach (var item in mistakesSpeedDict)
            {
                avgTypingSpeed[k] = Math.Round(1000 / (double)average * 0.8, 2);
                k++;
            }
            isLoadedMistakesSpeed = true;
        }
Пример #3
0
 public void WriteToDB(string query)
 {
     DBUtils.OpenConection();
     DBUtils.ExecuteQueries(query);
     DBUtils.CloseConnection();
 }
Пример #4
0
        private async void TestInsert()
        {
            string connectionString = "Data Source=DatabaseLite.sqlite;Version=3;PRAGMA journal_mode=WAL;";

            OrmLiteConnectionFactory dbFactory = new OrmLiteConnectionFactory(connectionString, SqliteDialect.Provider);



            List <int> stList = new List <int>();
            Stopwatch  st     = new Stopwatch();

            Heatmap ht = new Heatmap();

            ht.date       = "2018-06-20 10:06:14";
            ht.delay      = 500;
            ht.program_id = 12;
            ht.input      = "Return";



            using (IDbConnection db = dbFactory.OpenDbConnection())
            {
                using (IDbTransaction trans = db.OpenTransaction())
                {
                    st.Start();
                    // db.BeginTransaction();
                    for (int i = 0; i < 500000; i++)
                    {
                        db.Insert(ht);
                    }

                    trans.Commit();
                    st.Stop();

                    stList.Add((int)st.ElapsedMilliseconds);
                };
            };


            /* using (var db = dbFactory.Open())
             * {
             *   for (int i = 0; i < 100; i++)
             *   {
             *       db.ExecuteNonQuery("BEGIN");
             *       db.Insert(new Heatmap { input = "Return", delay = 500, date = "2018-06-20 10:06:14", program_id = 12 });
             *       db.ExecuteNonQuery("end");
             *   }
             *   st.Stop();
             *   stList.Add((int)st.ElapsedMilliseconds);
             * }*/



            DBUtils.OpenConection();
            st.Restart();
            for (int i = 0; i < 500000; i++)
            {
                query = "INSERT INTO Heatmap (input,delay,date,program_id) " + "VALUES ('Return', 500, '2018-06-20 10:06:1', '12')";
                DBUtils.ExecuteQueries(query);
            }
            st.Stop();
            stList.Add((int)st.ElapsedMilliseconds);
            DBUtils.CloseConnection();

            string t = "";

            using (var db = dbFactory.Open())
            {
            }
        }
 public void InitializePrograms()
 {
     DBUtils.OpenConection();
     programList = DBUtils.ReadPrograms();
     DBUtils.CloseConnection();
 }