public void ShouldApplyPluralsWithUnderscoreUpperCase()
{
var inflector = new EnglishInflector();
var applier = new ManyToManyPluralizedTableApplier((new Mock <IDomainInspector>()).Object, inflector);
applier.GetTableNameForRelation(new Relation(typeof(Person), typeof(Role)), new Relation(typeof(Role), typeof(Person))).Should().Be("PEOPLE_ROLES");
}
private Mapper GetMapper()
{
#region Initialize ConfORM
var inflector = new EnglishInflector();
var orm = new ObjectRelationalMapper();
IPatternsAppliersHolder patternsAppliers =
(new SafePropertyAccessorPack())
.Merge(new SafePoidPack())
.Merge(new OneToOneRelationPack(orm))
.Merge(new BidirectionalManyToManyRelationPack(orm))
.Merge(new BidirectionalOneToManyRelationPack(orm))
.Merge(new DiscriminatorValueAsClassNamePack(orm))
//.Merge(new CoolTablesNamingPack(orm))
.Merge(new PluralizedTablesPack(orm, inflector))
.Merge(new CoolColumnsNamingPack(orm))
.UnionWith(new ConfOrm.Shop.InflectorNaming.CollectionOfElementsColumnApplier(orm, inflector))
.Merge(new PolymorphismPack(orm))
.Merge(new TablePerClassPack())
.Merge(new UseNoLazyForNoProxablePack()) // <== Lazy false when the class is not proxable
.Merge(new ConfOrm.Shop.CoolNaming.UnidirectionalOneToManyMultipleCollectionsKeyColumnApplier(orm))
.Merge(new UseCurrencyForDecimalApplier())
.Merge(new DatePropertyByNameApplier())
.Merge(new MsSQL2008DateTimeApplier());
orm.Patterns.PoidStrategies.Add(new HighLowPoidPattern(new { max_lo = 100 }));
var mapper = new Mapper(orm, patternsAppliers);
IEnumerable <Type> tablePerClassEntities = typeof(Entity)
.Assembly.GetTypes().Where(t => IsRootEntity(t) &&
!tablePerClassHierarchy.Contains(t) &&
!tablePerConcreteClass.Contains(t)).ToList();
// Mappings
orm.TablePerClass(tablePerClassEntities);
orm.TablePerClassHierarchy(tablePerClassHierarchy);
orm.TablePerConcreteClass(tablePerConcreteClass);
#endregion
ConfOrmMapping(orm, mapper);
return(mapper);
}
public HbmMapping GenerateMappigs()
{
var orm = new ObjectRelationalMapper();
orm.Patterns.PoidStrategies.Add(new NativePoidPattern());
//// map .NET4 ISet<T> as a NHibernate's set
orm.Patterns.Sets.Add(new UseSetWhenGenericCollectionPattern());
var englishInflector = new EnglishInflector();
IPatternsAppliersHolder patternsAppliers = (new SafePropertyAccessorPack())
.Merge(new ClassPluralizedTableApplier(englishInflector))
.Merge(new DiscriminatorValueAsEnumValuePack <ChildA, Types>(orm))
.Merge(new DiscriminatorValueAsEnumValuePack <ChildB, Types>(orm))
.Merge(new CoolPatternsAppliersHolder(orm));
IEnumerable <Type> allPersistEntities = GetDomainEntities();
IEnumerable <Type> roots = allPersistEntities.Where(t => t.IsAbstract && t.InheritedFromBaseEntity());
IEnumerable <Type> hierarchyEntities = allPersistEntities.Where(t => typeof(IHierarchyEntity).IsAssignableFrom(t));
IEnumerable <Type> separateEntities = allPersistEntities.Except(roots).Except(hierarchyEntities);
orm.TablePerConcreteClass(separateEntities);
var hierarchyRoots = hierarchyEntities.Where(t => t.IsAbstract && t.InheritedFromBaseEntity());
orm.TablePerClassHierarchy(hierarchyRoots);
orm.Cascade <ChildA, Container>(CascadeOn.Persist | CascadeOn.Merge);
orm.Cascade <Container, ChildA>(CascadeOn.Persist);
orm.Cascade <ChildB, Container>(CascadeOn.Persist | CascadeOn.Merge);
orm.Cascade <Container, ChildB>(CascadeOn.Persist);
var mapper = new Mapper(orm, patternsAppliers);
HbmMapping mapping = mapper.CompileMappingFor(allPersistEntities);
File.WriteAllText(@"c:\Test\mappings.xml", Serialize(mapping)); // сохраняем маппинги в файл.
return(mapping);
}
static Inflector()
{
English = new EnglishInflector();
Spanish = new SpanishInflector();
}
/// Originally implemented by http://andrewpeters.net/inflectornet/
#region Fixture Data
public EnglishInflectorFixture()
{
SingularToPlural.Add("search", "searches");
SingularToPlural.Add("switch", "switches");
SingularToPlural.Add("fix", "fixes");
SingularToPlural.Add("box", "boxes");
SingularToPlural.Add("process", "processes");
SingularToPlural.Add("address", "addresses");
SingularToPlural.Add("case", "cases");
SingularToPlural.Add("stack", "stacks");
SingularToPlural.Add("wish", "wishes");
SingularToPlural.Add("fish", "fish");
SingularToPlural.Add("category", "categories");
SingularToPlural.Add("query", "queries");
SingularToPlural.Add("ability", "abilities");
SingularToPlural.Add("agency", "agencies");
SingularToPlural.Add("movie", "movies");
SingularToPlural.Add("archive", "archives");
SingularToPlural.Add("index", "indices");
SingularToPlural.Add("wife", "wives");
SingularToPlural.Add("safe", "saves");
SingularToPlural.Add("half", "halves");
SingularToPlural.Add("move", "moves");
SingularToPlural.Add("salesperson", "salespeople");
SingularToPlural.Add("person", "people");
SingularToPlural.Add("spokesman", "spokesmen");
SingularToPlural.Add("man", "men");
SingularToPlural.Add("woman", "women");
SingularToPlural.Add("basis", "bases");
SingularToPlural.Add("diagnosis", "diagnoses");
SingularToPlural.Add("datum", "data");
SingularToPlural.Add("medium", "media");
SingularToPlural.Add("analysis", "analyses");
SingularToPlural.Add("node_child", "node_children");
SingularToPlural.Add("child", "children");
SingularToPlural.Add("experience", "experiences");
SingularToPlural.Add("day", "days");
SingularToPlural.Add("comment", "comments");
SingularToPlural.Add("foobar", "foobars");
SingularToPlural.Add("newsletter", "newsletters");
SingularToPlural.Add("old_news", "old_news");
SingularToPlural.Add("news", "news");
SingularToPlural.Add("series", "series");
SingularToPlural.Add("species", "species");
SingularToPlural.Add("quiz", "quizzes");
SingularToPlural.Add("perspective", "perspectives");
SingularToPlural.Add("ox", "oxen");
SingularToPlural.Add("photo", "photos");
SingularToPlural.Add("buffalo", "buffaloes");
SingularToPlural.Add("tomato", "tomatoes");
SingularToPlural.Add("dwarf", "dwarves");
SingularToPlural.Add("elf", "elves");
SingularToPlural.Add("information", "information");
SingularToPlural.Add("equipment", "equipment");
SingularToPlural.Add("bus", "buses");
SingularToPlural.Add("status", "statuses");
SingularToPlural.Add("status_code", "status_codes");
SingularToPlural.Add("mouse", "mice");
SingularToPlural.Add("louse", "lice");
SingularToPlural.Add("house", "houses");
SingularToPlural.Add("octopus", "octopi");
SingularToPlural.Add("virus", "viri");
SingularToPlural.Add("alias", "aliases");
SingularToPlural.Add("portfolio", "portfolios");
SingularToPlural.Add("vertex", "vertices");
SingularToPlural.Add("matrix", "matrices");
SingularToPlural.Add("axis", "axes");
SingularToPlural.Add("testis", "testes");
SingularToPlural.Add("crisis", "crises");
SingularToPlural.Add("rice", "rice");
SingularToPlural.Add("shoe", "shoes");
SingularToPlural.Add("horse", "horses");
SingularToPlural.Add("prize", "prizes");
SingularToPlural.Add("edge", "edges");
PascalToUnderscore.Add("Product", "product");
PascalToUnderscore.Add("SpecialGuest", "special_guest");
PascalToUnderscore.Add("ApplicationController", "application_controller");
PascalToUnderscore.Add("Area51Controller", "area51_controller");
UnderscoreToCamel.Add("product", "product");
UnderscoreToCamel.Add("special_guest", "specialGuest");
UnderscoreToCamel.Add("application_controller", "applicationController");
UnderscoreToCamel.Add("area51_controller", "area51Controller");
PascalToUnderscoreWithoutReverse.Add("HTMLTidy", "html_tidy");
PascalToUnderscoreWithoutReverse.Add("HTMLTidyGenerator", "html_tidy_generator");
PascalToUnderscoreWithoutReverse.Add("FreeBSD", "free_bsd");
PascalToUnderscoreWithoutReverse.Add("HTML", "html");
UnderscoreToHuman.Add("employee_salary", "Employee salary");
UnderscoreToHuman.Add("employee_id", "Employee id");
UnderscoreToHuman.Add("underground", "Underground");
MixtureToTitleCase.Add("active_record", "Active Record");
MixtureToTitleCase.Add("ActiveRecord", "Active Record");
MixtureToTitleCase.Add("action web service", "Action Web Service");
MixtureToTitleCase.Add("Action Web Service", "Action Web Service");
MixtureToTitleCase.Add("Action web service", "Action Web Service");
MixtureToTitleCase.Add("actionwebservice", "Actionwebservice");
MixtureToTitleCase.Add("Actionwebservice", "Actionwebservice");
OrdinalNumbers.Add("0", "0th");
OrdinalNumbers.Add("1", "1st");
OrdinalNumbers.Add("2", "2nd");
OrdinalNumbers.Add("3", "3rd");
OrdinalNumbers.Add("4", "4th");
OrdinalNumbers.Add("5", "5th");
OrdinalNumbers.Add("6", "6th");
OrdinalNumbers.Add("7", "7th");
OrdinalNumbers.Add("8", "8th");
OrdinalNumbers.Add("9", "9th");
OrdinalNumbers.Add("10", "10th");
OrdinalNumbers.Add("11", "11th");
OrdinalNumbers.Add("12", "12th");
OrdinalNumbers.Add("13", "13th");
OrdinalNumbers.Add("14", "14th");
OrdinalNumbers.Add("20", "20th");
OrdinalNumbers.Add("21", "21st");
OrdinalNumbers.Add("22", "22nd");
OrdinalNumbers.Add("23", "23rd");
OrdinalNumbers.Add("24", "24th");
OrdinalNumbers.Add("100", "100th");
OrdinalNumbers.Add("101", "101st");
OrdinalNumbers.Add("102", "102nd");
OrdinalNumbers.Add("103", "103rd");
OrdinalNumbers.Add("104", "104th");
OrdinalNumbers.Add("110", "110th");
OrdinalNumbers.Add("1000", "1000th");
OrdinalNumbers.Add("1001", "1001st");
UnderscoresToDashes.Add("street", "street");
UnderscoresToDashes.Add("street_address", "street-address");
UnderscoresToDashes.Add("person_street_address", "person-street-address");
ClassNameToTableName.Add("CostomerOrders", "CostomerOrder");
ClassNameToTableName.Add("Costomer_Orders", "Costomer_Order");
ClassNameToForeignKeyName.Add("ProductId", "Product");
ClassNameToForeignKeyName.Add("SpecialGuestId", "SpecialGuest");
ClassNameToForeignKeyName.Add("ApplicationControllerId", "ApplicationController");
TestInflector = new EnglishInflector();
}
/// Originally implemented by http://andrewpeters.net/inflectornet/
public EnglishInflectorTest()
{
SingularToPlural.Add("search", "searches");
SingularToPlural.Add("switch", "switches");
SingularToPlural.Add("fix", "fixes");
SingularToPlural.Add("box", "boxes");
SingularToPlural.Add("process", "processes");
SingularToPlural.Add("address", "addresses");
SingularToPlural.Add("case", "cases");
SingularToPlural.Add("stack", "stacks");
SingularToPlural.Add("wish", "wishes");
SingularToPlural.Add("fish", "fish");
SingularToPlural.Add("category", "categories");
SingularToPlural.Add("query", "queries");
SingularToPlural.Add("ability", "abilities");
SingularToPlural.Add("agency", "agencies");
SingularToPlural.Add("movie", "movies");
SingularToPlural.Add("archive", "archives");
SingularToPlural.Add("index", "indices");
SingularToPlural.Add("wife", "wives");
SingularToPlural.Add("safe", "saves");
SingularToPlural.Add("half", "halves");
SingularToPlural.Add("move", "moves");
SingularToPlural.Add("salesperson", "salespeople");
SingularToPlural.Add("person", "people");
SingularToPlural.Add("spokesman", "spokesmen");
SingularToPlural.Add("man", "men");
SingularToPlural.Add("woman", "women");
SingularToPlural.Add("basis", "bases");
SingularToPlural.Add("diagnosis", "diagnoses");
SingularToPlural.Add("datum", "data");
SingularToPlural.Add("medium", "media");
SingularToPlural.Add("analysis", "analyses");
SingularToPlural.Add("node_child", "node_children");
SingularToPlural.Add("child", "children");
SingularToPlural.Add("experience", "experiences");
SingularToPlural.Add("day", "days");
SingularToPlural.Add("comment", "comments");
SingularToPlural.Add("foobar", "foobars");
SingularToPlural.Add("newsletter", "newsletters");
SingularToPlural.Add("old_news", "old_news");
SingularToPlural.Add("news", "news");
SingularToPlural.Add("series", "series");
SingularToPlural.Add("species", "species");
SingularToPlural.Add("quiz", "quizzes");
SingularToPlural.Add("perspective", "perspectives");
SingularToPlural.Add("ox", "oxen");
SingularToPlural.Add("photo", "photos");
SingularToPlural.Add("buffalo", "buffaloes");
SingularToPlural.Add("tomato", "tomatoes");
SingularToPlural.Add("dwarf", "dwarves");
SingularToPlural.Add("elf", "elves");
SingularToPlural.Add("information", "information");
SingularToPlural.Add("equipment", "equipment");
SingularToPlural.Add("bus", "buses");
SingularToPlural.Add("status", "statuses");
SingularToPlural.Add("status_code", "status_codes");
SingularToPlural.Add("mouse", "mice");
SingularToPlural.Add("louse", "lice");
SingularToPlural.Add("house", "houses");
SingularToPlural.Add("octopus", "octopi");
SingularToPlural.Add("virus", "viri");
SingularToPlural.Add("alias", "aliases");
SingularToPlural.Add("portfolio", "portfolios");
SingularToPlural.Add("vertex", "vertices");
SingularToPlural.Add("matrix", "matrices");
SingularToPlural.Add("axis", "axes");
SingularToPlural.Add("testis", "testes");
SingularToPlural.Add("crisis", "crises");
SingularToPlural.Add("rice", "rice");
SingularToPlural.Add("shoe", "shoes");
SingularToPlural.Add("horse", "horses");
SingularToPlural.Add("prize", "prizes");
SingularToPlural.Add("edge", "edges");
TestInflector = new EnglishInflector();
}
