public void GenerateCustomTableNameFromJsonUsingRegexRenaming() { //Arrange var expected = "NewTableName"; var exampleOption = new List <Schema> { new Schema { SchemaName = "dbo", TableRegexPattern = "^Old", TablePatternReplaceWith = "New" } }; var sut = new ReplacingCandidateNamingService(exampleOption); var exampleDbTable = new DatabaseTable { Name = "OldTableName", Schema = "dbo" }; // Act var result = sut.GenerateCandidateIdentifier(exampleDbTable); //Assert StringAssert.Contains(expected, result); }
public void GenerateCustomColumnNameFromJsonUsingRegexRenaming() { //Arrange var exampleColumn = new DatabaseColumn { Name = "OldColumnName", Table = new DatabaseTable { Name = "table_name", Schema = "dbo" } }; var expected = "NewColumnName"; var exampleOption = new List <Schema> { new Schema { SchemaName = "dbo", UseSchemaName = true, ColumnRegexPattern = "^Old", ColumnPatternReplaceWith = "New" } }; var sut = new ReplacingCandidateNamingService(exampleOption); //Act var actResult = sut.GenerateCandidateIdentifier(exampleColumn); //Assert StringAssert.Contains(expected, actResult); }
public void GeneratePascalCaseTableNameWithSchemaNameWithMoreThanTwoSchemas() { //Arrange var expected = "MachineAlertUi"; var exampleOption = new List <Schema> { new Schema { SchemaName = "machine", UseSchemaName = true }, new Schema { SchemaName = "master", UseSchemaName = true } }; var sut = new ReplacingCandidateNamingService(exampleOption); var exampleDbTable = new DatabaseTable { Name = "alert_ui", Schema = "machine" }; // Act var result = sut.GenerateCandidateIdentifier(exampleDbTable); //Assert StringAssert.Contains(expected, result); }
public void GenerateCustomTableNameFromJson() { //Arrange var expected = "new_name_of_the_table"; var exampleOption = new List <Schema> { new Schema { SchemaName = "machine", Tables = new List <TableRenamer> { new TableRenamer { NewName = "new_name_of_the_table", Name = "OldTableName", } } } }; var sut = new ReplacingCandidateNamingService(exampleOption); var exampleDbTable = new DatabaseTable { Name = "OldTableName", Schema = "machine" }; // Act var result = sut.GenerateCandidateIdentifier(exampleDbTable); //Assert StringAssert.Contains(expected, result); }
public void GeneratePascalCaseTableNameWithSchemaName_Issue988() { //Arrange var expected = "PetGuineaPig"; var exampleOption = new List <Schema> { new Schema { SchemaName = "pet", UseSchemaName = true, Tables = new List <TableRenamer> { new TableRenamer { Name = "GUINEAPig", NewName = "GuineaPig", }, }, }, }; var sut = new ReplacingCandidateNamingService(exampleOption); var exampleDbTable = new DatabaseTable { Name = "GUINEAPig", Schema = "pet" }; // Act var result = sut.GenerateCandidateIdentifier(exampleDbTable); //Assert StringAssert.Contains(expected, result); }
public void Issue_354() { // Arrange var exampleOption = new List <Schema> { new Schema { SchemaName = "stg", UseSchemaName = false, Tables = new List <TableRenamer> { new TableRenamer { Name = "Jobs", NewName = "stg_Jobs", Columns = new List <ColumnNamer> { new ColumnNamer { Name = "JobName", NewName = "JobRename", }, }, }, new TableRenamer { Name = "DeliveryAddress", NewName = "stg_DeliveryAddress" }, }, }, }; var sut = new ReplacingCandidateNamingService(exampleOption); var exampleDbTables = new List <DatabaseTable> { new DatabaseTable { Name = "DeliveryAddress", Schema = "stg", }, new DatabaseTable { Name = "Jobs", Schema = "stg", }, }; // Act var results = new List <string>(); foreach (var table in exampleDbTables) { results.Add(sut.GenerateCandidateIdentifier(table)); } // Assert StringAssert.AreEqualIgnoringCase("stg_Jobs", results[1]); StringAssert.AreEqualIgnoringCase("stg_DeliveryAddress", results[0]); }
public void GenerateCustomTableNameFromJsonWithTableCollection() { // Arrange var expected = "new_name_of_the_table"; var expected1 = "AlertUi"; var expected2 = "WorkType"; var exampleOption = new List <Schema> { new Schema { SchemaName = "machine", Tables = new List <TableRenamer> { new TableRenamer { NewName = "new_name_of_the_table", Name = "OldTableName", }, }, }, }; var sut = new ReplacingCandidateNamingService(exampleOption); var exampleDbTables = new List <DatabaseTable> { new DatabaseTable { Name = "OldTableName", Schema = "machine", }, new DatabaseTable { Name = "alert_ui", Schema = "machine", }, new DatabaseTable { Name = "WorkType", Schema = "dbo", }, }; var result = new List <string>(); // Act foreach (var exmapleTable in exampleDbTables) { result.Add(sut.GenerateCandidateIdentifier(exmapleTable)); } // Assert StringAssert.Contains(expected, result[0]); StringAssert.Contains(expected1, result[1]); StringAssert.Contains(expected2, result[2]); }
public void GenerateColumnNameInStandarNamingConvention() { //Arrange var exampleColumn = new DatabaseColumn { Name = "column_name_to_rename", Table = new DatabaseTable { Name = "table_name", Schema = "dbo" } }; var expected = "ColumnNameToRename"; var exampleOption = new List <Schema> { new Schema { SchemaName = "machine", UseSchemaName = true, Tables = new List <TableRenamer> { new TableRenamer { Name = "table_name", Columns = new List <ColumnNamer> { new ColumnNamer { Name = "OldDummyColumnName", NewName = "NewDummyColumnName" } } } } } }; var sut = new ReplacingCandidateNamingService(exampleOption); //Act var actResult = sut.GenerateCandidateIdentifier(exampleColumn); //Assert StringAssert.Contains(expected, actResult); }
public void GenerateIForeignKeyForSelfReferenceTable() { //Arrange var expected = "SelfRef"; var exampleOption = new List <Schema> { }; var sut = new ReplacingCandidateNamingService(exampleOption); var fk = CreateSelfRefFK(); // Act var result = sut.GetDependentEndCandidateNavigationPropertyName(fk); //Assert StringAssert.Contains(expected, result); //Assert.AreSame(fk.PrincipalEntityType, fk.ResolveOtherEntityType(fk.DeclaringEntityType)); }
public void GenerateIForeignKeyNameWithoutSchemaName() { //Arrange var expected = "OneToManyPrincipal"; var exampleOption = new List <Schema> { new Schema { SchemaName = "schema", UseSchemaName = false } }; var sut = new ReplacingCandidateNamingService(exampleOption); var fk = CreateOneToManyFK(); // Act var result = sut.GetDependentEndCandidateNavigationPropertyName(fk); //Assert StringAssert.Contains(expected, result); }
public void GeneratePascalCaseTableNameWithSchemaNameWithMoreThanTwoSchemasForTableCollection() { //Arrange var expected = "MachineAlertUi"; var expected2 = "MachineMeasure"; var expected3 = "MasterMeasure"; var expected4 = "DboWorkType"; var exampleOption = new List <Schema> { new Schema { SchemaName = "machine", UseSchemaName = true }, new Schema { SchemaName = "master", UseSchemaName = true }, new Schema { SchemaName = "dbo", UseSchemaName = true, Tables = new List <TableRenamer> { new TableRenamer { Name = "work_type" } } } }; var sut = new ReplacingCandidateNamingService(exampleOption); var exampleDbTables = new List <DatabaseTable> { new DatabaseTable { Name = "alert_ui", Schema = "machine" }, new DatabaseTable { Name = "measure", Schema = "machine" }, new DatabaseTable { Name = "measure", Schema = "master" }, new DatabaseTable { Name = "work_type", Schema = "dbo" } }; // Act List <string> results = new List <string>(); foreach (var table in exampleDbTables) { results.Add(sut.GenerateCandidateIdentifier(table)); } //Assert StringAssert.Contains(expected, results[0]); StringAssert.Contains(expected2, results[1]); StringAssert.Contains(expected3, results[2]); StringAssert.Contains(expected4, results[3]); }
public void ChangeColumnNameToCustom() { //Arrange var exampleColumns = new List <DatabaseColumn> { new DatabaseColumn { Name = "column_name_to_rename", Table = new DatabaseTable { Name = "table_name", Schema = "dbo" } }, new DatabaseColumn { Name = "measure", Table = new DatabaseTable { Name = "table_name", Schema = "machine" } } }; var expected = "SomethingCustom"; var expected1 = "Measure"; var exampleOption = new List <Schema> { new Schema { SchemaName = "machine", UseSchemaName = true, Tables = new List <TableRenamer> { new TableRenamer { Name = "table_name", Columns = new List <ColumnNamer> { new ColumnNamer { Name = "OldDummyColumnName", NewName = "NewDummyColumnName" } } } } }, new Schema { SchemaName = "dbo", UseSchemaName = false, Tables = new List <TableRenamer> { new TableRenamer { Name = "table_name", Columns = new List <ColumnNamer> { new ColumnNamer { Name = "column_name_to_rename", NewName = "SomethingCustom" } } } } } }; var sut = new ReplacingCandidateNamingService(exampleOption); //Act var actResult = new List <string>(); foreach (var column in exampleColumns) { actResult.Add(sut.GenerateCandidateIdentifier(column)); } //Assert StringAssert.Contains(expected, actResult[0]); StringAssert.Contains(expected1, actResult[1]); }