public void FetchFromList_Expected_NonNullDisplayName()
{
string error;
IBinaryDataList dl1;
dl1 = Dev2BinaryDataListFactory.CreateDataList();
IList <Dev2Column> cols = new List <Dev2Column>();
cols.Add(Dev2BinaryDataListFactory.CreateColumn("field1"));
dl1.TryCreateRecordsetTemplate("recset", "", cols, true, out error);
dl1.TryCreateRecordsetValue("value", "field1", "recset", 1, out error);
IBinaryDataListEntry entry;
dl1.TryGetEntry("recset", out entry, out error);
// DataList Cleanup ;)
Assert.AreEqual("recset(1).field1", entry.FetchRecordAt(1, out error).First().DisplayValue);
Assert.AreEqual(error, "");
}
public void MyTestInitialize()
{
string error;
var dataListCompiler = DataListFactory.CreateDataListCompiler();
_dl1 = Dev2BinaryDataListFactory.CreateDataList();
_dl1.TryCreateScalarTemplate(string.Empty, "myScalar", "A scalar", true, out error);
_dl1.TryCreateScalarValue("[[otherScalar]]", "myScalar", out error);
_dl1.TryCreateScalarTemplate(string.Empty, "otherScalar", "A scalar", true, out error);
_dl1.TryCreateScalarValue("testRegion", "otherScalar", out error);
_dl1.TryCreateScalarTemplate(string.Empty, "scalar1", "A scalar", true, out error);
_dl1.TryCreateScalarValue("foobar", "scalar1", out error);
IList <Dev2Column> cols = new List <Dev2Column>();
cols.Add(Dev2BinaryDataListFactory.CreateColumn("f1"));
cols.Add(Dev2BinaryDataListFactory.CreateColumn("f2"));
cols.Add(Dev2BinaryDataListFactory.CreateColumn("f3"));
_dl1.TryCreateRecordsetTemplate("recset", "a recordset", cols, true, out error);
_dl1.TryCreateRecordsetValue("r1.f1.value", "f1", "recset", 1, out error);
_dl1.TryCreateRecordsetValue("r1.f2.value", "f2", "recset", 1, out error);
_dl1.TryCreateRecordsetValue("r1.f3.value", "f3", "recset", 1, out error);
_dl1.TryCreateRecordsetValue("r2.f1.value", "f1", "recset", 2, out error);
_dl1.TryCreateRecordsetValue("r2.f2.value", "f2", "recset", 2, out error);
_dl1.TryCreateRecordsetValue("r2.f3.value", "f3", "recset", 2, out error);
// skip 3 ;)
_dl1.TryCreateRecordsetValue("r4.f1.value", "f1", "recset", 4, out error);
_dl1.TryCreateRecordsetValue("r4.f2.value", "f2", "recset", 4, out error);
_dl1.TryCreateRecordsetValue("r4.f3.value", "f3", "recset", 4, out error);
dataListCompiler.PushBinaryDataList(_dl1.UID, _dl1, out _errors);
//_compiler.UpsertSystemTag(dl1.UID, enSystemTag.EvaluateIteration, "true", out errors);
/* list 2 */
_dl2 = Dev2BinaryDataListFactory.CreateDataList();
_dl2.TryCreateScalarTemplate(string.Empty, "idx", "A scalar", true, out error);
_dl2.TryCreateScalarValue("1", "idx", out error);
_dl2.TryCreateRecordsetTemplate("recset", "a recordset", cols, true, out error);
_dl2.TryCreateRecordsetValue("r1.f1.value", "f1", "recset", 1, out error);
_dl2.TryCreateRecordsetValue("r1.f2.value", "f2", "recset", 1, out error);
_dl2.TryCreateRecordsetValue("r1.f3.value", "f3", "recset", 1, out error);
_dl2.TryCreateRecordsetValue("r2.f1.value", "f1", "recset", 2, out error);
_dl2.TryCreateRecordsetValue("r2.f2.value", "f2", "recset", 2, out error);
_dl2.TryCreateRecordsetValue("r2.f3.value", "f3", "recset", 2, out error);
dataListCompiler.PushBinaryDataList(_dl2.UID, _dl2, out _errors);
//_compiler.UpsertSystemTag(dl2.UID, enSystemTag.EvaluateIteration, "true", out errors);
}
public void Clone_50EntryRS_1kTimes_AtDepth()
{
string error;
IBinaryDataList dl1 = Dev2BinaryDataListFactory.CreateDataList(GlobalConstants.NullDataListID);
IList <Dev2Column> cols = new List <Dev2Column>();
cols.Add(Dev2BinaryDataListFactory.CreateColumn("f1"));
cols.Add(Dev2BinaryDataListFactory.CreateColumn("f2"));
cols.Add(Dev2BinaryDataListFactory.CreateColumn("f3"));
cols.Add(Dev2BinaryDataListFactory.CreateColumn("f4"));
cols.Add(Dev2BinaryDataListFactory.CreateColumn("f5"));
const int r = 50;
const int runs = 1000;
dl1.TryCreateRecordsetTemplate("recset", string.Empty, cols, true, out error);
for (int i = 0; i < r; i++)
{
dl1.TryCreateRecordsetValue("r1.f1.value r1.f1.value r1.f1.valuer1.f1.valuer1.f1.value", "f1", "recset", (i + 1), out error);
dl1.TryCreateRecordsetValue("r1.f2.value", "f2", "recset", (i + 1), out error);
dl1.TryCreateRecordsetValue("r1.f3.valuer1.f3.valuer1.f3.valuer1.f3.valuer1.f3.valuer1.f3.valuer1.f3.value", "f3", "recset", (i + 1), out error);
dl1.TryCreateRecordsetValue("r1.f3.value", "f4", "recset", (i + 1), out error);
dl1.TryCreateRecordsetValue("r1.f3.value r1.f3.value v r1.f3.value r1.f3.value", "f5", "recset", (i + 1), out error);
}
DateTime start1 = DateTime.Now;
string er;
IBinaryDataListEntry val;
bool tryGetEntry = dl1.TryGetEntry("recset", out val, out er);
for (int q = 0; q < runs; q++)
{
if (tryGetEntry)
{
val.Clone(enTranslationDepth.Data, dl1.UID, out er);
}
}
DateTime end1 = DateTime.Now;
long ticks = (end1.Ticks - start1.Ticks);
double result1 = (ticks / _ticksPerSec);
Console.WriteLine(result1 + @" seconds for " + runs + @" to clone ");
Assert.IsTrue(result1 <= 10.5); // Given .01 buffer ;) WAS : 0.065
}
public void LargeBDL_Create_1Mil_5Cols_Recordset_Entries()
{
string error;
IBinaryDataList dl1 = Dev2BinaryDataListFactory.CreateDataList(GlobalConstants.NullDataListID);
IList <Dev2Column> cols = new List <Dev2Column>();
cols.Add(Dev2BinaryDataListFactory.CreateColumn("f1"));
cols.Add(Dev2BinaryDataListFactory.CreateColumn("f2"));
cols.Add(Dev2BinaryDataListFactory.CreateColumn("f3"));
cols.Add(Dev2BinaryDataListFactory.CreateColumn("f4"));
cols.Add(Dev2BinaryDataListFactory.CreateColumn("f5"));
const int runs = 10000;
dl1.TryCreateRecordsetTemplate("recset", string.Empty, cols, true, out error);
using (dl1)
{
DateTime start1 = DateTime.Now;
for (int i = 0; i < runs; i++)
{
dl1.TryCreateRecordsetValue("r1.f1.value r1.f1.value r1.f1.valuer1.f1.valuer1.f1.value", "f1", "recset", (i + 1), out error);
dl1.TryCreateRecordsetValue("r1.f2.value", "f2", "recset", (i + 1), out error);
dl1.TryCreateRecordsetValue("r1.f3.valuer1.f3.valuer1.f3.valuer1.f3.valuer1.f3.valuer1.f3.valuer1.f3.value", "f3", "recset", (i + 1), out error);
dl1.TryCreateRecordsetValue("r1.f3.value", "f4", "recset", (i + 1), out error);
dl1.TryCreateRecordsetValue("r1.f3.value r1.f3.value v r1.f3.value r1.f3.value", "f5", "recset", (i + 1), out error);
}
DateTime end1 = DateTime.Now;
long ticks = (end1.Ticks - start1.Ticks);
double result1 = (ticks / _ticksPerSec);
Console.WriteLine(result1 + @" seconds for " + runs + @" with 5 cols");
Assert.IsTrue(result1 <= 1500, "Expected 500 seconds but got " + result1 + " seconds"); // Given 0.75 WAS : 0.75
// Since Windblow really sucks at resource allocation, I need to adjust these for when it is forced into a multi-user enviroment!!!!
}
}
public void CloneWhereHasComplexExpressionAuditorExpectIsOnClonedObject()
{
//------------Setup for test--------------------------
string error;
IBinaryDataList dl1 = Dev2BinaryDataListFactory.CreateDataList(GlobalConstants.NullDataListID);
IList <Dev2Column> cols = new List <Dev2Column>();
cols.Add(Dev2BinaryDataListFactory.CreateColumn("f1"));
dl1.TryCreateRecordsetTemplate("recset", string.Empty, cols, true, out error);
dl1.TryCreateRecordsetValue("r1.f1.value r1.f1.value r1.f1.valuer1.f1.valuer1.f1.value", "f1", "recset", 1, out error);
string er;
IBinaryDataListEntry val;
dl1.TryGetEntry("recset", out val, out er);
val.ComplexExpressionAuditor = new ComplexExpressionAuditor();
//------------Execute Test---------------------------
IBinaryDataListEntry res = val.Clone(enTranslationDepth.Data, dl1.UID, out er);
//------------Assert Results-------------------------
Assert.IsNotNull(res.ComplexExpressionAuditor);
}
public void LargeBDL_Persist_1M_5Cols_Recordset_Entries()
{
string error;
IBinaryDataList dl1 = Dev2BinaryDataListFactory.CreateDataList(GlobalConstants.NullDataListID);
IList <Dev2Column> cols = new List <Dev2Column>();
cols.Add(Dev2BinaryDataListFactory.CreateColumn("f1"));
cols.Add(Dev2BinaryDataListFactory.CreateColumn("f2"));
cols.Add(Dev2BinaryDataListFactory.CreateColumn("f3"));
cols.Add(Dev2BinaryDataListFactory.CreateColumn("f4"));
cols.Add(Dev2BinaryDataListFactory.CreateColumn("f5"));
const int runs = 10000; //1000000;
dl1.TryCreateRecordsetTemplate("recset", string.Empty, cols, true, out error);
DateTime start1 = DateTime.Now;
for (int i = 0; i < runs; i++)
{
dl1.TryCreateRecordsetValue("r1.f1.value r1.f1.value r1.f1.valuer1.f1.valuer1.f1.value", "f1", "recset", (i + 1), out error);
dl1.TryCreateRecordsetValue("r1.f2.value", "f2", "recset", (i + 1), out error);
dl1.TryCreateRecordsetValue("r1.f3.valuer1.f3.valuer1.f3.valuer1.f3.valuer1.f3.valuer1.f3.valuer1.f3.value", "f3", "recset", (i + 1), out error);
dl1.TryCreateRecordsetValue("r1.f3.value", "f4", "recset", (i + 1), out error);
dl1.TryCreateRecordsetValue("r1.f3.value r1.f3.value v r1.f3.value r1.f3.value", "f5", "recset", (i + 1), out error);
}
DateTime end1 = DateTime.Now;
long ticks = (end1.Ticks - start1.Ticks);
double result1 = (ticks / _ticksPerSec);
Console.WriteLine(result1 + @" seconds for " + runs + @" with 5 cols");
Assert.IsTrue(result1 <= 2600, "Expected 600 seconds but got " + result1 + " seconds"); // create speed
}
private Guid CreateDataList(enDev2ColumnArgumentDirection dir)
{
DataListFactory.CreateDataListCompiler();
string error;
ErrorResultTO errors;
IBinaryDataList dl1 = Dev2BinaryDataListFactory.CreateDataList(GlobalConstants.NullDataListID);
IList <Dev2Column> cols = new List <Dev2Column>();
cols.Add(Dev2BinaryDataListFactory.CreateColumn("f1", dir));
cols.Add(Dev2BinaryDataListFactory.CreateColumn("f2", dir));
cols.Add(Dev2BinaryDataListFactory.CreateColumn("f3", dir));
cols.Add(Dev2BinaryDataListFactory.CreateColumn("f4", dir));
cols.Add(Dev2BinaryDataListFactory.CreateColumn("f5", dir));
dl1.TryCreateRecordsetTemplate("recset", string.Empty, cols, true, true, dir, out error);
dl1.TryCreateScalarTemplate(string.Empty, "myScalar", string.Empty, true, true, dir, out error);
// dl1.Dispose();
return(_compiler.PushBinaryDataList(dl1.UID, dl1, out errors));
}
public void Clone_50EntryRS_10kTimes_AtDepth()
{
IBinaryDataList dl1;
double result1;
const int r = 50;
const int runs = 10000;
using (dl1 = Dev2BinaryDataListFactory.CreateDataList(GlobalConstants.NullDataListID))
{
IList <Dev2Column> cols = new List <Dev2Column>();
cols.Add(Dev2BinaryDataListFactory.CreateColumn("f1"));
cols.Add(Dev2BinaryDataListFactory.CreateColumn("f2"));
cols.Add(Dev2BinaryDataListFactory.CreateColumn("f3"));
cols.Add(Dev2BinaryDataListFactory.CreateColumn("f4"));
cols.Add(Dev2BinaryDataListFactory.CreateColumn("f5"));
string error;
dl1.TryCreateRecordsetTemplate("recset", string.Empty, cols, true, out error);
for (int i = 0; i < r; i++)
{
dl1.TryCreateRecordsetValue("r1.f1.value r1.f1.value r1.f1.valuer1.f1.valuer1.f1.value", "f1", "recset", (i + 1), out error);
dl1.TryCreateRecordsetValue("r1.f2.value", "f2", "recset", (i + 1), out error);
dl1.TryCreateRecordsetValue("r1.f3.valuer1.f3.valuer1.f3.valuer1.f3.valuer1.f3.valuer1.f3.valuer1.f3.value", "f3", "recset", (i + 1), out error);
dl1.TryCreateRecordsetValue("r1.f3.value", "f4", "recset", (i + 1), out error);
dl1.TryCreateRecordsetValue("r1.f3.value r1.f3.value v r1.f3.value r1.f3.value", "f5", "recset", (i + 1), out error);
}
DateTime start1 = DateTime.Now;
string er;
IBinaryDataListEntry val;
bool tryGetEntry = dl1.TryGetEntry("recset", out val, out er);
for (int q = 0; q < runs; q++)
{
if (tryGetEntry)
{
// ReSharper disable RedundantAssignment
val.Clone(enTranslationDepth.Data, dl1.UID, out er);
// ReSharper restore RedundantAssignment
}
}
DateTime end1 = DateTime.Now;
long ticks = (end1.Ticks - start1.Ticks);
result1 = (ticks / _ticksPerSec);
}
Console.WriteLine(result1 + @" seconds for " + runs + @" to clone ");
// Was 5, now 25 for enviroments ;)
if (result1 <= 125)
{
Assert.IsTrue(result1 <= 125, " It Took " + result1); // Given .1 buffer ;) WAS " 0.65
}
else
{
Assert.Fail("Time for new hardward buddy!");
}
}
public void MyTestInitialize()
{
string error;
_dl1 = Dev2BinaryDataListFactory.CreateDataList();
_dl1.TryCreateScalarTemplate(string.Empty, "myScalar", "A scalar", true, out error);
_dl1.TryCreateScalarValue("myValue", "myScalar", out error);
IList <Dev2Column> cols = new List <Dev2Column>();
cols.Add(Dev2BinaryDataListFactory.CreateColumn("f1"));
cols.Add(Dev2BinaryDataListFactory.CreateColumn("f2"));
cols.Add(Dev2BinaryDataListFactory.CreateColumn("f3"));
_dl1.TryCreateRecordsetTemplate("recset", "a recordset", cols, true, out error);
_dl1.TryCreateRecordsetValue("r1.f1.value", "f1", "recset", 1, out error);
_dl1.TryCreateRecordsetValue("r1.f2.value", "f2", "recset", 1, out error);
_dl1.TryCreateRecordsetValue("r1.f3.value", "f3", "recset", 1, out error);
_dl1.TryCreateRecordsetValue("r2.f1.value", "f1", "recset", 2, out error);
_dl1.TryCreateRecordsetValue("r2.f2.value", "f2", "recset", 2, out error);
_dl1.TryCreateRecordsetValue("r2.f3.value", "f3", "recset", 2, out error);
// skip 3 ;)
_dl1.TryCreateRecordsetValue("r4.f1.value", "f1", "recset", 4, out error);
_dl1.TryCreateRecordsetValue("r4.f2.value", "f2", "recset", 4, out error);
_dl1.TryCreateRecordsetValue("r4.f3.value", "f3", "recset", 4, out error);
// create 2nd obj
_dl2 = Dev2BinaryDataListFactory.CreateDataList();
_dl2.TryCreateScalarTemplate(string.Empty, "myScalar", "A scalar", true, out error);
_dl2.TryCreateScalarValue("myValue2", "myScalar", out error);
cols = new List <Dev2Column> {
Dev2BinaryDataListFactory.CreateColumn("f1"), Dev2BinaryDataListFactory.CreateColumn("f2"), Dev2BinaryDataListFactory.CreateColumn("f3")
};
_dl2.TryCreateRecordsetTemplate("recset", "a recordset", cols, true, out error);
_dl2.TryCreateRecordsetValue("r1a.f1.value2", "f1", "recset", 1, out error);
_dl2.TryCreateRecordsetValue("r1a.f2.value2", "f2", "recset", 1, out error);
_dl2.TryCreateRecordsetValue("r1a.f3.value2", "f3", "recset", 1, out error);
_dl2.TryCreateRecordsetValue("r2a.f1.value2", "f1", "recset", 2, out error);
_dl2.TryCreateRecordsetValue("r2a.f2.value2", "f2", "recset", 2, out error);
_dl2.TryCreateRecordsetValue("r2a.f3.value2", "f3", "recset", 2, out error);
_dl2.TryCreateRecordsetValue("r3a.f1.value2", "f1", "recset", 3, out error);
_dl2.TryCreateRecordsetValue("r3a.f2.value2", "f2", "recset", 3, out error);
_dl2.TryCreateRecordsetValue("r3a.f3.value2", "f3", "recset", 3, out error);
// create 3rd obj
_dl3 = Dev2BinaryDataListFactory.CreateDataList();
_dl3.TryCreateScalarTemplate(string.Empty, "theScalar", "A scalar", true, out error);
_dl3.TryCreateScalarValue("theValue", "theScalar", out error);
cols = new List <Dev2Column> {
Dev2BinaryDataListFactory.CreateColumn("f1"), Dev2BinaryDataListFactory.CreateColumn("f2"), Dev2BinaryDataListFactory.CreateColumn("f3")
};
_dl3.TryCreateRecordsetTemplate("recset2", "a recordset", cols, true, out error);
_dl3.TryCreateRecordsetValue("r1a.f1.value2", "f1", "recset2", 1, out error);
_dl3.TryCreateRecordsetValue("r1a.f2.value2", "f2", "recset2", 1, out error);
_dl3.TryCreateRecordsetValue("r1a.f3.value2", "f3", "recset2", 1, out error);
_dl3.TryCreateRecordsetValue("r2a.f1.value2", "f1", "recset2", 2, out error);
_dl3.TryCreateRecordsetValue("r2a.f2.value2", "f2", "recset2", 2, out error);
_dl3.TryCreateRecordsetValue("r2a.f3.value2", "f3", "recset2", 2, out error);
_dl3.TryCreateRecordsetValue("r3a.f1.value2", "f1", "recset2", 3, out error);
_dl3.TryCreateRecordsetValue("r3a.f2.value2", "f2", "recset2", 3, out error);
_dl3.TryCreateRecordsetValue("r3a.f3.value2", "f3", "recset2", 3, out error);
// create 4th obj
_dl4 = Dev2BinaryDataListFactory.CreateDataList();
_dl4.TryCreateScalarTemplate(string.Empty, "theScalar", "A scalar", true, out error);
_dl4.TryCreateScalarValue("theValue4", "theScalar", out error);
_dl4.TryCreateScalarTemplate(string.Empty, "myScalar", "A scalar", true, out error);
_dl4.TryCreateScalarValue("myValue4", "myScalar", out error);
cols = new List <Dev2Column> {
Dev2BinaryDataListFactory.CreateColumn("f1"), Dev2BinaryDataListFactory.CreateColumn("f2"), Dev2BinaryDataListFactory.CreateColumn("f3")
};
_dl4.TryCreateRecordsetTemplate("recset2", "a recordset", cols, true, out error);
_dl4.TryCreateRecordsetValue("r1a.f1.value2", "f1", "recset2", 1, out error);
_dl4.TryCreateRecordsetValue("r1a.f2.value2", "f2", "recset2", 1, out error);
_dl4.TryCreateRecordsetValue("r1a.f3.value2", "f3", "recset2", 1, out error);
_dl4.TryCreateRecordsetValue("r2a.f1.value2", "f1", "recset2", 2, out error);
_dl4.TryCreateRecordsetValue("r2a.f2.value2", "f2", "recset2", 2, out error);
_dl4.TryCreateRecordsetValue("r2a.f3.value2", "f3", "recset2", 2, out error);
_dl4.TryCreateRecordsetValue("r3a.f1.value2", "f1", "recset2", 3, out error);
_dl4.TryCreateRecordsetValue("r3a.f2.value2", "f2", "recset2", 3, out error);
_dl4.TryCreateRecordsetValue("r3a.f3.value2", "f3", "recset2", 3, out error);
// create 5th obj
_dlWithBankScalar = Dev2BinaryDataListFactory.CreateDataList();
_dlWithBankScalar.TryCreateScalarTemplate(string.Empty, "myScalar", "A scalar", true, out error);
_dlWithBankScalar.TryCreateScalarValue("", "myScalar", out error);
_dlWithPopulatedScalar = Dev2BinaryDataListFactory.CreateDataList();
_dlWithPopulatedScalar.TryCreateScalarTemplate(string.Empty, "myScalar", "A scalar", true, out error);
_dlWithPopulatedScalar.TryCreateScalarValue("CAKE!", "myScalar", out error);
}
