public void ExecuteInsertTableTemplatePathTest() { string dbfile = "taskaludb33.sqlite"; string path = Path.GetTempPath() + "\\" + dbfile; TouchTestDB(dbfile); var lt = new ListTemplatePath(); lt.Template_Id = 1; lt.Order = 1; lt.Path = "path"; Debug.Assert(SQLiteClass.ExecuteInsertTableTemplatePath(path, lt)); }
public void ExecuteSelectTableTemplatePathTest() { string dbfile = "taskaludb34.sqlite"; string path = Path.GetTempPath() + "\\" + dbfile; TouchTestDB(dbfile); var lt = new ListTemplatePath(); lt.Template_Id = 1; lt.Order = 1; lt.Path = "path"; SQLiteClass.ExecuteInsertTableTemplatePath(path, lt); var tplv = new TemplatePathListViewModel(); Debug.Assert(SQLiteClass.ExecuteSelectTableTemplatePath(path, tplv, 1)); Debug.Assert(tplv.Entries.Count == 1); }
public void ExecuteSelectCountTemplatePathTest() { string dbfile = "taskaludb36.sqlite"; string path = Path.GetTempPath() + "\\" + dbfile; TouchTestDB(dbfile); var lt = new ListTemplatePath(); lt.Template_Id = 1; lt.Order = 1; lt.Path = "path"; SQLiteClass.ExecuteInsertTableTemplatePath(path, lt); var lt2 = new ListTemplatePath(); lt2.Template_Id = 1; lt2.Order = 2; lt2.Path = "path2"; SQLiteClass.ExecuteInsertTableTemplatePath(path, lt2); Debug.Assert(SQLiteClass.ExecuteSelectCountTemplatePath(path, 1, "path2") == 1); }