public void TestThatManipulateDataReturnsWithoutManipulatingDataIfTableSourceNameDoesNotMatchTableNameInTheConstructor() { var fixture = new Fixture(); fixture.Customize <Type>(e => e.FromFactory(() => typeof(int))); fixture.Customize <IMap>(e => e.FromFactory(() => MockRepository.GenerateMock <IMap>())); fixture.Customize <IField>(e => e.FromFactory(() => { var fieldMock = MockRepository.GenerateMock <IField>(); fieldMock.Expect(m => m.NameSource) .Return(fixture.CreateAnonymous <string>()) .Repeat.Any(); return(fieldMock); })); var tableMock = MockRepository.GenerateMock <ITable>(); tableMock.Expect(m => m.NameSource) .Return(fixture.CreateAnonymous <string>()) .Repeat.Any(); tableMock.Expect(m => m.Fields) .Return(new ReadOnlyObservableCollection <IField>(new ObservableCollection <IField>(fixture.CreateMany <IField>(5).ToList()))) .Repeat.Any(); fixture.Customize <ITable>(e => e.FromFactory(() => tableMock)); var fieldUpdatesMock = new Collection <Tuple <string, object> > { new Tuple <string, object>(tableMock.Fields.ElementAt(0).NameSource, fixture.CreateAnonymous <int>()), new Tuple <string, object>(tableMock.Fields.ElementAt(1).NameSource, fixture.CreateAnonymous <int>()) }; var dataCollectionMock = new Collection <IEnumerable <IDataObjectBase> >(); while (dataCollectionMock.Count < 250) { var dataObjects = new Collection <IDataObjectBase>(); for (var i = 0; i < tableMock.Fields.Count; i++) { dataObjects.Add(MockRepository.GenerateMock <IFieldData <int, int> >()); } dataCollectionMock.Add(dataObjects); } var rowDuplicator = new RowDuplicator(fixture.CreateAnonymous <string>(), fieldUpdatesMock); Assert.That(rowDuplicator, Is.Not.Null); var manipulatedData = rowDuplicator.ManipulateData(fixture.CreateAnonymous <ITable>(), dataCollectionMock); Assert.That(manipulatedData, Is.Not.Null); Assert.That(manipulatedData, Is.Not.Empty); Assert.That(manipulatedData.Count(), Is.EqualTo(dataCollectionMock.Count)); }
public void TestThatIsManipulatingFieldReturnsFalseIfDataManipulatorIsNotManipulatingFieldName() { var fixture = new Fixture(); fixture.Customize <Tuple <string, object> >(e => e.FromFactory(() => new Tuple <string, object>(fixture.CreateAnonymous <string>(), fixture.CreateAnonymous <int>()))); fixture.Customize <Tuple <Type, string, object> >(e => e.FromFactory(() => new Tuple <Type, string, object>(typeof(EqualCriteria <>), fixture.CreateAnonymous <string>(), fixture.CreateAnonymous <int>()))); var fieldUpdates = fixture.CreateMany <Tuple <string, object> >(5).ToList(); var rowDuplicator = new RowDuplicator(fixture.CreateAnonymous <string>(), fieldUpdates); Assert.That(rowDuplicator, Is.Not.Null); Assert.That(rowDuplicator.IsManipulatingField(fixture.CreateAnonymous <string>()), Is.False); }
public void TestThatConstructorInitializeRowDuplicatorWithoutCriteriaConfigurations() { var fixture = new Fixture(); fixture.Customize <Tuple <string, object> >(e => e.FromFactory(() => new Tuple <string, object>(fixture.CreateAnonymous <string>(), fixture.CreateAnonymous <int>()))); var tableName = fixture.CreateAnonymous <string>(); var fieldUpdates = fixture.CreateMany <Tuple <string, object> >(5).ToList(); var rowDuplicator = new RowDuplicator(tableName, fieldUpdates); Assert.That(rowDuplicator, Is.Not.Null); Assert.That(rowDuplicator.TableName, Is.Not.Null); Assert.That(rowDuplicator.TableName, Is.Not.Empty); Assert.That(rowDuplicator.TableName, Is.EqualTo(tableName)); Assert.That(rowDuplicator.FieldUpdates, Is.Not.Null); Assert.That(rowDuplicator.FieldUpdates, Is.Not.Empty); Assert.That(rowDuplicator.FieldUpdates, Is.EqualTo(fieldUpdates)); Assert.That(rowDuplicator.CriteriaConfigurations, Is.Not.Null); Assert.That(rowDuplicator.CriteriaConfigurations, Is.Empty); }
public void TestThatManipulateDataDuplicatesRowsUsingIntervalCriteria() { var fixture = new Fixture(); fixture.Customize <Type>(e => e.FromFactory(() => typeof(int))); fixture.Customize <IMap>(e => e.FromFactory(() => MockRepository.GenerateMock <IMap>())); fixture.Customize <IField>(e => e.FromFactory(() => { var fieldMock = MockRepository.GenerateMock <IField>(); fieldMock.Expect(m => m.NameSource) .Return(fixture.CreateAnonymous <string>()) .Repeat.Any(); fieldMock.Expect(m => m.DatatypeOfSource) .Return(typeof(int)) .Repeat.Any(); return(fieldMock); })); var tableMock = MockRepository.GenerateMock <ITable>(); tableMock.Expect(m => m.NameSource) .Return(fixture.CreateAnonymous <string>()) .Repeat.Any(); tableMock.Expect(m => m.Fields) .Return(new ReadOnlyObservableCollection <IField>(new ObservableCollection <IField>(fixture.CreateMany <IField>(5).ToList()))) .Repeat.Any(); fixture.Customize <ITable>(e => e.FromFactory(() => tableMock)); var fieldUpdatesMock = new Collection <Tuple <string, object> > { new Tuple <string, object>(tableMock.Fields.ElementAt(0).NameSource, fixture.CreateAnonymous <int>()), new Tuple <string, object>(tableMock.Fields.ElementAt(1).NameSource, fixture.CreateAnonymous <int>()) }; var criteriaConfigurationsMock = new Collection <Tuple <Type, string, object> > { new Tuple <Type, string, object>(typeof(IntervalCriteria <>), tableMock.Fields.ElementAt(0).NameSource, new Tuple <string, string>("1", "3")) }; var dataCollectionMock = new Collection <IEnumerable <IDataObjectBase> >(); while (dataCollectionMock.Count < 250) { var dataObjects = new Collection <IDataObjectBase>(); for (var i = 0; i < tableMock.Fields.Count; i++) { var clonedDataObjectMock = MockRepository.GenerateMock <IFieldData <int, int> >(); clonedDataObjectMock.Expect(m => m.Field) .Return(tableMock.Fields.ElementAt(i)) .Repeat.Any(); var dataObjectMock = MockRepository.GenerateMock <IFieldData <int, int> >(); dataObjectMock.Expect(m => m.Field) .Return(tableMock.Fields.ElementAt(i)) .Repeat.Any(); dataObjectMock.Expect(m => m.SourceValue) .Return(i == 0 ? dataCollectionMock.Count % 4 : fixture.CreateAnonymous <int>()) .Repeat.Any(); dataObjectMock.Expect(m => m.GetSourceValue <int>()) .Return(dataObjectMock.SourceValue) .Repeat.Any(); dataObjectMock.Expect(m => m.Clone()) .Return(clonedDataObjectMock) .Repeat.Any(); dataObjects.Add(dataObjectMock); } dataCollectionMock.Add(dataObjects); } var rowDuplicator = new RowDuplicator(tableMock.NameSource, fieldUpdatesMock, criteriaConfigurationsMock); Assert.That(rowDuplicator, Is.Not.Null); var rowsToDuplicate = dataCollectionMock.Count(m => m.ElementAt(0).GetSourceValue <int>() > 0); var manipulatedData = rowDuplicator.ManipulateData(fixture.CreateAnonymous <ITable>(), dataCollectionMock).ToList(); Assert.That(manipulatedData, Is.Not.Null); Assert.That(manipulatedData, Is.Not.Empty); Assert.That(manipulatedData.Count, Is.EqualTo(250 + rowsToDuplicate)); for (var manipulatedDataRowNo = 0; manipulatedDataRowNo < manipulatedData.Count; manipulatedDataRowNo++) { if (manipulatedDataRowNo < dataCollectionMock.Count) { if (manipulatedData.ElementAt(manipulatedDataRowNo).ElementAt(0).GetSourceValue <int>() > 0) { foreach (var dataObject in manipulatedData.ElementAt(manipulatedDataRowNo)) { dataObject.AssertWasCalled(m => m.Clone()); } } continue; } manipulatedData.ElementAt(manipulatedDataRowNo).ElementAt(0).AssertWasCalled(m => m.UpdateSourceValue(Arg <int> .Is.Equal(fieldUpdatesMock.ElementAt(0).Item2))); manipulatedData.ElementAt(manipulatedDataRowNo).ElementAt(1).AssertWasCalled(m => m.UpdateSourceValue(Arg <int> .Is.Equal(fieldUpdatesMock.ElementAt(1).Item2))); } }
/// <summary> /// Adding configuration to the container for Inversion of Control. /// </summary> /// <param name="container">Container for Inversion of Control.</param> public void AddConfiguration(IWindsorContainer container) { var dataManipulatorsFileName = ConfigurationManager.AppSettings["DataManipulatorsFileName"]; if (dataManipulatorsFileName == null) { throw new DeliveryEngineSystemException(Resource.GetExceptionMessage(ExceptionMessage.ApplicationSettingMissing, "DataManipulatorsFileName")); } dataManipulatorsFileName = Environment.ExpandEnvironmentVariables(dataManipulatorsFileName); if (string.IsNullOrEmpty(dataManipulatorsFileName)) { container.Register(Component.For <IDataManipulators>().ImplementedBy <DataManipulators>().LifeStyle.Transient); return; } if (!File.Exists(dataManipulatorsFileName)) { throw new DeliveryEngineSystemException(Resource.GetExceptionMessage(ExceptionMessage.FileNotFound, dataManipulatorsFileName)); } var assembly = typeof(DataManipulators).Assembly; using (var resourceStream = assembly.GetManifestResourceStream(string.Format("{0}.Schemas.DataManipulators.xsd", assembly.GetName().Name))) { if (resourceStream == null) { throw new DeliveryEngineSystemException(Resource.GetExceptionMessage(ExceptionMessage.ResourceNotFound, string.Format("{0}.Schemas.DataManipulators.xsd", assembly.GetName().Name))); } var schema = XmlSchema.Read(resourceStream, ValidationEventHandler); var readerSettings = new XmlReaderSettings { IgnoreComments = true, IgnoreProcessingInstructions = true, IgnoreWhitespace = true, ValidationFlags = XmlSchemaValidationFlags.ReportValidationWarnings, ValidationType = ValidationType.Schema }; readerSettings.Schemas.Add(schema); readerSettings.ValidationEventHandler += ValidationEventHandler; var reader = XmlReader.Create(dataManipulatorsFileName, readerSettings); try { var document = new XmlDocument(); document.Load(reader); var namespaceManager = new XmlNamespaceManager(document.NameTable); namespaceManager.AddNamespace("ns", schema.TargetNamespace); var dataSetterNodeList = document.SelectNodes("/ns:DataManipulators/ns:DataSetter", namespaceManager); if (dataSetterNodeList != null && dataSetterNodeList.Count > 0) { var dataSetterNo = 0; foreach (XmlNode dataSetterNode in dataSetterNodeList) { var criteriaConfigurations = GenerateCriteriaConfigurations(dataSetterNode.SelectNodes("ns:EqualCriteria | ns:PoolCriteria | ns:IntervalCriteria", namespaceManager)); // ReSharper disable PossibleNullReferenceException var dataSetter = new DataSetter(dataSetterNode.Attributes["table"].Value, dataSetterNode.SelectSingleNode("ns:Field", namespaceManager).Attributes["name"].Value, dataSetterNode.SelectSingleNode("ns:Field", namespaceManager).Attributes["value"].Value, criteriaConfigurations); // ReSharper restore PossibleNullReferenceException container.Register(Component.For <IDataSetter>().Named(string.Format("{0}[{1}]", typeof(IDataSetter).Name, dataSetterNo++)).Instance(dataSetter).LifeStyle.Transient); } } var regularExpressionReplacerNodeList = document.SelectNodes("/ns:DataManipulators/ns:RegularExpressionReplacer", namespaceManager); if (regularExpressionReplacerNodeList != null && regularExpressionReplacerNodeList.Count > 0) { var regularExpressionReplacerNo = 0; foreach (XmlNode regularExpressionReplacerNode in regularExpressionReplacerNodeList) { var fieldNode = regularExpressionReplacerNode.SelectSingleNode("ns:Field", namespaceManager); // ReSharper disable PossibleNullReferenceException var regularExpression = new Regex(fieldNode.Attributes["regularExpression"].Value, RegexOptions.Compiled); var newFieldValue = fieldNode.Attributes["value"].Value; var regularExpressionReplacer = new RegularExpressionReplacer(regularExpressionReplacerNode.Attributes["table"].Value, regularExpression, (RegularExpressionApplyOn)Enum.Parse(typeof(RegularExpressionApplyOn), fieldNode.Attributes["applyOn"].Value), fieldNode.Attributes["name"].Value, Equals(newFieldValue, "{null}") ? null : newFieldValue); // ReSharper restore PossibleNullReferenceException container.Register(Component.For <IRegularExpressionReplacer>().Named(string.Format("{0}[{1}]", typeof(IRegularExpressionReplacer).Name, regularExpressionReplacerNo++)).Instance(regularExpressionReplacer).LifeStyle.Transient); } } var rowDuplicatorNodeList = document.SelectNodes("/ns:DataManipulators/ns:RowDuplicator", namespaceManager); if (rowDuplicatorNodeList != null && rowDuplicatorNodeList.Count > 0) { var rowDuplicatorNo = 0; foreach (XmlNode rowDuplicatorNode in rowDuplicatorNodeList) { var criteriaConfigurations = GenerateCriteriaConfigurations(rowDuplicatorNode.SelectNodes("ns:EqualCriteria | ns:PoolCriteria | ns:IntervalCriteria", namespaceManager)); var fieldUpdates = new Collection <Tuple <string, object> >(); var fieldNodeList = rowDuplicatorNode.SelectNodes("ns:Field", namespaceManager); if (fieldNodeList != null && fieldNodeList.Count > 0) { foreach (XmlNode fieldNode in fieldNodeList) { // ReSharper disable PossibleNullReferenceException fieldUpdates.Add(new Tuple <string, object>(fieldNode.Attributes["name"].Value, fieldNode.Attributes["value"].Value)); // ReSharper restore PossibleNullReferenceException } } // ReSharper disable PossibleNullReferenceException var rowDuplicator = new RowDuplicator(rowDuplicatorNode.Attributes["table"].Value, fieldUpdates, criteriaConfigurations); // ReSharper restore PossibleNullReferenceException container.Register(Component.For <IRowDuplicator>().Named(string.Format("{0}[{1}]", typeof(IRowDuplicator).Name, rowDuplicatorNo++)).Instance(rowDuplicator).LifeStyle.Transient); } } var missingForeignKeyHandlerNodeList = document.SelectNodes("ns:DataManipulators/ns:MissingForeignKeyHandler", namespaceManager); if (missingForeignKeyHandlerNodeList != null && missingForeignKeyHandlerNodeList.Count > 0) { var missingForeignKeyHandlerNo = 0; foreach (XmlNode missingForeignKeyHandlerNode in missingForeignKeyHandlerNodeList) { var workerNode = missingForeignKeyHandlerNode.SelectSingleNode("ns:PrimaryKeyAdder | ns:ForeignKeyCleaner | ns:ForeignKeyDeleter", namespaceManager); if (workerNode == null) { continue; } var foreignKeyFields = new List <string>(); var foreignKeyFieldNodeList = workerNode.SelectNodes("ns:ForeignKey", namespaceManager); if (foreignKeyFieldNodeList != null && foreignKeyFieldNodeList.Count > 0) { // ReSharper disable PossibleNullReferenceException foreignKeyFields.AddRange(from XmlNode foreignKeyFieldNode in foreignKeyFieldNodeList select foreignKeyFieldNode.Attributes["field"].Value); // ReSharper restore PossibleNullReferenceException } IMissingForeignKeyWorker worker = null; switch (workerNode.LocalName) { case "PrimaryKeyAdder": var setFieldValues = new Dictionary <string, object>(); var setFieldValueNodeList = workerNode.SelectNodes("ns:SetValue", namespaceManager); if (setFieldValueNodeList != null && setFieldValueNodeList.Count > 0) { foreach (XmlNode setFieldValueNode in setFieldValueNodeList) { // ReSharper disable PossibleNullReferenceException setFieldValues.Add(setFieldValueNode.Attributes["field"].Value, setFieldValueNode.Attributes["value"].Value); // ReSharper restore PossibleNullReferenceException } } try { // ReSharper disable PossibleNullReferenceException worker = new PrimaryKeyAdder(workerNode.Attributes["targetTable"].Value, foreignKeyFields, setFieldValues, container.Resolve <IMetadataRepository>(), container.Resolve <IInformationLogger>()); // ReSharper restore PossibleNullReferenceException } catch (DeliveryEngineSystemException) { continue; } break; case "ForeignKeyCleaner": try { // ReSharper disable PossibleNullReferenceException worker = new ForeignKeyCleaner(workerNode.Attributes["targetTable"].Value, foreignKeyFields, container.Resolve <IMetadataRepository>(), container.Resolve <IInformationLogger>()); // ReSharper restore PossibleNullReferenceException } catch (DeliveryEngineSystemException) { continue; } break; case "ForeignKeyDeleter": try { // ReSharper disable PossibleNullReferenceException worker = new ForeignKeyDeleter(workerNode.Attributes["targetTable"].Value, foreignKeyFields, container.Resolve <IMetadataRepository>(), container.Resolve <IInformationLogger>()); // ReSharper restore PossibleNullReferenceException } catch (DeliveryEngineSystemException) { continue; } break; } // ReSharper disable PossibleNullReferenceException var missingForeignKeHandler = new MissingForeignKeyHandler(missingForeignKeyHandlerNode.Attributes["table"].Value, worker, container.Resolve <IContainer>()); // ReSharper restore PossibleNullReferenceException container.Register(Component.For <IMissingForeignKeyHandler>().Named(string.Format("{0}[{1}]", typeof(IMissingForeignKeyHandler).Name, missingForeignKeyHandlerNo++)).Instance(missingForeignKeHandler).LifeStyle.Transient); } } } finally { reader.Close(); } resourceStream.Close(); } container.Register(Component.For <IDataManipulators>().ImplementedBy <DataManipulators>().LifeStyle.Transient); }