public void ReadAllDataForASimulation()
{
CreateTable(database);
DataStoreReader reader = new DataStoreReader(database);
var data = reader.GetData(tableName: "Report",
simulationNames: new string[] { "Sim1" });
Assert.IsTrue(
Utilities.CreateTable(new string[] { "CheckpointName", "CheckpointID", "SimulationName", "SimulationID", "Col1", "Col2" },
new List <object[]> {
new object[] { "Current", 1, "Sim1", 1, new DateTime(2017, 01, 01), 1.0 },
new object[] { "Current", 1, "Sim1", 1, new DateTime(2017, 01, 02), 2.0 }
})
.IsSame(data));
}
public void ReadDataUsingSql()
{
CreateTable(database);
DataStoreReader reader = new DataStoreReader(database);
var data = reader.GetDataUsingSql("SELECT [Col1] FROM [Report]");
Assert.AreEqual(Utilities.TableToString(data),
$" Col1{Environment.NewLine}" +
$"2017-01-01{Environment.NewLine}" +
$"2017-01-02{Environment.NewLine}" +
$"2017-01-01{Environment.NewLine}" +
$"2017-01-02{Environment.NewLine}" +
$"2017-01-01{Environment.NewLine}" +
$"2017-01-02{Environment.NewLine}" +
$"2017-01-01{Environment.NewLine}" +
$"2017-01-02{Environment.NewLine}");
}
public void ReadDataUsingSql()
{
CreateTable(database);
DataStoreReader reader = new DataStoreReader(database);
var data = reader.GetDataUsingSql("SELECT Col1 FROM Report");
Assert.AreEqual(Utilities.TableToString(data),
" Col1\r\n" +
"2017-01-01\r\n" +
"2017-01-02\r\n" +
"2017-01-01\r\n" +
"2017-01-02\r\n" +
"2017-01-01\r\n" +
"2017-01-02\r\n" +
"2017-01-01\r\n" +
"2017-01-02\r\n");
}
public void ReadDataForASimulationWithAFilter()
{
CreateTable(database);
DataStoreReader reader = new DataStoreReader(database);
var data = reader.GetData(tableName: "Report",
simulationNames: new string[] { "Sim1" },
fieldNames: new string[] { "Col2" },
filter: "Col2=2");
Assert.IsTrue(
Utilities.CreateTable(
new string[] { "CheckpointName", "CheckpointID", "SimulationName", "SimulationID", "Col2" },
new List <object[]> {
new object[] { "Current", 1, "Sim1", 1, 2 }
})
.IsSame(data));
}
public void PagingWithSimulationColumnandRowFilterWorks()
{
CreateTable(database);
var reader = new DataStoreReader(database);
var provider = new PagedDataProvider(reader, "Current", "Report",
new string[] { "Sim1" },
"Col1,Col2",
"Col1 > 2",
2);
Assert.AreEqual(3, provider.ColumnCount);
Assert.AreEqual("SimulationName", provider.GetCellContents(0, 0));
Assert.AreEqual("Col1", provider.GetCellContents(1, 0));
Assert.AreEqual("Col2", provider.GetCellContents(2, 0));
Assert.AreEqual(3, provider.RowCount);
Assert.AreEqual(2, provider.NumHeadingRows);
Assert.AreEqual("g", provider.GetCellContents(1, 1));
Assert.IsNull(provider.GetCellContents(2, 1));
Assert.AreEqual("10", provider.GetCellContents(2, 2));
}
public void ReadDataUsingSql()
{
CreateTable(database);
DataStoreReader reader = new DataStoreReader(database);
var data = reader.GetDataUsingSql("SELECT [Col1] FROM [Report]");
Assert.IsTrue(
Utilities.CreateTable(
new string[] { "Col1" },
new List <object[]> {
new object[] { new DateTime(2017, 01, 01) },
new object[] { new DateTime(2017, 01, 02) },
new object[] { new DateTime(2017, 01, 01) },
new object[] { new DateTime(2017, 01, 02) },
new object[] { new DateTime(2017, 01, 01) },
new object[] { new DateTime(2017, 01, 02) },
new object[] { new DateTime(2017, 01, 01) },
new object[] { new DateTime(2017, 01, 02) }
})
.IsSame(data));
}
public void PagingWithColumnFilterWorks()
{
CreateTable(database);
var reader = new DataStoreReader(database);
var provider = new PagedDataProvider(reader, "Current", "Report",
null,
"Col2",
null,
2);
Assert.AreEqual(2, provider.ColumnCount);
Assert.AreEqual("SimulationName", provider.GetCellContents(0, 0));
Assert.AreEqual("Col2", provider.GetCellContents(1, 0));
Assert.AreEqual(8, provider.RowCount);
Assert.AreEqual(1, provider.NumHeadingRows);
Assert.AreEqual("8", provider.GetCellContents(1, 1));
Assert.AreEqual("9", provider.GetCellContents(1, 2));
Assert.AreEqual("10", provider.GetCellContents(1, 3));
Assert.AreEqual("11", provider.GetCellContents(1, 4));
Assert.AreEqual("12", provider.GetCellContents(1, 5));
Assert.AreEqual("13", provider.GetCellContents(1, 6));
Assert.AreEqual("14", provider.GetCellContents(1, 7));
}
