internal static void SeedData(this PortfolioApplicationDbContext portfolioApplicationDbContext)
{
if (portfolioApplicationDbContext.AllMigrationsApplied())
{
SeedTechnologyProjectEnums(portfolioApplicationDbContext);
SeedTechnologiesProjectsExperiences(portfolioApplicationDbContext);
SeedProjectTechnologyJunctionTable(portfolioApplicationDbContext);
}
}
private static void SeedProjectTechnologyJunctionTable(PortfolioApplicationDbContext portfolioApplicationDbContext)
{
if (!portfolioApplicationDbContext.Set <ProjectTechnologyJunctionEntity>().Any())
{
var fullstackProjectId =
portfolioApplicationDbContext.Set <ProjectEntity>().Single(x => x.ProjectType.ProjectTypeEnum == ProjectTypeEnum.Fullstack).Id;
var backendProjectId =
portfolioApplicationDbContext.Set <ProjectEntity>().Single(x => x.ProjectType.ProjectTypeEnum == ProjectTypeEnum.Backend).Id;
var frontendProjectId =
portfolioApplicationDbContext.Set <ProjectEntity>().Single(x => x.ProjectType.ProjectTypeEnum == ProjectTypeEnum.Frontend).Id;
var languageTechnologyId =
portfolioApplicationDbContext.Set <TechnologyEntity>().First(x => x.TechnologyType.TechnologyTypeEnum == TechnologyTypeEnum.Language).Id;
var frameworkTechnologyId =
portfolioApplicationDbContext.Set <TechnologyEntity>().First(x => x.TechnologyType.TechnologyTypeEnum == TechnologyTypeEnum.Framework).Id;
var toolTechnologyId =
portfolioApplicationDbContext.Set <TechnologyEntity>().First(x => x.TechnologyType.TechnologyTypeEnum == TechnologyTypeEnum.Tool).Id;
portfolioApplicationDbContext.Set <ProjectTechnologyJunctionEntity>().AddRange(
new ProjectTechnologyJunctionEntity()
{
ProjectId = fullstackProjectId, TechnologyId = languageTechnologyId
},
new ProjectTechnologyJunctionEntity()
{
ProjectId = fullstackProjectId, TechnologyId = frameworkTechnologyId
},
new ProjectTechnologyJunctionEntity()
{
ProjectId = fullstackProjectId, TechnologyId = toolTechnologyId
},
new ProjectTechnologyJunctionEntity()
{
ProjectId = backendProjectId, TechnologyId = languageTechnologyId
},
new ProjectTechnologyJunctionEntity()
{
ProjectId = backendProjectId, TechnologyId = toolTechnologyId
},
new ProjectTechnologyJunctionEntity()
{
ProjectId = frontendProjectId, TechnologyId = frameworkTechnologyId
}
);
}
portfolioApplicationDbContext.SaveChanges();
}
private static void SeedTechnologyProjectEnums(PortfolioApplicationDbContext portfolioApplicationDbContext)
{
if (!portfolioApplicationDbContext.Set <TechnologyTypeEntity>().Any())
{
portfolioApplicationDbContext.Set <TechnologyTypeEntity>().AddRange(
new TechnologyTypeEntity()
{
Name = "Languages", TechnologyTypeEnum = TechnologyTypeEnum.Language
},
new TechnologyTypeEntity()
{
Name = "Frameworks", TechnologyTypeEnum = TechnologyTypeEnum.Framework
},
new TechnologyTypeEntity()
{
Name = "Methodologies", TechnologyTypeEnum = TechnologyTypeEnum.Methodology
},
new TechnologyTypeEntity()
{
Name = "Tools", TechnologyTypeEnum = TechnologyTypeEnum.Tool
}
);
}
if (!portfolioApplicationDbContext.Set <ProjectTypeEntity>().Any())
{
portfolioApplicationDbContext.Set <ProjectTypeEntity>().AddRange(
new ProjectTypeEntity()
{
Name = "testBackend", ProjectTypeEnum = ProjectTypeEnum.Backend
},
new ProjectTypeEntity()
{
Name = "testFrontend", ProjectTypeEnum = ProjectTypeEnum.Frontend
},
new ProjectTypeEntity()
{
Name = "testFullstack", ProjectTypeEnum = ProjectTypeEnum.Fullstack
}
);
}
portfolioApplicationDbContext.SaveChanges();
}
public void DbContextMustCreateDynamicallyAllModelEntitiesOnItsOwnCreation()
{
var builder = new DbContextOptionsBuilder <PortfolioApplicationDbContext>().UseInMemoryDatabase("testInMemoryDatabase");
var options = builder.Options;
var portfolioApplicationDbContext = new PortfolioApplicationDbContext(options);
var allModelEntitiesCreated = true;
var modelEntities = typeof(BaseEntity).GetTypeInfo().Assembly.GetTypes().Where(x => x.GetTypeInfo().BaseType == typeof(BaseEntity));
foreach (Type modelEntity in modelEntities)
{
var modelEntityTypeName = modelEntity.GetTypeInfo().FullName;
var foundEntityType = portfolioApplicationDbContext.Model.FindEntityType(modelEntityTypeName);
if (foundEntityType == null)
{
allModelEntitiesCreated = false;
break;
}
}
Assert.True(allModelEntitiesCreated, "Did not create all of the application's model entities");
}
private static void SeedTechnologiesProjectsExperiences(PortfolioApplicationDbContext portfolioApplicationDbContext)
{
if (!portfolioApplicationDbContext.Set <TechnologyEntity>().Any())
{
portfolioApplicationDbContext.Set <TechnologyEntity>().AddRange(
new TechnologyEntity()
{
Name = "C#",
TechnologyTypeId = portfolioApplicationDbContext.Set <TechnologyTypeEntity>().Single(x => x.TechnologyTypeEnum == TechnologyTypeEnum.Language).Id,
IconClass = "devicon-csharp-line-wordmark colored"
},
new TechnologyEntity()
{
Name = "Angular",
TechnologyTypeId = portfolioApplicationDbContext.Set <TechnologyTypeEntity>().Single(x => x.TechnologyTypeEnum == TechnologyTypeEnum.Framework).Id,
IconClass = "devicon-angularjs-plain colored"
},
new TechnologyEntity()
{
Name = "CSS",
TechnologyTypeId = portfolioApplicationDbContext.Set <TechnologyTypeEntity>().Single(x => x.TechnologyTypeEnum == TechnologyTypeEnum.Language).Id,
IconClass = "devicon-css3-plain-wordmark colored"
},
new TechnologyEntity()
{
Name = "HTML",
TechnologyTypeId = portfolioApplicationDbContext.Set <TechnologyTypeEntity>().Single(x => x.TechnologyTypeEnum == TechnologyTypeEnum.Language).Id,
IconClass = "devicon-html5-plain-wordmark colored"
},
new TechnologyEntity()
{
Name = "Cucumber",
TechnologyTypeId = portfolioApplicationDbContext.Set <TechnologyTypeEntity>().Single(x => x.TechnologyTypeEnum == TechnologyTypeEnum.Framework).Id,
IconClass = "devicon-cucumber-plain colored"
},
new TechnologyEntity()
{
Name = "Redis",
TechnologyTypeId = portfolioApplicationDbContext.Set <TechnologyTypeEntity>().Single(x => x.TechnologyTypeEnum == TechnologyTypeEnum.Tool).Id,
IconClass = "devicon-redis-plain colored"
}
);
}
if (!portfolioApplicationDbContext.Set <ProjectEntity>().Any())
{
portfolioApplicationDbContext.Set <ProjectEntity>().AddRange(
new ProjectEntity()
{
Name = "testProjectFullstack",
Description = "testDescriptionFullstack",
ProjectTypeId = portfolioApplicationDbContext.Set <ProjectTypeEntity>().Single(x => x.ProjectTypeEnum == ProjectTypeEnum.Fullstack).Id,
StartTime = new DateTime(2016, 5, 5),
EndTime = new DateTime(2017, 3, 18)
},
new ProjectEntity()
{
Name = "testProjectBackend",
Description = "testDescriptionBackend",
ProjectTypeId = portfolioApplicationDbContext.Set <ProjectTypeEntity>().Single(x => x.ProjectTypeEnum == ProjectTypeEnum.Backend).Id,
StartTime = new DateTime(2015, 1, 1),
EndTime = new DateTime(2015, 6, 25)
},
new ProjectEntity()
{
Name = "testProjectFrontend",
Description = "testDescriptionFrontend",
ProjectTypeId = portfolioApplicationDbContext.Set <ProjectTypeEntity>().Single(x => x.ProjectTypeEnum == ProjectTypeEnum.Frontend).Id,
StartTime = new DateTime(2014, 1, 1),
EndTime = new DateTime(2016, 5, 4)
}
);
}
portfolioApplicationDbContext.SaveChanges();
if (!portfolioApplicationDbContext.Set <ExperienceEntity>().Any())
{
portfolioApplicationDbContext.Set <ExperienceEntity>().AddRange(
new ExperienceEntity()
{
CompanyName = "testCompany",
Position = "testJuniorDeveloper",
Projects = portfolioApplicationDbContext.Set <ProjectEntity>().ToList()
}
);
}
}
