public static IEnumerable<int> Search(ModuleInfo module) { using (var db = new DbManager(TextIndexCfg.ConnectionStringName)) { return db.ExecuteList(module.SqlQuery).ConvertAll(r => GetId(r[0])); } }
public static DateTime GetLastDeltaIndexDate(ModuleInfo module) { using (var db = new DbManager("default")) { return db.ExecuteScalar<DateTime>(new SqlQuery("webstudio_index").Select("last_modified").Where("index_name", module.Delta)); } }
public static void UpdateLastDeltaIndexDate(ModuleInfo module) { using (var db = new DbManager("default")) { db.ExecuteNonQuery(new SqlInsert("webstudio_index", true).InColumnValue("index_name", module.Delta)); } }
public static bool CheckDeltaIndexNotEmpty(ModuleInfo module) { using (var db = new DbManager(TextIndexCfg.ConnectionStringName)) { var query = new SqlQuery(module.Delta).SelectCount(); return db.ExecuteScalar<int>(query) > 0; } }
public TextIndexer(string path, Tenant tenant, ModuleInfo module) { this.path = path; this.tenant = tenant; this.module = module; }
public bool CheckDeltaIndexNotEmpty(ModuleInfo module) { Start(); return(DbProvider.CheckDeltaIndexNotEmpty(module)); }