/// <summary>
/// Get TF-IDF from hubble table base on specified field.
/// Text is segmented.
/// Text format is like "abc^5^0 news^5^4" or "abc news"
/// </summary>
/// <param name="tableName">table name</param>
/// <param name="fieldName">field name must be tokenized index type</param>
/// <param name="formattedText">text segmentd</param>
/// <returns>TF IDF List</returns>
public HashSet <TFIDF> SP_GetTFIDFWithSegmentedText(string tableName,
string fieldName, string segmentdText)
{
SPExecutor <TFIDF> spExecutor = new SPExecutor <TFIDF>(this);
return(spExecutor.ReturnAsHashSet("exec SP_GetTFIDF {0}, {1}, {2}", tableName,
fieldName, segmentdText));
}
public HashSet <TableInfo> SP_TableList(string databaseName)
{
SPExecutor <TableInfo> spExecutor = new SPExecutor <TableInfo>(this);
HashSet <TableInfo> result = spExecutor.ReturnAsHashSet("exec SP_TableList {0}", databaseName);
foreach (TableInfo tableInfo in result)
{
tableInfo.TableName = tableInfo.TableName.Substring(databaseName.Trim().Length + 1,
tableInfo.TableName.Length - (databaseName.Trim().Length + 1));
}
return(result);
}
/// <summary>
/// List all the columns in the table specified.
/// </summary>
/// <param name="tableName">table name</param>
/// <returns>Columns</returns>
public HashSet <ColumnInfo> SP_Columns(string tableName)
{
SPExecutor <ColumnInfo> spExecutor = new SPExecutor <ColumnInfo>(this);
return(spExecutor.ReturnAsHashSet("exec SP_Columns {0}", tableName));
}
/// <summary>
/// List all the databases
/// </summary>
/// <returns></returns>
public HashSet <DatabaseInfo> SP_DatabaseList()
{
SPExecutor <DatabaseInfo> spExecutor = new SPExecutor <DatabaseInfo>(this);
return(spExecutor.ReturnAsHashSet("exec SP_DatabaseList", null));
}
/// <summary>
/// List all the tables in all the database
/// </summary>
/// <returns></returns>
public HashSet <TableInfo> SP_TableList()
{
SPExecutor <TableInfo> spExecutor = new SPExecutor <TableInfo>(this);
return(spExecutor.ReturnAsHashSet("exec SP_TableList", null));
}