/// <summary>
/// Update table usage stats
/// </summary>
/// <param name="query"></param>
public static void UpdateTableUsageStatistics(
Query query)
{
int count, ti, ci;
QueryTable qt;
QueryColumn qc;
if (SS.I.QueryTestMode)
{
return; // don't do if test mode
}
for (ti = 0; ti < query.Tables.Count; ti++) // update table usage stats
{
qt = query.Tables[ti];
string mtName = qt.MetaTable.Name;
if (SS.I.TableUsageStatistics.ContainsKey(mtName))
{
count = SS.I.TableUsageStatistics[mtName];
}
else
{
count = 0;
}
SS.I.TableUsageStatistics[qt.MetaTable.Name] = count + 1;
for (ci = 0; ci < qt.QueryColumns.Count; ci++) // count structure search types
{
qc = qt.QueryColumns[ci];
if (qc.MetaColumn == null)
{
continue;
}
if (qc.MetaColumn.DataType != MetaColumnType.Structure)
{
continue;
}
if (qc.Criteria == "")
{
continue;
}
ParsedSingleCriteria psc = MqlUtil.ParseSingleCriteria(qc.Criteria);
if (psc != null && psc.Op != null && psc.Op.Length >= 1)
{
string txt = psc.Op;
if (!Char.IsLetter(txt[0]))
{
txt = "FSS " + txt;
}
else if (Lex.Eq(txt, "msimilar")) // include type of
{
int i1 = psc.Value2.IndexOf(" ");
if (i1 >= 0)
{
psc.Value2 = psc.Value2.Substring(0, i1);
}
txt += " " + psc.Value2;
}
txt = "StrSrch " + txt;
UsageDao.LogEvent(txt);
}
}
}
}
/// <summary>
/// Format grid and show the data
/// </summary>
/// <param name="qm"></param>
/// <param name="container">Either a QueryResultsControl or a PopupGrid</param>
public static void ConfigureAndShow(
QueryManager qm,
Control container)
{
QueryResultsControl qrc = null;
PopupGrid pug = null;
MoleculeGridPageControl page;
MoleculeGridPanel panel;
MoleculeGridControl grid;
Query q = qm.Query;
ResultsFormat rf = qm.ResultsFormat;
//qm.QueryResultsControl = null;
page = new MoleculeGridPageControl(); // Create a new, clean page, panel and grids
panel = page.MoleculeGridPanel;
grid = panel.SelectBaseGridViewGrid(qm);
qm.LinkMember(grid); // link grid into qm
grid.ShowCheckMarkCol = q.ShowGridCheckBoxes;
DataTableMx dt = qm.DataTable; // save ref to data table
grid.DataSource = null; // clear source for header build
qm.DataTable = dt; // restore data table
grid.FormatGridHeaders(qm.ResultsFormat); // qm.MoleculeGrid.V.Columns.Count should be set for proper cols
if (container is QueryResultsControl && rf.NotPopupOutputFormContext) // normal query results
{
qrc = container as QueryResultsControl;
qrc.RemoveExistingControlsFromResultsPageControlContainer(); // properly dispose of any existing DevExpress controls
qrc.MoleculeGridPageControl = page; // link query results to this page
qrc.ResultsPageControlContainer.Controls.Add(page);
page.Dock = DockStyle.Fill;
//qm.QueryResultsControl = qrc; // link view set into query manager (used for filtering)
if (q.Parent == null) // switch display to browse mode if root query
{
QbUtil.SetMode(QueryMode.Browse, q);
}
if (rf.Query.LogicType == QueryLogicType.And) // log grid query by logic type
{
UsageDao.LogEvent("QueryGridAnd", "");
}
else if (rf.Query.LogicType == QueryLogicType.Or)
{
UsageDao.LogEvent("QueryGridOr", "");
}
else if (rf.Query.LogicType == QueryLogicType.Complex)
{
UsageDao.LogEvent("QueryGridComplex", "");
}
}
else if (container is PopupGrid || rf.PopupOutputFormContext) // popup results
{
if (container is PopupGrid)
{
pug = container as PopupGrid;
}
else // create a popup
{
pug = new PopupGrid(qm);
pug.Text = q.UserObject.Name;
}
if (pug.Controls.ContainsKey(panel.Name)) // remove any existing panel control
{
pug.Controls.RemoveByKey(panel.Name);
}
pug.Controls.Add(panel);
pug.MoleculeGridPanel = panel; // restore direct link as well
grid.ScaleView(q.ViewScale);
UIMisc.PositionPopupForm(pug);
pug.Text = q.UserObject.Name;
pug.Show();
}
else
{
throw new Exception("Invalid container type: " + container.GetType());
}
// Set the DataSource to the real DataTable
panel.SetDataSource(qm, dt);
return;
}
/// <summary>
/// OK button clicked, process input
/// </summary>
/// <returns></returns>
DialogResult ProcessInput()
{
int rgCount; // number of Rgroups
List <Rgroup> rgList; // list of existing Rgroups
bool[] rgExists; // entry = true if rgroup exists in core
Rgroup rg;
bool oneD, twoD; // matrix dimensionality
List <string> keys = null;
Dictionary <string, List <QualifiedNumber> > mElem; // matrix element dictionary
List <RgroupSubstituent>[] rSubs; // substituents seen for each Rgroup
Query q, q0, q2;
QueryTable qt, qt2;
QueryColumn qc, qc2;
MetaTable mt, mt2;
MetaColumn mc, mc2;
DataTableMx dt;
DataRowMx dr;
DialogResult dlgRslt;
string tok;
int ri, rii, si, qti, qci, bi, bi2;
// Get core structure & list of R-groups
MoleculeMx core = new MoleculeMx(MoleculeFormat.Molfile, SQuery.MolfileString);
if (core.AtomCount == 0)
{
MessageBoxMx.ShowError("A Core structure with R-groups must be defined");
return(DialogResult.None);
}
if (!Structure.Checked && !Smiles.Checked && !Formula.Checked &&
!Weight.Checked && !Index.Checked)
{
MessageBoxMx.ShowError("At least one substituent display format must be selected.");
return(DialogResult.None);
}
mt = MetaTableCollection.GetWithException("Rgroup_Decomposition");
qt = new QueryTable(mt);
qc = qt.GetQueryColumnByNameWithException("Core");
qc.MolString = core.GetMolfileString(); // put core structure into table criteria
qc.CriteriaDisplay = "Substructure search (SSS)";
qc.Criteria = "CORE SSS SQUERY";
qc = qt.GetQueryColumnByNameWithException("R1_Structure");
if (ShowCoreStructure.Checked)
{
qc.Label = "R-group, Core\tChime=" + core.GetChimeString(); // reference core in query col header label
qc.MetaColumn.Width = 25;
}
RgroupDecomposition.SetSelected(qt, "R1_Structure", Structure.Checked); // select for retrieval if checked
RgroupDecomposition.SetSelected(qt, "R1_Smiles", Smiles.Checked);
RgroupDecomposition.SetSelected(qt, "R1_Formula", Formula.Checked);
RgroupDecomposition.SetSelected(qt, "R1_Weight", Weight.Checked);
RgroupDecomposition.SetSelected(qt, "R1_SubstNo", Index.Checked);
string terminateOption = "First mapping"; // terminate on first complete match
qc = qt.GetQueryColumnByNameWithException("Terminate_Option");
qc.Criteria = qt.MetaTable.Name + " = " + Lex.AddSingleQuotes(terminateOption);
qc.CriteriaDisplay = "= " + Lex.AddSingleQuotes(terminateOption);
QueryTable rgdQt = qt; // keep a ref to it
if (QbUtil.Query == null || QbUtil.Query.Tables.Count == 0)
{
MessageBoxMx.ShowError("No current query.");
return(DialogResult.None);
}
q0 = QbUtil.Query; // original query this analysis is based on
q = q0.Clone(); // make copy of source query we can modify
q.SingleStepExecution = false;
qti = 0;
while (qti < q.Tables.Count) // deselect query columns that we don't want
{
qt = q.Tables[qti];
if (Lex.Eq(qt.MetaTable.Name, "Rgroup_Decomposition"))
{ // remove any rgroup decomp table
qti++;
continue;
}
mt = qt.MetaTable;
if (mt.MultiPivot || // check for tables not allowed in underlying query
mt.MetaBrokerType == MetaBrokerType.CalcField || // (called ShouldPresearchAndTransform previously)
mt.MetaBrokerType == MetaBrokerType.MultiTable ||
mt.MetaBrokerType == MetaBrokerType.RgroupDecomp)
{
MessageBoxMx.ShowError("Multipivot/Rgroup table \"" + qt.ActiveLabel +
"\" can't be included in an underlying Rgroup Matrix query");
return(DialogResult.None);
}
for (qci = 0; qci < qt.QueryColumns.Count; qci++)
{
qc = qt.QueryColumns[qci];
if (qc.MetaColumn == null)
{
continue;
}
switch (qc.MetaColumn.DataType)
{
case MetaColumnType.CompoundId: // keep only these
case MetaColumnType.Integer:
case MetaColumnType.Number:
case MetaColumnType.QualifiedNo:
case MetaColumnType.String:
break;
default:
qc.Selected = false;
break;
}
}
qti++;
}
q.AddQueryTable(rgdQt); // Add Rgroup decom table to end of cloned source query
Progress.Show("Retrieving data...");
try
{
dlgRslt = ToolHelper.ExecuteQuery(ref q, out keys);
if (dlgRslt != DialogResult.OK)
{
return(dlgRslt);
}
}
catch (Exception ex)
{
MessageBoxMx.ShowError("Error executing query:\r\n" + ex.Message);
return(DialogResult.None);
}
if (keys == null || keys.Count == 0)
{
Progress.Hide();
MessageBoxMx.ShowError("No results were returned by the query.");
return(DialogResult.None);
}
// Scan modified query to get list of rgroup indexes that are present
rgExists = new bool[32];
rgList = new List <Rgroup>();
QueryTable rgQt = q.GetQueryTableByName("Rgroup_Decomposition");
foreach (QueryColumn qc0 in rgQt.QueryColumns)
{
mc = qc0.MetaColumn;
if (!(mc.Name.StartsWith("R") && mc.Name.EndsWith("_STRUCTURE") && qc0.Selected))
{
continue; // skip if not a selected Rgroup structure
}
int len = mc.Name.Length - ("R" + "_STRUCTURE").Length;
tok = mc.Name.Substring(1, len);
if (!int.TryParse(tok, out ri))
{
continue;
}
rgExists[ri - 1] = true;
rg = new Rgroup();
rg.RIndex = ri;
rg.VoPos = qc0.VoPosition;
rgList.Add(rg);
}
for (bi = 1; bi < rgList.Count; bi++)
{ // sort by increasing R index
rg = rgList[bi];
for (bi2 = bi - 1; bi2 >= 0; bi2--)
{
if (rg.RIndex >= rgList[bi2].RIndex)
{
break;
}
rgList[bi2 + 1] = rgList[bi2];
}
rgList[bi2 + 1] = rg;
}
rgCount = rgList.Count;
twoD = TwoD.Checked;
if (rgCount == 1)
{
twoD = false; // if only 1 rgroup can't do as 2d
}
oneD = !twoD;
// Read data into mElem and rgroup substituents into rSubs.
// Matrix mElem is keyed on [R1Smiles, R2Smiles,... RnSmiles, FieldName] for 1d and
// [R1Smiles, R2Smiles,... FieldName, RnSmiles] for 2d
QueryManager qm = q.QueryManager as QueryManager;
DataTableManager dtm = qm.DataTableManager;
dt = qm.DataTable;
mElem = new Dictionary <string, List <QualifiedNumber> >(); // matrix element dictionary
rSubs = new List <RgroupSubstituent> [32]; // list of substituents seen for each Rgroup
for (rii = 0; rii < rgCount; rii++) // alloc substituent list for rgroup
{
rSubs[rii] = new List <RgroupSubstituent>();
}
int rowCount = 0;
while (true)
{ // scan data accumulating rgroup substituents and data values
dr = dtm.FetchNextDataRow();
if (dr == null)
{
break;
}
rowCount++;
string cid = dr[dtm.KeyValueVoPos] as string;
string lastMapCid = "", rgroupKey = "", rgroupKeyLast = "";
int mapCount = 0;
for (rii = 0; rii < rgCount; rii++) // for
{
MoleculeMx rSub = dr[rgList[rii].VoPos] as MoleculeMx;
if (rSub == null || rSub.AtomCount == 0)
{
continue;
}
ri = rgList[rii].RIndex; // actual R index in query
int subIdx = RgroupSubstituent.Get(rSub, rSubs[rii]);
// if (ri == 1 && subIdx != 0) subIdx = subIdx; // debug
if (subIdx < 0)
{
continue;
}
string rKey = "R" + ri.ToString() + "_" + (subIdx + 1).ToString();
if (oneD || rii < rgCount - 1)
{
if (rgroupKey != "")
{
rgroupKey += "\t";
}
rgroupKey += rKey;
}
else
{
rgroupKeyLast = rKey;
}
lastMapCid = cid;
mapCount++;
}
if (lastMapCid == cid) // add the data if compound has a mapping
{
AccumulateMatrixElements(mElem, q, dr, rgroupKey, rgroupKeyLast, cid);
}
if (Progress.IsTimeToUpdate)
{
Progress.Show("Retrieving data: " + StringMx.FormatIntegerWithCommas(rowCount) + " rows...");
}
}
if (rowCount == 0)
{
Progress.Hide();
MessageBoxMx.ShowError("No data rows retrieved");
return(DialogResult.None);
}
if (twoD && (rSubs[rgCount - 1] == null || rSubs[rgCount - 1].Count == 0))
{ // if 2D be sure we have at least one substituent for the last Rgroup
Progress.Hide();
MessageBoxMx.ShowError("No substituents found for R" + rgCount.ToString());
return(DialogResult.None);
}
// Create a MetaTable & DataTable for matrix results
Progress.Show("Analyzing data...");
mt = new MetaTable(); // create output table
MatrixCount++;
mt.Name = "RGROUPMATRIX_" + MatrixCount;
mt.Label = "R-group Matrix " + MatrixCount;
mt.MetaBrokerType = MetaBrokerType.RgroupDecomp;
mc = // use sequence for key
mt.AddMetaColumn("RgroupMatrixId", "No.", MetaColumnType.Integer, ColumnSelectionEnum.Selected, 3);
mc.ClickFunction = "None"; // avoid hyperlink on this key
mc.IsKey = true;
int maxLeftR = rgCount;
if (twoD)
{
maxLeftR = rgCount - 1;
}
for (ri = 0; ri < maxLeftR; ri++)
{
string rStr = "R" + (ri + 1).ToString();
if (Structure.Checked)
{
mc = mt.AddMetaColumn(rStr + "Str", rStr, MetaColumnType.Structure, ColumnSelectionEnum.Selected, 12);
if (ri == 0 && ShowCoreStructure.Checked) // include core structure above R1 if requested
{
string chimeString = MoleculeMx.MolfileStringToSmilesString(SQuery.MolfileString);
mc.Label = "R1, Core\tChime=" + chimeString;
mc.Width = 25;
}
}
if (Smiles.Checked)
{
mc = mt.AddMetaColumn(rStr + "Smi", rStr + " Smiles", MetaColumnType.String, ColumnSelectionEnum.Selected, 12);
}
if (Formula.Checked)
{
mc = mt.AddMetaColumn(rStr + "Mf", rStr + " Formula", MetaColumnType.String, ColumnSelectionEnum.Selected, 8);
}
if (Weight.Checked)
{
mc = mt.AddMetaColumn(rStr + "MW", rStr + " Mol. Wt.", MetaColumnType.Number, ColumnSelectionEnum.Selected, 6, ColumnFormatEnum.Decimal, 2);
}
if (Index.Checked)
{
mc = mt.AddMetaColumn(rStr + "Index", rStr + " Subst. Idx.", MetaColumnType.Number, ColumnSelectionEnum.Selected, 4);
mc.Format = ColumnFormatEnum.Decimal;
}
}
mc = // add column to contain result type
mt.AddMetaColumn("ResultType", "Result Type", MetaColumnType.String, ColumnSelectionEnum.Selected, 12);
if (oneD) // add just 1 column to contain results
{
mc = mt.AddMetaColumn("Results", "Results", MetaColumnType.QualifiedNo, ColumnSelectionEnum.Selected, 12);
mc.MetaBrokerType = MetaBrokerType.RgroupDecomp; // broker to do special col handling for cond formtting
if (QbUtil.Query.UserObject.Id > 0)
{
mc.DetailsAvailable = true;
}
}
else // add col for each substituent for last rgroup
{
string rStr = "R" + rgCount.ToString();
for (si = 0; si < rSubs[rgCount - 1].Count; si++)
{
string cName = rStr + "_" + (si + 1).ToString();
string cLabel = cName.Replace("_", ".");
RgroupSubstituent rgs = rSubs[ri][si]; // get substituent info
if (Structure.Checked) // include structure
{
cLabel += "\tChime=" + rgs.Struct.GetChimeString();
}
else if (Smiles.Checked)
{
cLabel += " = " + rgs.Struct.GetSmilesString();
}
else if (Formula.Checked)
{
cLabel += " = " + rgs.Struct.MolFormula;
}
else if (Weight.Checked)
{
cLabel += " = " + rgs.Struct.MolWeight;
}
else if (Index.Checked)
{
cLabel += " = " + (si + 1).ToString();
}
mc = mt.AddMetaColumn(cName, cLabel, MetaColumnType.QualifiedNo, ColumnSelectionEnum.Selected, 12);
mc.MetaBrokerType = MetaBrokerType.RgroupDecomp;
if (QbUtil.Query.UserObject.Id > 0)
{
mc.DetailsAvailable = true;
}
}
}
MetaTableCollection.UpdateGlobally(mt); // add as a known metatable
if (mElem.Count == 0) // be sure we have a matrix
{
Progress.Hide();
MessageBoxMx.ShowError("No matrix can be created because insufficient data was found.");
return(DialogResult.None);
}
// Build the DataTable
Progress.Show("Building data table...");
q2 = new Query(); // build single-table query to hold matrix
qt2 = new QueryTable(q2, mt);
dt = DataTableManager.BuildDataTable(q2);
Dictionary <string, List <QualifiedNumber> > .KeyCollection kc = mElem.Keys;
string[] rgKeys = new string[mElem.Count];
kc.CopyTo(rgKeys, 0);
Array.Sort(rgKeys);
string[] rgKey = null, lastRgKey = null;
int rki = 0;
for (rki = 0; rki < rgKeys.Length; rki++)
{
rgKey = rgKeys[rki].Split('\t');
int riTop = rgCount + 1; // all r substituents & field name on left
if (twoD)
{
riTop = rgCount;
}
for (ri = 0; ri < riTop; ri++) // see if any changes in left side substituents or field name
{
if (lastRgKey == null || rgKey[ri] != lastRgKey[ri])
{
break;
}
}
if (ri < riTop || oneD) // if 2d then new row only if some change before last R
{
dr = dt.NewRow();
dt.Rows.Add(dr);
dr[dtm.KeyValueVoPos + 1] = new NumberMx(dt.Rows.Count); // integer row key
}
if (!HideRepeatingSubstituents.Checked)
{
ri = 0; // start at first if not hiding
}
lastRgKey = rgKey;
for (ri = ri; ri < riTop; ri++) // build row with these
{
string rgSub = rgKey[ri]; // get substituent id or table.column name
if (rgSub == "")
{
continue;
}
if (ri < riTop - 1)
{ // output substituent and/or smiles
string rStr = "R" + (ri + 1).ToString();
si = rgSub.IndexOf("_");
si = Int32.Parse(rgSub.Substring(si + 1)) - 1; // get substituent index
RgroupSubstituent rgs = rSubs[ri][si]; // get substituent info
if (Structure.Checked)
{
qc2 = qt2.GetQueryColumnByName(rStr + "Str");
dr[QcToDcName(qc2)] = rgs.Struct;
}
if (Smiles.Checked)
{
qc2 = qt2.GetQueryColumnByName(rStr + "Smi");
dr[QcToDcName(qc2)] = new StringMx(rgs.Struct.GetSmilesString());
}
if (Formula.Checked)
{
qc2 = qt2.GetQueryColumnByName(rStr + "Mf");
dr[QcToDcName(qc2)] = new StringMx(rgs.Struct.MolFormula);
}
if (Weight.Checked)
{
qc2 = qt2.GetQueryColumnByName(rStr + "Mw");
dr[QcToDcName(qc2)] = new NumberMx(rgs.Struct.MolWeight);
}
if (Index.Checked)
{
qc2 = qt2.GetQueryColumnByName(rStr + "Index");
dr[QcToDcName(qc2)] = new NumberMx(si + 1);
}
}
else // output field name
{
string[] sa = rgSub.Split('.'); // get field name
qt = q.GetQueryTableByName(sa[0]);
qc = qt.GetQueryColumnByName(sa[1]);
string fieldName = qc.ActiveLabel;
if (q0.Tables.Count >= 3) // qualify by table if 3 or more tables in original query
{
fieldName = qt.ActiveLabel + " - " + fieldName;
}
qc2 = qt2.GetQueryColumnByName("ResultType");
dr[QcToDcName(qc2)] = new StringMx(fieldName);
}
}
// Output value
string cName;
if (oneD)
{
cName = "Results";
}
else
{
cName = rgKey[rgCount]; // get key for this substituent (e.g. R2_1)
}
if (Lex.IsUndefined(cName))
{
continue; // may be no substituent match
}
qc2 = qt2.GetQueryColumnByName(cName);
QualifiedNumber qn = SummarizeData(mElem[rgKeys[rki]]); // get summarized value
dr[QcToDcName(qc2)] = qn;
}
ToolHelper.DisplayData(q2, dt, true);
UsageDao.LogEvent("RgroupMatrix");
Progress.Hide();
return(DialogResult.OK);
}
/// <summary>
/// Transform basic query to select all data for a compound number
/// </summary>
/// <param name="keyMt">Key metatable. If null then try to determine from key value</param>
/// <param name="cn"></param>
/// <returns></returns>
public static Query TransformSelectAllDataQuery(
Query originalQuery,
QueryTable qt0,
Query newQuery)
{
Query q2 = null;
MetaTable mt;
MetaColumn mc;
QueryTable qt;
QueryColumn qc;
MetaTreeNode mtn, tn;
qc = qt0.GetQueryColumnByNameWithException("root_table");
ParsedSingleCriteria psc = MqlUtil.ParseQueryColumnCriteria(qc);
if (psc == null || Lex.IsUndefined(psc.Value))
{
throw new UserQueryException("Root table not defined");
}
string keyMtName = psc.Value;
psc = MqlUtil.ParseSingleCriteria("cid " + originalQuery.KeyCriteria);
if (psc == null || Lex.IsUndefined(psc.Value))
{
throw new UserQueryException("Compound Id not defined");
}
string cn = psc.Value;
MetaTable keyMt = null;
if (Lex.IsDefined(keyMtName))
{
keyMt = MetaTableCollection.Get(keyMtName);
}
if (keyMt != null && keyMt.Root.IsUserDatabaseStructureTable) // if root metatable is user database then normalize based on key
{
keyMt = keyMt.Root; // be sure we have root
cn = CompoundId.Normalize(cn, keyMt);
}
else
{
cn = CompoundId.Normalize(cn);
keyMt = CompoundId.GetRootMetaTableFromCid(cn, keyMt);
keyMt = keyMt.Root; // be sure we have root (may not be structure table)
}
if (keyMt == null)
{
throw new Exception("Failed to identify key MetaTable");
}
string allTableName = keyMt.Name + "_AllData"; // see if specific all-data tree node
mtn = MetaTree.GetNode(allTableName);
if (mtn == null) // no special "_AllData" node, lookup in menu
{
foreach (MetaTreeNode parent in MetaTree.Nodes.Values)
{
foreach (MetaTreeNode child in parent.Nodes)
{
if (Lex.Eq(child.Target, keyMt.Name))
{
mtn = parent;
break;
}
}
}
IUserObjectTree iuot = InterfaceRefs.IUserObjectTree;
if (mtn == null && keyMt.IsUserDatabaseStructureTable && iuot != null) // see if user structure table & db
{
int userObjId = UserObject.ParseObjectIdFromInternalName(keyMt.Name);
string nodeItemId = "ANNOTATION_" + userObjId;
MetaTreeNode childMtn = iuot.GetUserObjectNodeBytarget(nodeItemId);
if (childMtn != null && childMtn.Parent.Type == MetaTreeNodeType.Database)
{
mtn = childMtn.Parent;
}
}
}
if (mtn == null)
{
return(null);
}
Query q = newQuery;
for (int i1 = 0; i1 < mtn.Nodes.Count; i1++)
{
tn = (MetaTreeNode)mtn.Nodes[i1];
if (!tn.IsDataTableType)
{
continue;
}
mt = MetaTableCollection.Get(tn.Target);
if (mt == null)
{
continue;
}
if (mt.Root.Name != keyMt.Name)
{
continue; // must have same root
}
if (mt.MultiPivot && !mt.UseSummarizedData && mt.SummarizedExists)
{
MetaTable mt2 = MetaTableCollection.Get(mt.Name + MetaTable.SummarySuffix);
if (mt2 != null)
{
mt = mt2;
}
}
//if (mt.RemapForRetrieval && mt.SummarizedExists) mt.UseSummarizedData = true; // get summarized multipivot data (not good, permanently changes the metatable)
qt = new QueryTable(mt);
// if (Lex.Eq(mt.Name, "all_star_pivoted") || Lex.Eq(mt.Name, "all_annotation_pivoted")) mt = mt // debug;
if (qt.SelectedCount > 0) // be sure something is selected
{
q.AddQueryTable(qt);
}
}
// See if a model query exists & use it or append to what we have already
string fileName = ServicesDirs.ModelQueriesDir + @"\" + allTableName + ".qry";
if (!ServerFile.GetLastWriteTime(fileName).Equals(DateTime.MinValue)) // model query file exist?
{
try
{
string query2String = FileUtil.ReadFile(fileName);
q2 = Query.Deserialize(query2String);
q.MergeSubqueries(q2); // just use subquery
}
catch (Exception ex) { ex = ex; }
}
q.SetupQueryPagesAndViews(ResultsViewType.HtmlTable); // be sure we have a default page & HTML view
// Set key criteria
q.KeyCriteria = " = " + cn;
// Review tables (debug)
//int tCnt = q.Tables.Count;
//string tls = q.TableListString;
//q.Tables.RemoveRange(23, 1);
//q.Tables.RemoveRange(27, q.Tables.Count - 27);
//q.Tables.RemoveRange(1, 25);
// Get list of any inaccessible tables & remove from query
q.InaccessableData = CheckDataSourceAccessibility(q);
if (q.InaccessableData != null)
{
foreach (string schema in q.InaccessableData.Keys)
{
foreach (string tName in q.InaccessableData[schema])
{
qt = q.GetQueryTableByName(tName);
if (qt != null && !qt.MetaTable.IsRootTable && q.Tables.Contains(qt))
{
q.RemoveQueryTable(qt);
}
}
}
//ShowUnavailableDataMessage(q);
q.InaccessableData = null;
}
UsageDao.LogEvent("QueryAllData", "");
//string mql = MqlUtil.ConvertQueryToMql(q); // debug
return(q);
}