public static IEnumerable <ViewSpec> ConvertAll(IEnumerable <ReportOrViewSpec> reportOrViewSpecs,
SrmDocument document)
{
ReportSpecConverter converter = null;
foreach (var reportOrViewSpec in reportOrViewSpecs)
{
if (reportOrViewSpec.ViewSpec != null)
{
yield return(reportOrViewSpec.ViewSpec);
}
else
{
converter = converter ?? new ReportSpecConverter(GetSkylineDataSchema(document, DataSchemaLocalizer.INVARIANT));
yield return(converter.Convert(reportOrViewSpec.ReportSpec).GetViewSpec());
}
}
}
public static IEnumerable <ViewSpecLayout> ConvertAll(IEnumerable <ReportOrViewSpec> reportOrViewSpecs,
SrmDocument document)
{
ReportSpecConverter converter = null;
foreach (var reportOrViewSpec in reportOrViewSpecs)
{
if (reportOrViewSpec.ViewSpecLayout != null)
{
yield return(reportOrViewSpec.ViewSpecLayout);
}
else
{
converter = converter ?? new ReportSpecConverter(GetSkylineDataSchema(document, DataSchemaLocalizer.INVARIANT));
yield return(new ViewSpecLayout(converter.Convert(reportOrViewSpec.ReportSpec).GetViewSpec().SetUiMode(String.Empty), ViewLayoutList.EMPTY));
}
}
}
public void TestMapping()
{
var settings = SrmSettingsList.GetDefault();
var document = new SrmDocument(settings);
var documentContainer = new MemoryDocumentContainer();
documentContainer.SetDocument(document, null);
using (var database = new Database(settings))
{
var dataSchema = new SkylineDataSchema(documentContainer, DataSchemaLocalizer.INVARIANT);
var sessionFactory = database.SessionFactory;
foreach (var classMetaData in sessionFactory.GetAllClassMetadata().Values)
{
var tableType = classMetaData.GetMappedClass(EntityMode.Poco);
foreach (var propertyName in classMetaData.PropertyNames)
{
if (propertyName == "Protein" && tableType == typeof (DbProteinResult))
{
continue;
}
var queryDef = new QueryDef
{
Select = new[] {new ReportColumn(tableType, propertyName),}
};
var reportSpec = new ReportSpec("test", queryDef);
var newTableType = ReportSpecConverter.GetNewTableType(reportSpec);
Assert.IsNotNull(newTableType, "No table for type {0}", tableType);
var converter = new ReportSpecConverter(dataSchema);
var viewInfo = converter.Convert(reportSpec);
Assert.IsNotNull(viewInfo, "Unable to convert property {0} in table {1}", propertyName, tableType);
Assert.AreEqual(1, viewInfo.DisplayColumns.Count, "No conversion for property {0} in table {1}", propertyName, tableType);
Assert.IsNotNull(viewInfo.DisplayColumns[0].ColumnDescriptor, "Column not found for property {0} in table {1}", propertyName, tableType);
var report = Report.Load(reportSpec);
var resultSet = report.Execute(database);
var bindingListSource = new BindingListSource();
bindingListSource.SetViewContext(new SkylineViewContext(viewInfo.ParentColumn, Array.CreateInstance(viewInfo.ParentColumn.PropertyType, 0)), viewInfo);
var properties = bindingListSource.GetItemProperties(null);
var oldCaptions = resultSet.ColumnInfos.Select(columnInfo => columnInfo.Caption).ToArray();
var newCaptions = properties.Cast<PropertyDescriptor>().Select(pd=>pd.DisplayName).ToArray();
if (oldCaptions.Length != newCaptions.Length)
{
Console.Out.WriteLine(oldCaptions);
}
CollectionAssert.AreEqual(oldCaptions, newCaptions, "Caption mismatch on {0} in {1}", propertyName, tableType);
for (int i = 0; i < resultSet.ColumnInfos.Count; i++)
{
var columnInfo = resultSet.ColumnInfos[i];
var formatAttribute = (FormatAttribute)properties[i].Attributes[typeof(FormatAttribute)];
string message = string.Format("Format problem on column converted from {0} in {1}",
columnInfo.ReportColumn.Column, columnInfo.ReportColumn.Table);
if (null == columnInfo.Format)
{
Assert.IsTrue(null == formatAttribute || null == formatAttribute.Format, message);
}
else
{
Assert.IsNotNull(formatAttribute, message);
Assert.AreEqual(columnInfo.Format, formatAttribute.Format, message);
}
if (columnInfo.IsNumeric)
{
Assert.IsNotNull(formatAttribute, message);
Assert.AreEqual(TextUtil.EXCEL_NA, formatAttribute.NullValue, message);
}
else
{
Assert.IsTrue(null == formatAttribute || null == formatAttribute.NullValue, message);
}
}
}
}
}
}
public void CheckReport(ReportSpec reportSpec)
{
string message = string.Format("Report {0}", reportSpec.Name);
var converter = new ReportSpecConverter(_dataSchema);
var viewInfo = converter.Convert(reportSpec);
var report = Report.Load(reportSpec);
ResultSet resultSet;
try
{
resultSet = report.Execute(_database);
}
catch (Exception)
{
return;
}
using (var bindingListSource = new BindingListSource())
{
bindingListSource.SetViewContext(new SkylineViewContext(viewInfo.ParentColumn, GetRowSource(viewInfo)),
viewInfo);
var oldCaptions = resultSet.ColumnInfos.Select(columnInfo => columnInfo.Caption).ToArray();
var properties = bindingListSource.GetItemProperties(null);
IList resultRows = bindingListSource;
var newCaptions = properties.Cast<PropertyDescriptor>().Select(pd => pd.DisplayName).ToArray();
if (!oldCaptions.SequenceEqual(newCaptions))
{
CollectionAssert.AreEqual(oldCaptions, newCaptions, message);
}
if (resultSet.RowCount != resultRows.Count)
{
Assert.AreEqual(resultSet.RowCount, resultRows.Count, message);
}
resultRows = SortRows(resultRows, properties);
resultSet = SortResultSet(resultSet);
for (int iRow = 0; iRow < resultSet.RowCount; iRow++)
{
for (int iCol = 0; iCol < resultSet.ColumnInfos.Count; iCol++)
{
var propertyDescriptor = properties[iCol];
object oldValue = resultSet.GetRow(iRow)[iCol];
object newValue = propertyDescriptor.GetValue(resultRows[iRow]);
if (!Equals(oldValue, newValue))
{
Assert.AreEqual(oldValue, newValue,
message + "{0}:Values are not equal on Row {1} Column {2} ({3}) FullName:{4}",
message, iRow, iCol, propertyDescriptor.DisplayName, propertyDescriptor.Name);
}
}
}
foreach (char separator in new[] { ',', '\t' })
{
StringWriter oldStringWriter = new StringWriter();
var cultureInfo = LocalizationHelper.CurrentCulture;
ResultSet.WriteReportHelper(resultSet, separator, oldStringWriter, cultureInfo);
StringWriter newStringWriter = new StringWriter();
var skylineViewContext = (SkylineViewContext) bindingListSource.ViewContext;
ProgressStatus progressStatus = new ProgressStatus("Status");
skylineViewContext.Export(null, ref progressStatus, viewInfo, newStringWriter,
new DsvWriter(cultureInfo, separator));
var newLineSeparators = new[] { "\r\n" };
var oldLines = oldStringWriter.ToString().Split(newLineSeparators, StringSplitOptions.None);
var newLines = newStringWriter.ToString().Split(newLineSeparators, StringSplitOptions.None);
// TODO(nicksh): Old reports would hide columns for annotations that were not in the document.
bool anyHiddenColumns = resultSet.ColumnInfos.Any(column => column.IsHidden);
if (!anyHiddenColumns)
{
Assert.AreEqual(oldLines[0], newLines[0]);
CollectionAssert.AreEquivalent(oldLines, newLines);
}
}
}
}
private void ValidateReport(ReportSpec reportSpec, Type rowType)
{
var dataSchema = GetDataSchema();
var converter = new ReportSpecConverter(dataSchema);
var viewInfo = converter.Convert(reportSpec);
Assert.AreEqual(rowType, viewInfo.ParentColumn.PropertyType);
EnsureViewRoundTrips(viewInfo);
}
