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