public void ExecuteUpdateTableAutoGenerateTest() { string dbfile = "taskaludb45.sqlite"; string path = Path.GetTempPath() + "\\" + dbfile; TouchTestDB(dbfile); var lt = new ListAutoGenerate(); lt.Order = 1; lt.Type = 0; lt.Name = "name"; lt.Priority = ""; lt.Template = 1; lt.Number0 = 0; lt.Number1 = 0; lt.Checked_date = "2019-02-01 01:23:45"; SQLiteClass.ExecuteInsertTableAutoGenerate(path, lt); var lt2 = new ListAutoGenerate(); lt2.Order = 2; lt2.Type = 1; lt2.Name = "name2"; lt2.Priority = ""; lt2.Template = 1; lt2.Number0 = 0; lt2.Number1 = 0; lt2.Checked_date = "2019-02-01 01:23:45"; Debug.Assert(SQLiteClass.ExecuteUpdateTableAutoGenerate(path, lt2)); }
public void CaluculateTheNextADayOfEveryMonthTest() { var lt = new ListAutoGenerate(); lt.Order = 1; lt.Type = 0; lt.Name = "name"; lt.Priority = ""; lt.Template = 1; lt.Number0 = 2; lt.Number1 = 0; lt.Checked_date = "2019-02-01 00:00:00"; DateTime result = AutoGenerate.CaluculateTheNextADayOfEveryMonth(lt); Debug.Assert(DateTime.Compare(result, new DateTime(2019, 2, 2, 0, 0, 0)) == 0); lt.Number0 = 2; lt.Checked_date = "2019-02-02 00:00:00"; result = AutoGenerate.CaluculateTheNextADayOfEveryMonth(lt); Debug.Assert(DateTime.Compare(result, new DateTime(2019, 3, 2, 0, 0, 0)) == 0); lt.Number0 = 29; lt.Checked_date = "2019-02-02 00:00:00"; result = AutoGenerate.CaluculateTheNextADayOfEveryMonth(lt); Debug.Assert(DateTime.Compare(result, new DateTime(2019, 2, 28, 0, 0, 0)) == 0); lt.Number0 = 2; lt.Checked_date = "2019-12-02 00:00:00"; result = AutoGenerate.CaluculateTheNextADayOfEveryMonth(lt); Debug.Assert(DateTime.Compare(result, new DateTime(2020, 1, 2, 0, 0, 0)) == 0); }
public void CaluculateTheNextAWeekDayOfEveryWeekTest() { var lt = new ListAutoGenerate(); lt.Order = 1; lt.Type = 1; lt.Name = "name"; lt.Priority = ""; lt.Template = 1; lt.Number0 = 0; lt.Number1 = 0; lt.Checked_date = "2019-02-02 00:00:00"; DateTime result = AutoGenerate.CaluculateTheNextAWeekDayOfEveryWeek(lt); Debug.Assert(DateTime.Compare(result, new DateTime(2019, 2, 3, 0, 0, 0)) == 0); lt.Number1 = 0; lt.Checked_date = "2019-02-03 00:00:00"; result = AutoGenerate.CaluculateTheNextAWeekDayOfEveryWeek(lt); Debug.Assert(DateTime.Compare(result, new DateTime(2019, 2, 10, 0, 0, 0)) == 0); lt.Number1 = 6; lt.Checked_date = "2019-02-02 00:00:00"; result = AutoGenerate.CaluculateTheNextAWeekDayOfEveryWeek(lt); Debug.Assert(DateTime.Compare(result, new DateTime(2019, 2, 9, 0, 0, 0)) == 0); }
public void AutoGenerateTaskTest2() { string dbfile = "taskaludb_autogenerate1.sqlite"; string path = Path.GetTempPath() + "\\" + dbfile; TouchTestDB(dbfile); var lt = new ListTemplate(); lt.Order = 1; lt.Name = "name"; lt.Template = "template"; SQLiteClass.ExecuteInsertTableTemplate(path, lt); var la = new ListAutoGenerate(); la.Order = 1; la.Type = 0; la.Name = "name"; la.Priority = ""; la.Template = 1; la.Number0 = 2; la.Number1 = 0; la.Checked_date = "2019-02-02 00:00:00"; var result = AutoGenerate.AutoGenerateTask(path, la, new DateTime(2019, 2, 2)); Debug.Assert(result == 1 + 2 + 4 + 8); }
public void ExecuteSelectTableAutoGenerateTest() { string dbfile = "taskaludb43.sqlite"; string path = Path.GetTempPath() + "\\" + dbfile; TouchTestDB(dbfile); var lt = new ListAutoGenerate(); lt.Order = 1; lt.Type = 0; lt.Name = "name"; lt.Priority = ""; lt.Template = 1; lt.Number0 = 0; lt.Number1 = 0; lt.Checked_date = "2019-02-01 01:23:45"; SQLiteClass.ExecuteInsertTableAutoGenerate(path, lt); var lt2 = new ListAutoGenerate(); lt2.Order = 2; lt2.Type = 1; lt2.Name = "name2"; lt2.Priority = ""; lt2.Template = 1; lt2.Number0 = 0; lt2.Number1 = 0; lt2.Checked_date = "2019-02-01 01:23:45"; SQLiteClass.ExecuteInsertTableAutoGenerate(path, lt2); var aglv = new AutoGenerateListViewModel(); var result = SQLiteClass.ExecuteSelectTableAutoGenerate(path, aglv); Debug.Assert(result); Debug.Assert(aglv.Entries.Count == 2); }