public void Delete_Last_Record_Expected_Last_Row_Deleted() { var entires = _dl2.FetchRecordsetEntries(); var entry = entires[0]; int preRecordCount = entry.ItemCollectionSize(); string errors; bool result = entry.TryDeleteRows("", out errors); int postRecordCount = entry.ItemCollectionSize(); Assert.IsTrue(postRecordCount == (preRecordCount - 1)); Assert.IsTrue(result); }
public OptomizedObservableCollection <IDataListItem> CreateListToBindTo(IBinaryDataList dataList) { var result = new OptomizedObservableCollection <IDataListItem>(); if (dataList != null) { var listOfEntries = dataList.FetchScalarEntries(); // process scalars ;) foreach (var entry in listOfEntries .Where(e => ((e.ColumnIODirection == enDev2ColumnArgumentDirection.Input || e.ColumnIODirection == enDev2ColumnArgumentDirection.Both)))) { result.AddRange(ConvertIBinaryDataListEntryToIDataListItem(entry)); } // now process recordsets ;) listOfEntries = dataList.FetchRecordsetEntries(); foreach (var entry in listOfEntries) { result.AddRange(ConvertIBinaryDataListEntryToIDataListItem(entry)); } } return(result); }
public void SerializeToXML_ValidXML_Expect_Sucess() { ErrorResultTO errors; string error; IDataListTranslator xmlConverter = Dls.GetTranslator(XmlFormat); byte[] data = (TestHelper.ConvertStringToByteArray(DataListWellformedData)); IBinaryDataList obj = xmlConverter.ConvertTo(data, _dataListWellformed, out errors); IBinaryDataListEntry entry; if (obj.TryGetEntry("rs1", out entry, out error)) { IList <IBinaryDataListItem> cols = entry.FetchRecordAt(1, out error); int systemTagCount = Enum.GetValues(typeof(enSystemTag)).Length; var res1 = obj.FetchAllEntries().Count; var res2 = obj.FetchScalarEntries().Count; var res3 = obj.FetchRecordsetEntries().Count; var res4 = cols.Count; Assert.AreEqual(3 + systemTagCount, res1); Assert.AreEqual(2 + systemTagCount, res2); Assert.AreEqual(1, res3); Assert.AreEqual(2, res4); } else { Assert.Fail("Error"); } }
public OptomizedObservableCollection<IDataListItem> CreateListToBindTo(IBinaryDataList dataList) { var result = new OptomizedObservableCollection<IDataListItem>(); if(dataList != null) { var listOfEntries = dataList.FetchScalarEntries(); // process scalars ;) foreach(var entry in listOfEntries .Where(e => ((e.ColumnIODirection == enDev2ColumnArgumentDirection.Input || e.ColumnIODirection == enDev2ColumnArgumentDirection.Both)))) { result.AddRange(ConvertIBinaryDataListEntryToIDataListItem(entry)); } // now process recordsets ;) listOfEntries = dataList.FetchRecordsetEntries(); foreach(var entry in listOfEntries) { result.AddRange(ConvertIBinaryDataListEntryToIDataListItem(entry)); } } return result; }
public void SerializeToXML_ValidXML_BlankXML_Expect_Blank_Values_Returned() { string error; ErrorResultTO errors; IDataListTranslator xmlConverter = Dls.GetTranslator(XmlFormat); byte[] data = (TestHelper.ConvertStringToByteArray("")); IBinaryDataList obj = xmlConverter.ConvertTo(data, _dataListWellformedDescAttributes, out errors); IList <IBinaryDataListEntry> scalars = obj.FetchScalarEntries(); IList <IBinaryDataListEntry> recordsets = obj.FetchRecordsetEntries(); IBinaryDataListItem item = scalars[0].FetchScalar(); IList <IBinaryDataListItem> items = recordsets[0].FetchRecordAt(1, out error); Assert.IsTrue(item != null && items != null); }
public void SerializeToXML_ValidXMLWithDescriptions_Return_Decriptions_Expect_Sucess() { ErrorResultTO errors; IDataListTranslator xmlConverter = Dls.GetTranslator(XmlFormat); byte[] data = (TestHelper.ConvertStringToByteArray(DataListWellformedDataWithDesc)); IBinaryDataList obj = xmlConverter.ConvertTo(data, _dataListWellformedDescAttributes, out errors); IList <IBinaryDataListEntry> scalars = obj.FetchScalarEntries(); IList <IBinaryDataListEntry> recordsets = obj.FetchRecordsetEntries(); var res1 = scalars[0].Description; var res2 = recordsets[0].Columns[0].ColumnDescription; Assert.AreEqual("Test scalar description", res1); Assert.AreEqual("Test field1 desciption", res2); }
public void UpsertWhereListStringExpectUpsertCorrectlyMultipleRecordset() { //------------Setup for test-------------------------- IDataListCompiler compiler = DataListFactory.CreateDataListCompiler(); IDev2DataListUpsertPayloadBuilder <List <string> > toUpsert = Dev2DataListBuilderFactory.CreateStringListDataListUpsertBuilder(); toUpsert.Add("[[rec().f1]]", new List <string> { "test11", "test12" }); toUpsert.Add("[[rec().f2]]", new List <string> { "test21", "test22" }); IBinaryDataList dataList = Dev2BinaryDataListFactory.CreateDataList(); string creationError; dataList.TryCreateRecordsetTemplate("rec", "recset", new List <Dev2Column> { DataListFactory.CreateDev2Column("f1", "f1"), DataListFactory.CreateDev2Column("f2", "f2") }, true, out creationError); ErrorResultTO localErrors; compiler.PushBinaryDataList(dataList.UID, dataList, out localErrors); //------------Execute Test--------------------------- compiler.Upsert(dataList.UID, toUpsert, out _errors); //------------Assert Results------------------------- IList <IBinaryDataListEntry> binaryDataListEntries = dataList.FetchRecordsetEntries(); IBinaryDataListEntry binaryDataListEntry = binaryDataListEntries[0]; string errString; IList <IBinaryDataListItem> binaryDataListItems = binaryDataListEntry.FetchRecordAt(1, out errString); IBinaryDataListItem binaryDataListItem = binaryDataListItems[0]; IBinaryDataListItem binaryDataListItem2 = binaryDataListItems[1]; string theValue = binaryDataListItem.TheValue; Assert.AreEqual("test11", theValue); theValue = binaryDataListItem2.TheValue; Assert.AreEqual("test21", theValue); binaryDataListItems = binaryDataListEntry.FetchRecordAt(2, out errString); binaryDataListItem = binaryDataListItems[0]; binaryDataListItem2 = binaryDataListItems[1]; theValue = binaryDataListItem.TheValue; Assert.AreEqual("test12", theValue); theValue = binaryDataListItem2.TheValue; Assert.AreEqual("test22", theValue); }
public void BaseConvertRecsetWithStarIndexToBinaryExpectedOutputToCorrectRecords() { SetupArguments( @"<root></root>" , ActivityStrings.BaseConvert_DLShape.Replace("<ADL>", "<ADL><setup/>") , new List <BaseConvertTO> { new BaseConvertTO("", "Text", "Binary", "[[setup]]", 1) } ); IDSFDataObject result = ExecuteProcess(); ErrorResultTO errorResult; IBinaryDataList bdl = Compiler.FetchBinaryDataList(result.DataListID, out errorResult); IBinaryDataListItem isolatedRecord = Dev2BinaryDataListFactory.CreateBinaryItem("CONVERT THIS TO BINARY", "Field"); string error; IBinaryDataListEntry entry; bdl.TryGetEntry("Recset", out entry, out error); entry.TryPutRecordItemAtIndex(isolatedRecord, 5, out error); IList <BaseConvertTO> convertCollection = new List <BaseConvertTO> { new BaseConvertTO("[[Recset(*).Field]]", "Text", "Binary", "[[Recset(*).Field]]", 1) }; TestStartNode = new FlowStep { Action = new DsfBaseConvertActivity { ConvertCollection = convertCollection } }; result = ExecuteProcess(); IList <IBinaryDataListEntry> actual = bdl.FetchRecordsetEntries(); var index = actual[0].FetchRecordAt(5, out error)[0].ItemCollectionIndex; var count = actual.Count(); var actualValue = actual[0].FetchRecordAt(5, out error)[0].TheValue; // remove test datalist ;) DataListRemoval(result.DataListID); Assert.AreEqual("01000011010011110100111001010110010001010101001001010100001000000101010001001000010010010101001100100000010101000100111100100000010000100100100101001110010000010101001001011001", actualValue); Assert.AreEqual(1, count); // still only one record Assert.AreEqual(5, index); // and that record has not moved }