public void ExecuteSelectTableTemplateTest()
{
string dbfile = "taskaludb29.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 lt2 = new ListTemplate();
lt2.Order = 2;
lt2.Name = "name2";
lt2.Template = "template2";
SQLiteClass.ExecuteInsertTableTemplate(path, lt2);
var tlv = new TemplateListViewModel();
var result = SQLiteClass.ExecuteSelectTableTemplate(path, tlv);
Debug.Assert(result);
Debug.Assert(tlv.Entries.Count == 2);
}
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 ExecuteInsertTableTemplateTest()
{
string dbfile = "taskaludb28.sqlite";
string path = Path.GetTempPath() + "\\" + dbfile;
TouchTestDB(dbfile);
var lt = new ListTemplate();
lt.Order = 1;
lt.Name = "name";
lt.Template = "template";
Debug.Assert(SQLiteClass.ExecuteInsertTableTemplate(path, lt));
}
public void ExecuteSelectTemplateOrderFromIDTest()
{
string dbfile = "taskaludb47.sqlite";
string path = Path.GetTempPath() + "\\" + dbfile;
TouchTestDB(dbfile);
var lt = new ListTemplate();
lt.Order = 2;
lt.Name = "name";
lt.Template = "template";
SQLiteClass.ExecuteInsertTableTemplate(path, lt);
Debug.Assert(SQLiteClass.ExecuteSelectTemplateOrderFromID(path, 1) == 2);
}
