public void GetAllSocMappings(string socCode, string onetSocCode)
{
var mapperConfig = new MapperConfiguration(cfg => cfg.AddProfile(new SkillsFrameworkMapper()));
var mapper = mapperConfig.CreateMapper();
using (OnetSkillsFramework dbcontext = new OnetSkillsFramework())
{
var repository = new SocMappingsQueryRepository(dbcontext, mapper);
var all = repository.GetAll();
all.Should().NotBeNull();
var count = all.Count();
count.Should().Be(780);
var single = repository.GetById(socCode);
single.Should().NotBeNull();
single.ONetOccupationalCode.Should().Be(onetSocCode);
var singleByExpression = repository.Get(s => s.SOCCode == socCode);
singleByExpression.Should().NotBeNull();
singleByExpression.ONetOccupationalCode.Should().Be(onetSocCode);
var manyByExpression = repository.GetMany(s => s.SOCCode.StartsWith(socCode.Substring(0, 2), StringComparison.CurrentCulture));
manyByExpression.Should().NotBeNull();
}
}
public void GetSkillsForOnetCodeTest(string onetSocCode)
{
var fakeLogger = A.Fake <IApplicationLogger>();
var fakeSocRepository = A.Fake <IRepository <SocCode> >();
var fakeDigitalSkillRepository = A.Fake <IRepository <DigitalSkill> >();
var fakeDigitalTranslationRepository = A.Fake <IRepository <FrameworkSkill> >();
using (OnetSkillsFramework dbcontext = new OnetSkillsFramework())
{
var skillsRepository = new SkillsOueryRepository(dbcontext);
var combinationRepository = new CombinationsQueryRepository(dbcontext);
var suppressionRepository = new SuppressionsQueryRepository(dbcontext);
var contentReferenceRepository = new ContentReferenceQueryRepository(dbcontext);
ISkillFrameworkBusinessRuleEngine skillFrameworkBusinessRuleEngine = new SkillFrameworkBusinessRuleEngine(
skillsRepository, suppressionRepository,
combinationRepository, contentReferenceRepository);
var skillsFrameworkService = new SkillsFrameworkService(fakeLogger, fakeSocRepository, fakeDigitalSkillRepository, fakeDigitalTranslationRepository, skillFrameworkBusinessRuleEngine);
var result = skillsFrameworkService.GetRelatedSkillMapping(onetSocCode);
result.Should().NotBeNull();
}
}
public void GetTranslationById(string onetElementId)
{
using (OnetSkillsFramework dbcontext = new OnetSkillsFramework())
{
var repository = new TranslationQueryRepository(dbcontext);
var single = repository.GetById(onetElementId);
single.Should().NotBeNull();
single.ONetElementId.Should().Be(onetElementId);
}
}
public void GetDigitalSkillsRank(string onetSocCode)
{
using (OnetSkillsFramework dbcontext = new OnetSkillsFramework())
{
var repository = new DigitalSkillsQueryRepository(dbcontext);
var single = repository.GetById(onetSocCode);
single.Should().NotBeNull();
single.ApplicationCount.Should().BeGreaterThan(0);
}
}
public void GetTranslationsMany(string field1, string field2)
{
using (OnetSkillsFramework dbcontext = new OnetSkillsFramework())
{
var repository = new TranslationQueryRepository(dbcontext);
var single = repository.GetMany(x => x.ONetElementId == field1 && x.Description == field2);
single.Should().NotBeNull();
single.Should().Contain(x => x.ONetElementId == field1);
}
}
public void GetAllTransalations()
{
using (OnetSkillsFramework dbcontext = new OnetSkillsFramework())
{
var repository = new TranslationQueryRepository(dbcontext);
var all = repository.GetAll().ToList();
all.Should().NotBeNull();
all.Count.Should().BeGreaterThan(0);
var single = repository.GetById("1.A.1.a");
single.Should().NotBeNull();
single.ONetElementId.Should().Be("1.A.1.a");
var singleByExpression = repository.Get(s => s.ONetElementId == "1.A.1.a");
singleByExpression.Should().NotBeNull();
singleByExpression.ONetElementId.Should().Be("1.A.1.a");
var manyByExpression = repository.GetMany(s => s.ONetElementId.StartsWith("1.A.", StringComparison.Ordinal));
manyByExpression.Should().NotBeNull();
}
}
public TranslationQueryRepository(OnetSkillsFramework onetDbContext)
{
this.onetDbContext = onetDbContext;
}
public CombinationsQueryRepository(OnetSkillsFramework onetDbContext)
{
this.onetDbContext = onetDbContext;
}
public SocMappingRepository(OnetSkillsFramework onetDbContext, IMapper autoMapper)
{
this.onetDbContext = onetDbContext;
this.autoMapper = autoMapper;
}
public SuppressionsQueryRepository(OnetSkillsFramework onetDbContext)
{
this.onetDbContext = onetDbContext;
}
public SkillsOueryRepository(OnetSkillsFramework onetDbContext)
{
this.onetDbContext = onetDbContext;
}
public ContentReferenceQueryRepository(OnetSkillsFramework onetDbContext)
{
this.onetDbContext = onetDbContext;
}
public DigitalSkillsQueryRepository(OnetSkillsFramework onetDbContext)
{
this.onetDbContext = onetDbContext;
}
