示例#1
0
        public void ExecuteMoreSelectTableTaskTimeTest()
        {
            string dbfile = "taskaludb25.sqlite";
            string path   = Path.GetTempPath() + "\\" + dbfile;

            TouchTestDB(dbfile);

            SQLiteClass.DateSumMoreSize  = 20;
            SQLiteClass.DateSumMoreCount = 20;
            for (int i = 1; i <= 41; 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.ExecuteMoreSelectTableTaskTime(path, new DateTime(2019, 2, 1)));
        }