public void ExecuteMoreSelectTableTest() { string dbfile = "taskaludb10.sqlite"; CreateSQLiteDBFlie(dbfile); CreateTableTaskList(dbfile); SQLiteClass.moreSize = 10; for (int i = 0; i <= 20; i++) { InsertTableTaskList(dbfile, "hoge", i); } string path = Path.GetTempPath() + "\\" + dbfile; Debug.Assert(SQLiteClass.ExecuteFirstSelectTable(path, SQLiteClass.searchString)); }
public void ExecuteMoreSelectTableFTSTest() { string dbfile = "taskaludb11.sqlite"; string path = Path.GetTempPath() + "\\" + dbfile; TouchTestDB(dbfile); SQLiteClass.moreSize = 10; for (int i = 1; i <= 20; i++) { InsertTableTaskList(dbfile, "hoge", i); SQLiteClass.ExecuteInsertTableFTSString(path, i, "tasklist_name", Ngram.getNgramText("hoge", 2)); } InsertTableTaskList(dbfile, "ogem", 21); SQLiteClass.ExecuteInsertTableFTSString(path, 21, "tasklist_name", Ngram.getNgramText("ogem", 2)); Debug.Assert(SQLiteClass.ExecuteFirstSelectTable(path, "oge")); }