public void TestColumnsFromResultsTables() { SrmDocument srmDocument = ResultsUtil.DeserializeDocument("silac_1_to_4.sky", GetType()); using (Database database = new Database()) { database.AddSrmDocument(srmDocument); SimpleReport report = new SimpleReport { Columns = new[] { new ReportColumn(typeof(DbTransitionResult), "PrecursorResult", "PeptideResult", "ProteinResult", "ReplicateName"), new ReportColumn(typeof(DbTransition), "Precursor", "Peptide", "Protein", "Name"), new ReportColumn(typeof(DbTransition), "Precursor", "Peptide", "Sequence"), new ReportColumn(typeof(DbTransitionResult), "Area"), }, }; ColumnSet columnSet = ColumnSet.GetTransitionsColumnSet(database.GetSchema()); TreeView treeView = new TreeView(); treeView.Nodes.AddRange(columnSet.GetTreeNodes().ToArray()); List <NodeData> columnInfos; columnSet.GetColumnInfos(report, treeView, out columnInfos); Assert.AreEqual(report.Columns.Count, columnInfos.Count); SimpleReport reportCompare = (SimpleReport)columnSet.GetReport(columnInfos, null); Assert.IsTrue(ArrayUtil.EqualsDeep(report.Columns, reportCompare.Columns)); } }
public void TestReportSpecList() { ReportSpecList reportSpecList = new ReportSpecList(); using (Database database = new Database()) { ColumnSet columnSet = ColumnSet.GetTransitionsColumnSet(database.GetSchema()); TreeView treeView = new TreeView(); treeView.Nodes.AddRange(columnSet.GetTreeNodes().ToArray()); foreach (ReportSpec reportSpec in reportSpecList.GetDefaults()) { Report report = Report.Load(reportSpec); ResultSet resultSet = report.Execute(database); List <NodeData> nodeDatas; columnSet.GetColumnInfos(report, treeView, out nodeDatas); Assert.IsFalse(nodeDatas.Contains(null)); if (reportSpec.GroupBy == null) { SimpleReport simpleReport = (SimpleReport)report; Assert.AreEqual(simpleReport.Columns.Count, resultSet.ColumnInfos.Count); Assert.AreEqual(simpleReport.Columns.Count, nodeDatas.Count); } } } }
public void SetReport(Report report) { _columns.Clear(); lbxColumns.Items.Clear(); List <NodeData> newColumns; _columnSet.GetColumnInfos(report, treeView, out newColumns); foreach (NodeData column in newColumns) { AddColumn(column); } cbxPivotReplicate.Checked = false; cbxPivotIsotopeLabel.Checked = false; var pivotReport = report as PivotReport; if (pivotReport != null) { var testColumns = pivotReport.Columns.Union(pivotReport.CrossTabValues).ToArray(); foreach (var id in pivotReport.CrossTabHeaders) { if (PivotType.REPLICATE.GetCrosstabHeaders(testColumns).Contains(id)) { cbxPivotReplicate.Checked = true; } if (PivotType.ISOTOPE_LABEL.GetCrosstabHeaders(testColumns).Contains(id)) { cbxPivotIsotopeLabel.Checked = true; } } } }