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);
}
