예제 #1
0
        public void ExecuteFirstSelectTableTaskTimeTest()
        {
            string dbfile = "taskaludb24.sqlite";
            string path   = Path.GetTempPath() + "\\" + dbfile;

            TouchTestDB(dbfile);

            SQLiteClass.DateSumMoreSize = 20;
            for (int i = 1; i <= 21; i++)
            {
                InsertTableTaskList(dbfile, "hoge", i); // tasklist id = 1
                SQLiteClass.InsertOrUpdateTaskTime(
                    path, false, i,
                    new DateTime(2019, 2, 1, 0, i, 0, DateTimeKind.Utc),
                    new DateTime(2019, 2, 1, 0, i + 1, 0, DateTimeKind.Utc));
            }
            Debug.Assert(SQLiteClass.ExecuteFirstSelectTableTaskTime(path, new DateTime(2019, 2, 1)));
        }