public void EtlRunInfo() { var sourceModel = new TestModel(); sourceModel.GetTable("Secondary", "Pet").EtlRunInfoDisabled(); var targetModel = DwhDataDefinitionToRelationalModelConverter.Convert(sourceModel, "dbo"); Assert.AreEqual(2, targetModel.Schemas.Count); Assert.AreEqual(1, targetModel["dbo"].Tables.Count); Assert.AreEqual(1, targetModel["secondary"].Tables.Count); Assert.AreEqual(3, targetModel["dbo"]["people"].Columns.Count); Assert.AreEqual(3, targetModel["secondary"]["PeT"].Columns.Count); Assert.AreEqual(1, targetModel["dbo"]["PEOPLE"].PrimaryKeyColumns.Count); Assert.AreEqual(1, targetModel["secondarY"]["pet"].PrimaryKeyColumns.Count); Assert.AreEqual(1, targetModel["dbo"]["PEOPLE"].ForeignKeys.Count); Assert.AreEqual(1, targetModel["SECONDARY"]["pet"].ForeignKeys.Count); Assert.IsFalse(targetModel["dbo"]["people"].GetEtlRunInfoDisabled()); Assert.IsTrue(targetModel["secondary"]["PeT"].GetEtlRunInfoDisabled()); Assert.IsTrue(targetModel["dbo"]["people"].GetHasHistoryTable()); Assert.IsFalse(targetModel["secondary"]["PeT"].GetHasHistoryTable()); Assert.IsFalse(targetModel["dbo"]["people"]["id"].GetHistoryDisabled()); Assert.IsTrue(targetModel["dbo"]["people"]["name"].GetHistoryDisabled()); Assert.IsTrue(targetModel["dbo"]["people"]["id"].GetRecordTimestampIndicator()); Assert.IsFalse(targetModel["dbo"]["people"]["name"].GetRecordTimestampIndicator()); Assert.IsNull(targetModel["dbo"]["people"].GetSourceTableNameOverride()); Assert.AreEqual("animal", targetModel["secondary"]["pet"].GetSourceTableNameOverride()); }
public override void Execute() { DatabaseDeclaration.GetTable("dbo", "Company").HasHistoryTable(); var configuration = new DwhBuilderConfiguration(); var model = DwhDataDefinitionToRelationalModelConverter.Convert(DatabaseDeclaration, "dbo"); DataDefinitionExtenderMsSql2016.Extend(DatabaseDeclaration, configuration); RelationalModelExtender.Extend(model, configuration); CreateDatabase(DatabaseDeclaration); Init(configuration, model); Update(configuration, model); }