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]);
}
