/// <summary>
/// Required method to load the data.
/// </summary>
/// <param name="hvo"></param>
/// <param name="tag"></param>
/// <param name="ws"></param>
/// <param name="_cda"></param>
public override void Load(int hvo, int tag, int ws, SIL.FieldWorks.Common.COMInterfaces.IVwCacheDa _cda)
{
// Need to get stem.PartOfSpeech instead of cn.Obj because cn.Obj and cn.Txt may be null! See LT-6828.
string sql = "select ls.id, ls.MorphoSyntaxAnalysis, msao.Owner$, msao.class$, ms.txt, ms.fmt, stem.PartOfSpeech, cn.txt from LexSense ls"
+ " left outer join MultiStr$ ms on ms.obj = ls.id and ms.flid = 5016005 and ms.ws = " + m_cache.DefaultAnalWs
+ " left outer join MoStemMsa stem on stem.id = ls.MorphoSyntaxAnalysis"
+ " left outer join CmPossibility_Name cn on stem.PartOfSpeech = cn.obj and cn.ws = " + m_cache.DefaultAnalWs
+ " left outer join CmObject msao on msao.id = ls.MorphoSyntaxAnalysis";
IVwOleDbDa dba = m_cache.VwOleDbDaAccessor;
IDbColSpec dcs = DbColSpecClass.Create();
dcs.Push((int)DbColType.koctObjVec, 0, this.Tag, 0);
dcs.Push((int)DbColType.koctObj, 1, (int)LexSense.LexSenseTags.kflidMorphoSyntaxAnalysis, 0);
dcs.Push((int)DbColType.koctObj, 2, (int)CmObjectFields.kflidCmObject_Owner, 0);
dcs.Push((int)DbColType.koctInt, 2, (int)CmObjectFields.kflidCmObject_Class, 0);
dcs.Push((int)DbColType.koctMlsAlt, 1, (int)LexSense.LexSenseTags.kflidDefinition, m_cache.DefaultAnalWs);
dcs.Push((int)DbColType.koctFmt, 1, (int)LexSense.LexSenseTags.kflidDefinition, m_cache.DefaultAnalWs);
dcs.Push((int)DbColType.koctObj, 2, (int)MoStemMsa.MoStemMsaTags.kflidPartOfSpeech, 0);
dcs.Push((int)DbColType.koctMltAlt, 7, (int)CmPossibility.CmPossibilityTags.kflidName, m_cache.DefaultAnalWs);
dba.Load(sql, dcs, hvo, 0, null, false);
}
/// <summary>
/// Record the current parse timestamp of a whole collection of StTexts
/// Equivalent to calling RecordParseTimestamp on each of them.
/// </summary>
/// <param name="texts"></param>
public static void RecordParseTimestamps(List <IStText> texts)
{
if (texts.Count == 0)
{
return;
}
FdoCache cache = texts[0].Cache;
int[] targetHvos = new int[texts.Count];
for (int i = 0; i < targetHvos.Length; i++)
{
targetHvos[i] = texts[i].Hvo;
}
int index = 0;
string Hvos = DbOps.MakePartialIdList(ref index, targetHvos);
string whereClause = "";
if (index == targetHvos.Length)
{
// If we can make a single where clause we'll do it; otherwise do them all.
whereClause = " where Owner$ in (" + Hvos + ")";
}
string sql = "select owner$, max(UpdStmp) from StTxtPara_ " + whereClause + " group by owner$";
IDbColSpec dcs = DbColSpecClass.Create();
dcs.Push((int)DbColType.koctBaseId, 0, 0, 0);
int modifyTimestampTag = ParagraphsModifiedTimestampTag(cache);
dcs.Push((int)DbColType.koctInt64, 1, modifyTimestampTag, 0);
cache.VwOleDbDaAccessor.Load(sql, dcs, 0, 0, null, false);
ISilDataAccess sda = cache.MainCacheAccessor;
foreach (StText text in texts)
{
// Much of the logic of RecordParseTimestamp, but can assume modify timestamp is already loaded.
text.LastParsedTimestamp = sda.get_Int64Prop(text.Hvo, modifyTimestampTag);
text.ClearLastModifiedTimestamp();
}
}
