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