public void TestThatDataSourceGetAddCandidateKeys()
{
var oldToNewMetadataRepository = new OldToNewMetadataRepository(RepositoryTestHelper.GetSourcePathForTest(), GetConfigurationValuesMock());
Assert.That(oldToNewMetadataRepository, Is.Not.Null);
var dataSource = oldToNewMetadataRepository.DataSourceGet();
Assert.That(dataSource, Is.Not.Null);
Assert.That(dataSource.Tables, Is.Not.Null);
var table = dataSource.Tables.Single(m => String.Compare(m.NameSource, "SAG", StringComparison.Ordinal) == 0);
Assert.That(table, Is.Not.Null);
Assert.That(table.CandidateKeys, Is.Not.Null);
Assert.That(table.CandidateKeys, Is.Not.Empty);
Assert.That(table.CandidateKeys.Count, Is.EqualTo(1));
Assert.That(table.CandidateKeys.ElementAt(0).NameSource, Is.Not.Null);
Assert.That(table.CandidateKeys.ElementAt(0).NameSource, Is.Not.Empty);
Assert.That(table.CandidateKeys.ElementAt(0).NameSource, Is.EqualTo("PK_SAG"));
Assert.That(table.CandidateKeys.ElementAt(0).NameTarget, Is.Not.Null);
Assert.That(table.CandidateKeys.ElementAt(0).NameTarget, Is.Not.Empty);
Assert.That(table.CandidateKeys.ElementAt(0).NameTarget, Is.EqualTo("PK_SAG"));
Assert.That(table.CandidateKeys.ElementAt(0).Description, Is.Not.Null);
Assert.That(table.CandidateKeys.ElementAt(0).Description, Is.Not.Empty);
Assert.That(table.CandidateKeys.ElementAt(0).Description, Is.EqualTo("Primær nøgle på SAG"));
}
public void TestThatDataSourceGetAddViews()
{
var oldToNewMetadataRepository = new OldToNewMetadataRepository(RepositoryTestHelper.GetSourcePathForTest(), GetConfigurationValuesMock());
Assert.That(oldToNewMetadataRepository, Is.Not.Null);
var dataSource = oldToNewMetadataRepository.DataSourceGet();
Assert.That(dataSource, Is.Not.Null);
Assert.That(dataSource.Views, Is.Not.Null);
Assert.That(dataSource.Views.Count, Is.EqualTo(1));
var view = dataSource.Views.First();
Assert.That(view.NameSource, Is.Not.Null);
Assert.That(view.NameSource, Is.Not.Empty);
Assert.That(view.NameSource, Is.EqualTo("AV_VIEW1"));
Assert.That(view.NameTarget, Is.Not.Null);
Assert.That(view.NameTarget, Is.Not.Empty);
Assert.That(view.NameTarget, Is.EqualTo("AV_VIEW1"));
Assert.That(view.Description, Is.Not.Null);
Assert.That(view.Description, Is.Not.Empty);
Assert.That(view.Description, Is.EqualTo("Søgning af dokumenter efter sagsnummer og datointerval"));
Assert.That(view.SqlQuery, Is.Not.Null);
Assert.That(view.SqlQuery, Is.Not.Empty);
Assert.That(view.SqlQuery, Is.EqualTo("CREATE TABLE f (snr VARCHAR(16), brevdatofra DATE, brevdatotil DATE) INSERT INTO f (snr, brevdatofra, brevdatotil) VALUES (,,) SELECT sag.sagsnr, sag.sagstitel, doktabel.dokumenttitel, doktabel.dato FROM sag, doktabel WHERE sag.sagsnr LIKE (SELECT snr FROM f)+'%' and doktabel.sagsid=sag.sagsid and doktabel.dato < (SELECT brevdatotil FROM f) and doktabel.dato > (SELECT brevdatofra FROM f) DROP TABLE f"));
}
public void TestThatDataSourceGetAreMappingCodedValues()
{
var oldToNewMetadataRepository = new OldToNewMetadataRepository(RepositoryTestHelper.GetSourcePathForTest(), GetConfigurationValuesMock());
Assert.That(oldToNewMetadataRepository, Is.Not.Null);
var dataSource = oldToNewMetadataRepository.DataSourceGet();
Assert.That(dataSource, Is.Not.Null);
Assert.That(dataSource.Tables, Is.Not.Null);
var table = dataSource.Tables.Single(m => String.Compare(m.NameSource, "SAGSBEH", StringComparison.Ordinal) == 0);
Assert.That(table, Is.Not.Null);
Assert.That(table.Fields, Is.Not.Null);
var field = table.Fields.Single(m => String.Compare(m.NameSource, "Kontor", StringComparison.Ordinal) == 0);
Assert.That(field, Is.Not.Null);
Assert.That(field.DatatypeOfSource, Is.Not.Null);
Assert.That(field.DatatypeOfSource, Is.EqualTo(typeof(int?)));
Assert.That(field.LengthOfSource, Is.EqualTo(2));
Assert.That(field.DatatypeOfTarget, Is.Not.Null);
Assert.That(field.DatatypeOfTarget, Is.EqualTo(typeof(string)));
Assert.That(field.LengthOfTarget, Is.EqualTo(9));
Assert.That(field.Map, Is.Not.Null);
Assert.That(field.Map, Is.TypeOf(typeof(StaticMap <int?, string>)));
}
public void TestThatDataSourceGetAddsFunctionalityToAField()
{
var oldToNewMetadataRepository = new OldToNewMetadataRepository(RepositoryTestHelper.GetSourcePathForTest(), GetConfigurationValuesMock());
Assert.That(oldToNewMetadataRepository, Is.Not.Null);
var dataSource = oldToNewMetadataRepository.DataSourceGet();
Assert.That(dataSource, Is.Not.Null);
Assert.That(dataSource.Tables, Is.Not.Null);
var table = dataSource.Tables.Single(m => String.Compare(m.NameSource, "SAG", StringComparison.Ordinal) == 0);
Assert.That(table, Is.Not.Null);
Assert.That(table.Fields, Is.Not.Null);
var field = table.Fields.Single(m => String.Compare(m.NameSource, "SagsID", StringComparison.Ordinal) == 0);
Assert.That(field, Is.Not.Null);
Assert.That(field.Functionality, Is.Not.Null);
Assert.That(field.Functionality.OfType <IMarkFunctionality>(), Is.Not.Null);
Assert.That(field.Functionality.OfType <IMarkFunctionality>().Count(), Is.EqualTo(1));
Assert.That(field.Functionality.OfType <IMarkFunctionality>().First(), Is.Not.Null);
Assert.That(field.Functionality.OfType <IMarkFunctionality>().First().Functionality, Is.Not.Null);
Assert.That(field.Functionality.OfType <IMarkFunctionality>().First().Functionality, Is.Not.Empty);
Assert.That(field.Functionality.OfType <IMarkFunctionality>().First().Functionality, Is.EqualTo("Sagsidentifikation"));
}
public void TestThatDataSourceGetAddContextDocuments()
{
var oldToNewMetadataRepository = new OldToNewMetadataRepository(RepositoryTestHelper.GetSourcePathForTest(), GetConfigurationValuesMock());
Assert.That(oldToNewMetadataRepository, Is.Not.Null);
var dataSource = oldToNewMetadataRepository.DataSourceGet();
Assert.That(dataSource, Is.Not.Null);
Assert.That(dataSource.ContextDocuments, Is.Not.Null);
Assert.That(dataSource.ContextDocuments.Count, Is.EqualTo(2));
var contextDocument = dataSource.ContextDocuments.First();
Assert.That(contextDocument.Id, Is.EqualTo(1));
Assert.That(contextDocument.NameSource, Is.Not.Null);
Assert.That(contextDocument.NameSource, Is.Not.Empty);
Assert.That(contextDocument.NameSource, Is.EqualTo("ER diagram"));
Assert.That(contextDocument.NameTarget, Is.Not.Null);
Assert.That(contextDocument.NameTarget, Is.Not.Empty);
Assert.That(contextDocument.NameTarget, Is.EqualTo("ER diagram"));
Assert.That(contextDocument.Description, Is.Null);
Assert.That(contextDocument.DocumentDate, Is.EqualTo(DateTime.Now).Within(3).Seconds);
Assert.That(contextDocument.DocumentDatePresicion, Is.EqualTo(DateTimePresicion.Month));
Assert.That(contextDocument.DocumentAuthors, Is.Not.Null);
Assert.That(contextDocument.DocumentAuthors.Count, Is.EqualTo(2));
Assert.That(contextDocument.Categories, Is.Not.Null);
Assert.That(contextDocument.Categories.Count, Is.EqualTo(2));
Assert.That(contextDocument.Categories.Contains(ContextDocumentCategories.ArchivalTransformationInformation), Is.True);
Assert.That(contextDocument.Categories.Contains(ContextDocumentCategories.InformationOther), Is.True);
Assert.That(contextDocument.Reference, Is.Not.Null);
Assert.That(contextDocument.Reference, Is.Not.Empty);
var directoryName = Path.GetDirectoryName(contextDocument.Reference);
Assert.That(directoryName, Is.Not.Null);
Assert.That(directoryName, Is.Not.Empty);
// ReSharper disable AssignNullToNotNullAttribute
var directoryInfo = new DirectoryInfo(directoryName);
// ReSharper restore AssignNullToNotNullAttribute
Assert.That(directoryInfo, Is.Not.Null);
Assert.That(directoryInfo.Exists, Is.True);
var searchPattern = Path.GetFileName(contextDocument.Reference);
Assert.That(searchPattern, Is.Not.Null);
Assert.That(searchPattern, Is.Not.Empty);
// ReSharper disable AssignNullToNotNullAttribute
var files = directoryInfo.GetFiles(searchPattern);
// ReSharper restore AssignNullToNotNullAttribute
Assert.That(files, Is.Not.Null);
Assert.That(files.Count(), Is.EqualTo(1));
}
public void TestThatDataSourceGetThrowsDeliveryEngineRepositoryExceptionIfArkverTabIsNotFound()
{
var oldToNewMetadataRepository = new OldToNewMetadataRepository(new DirectoryInfo(Environment.ExpandEnvironmentVariables("%Temp%")), MockRepository.GenerateMock <IConfigurationValues>());
Assert.That(oldToNewMetadataRepository, Is.Not.Null);
var exception = Assert.Throws <DeliveryEngineRepositoryException>(() => oldToNewMetadataRepository.DataSourceGet());
Assert.That(exception, Is.Not.Null);
Assert.That(exception.Message, Is.Not.Null);
Assert.That(exception.Message, Is.Not.Empty);
Assert.That(exception.Message, Is.StringContaining("'ARKVER.TAB'"));
}
/// <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 sourcePath = ConfigurationManager.AppSettings["SourcePath"];
if (string.IsNullOrEmpty(sourcePath))
{
throw new DeliveryEngineSystemException(Resource.GetExceptionMessage(ExceptionMessage.ApplicationSettingMissing, "SourcePath"));
}
var metadataRepository = new OldToNewMetadataRepository(new DirectoryInfo(Environment.ExpandEnvironmentVariables(sourcePath)), new ConfigurationValues());
container.Register(Component.For <IMetadataRepository>().Instance(metadataRepository).LifeStyle.PerThread);
}
public void Test()
{
IMetadataRepository metadataRepository = new OldToNewMetadataRepository(RepositoryTestHelper.GetSourcePathForOracleTest(), new ConfigurationValues());
IDataSource dataSource = metadataRepository.DataSourceGet();
foreach (IContextDocument contextDocument in dataSource.ContextDocuments)
{
Debug.WriteLine(contextDocument.NameTarget);
}
Debug.WriteLine(string.Empty);
Debug.WriteLine(string.Empty);
foreach (IView view in dataSource.Views)
{
Debug.WriteLine(view.Description);
Debug.WriteLine(view.SqlQuery);
Debug.WriteLine(string.Empty);
}
}
public void TestThatDataSourceGetGetsDataSource()
{
var oldToNewMetadataRepository = new OldToNewMetadataRepository(RepositoryTestHelper.GetSourcePathForOracleTest(), GetConfigurationValuesMock(new Fixture()));
Assert.That(oldToNewMetadataRepository, Is.Not.Null);
var dataSource = oldToNewMetadataRepository.DataSourceGet();
Assert.That(dataSource, Is.Not.Null);
Assert.That(dataSource.NameSource, Is.Not.Null);
Assert.That(dataSource.NameSource, Is.Not.Empty);
Assert.That(dataSource.NameSource, Is.EqualTo("Civil-, Straffe-, Foged-, Auktions- og Skiftesystem"));
Assert.That(dataSource.NameTarget, Is.Not.Null);
Assert.That(dataSource.NameTarget, Is.Not.Empty);
Assert.That(dataSource.NameTarget, Is.EqualTo("Civil-, Straffe-, Foged-, Auktions- og Skiftesystem"));
Assert.That(dataSource.Description, Is.Not.Null);
Assert.That(dataSource.Description, Is.Not.Empty);
Assert.That(dataSource.Description, Is.EqualTo("Civil-, Straffe-, Foged-, Auktions- og Skiftesystem"));
Assert.That(dataSource.ArchiveInformationPackageId, Is.Not.Empty);
Assert.That(dataSource.ArchiveInformationPackageId, Is.Not.Null);
Assert.That(dataSource.ArchiveInformationPackageId, Is.EqualTo("12549"));
Assert.That(dataSource.ArchiveInformationPackageIdPrevious, Is.EqualTo(10701));
Assert.That(dataSource.ArchivePeriodStart, Is.EqualTo(new DateTime(1994, 5, 24, 0, 0, 0)));
Assert.That(dataSource.ArchivePeriodEnd, Is.EqualTo(new DateTime(2009, 6, 30, 0, 0, 0)));
Assert.That(dataSource.Creators, Is.Not.Null);
Assert.That(dataSource.Creators.Count, Is.EqualTo(1));
Assert.That(dataSource.Creators.ElementAt(0).NameSource, Is.Not.Null);
Assert.That(dataSource.Creators.ElementAt(0).NameSource, Is.Not.Empty);
Assert.That(dataSource.Creators.ElementAt(0).NameSource, Is.EqualTo("Retten i Åbenrå (retskreds 43)"));
Assert.That(dataSource.Creators.ElementAt(0).NameTarget, Is.Not.Null);
Assert.That(dataSource.Creators.ElementAt(0).NameTarget, Is.Not.Empty);
Assert.That(dataSource.Creators.ElementAt(0).NameTarget, Is.EqualTo("Retten i Åbenrå (retskreds 43)"));
Assert.That(dataSource.Creators.ElementAt(0).Description, Is.Null);
Assert.That(dataSource.Creators.ElementAt(0).PeriodStart, Is.EqualTo(dataSource.ArchivePeriodStart));
Assert.That(dataSource.Creators.ElementAt(0).PeriodEnd, Is.EqualTo(dataSource.ArchivePeriodEnd));
Assert.That(dataSource.Tables, Is.Not.Null);
Assert.That(dataSource.Tables.Count, Is.EqualTo(54));
Assert.That(dataSource.ContextDocuments, Is.Not.Null);
Assert.That(dataSource.ContextDocuments.Count, Is.EqualTo(5));
}
public void TestThatDataSourceGetAddCreators()
{
var oldToNewMetadataRepository = new OldToNewMetadataRepository(RepositoryTestHelper.GetSourcePathForTest(), GetConfigurationValuesMock());
Assert.That(oldToNewMetadataRepository, Is.Not.Null);
var dataSource = oldToNewMetadataRepository.DataSourceGet();
Assert.That(dataSource, Is.Not.Null);
Assert.That(dataSource.Creators, Is.Not.Null);
Assert.That(dataSource.Creators.Count, Is.EqualTo(1));
var creator = dataSource.Creators.First();
Assert.That(creator.NameSource, Is.Not.Null);
Assert.That(creator.NameSource, Is.Not.Empty);
Assert.That(creator.NameSource, Is.EqualTo("Myndighed1"));
Assert.That(creator.NameTarget, Is.Not.Null);
Assert.That(creator.NameTarget, Is.Not.Empty);
Assert.That(creator.NameTarget, Is.EqualTo("Myndighed1"));
Assert.That(creator.Description, Is.Null);
Assert.That(creator.PeriodStart, Is.EqualTo(new DateTime(1996, 1, 1, 0, 0, 0)));
Assert.That(creator.PeriodEnd, Is.EqualTo(new DateTime(1998, 5, 31, 0, 0, 0)));
}
private IDeliveryEngine CreateSut(bool useDataValidators, IExceptionHandler exceptionHandler)
{
if (exceptionHandler == null)
{
throw new ArgumentNullException(nameof(exceptionHandler));
}
IContainer containerMock = MockRepository.GenerateMock <IContainer>();
IInformationLogger informationLoggerMock = MockRepository.GenerateMock <IInformationLogger>();
informationLoggerMock.Expect(m => m.LogInformation(Arg <string> .Is.NotNull))
.WhenCalled(e => Debug.WriteLine(e.Arguments.ElementAt(0)))
.Repeat.Any();
informationLoggerMock.Expect(m => m.LogWarning(Arg <string> .Is.NotNull))
.WhenCalled(e => Debug.WriteLine(e.Arguments.ElementAt(0)))
.Repeat.Any();
IConfigurationRepository configurationRepositoryMock = MockRepository.GenerateMock <IConfigurationRepository>();
IMetadataRepository metadataRepository = new OldToNewMetadataRepository(RepositoryTestHelper.GetSourcePathForOracleTest(), new ConfigurationValues());
containerMock.Expect(m => m.Resolve <IMetadataRepository>())
.Return(metadataRepository)
.Repeat.Any();
ICollection <IDataManipulator> dataManipulatorCollection;
using (var windsorContainer = new WindsorContainer())
{
windsorContainer.Register(Component.For <IContainer>().Instance(containerMock).LifeStyle.Transient);
windsorContainer.Register(Component.For <IInformationLogger>().Instance(informationLoggerMock).LifeStyle.Transient);
windsorContainer.Register(Component.For <IMetadataRepository>().Instance(metadataRepository).LifeStyle.Transient);
IConfigurationProvider dataManipulatorsConfigurationProvider = new DataManipulatorsConfigurationProvider();
dataManipulatorsConfigurationProvider.AddConfiguration(windsorContainer);
dataManipulatorCollection = windsorContainer.ResolveAll <IDataManipulator>();
windsorContainer.Dispose();
}
containerMock.Expect(m => m.ResolveAll <IDataManipulator>())
.Return(dataManipulatorCollection.ToArray())
.Repeat.Any();
IDataRepository dataRepository = new OracleDataRepository(new OracleClientFactory(), new DataManipulators(containerMock));
containerMock.Expect(m => m.Resolve <IDataRepository>())
.Return(dataRepository)
.Repeat.Any();
IDocumentRepository documentRepositoryMock = MockRepository.GenerateMock <IDocumentRepository>();
IArchiveVersionRepository archiveRepository = new ArchiveVersionRepository(new DirectoryInfo(ConfigurationManager.AppSettings["ArchivePath"]));
ICollection <IDataValidator> dataValidatorCollection = useDataValidators ? new Collection <IDataValidator> {
new PrimaryKeyDataValidator(dataRepository), new ForeignKeysDataValidator(dataRepository), new MappingDataValidator()
} : new Collection <IDataValidator>();
containerMock.Expect(m => m.ResolveAll <IDataValidator>())
.Return(dataValidatorCollection.ToArray())
.Repeat.Any();
IDataValidators dataValidators = new DataValidators(containerMock);
return(new DeliveryEngine.BusinessLogic.DeliveryEngine(configurationRepositoryMock, metadataRepository, dataRepository, documentRepositoryMock, dataValidators, archiveRepository, exceptionHandler));
}
public void TestThatConstructorInitializeOldToNewMetadataRepository()
{
var oldToNewMetadataRepository = new OldToNewMetadataRepository(RepositoryTestHelper.GetSourcePathForOracleTest(), MockRepository.GenerateMock <IConfigurationValues>());
Assert.That(oldToNewMetadataRepository, Is.Not.Null);
}
public void TestThatDataSourceGetGetsDataSource()
{
var configurationValuesMock = GetConfigurationValuesMock();
var oldToNewMetadataRepository = new OldToNewMetadataRepository(RepositoryTestHelper.GetSourcePathForTest(), configurationValuesMock);
Assert.That(oldToNewMetadataRepository, Is.Not.Null);
var dataSource = oldToNewMetadataRepository.DataSourceGet();
Assert.That(dataSource, Is.Not.Null);
Assert.That(dataSource.NameSource, Is.Not.Null);
Assert.That(dataSource.NameSource, Is.Not.Empty);
Assert.That(dataSource.NameSource, Is.EqualTo("DocSysPro"));
Assert.That(dataSource.NameTarget, Is.Not.Null);
Assert.That(dataSource.NameTarget, Is.Not.Empty);
Assert.That(dataSource.NameTarget, Is.EqualTo("DocSysPro"));
Assert.That(dataSource.Description, Is.Not.Null);
Assert.That(dataSource.Description, Is.Not.Empty);
Assert.That(dataSource.Description, Is.EqualTo("DocSysPro"));
Assert.That(dataSource.ArchiveInformationPackageId, Is.Not.Empty);
Assert.That(dataSource.ArchiveInformationPackageId, Is.Not.Null);
Assert.That(dataSource.ArchiveInformationPackageId, Is.EqualTo("40330"));
Assert.That(dataSource.ArchiveInformationPackageIdPrevious, Is.EqualTo(0));
Assert.That(dataSource.ArchivePeriodStart, Is.EqualTo(new DateTime(1996, 1, 1, 0, 0, 0)));
Assert.That(dataSource.ArchivePeriodEnd, Is.EqualTo(new DateTime(2000, 12, 31, 0, 0, 0)));
Assert.That(dataSource.ArchiveInformationPacketType, Is.EqualTo(configurationValuesMock.ArchiveInformationPacketType));
Assert.That(dataSource.ArchiveType, Is.True);
Assert.That(dataSource.AlternativeSystemNames, Is.Not.Null);
Assert.That(dataSource.AlternativeSystemNames.Count, Is.EqualTo(3));
Assert.That(dataSource.SystemPurpose, Is.Not.Null);
Assert.That(dataSource.SystemPurpose, Is.Not.Empty);
Assert.That(dataSource.SystemPurpose, Is.EqualTo(configurationValuesMock.SystemPurpose));
Assert.That(dataSource.SystemContent, Is.Not.Null);
Assert.That(dataSource.SystemContent, Is.Not.Empty);
Assert.That(dataSource.SystemContent, Is.EqualTo(configurationValuesMock.SystemContent));
Assert.That(dataSource.RegionNum, Is.EqualTo(configurationValuesMock.RegionNum));
Assert.That(dataSource.KomNum, Is.EqualTo(configurationValuesMock.KomNum));
Assert.That(dataSource.CprNum, Is.EqualTo(configurationValuesMock.CprNum));
Assert.That(dataSource.CvrNum, Is.EqualTo(configurationValuesMock.CvrNum));
Assert.That(dataSource.MatrikNum, Is.EqualTo(configurationValuesMock.MatrikNum));
Assert.That(dataSource.BbrNum, Is.EqualTo(configurationValuesMock.BbrNum));
Assert.That(dataSource.WhoSygKod, Is.EqualTo(configurationValuesMock.WhoSygKod));
Assert.That(dataSource.SourceNames, Is.Not.Null);
Assert.That(dataSource.SourceNames.Count, Is.EqualTo(3));
Assert.That(dataSource.UserNames, Is.Not.Null);
Assert.That(dataSource.UserNames.Count, Is.EqualTo(3));
Assert.That(dataSource.PredecessorNames, Is.Not.Null);
Assert.That(dataSource.PredecessorNames.Count, Is.EqualTo(3));
Assert.That(dataSource.FormVersion, Is.Not.Null);
Assert.That(dataSource.FormVersion, Is.Not.Empty);
Assert.That(dataSource.FormVersion, Is.EqualTo(configurationValuesMock.FormVersion));
Assert.That(dataSource.FormClasses, Is.Not.Null);
Assert.That(dataSource.FormClasses.Count, Is.EqualTo(3));
Assert.That(dataSource.ContainsDigitalDocuments, Is.EqualTo(configurationValuesMock.ContainsDigitalDocuments));
Assert.That(dataSource.SearchRelatedOtherRecords, Is.EqualTo(configurationValuesMock.SearchRelatedOtherRecords));
Assert.That(dataSource.RelatedRecordsNames, Is.Not.Null);
Assert.That(dataSource.RelatedRecordsNames.Count, Is.EqualTo(3));
Assert.That(dataSource.SystemFileConcept, Is.EqualTo(configurationValuesMock.SystemFileConcept));
Assert.That(dataSource.MultipleDataCollection, Is.EqualTo(configurationValuesMock.MultipleDataCollection));
Assert.That(dataSource.PersonalDataRestrictedInfo, Is.EqualTo(configurationValuesMock.PersonalDataRestrictedInfo));
Assert.That(dataSource.OtherAccessTypeRestrictions, Is.EqualTo(configurationValuesMock.OtherAccessTypeRestrictions));
Assert.That(dataSource.ArchiveApproval, Is.Not.Null);
Assert.That(dataSource.ArchiveApproval, Is.Not.Empty);
Assert.That(dataSource.ArchiveApproval, Is.EqualTo(configurationValuesMock.ArchiveApproval));
Assert.That(dataSource.ArchiveRestrictions, Is.Not.Null);
Assert.That(dataSource.ArchiveRestrictions, Is.Not.Empty);
Assert.That(dataSource.ArchiveRestrictions, Is.EqualTo(configurationValuesMock.ArchiveRestrictions));
Assert.That(dataSource.Tables, Is.Not.Null);
Assert.That(dataSource.Tables.Count(), Is.EqualTo(5));
foreach (var table in dataSource.Tables)
{
Assert.That(table, Is.Not.Null);
Assert.That(table.Fields, Is.Not.Null);
Assert.That(table.Fields.Count(), Is.GreaterThan(0));
Assert.That(table.CandidateKeys, Is.Not.Null);
Assert.That(table.CandidateKeys.Count(), Is.EqualTo(1));
Assert.That(table.ForeignKeys, Is.Not.Null);
Assert.That(table.ForeignKeys.Count(), Is.GreaterThanOrEqualTo(0));
}
Assert.That(dataSource.Views, Is.Not.Null);
Assert.That(dataSource.Views.Count, Is.EqualTo(1));
Assert.That(dataSource.Creators, Is.Not.Null);
Assert.That(dataSource.Creators.Count, Is.EqualTo(1));
Assert.That(dataSource.ContextDocuments, Is.Not.Null);
Assert.That(dataSource.ContextDocuments.Count, Is.EqualTo(2));
configurationValuesMock.AssertWasCalled(m => m.ArchiveInformationPacketType);
configurationValuesMock.AssertWasCalled(m => m.AlternativeSystemNames);
configurationValuesMock.AssertWasCalled(m => m.SystemPurpose);
configurationValuesMock.AssertWasCalled(m => m.SystemContent);
configurationValuesMock.AssertWasCalled(m => m.RegionNum);
configurationValuesMock.AssertWasCalled(m => m.KomNum);
configurationValuesMock.AssertWasCalled(m => m.CprNum);
configurationValuesMock.AssertWasCalled(m => m.CvrNum);
configurationValuesMock.AssertWasCalled(m => m.MatrikNum);
configurationValuesMock.AssertWasCalled(m => m.BbrNum);
configurationValuesMock.AssertWasCalled(m => m.WhoSygKod);
configurationValuesMock.AssertWasCalled(m => m.SourceNames);
configurationValuesMock.AssertWasCalled(m => m.UserNames);
configurationValuesMock.AssertWasCalled(m => m.PredecessorNames);
configurationValuesMock.AssertWasCalled(m => m.FormVersion);
configurationValuesMock.AssertWasCalled(m => m.FormClasses);
configurationValuesMock.AssertWasCalled(m => m.ContainsDigitalDocuments);
configurationValuesMock.AssertWasCalled(m => m.SearchRelatedOtherRecords);
configurationValuesMock.AssertWasCalled(m => m.RelatedRecordsNames);
configurationValuesMock.AssertWasCalled(m => m.SystemFileConcept);
configurationValuesMock.AssertWasCalled(m => m.MultipleDataCollection);
configurationValuesMock.AssertWasCalled(m => m.PersonalDataRestrictedInfo);
configurationValuesMock.AssertWasCalled(m => m.OtherAccessTypeRestrictions);
configurationValuesMock.AssertWasCalled(m => m.ArchiveApproval);
configurationValuesMock.AssertWasCalled(m => m.ArchiveRestrictions);
}
public void TestThatDataSourceGetAddForeignKeys()
{
var oldToNewMetadataRepository = new OldToNewMetadataRepository(RepositoryTestHelper.GetSourcePathForTest(), GetConfigurationValuesMock());
Assert.That(oldToNewMetadataRepository, Is.Not.Null);
var dataSource = oldToNewMetadataRepository.DataSourceGet();
Assert.That(dataSource, Is.Not.Null);
Assert.That(dataSource.Tables, Is.Not.Null);
var table = dataSource.Tables.Single(m => String.Compare(m.NameSource, "DOKTABEL", StringComparison.Ordinal) == 0);
Assert.That(table, Is.Not.Null);
Assert.That(table.ForeignKeys, Is.Not.Null);
var foreignKey = table.ForeignKeys.Single(m => String.Compare(m.NameSource, "FK_DOKTABEL_SAG", StringComparison.Ordinal) == 0);
Assert.That(foreignKey, Is.Not.Null);
Assert.That(foreignKey.NameSource, Is.Not.Null);
Assert.That(foreignKey.NameSource, Is.Not.Empty);
Assert.That(foreignKey.NameSource, Is.EqualTo("FK_DOKTABEL_SAG"));
Assert.That(foreignKey.NameTarget, Is.Not.Null);
Assert.That(foreignKey.NameTarget, Is.Not.Empty);
Assert.That(foreignKey.NameTarget, Is.EqualTo("FK_DOKTABEL_SAG"));
Assert.That(foreignKey.Description, Is.Not.Null);
Assert.That(foreignKey.Description, Is.Not.Empty);
Assert.That(foreignKey.Description, Is.EqualTo("Fremmednøgle fra DOKTABEL til SAG"));
Assert.That(foreignKey.Table, Is.Not.Null);
Assert.That(foreignKey.Table, Is.EqualTo(table));
Assert.That(foreignKey.CandidateKey, Is.Not.Null);
Assert.That(foreignKey.CandidateKey.NameSource, Is.Not.Null);
Assert.That(foreignKey.CandidateKey.NameSource, Is.Not.Empty);
Assert.That(foreignKey.CandidateKey.NameSource, Is.EqualTo("PK_SAG"));
Assert.That(foreignKey.CandidateKey.NameTarget, Is.Not.Null);
Assert.That(foreignKey.CandidateKey.NameTarget, Is.Not.Empty);
Assert.That(foreignKey.CandidateKey.NameTarget, Is.EqualTo("PK_SAG"));
Assert.That(foreignKey.CandidateKey.Description, Is.Not.Null);
Assert.That(foreignKey.CandidateKey.Description, Is.Not.Empty);
Assert.That(foreignKey.CandidateKey.Description, Is.EqualTo("Primær nøgle på SAG"));
Assert.That(foreignKey.CandidateKey.Table, Is.Not.Null);
Assert.That(foreignKey.CandidateKey.Table.NameSource, Is.Not.Null);
Assert.That(foreignKey.CandidateKey.Table.NameSource, Is.Not.Empty);
Assert.That(foreignKey.CandidateKey.Table.NameSource, Is.EqualTo("SAG"));
Assert.That(foreignKey.CandidateKey.Table.NameTarget, Is.Not.Null);
Assert.That(foreignKey.CandidateKey.Table.NameTarget, Is.Not.Empty);
Assert.That(foreignKey.CandidateKey.Table.NameTarget, Is.EqualTo("SAG"));
Assert.That(foreignKey.CandidateKey.Fields, Is.Not.Null);
Assert.That(foreignKey.CandidateKey.Fields.Count, Is.EqualTo(1));
Assert.That(foreignKey.CandidateKey.Fields[0].Key, Is.Not.Null);
Assert.That(foreignKey.CandidateKey.Fields[0].Key.NameSource, Is.Not.Null);
Assert.That(foreignKey.CandidateKey.Fields[0].Key.NameSource, Is.Not.Empty);
Assert.That(foreignKey.CandidateKey.Fields[0].Key.NameSource, Is.EqualTo("SagsID"));
Assert.That(foreignKey.Fields, Is.Not.Null);
Assert.That(foreignKey.Fields.Count, Is.EqualTo(1));
Assert.That(foreignKey.Fields[0].Key, Is.Not.Null);
Assert.That(foreignKey.Fields[0].Key.NameSource, Is.Not.Null);
Assert.That(foreignKey.Fields[0].Key.NameSource, Is.Not.Empty);
Assert.That(foreignKey.Fields[0].Key.NameSource, Is.EqualTo("SagsID"));
Assert.That(foreignKey.Fields[0].Value, Is.Not.Null);
Assert.That(foreignKey.Fields[0].Value, Is.TypeOf(typeof(StaticMap <int?, int?>)));
Assert.That(foreignKey.Cardinality, Is.EqualTo(Cardinality.ManyToOne));
}
public void TestThatDataRepositoryGetsDataFromOracle()
{
var containerMock = MockRepository.GenerateMock <IContainer>();
var informationLoggerMock = MockRepository.GenerateMock <IInformationLogger>();
informationLoggerMock.Expect(m => m.LogInformation(Arg <string> .Is.NotNull))
.WhenCalled(e => Debug.WriteLine(e.Arguments[0]))
.Repeat.Any();
var metadataRepository = new OldToNewMetadataRepository(RepositoryTestHelper.GetSourcePathForOracleTest(), new ConfigurationValues());
Assert.That(metadataRepository, Is.Not.Null);
ICollection <IDataManipulator> dataMainpulatorCollection;
using (var windsorContainer = new WindsorContainer())
{
windsorContainer.Register(Component.For <IContainer>().Instance(containerMock).LifeStyle.Transient);
windsorContainer.Register(Component.For <IInformationLogger>().Instance(informationLoggerMock).LifeStyle.Transient);
windsorContainer.Register(Component.For <IMetadataRepository>().Instance(metadataRepository).LifeStyle.Transient);
var dataManipulatorsConfigurationProvider = new DataManipulatorsConfigurationProvider();
dataManipulatorsConfigurationProvider.AddConfiguration(windsorContainer);
dataMainpulatorCollection = windsorContainer.ResolveAll <IDataManipulator>();
windsorContainer.Dispose();
}
containerMock.Expect(m => m.ResolveAll <IDataManipulator>())
.Return(dataMainpulatorCollection.ToArray())
.Repeat.Any();
var oracleClientFactory = new OracleClientFactory();
Assert.That(oracleClientFactory, Is.Not.Null);
var dataManipulators = new DataManipulators(containerMock);
Assert.That(dataManipulators, Is.Not.Null);
Assert.That(dataManipulators, Is.Not.Empty);
var dataRepository = new OracleDataRepository(oracleClientFactory, dataManipulators);
Assert.That(dataRepository, Is.Not.Null);
containerMock.Expect(m => m.Resolve <IDataRepository>())
.Return(dataRepository)
.Repeat.Any();
var startTime = DateTime.MinValue;
var numberOfRecords = 0;
dataRepository.OnHandleData += (s, e) =>
{
Assert.That(s, Is.Not.Null);
Assert.That(e, Is.Not.Null);
Assert.That(e.Table, Is.Not.Null);
Assert.That(e.Data, Is.Not.Null);
numberOfRecords += e.Data.Count();
if (e.EndOfData)
{
// ReSharper disable AccessToModifiedClosure
Debug.WriteLine("{0} has been selected for the table named {1} in {2}", numberOfRecords, e.Table.NameTarget, new TimeSpan(DateTime.Now.Ticks - startTime.Ticks));
// ReSharper restore AccessToModifiedClosure
numberOfRecords = 0;
}
};
var dataSource = metadataRepository.DataSourceGet();
Assert.That(dataSource, Is.Not.Null);
Assert.That(dataSource.Tables, Is.Not.Null);
Assert.That(dataSource.Tables, Is.Not.Empty);
foreach (var table in dataSource.Tables)
{
startTime = DateTime.Now;
dataRepository.DataGetFromTable(table);
}
}
