public void TestLookUpMethods()
{
var lookUpManager = new LookUpManager(ReaderFactory.GetPholioReader(),
ReaderFactory.GetAreasReader(),
new List<int>{AreaTypeIds.Ccg},
new List<int>{CategoryTypeIds.EthnicGroups5});
// Assert property names
Assert.AreEqual("18+ yrs", lookUpManager.GetAgeName(AgeIds.Over18));
Assert.AreEqual("Male", lookUpManager.GetSexName(SexIds.Male));
Assert.AreEqual("Aggregated from all known lower geography values", lookUpManager.GetValueNoteText(ValueNoteIds.ValueAggregatedFromAllKnownGeographyValues));
// Assert area look ups
Assert.AreEqual("CCG", lookUpManager.GetAreaTypeName(AreaCodes.Ccg_Barnet));
Assert.AreEqual("NHS Barnet CCG", lookUpManager.GetAreaName(AreaCodes.Ccg_Barnet));
// Assert category names
Assert.AreEqual("Ethnic groups", lookUpManager.GetCategoryTypeName(CategoryTypeIds.EthnicGroups5));
Assert.AreEqual("Black / African / Caribbean / Black British", lookUpManager.GetCategoryName(CategoryTypeIds.EthnicGroups5,
CategoryIds.EthnicityBlack));
}
public void UploadProfile(int profileId)
{
// Ensure a group exists
var profile = profileReader.GetProfile(profileId);
var ckanGroup = GetCkanGroup(profile);
// Ckan parameters
var groupIdProvider = new GroupIdProvider(profileReader);
var areaTypeListProvider = new AreaTypeListProvider(groupIdProvider,
areasReader, groupDataReader);
var parameters = new ProfileParameters(areaTypeListProvider, profileId, ckanGroup.Name);
var metadataRepo = IndicatorMetadataRepository.Instance;
var areaCodesToIgnore = profileReader.GetAreaCodesToIgnore(profileId).AreaCodesIgnoredEverywhere;
var lookUpManager = new LookUpManager(pholioReader, areasReader,
parameters.AreaTypeIds, parameters.CategoryTypeIds);
var groupIds = groupIdProvider.GetGroupIds(profileId);
foreach (var groupId in groupIds)
{
var groupings = groupDataReader.GetGroupingsByGroupId(groupId);
var metadataCollection = metadataRepo.GetIndicatorMetadataCollection(groupings);
metadataRepo.RemoveSystemContentFields(metadataCollection.IndicatorMetadata);
foreach (var grouping in groupings)
{
var indicatorId = grouping.IndicatorId;
if (indicatorIdsAlreadyUploaded.Contains(indicatorId) == false)
{
indicatorIdsAlreadyUploaded.Add(indicatorId);
var timeRange = new TimeRange(grouping);
var metadata = metadataCollection.GetIndicatorMetadataById(indicatorId);
Console.WriteLine("#UPLOADING: [{0}] {1} \"{2}\"",
indicatorIdsAlreadyUploaded.Count, indicatorId,
metadata.Descriptive[IndicatorMetadataTextColumnNames.Name]
);
// Create/update package
var packageIdProvider = new PackageIdProvider(metadata.IndicatorId);
var ckanPackage = _ckanPackageRepository.RetrieveOrGetNew(packageIdProvider);
CkanGroup group = _ckanGroupRepository.GetExistingGroup(parameters.CkanGroupName);
new CkanPackagePropertySetter()
.SetProperties(ckanPackage, group, parameters, metadata, timeRange);
var savedPackage = _ckanPackageRepository.CreateOrUpdate(ckanPackage);
// Create metadata resource
var textMetadataResource = new MetadataResourceBuilder()
.GetUnsavedResource(savedPackage.Id, metadata, metadataRepo.IndicatorMetadataTextProperties);
// Create data resource
var allGroupingsForIndicator = groupings
.Where(x => x.IndicatorId == indicatorId).ToList();
var sexIds = allGroupingsForIndicator
.Select(x => x.SexId).Distinct().ToList();
var ageIds = groupDataReader.GetAllAgeIdsForIndicator(indicatorId);
var allDataList = new CoreDataListBuilder { GroupDataReader = groupDataReader }
.GetData(metadata.YearType, grouping, sexIds, ageIds,
parameters.AreaTypeIds, parameters.CategoryTypeIds, areaCodesToIgnore);
var dataResource = new CoreDataResourceBuilder(lookUpManager)
.GetUnsavedResource(savedPackage.Id, metadata, allDataList);
// Upload resources
new CkanResourceUploader { CkanApi = ckanApi }.AddResourcesToPackage(
savedPackage.Id, textMetadataResource, dataResource);
}
}
}
}
public CoreDataResourceBuilder(LookUpManager lookUpManager)
{
this.lookUpManager = lookUpManager;
}
