public void ExecuteSumTaskTimeTest()
{
string dbfile = "taskaludb21.sqlite";
string path = Path.GetTempPath() + "\\" + dbfile;
TouchTestDB(dbfile);
InsertTableTaskList(dbfile, "hoge", 0); // tasklist id = 1
SQLiteClass.InsertOrUpdateTaskTime(
path, false, 1,
new DateTime(2019, 2, 1, 0, 0, 0, DateTimeKind.Utc),
new DateTime(2019, 2, 1, 16, 0, 0, DateTimeKind.Utc));
TimeSpan result = SQLiteClass.ExecuteSumTaskTime(path, 1);
Debug.Assert(TimeSpan.Compare(result, new TimeSpan(16, 0, 0)) == 0);
}
public void ExecuteFirstSelecttDateDetailsTableTaskTimeTest()
{
string dbfile = "taskaludb26.sqlite";
string path = Path.GetTempPath() + "\\" + dbfile;
TouchTestDB(dbfile);
SQLiteClass.DateDetailsMoreSize = 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.ExecuteFirstSelecttDateDetailsTableTaskTime(path, new DateTime(2019, 2, 1)));
}
