public override TableColumnMappings GetColumnMappingsFromStage(DataStoreConfiguration c)
{
// establish the column mappings between the staging tables and this public table
var m = new TableColumnMappings();
m.AddConsolidatedOrFederatedIdMapping(c, Entity.Site, "site_id1");
m.AddColumnMappingLookup("site_id1", "site_name1", ConsolidationType.Site, c);
m.AddConsolidatedOrFederatedIdMapping(c, Entity.Site, "site_id2");
m.AddColumnMappingLookup("site_id2", "site_name2", ConsolidationType.Site, c);
m.AddRemainingSimpleMappings(Columns);
return(m);
}
public override TableColumnMappings GetColumnMappingsFromStage(DataStoreConfiguration c)
{
// establish the column mappings between the staging tables and this public table
var m = new TableColumnMappings();
m.AddFederatedIdMapping("exam_id");
m.AddExplicitColumnMappingLookup("federated_exam_id", "exam_id", "name", Entity.EsExam);
m.AddExplicitColumnMappingLookup("federated_exam_id", "exam_id", "unique_name", Entity.EsExam);
m.AddFederatedIdMapping("session_id");
m.AddColumnMappingLookup("session_id", "session_name", Entity.EsSession, c);
m.AddEventCatIdAndNameMapping(c);
m.AddDeptIdAndNameMapping(c);
m.AddFacultyIdAndNameMapping(c);
m.AddBooleanMapping("protected");
m.AddBooleanMapping("suspended");
m.AddBooleanMapping("registers_req");
m.AddBooleanMapping(ColumnConstants.RegistersReqResolvedColumnName);
m.AddAuditMapping(c);
m.AddOriginMapping();
m.AddRemainingSimpleMappings(Columns);
return(m);
}
public override TableColumnMappings GetColumnMappingsFromStage(DataStoreConfiguration c)
{
// establish the column mappings between the staging tables and this public table
var m = new TableColumnMappings();
m.AddConsolidatedOrFederatedIdMapping(c, Entity.EventCat, "event_cat_id");
m.AddColumnMappingLookup("event_cat_id", "name", ConsolidationType.EventCat, c);
m.AddBooleanMapping("registers_req");
m.AddBooleanMapping(ColumnConstants.RegistersReqResolvedColumnName);
m.AddAuditMapping(c);
m.AddOriginMapping();
m.AddRemainingSimpleMappings(Columns);
return(m);
}
public override TableColumnMappings GetColumnMappingsFromStage(DataStoreConfiguration c)
{
// establish the column mappings between the staging tables and this public table
var m = new TableColumnMappings();
m.AddConsolidatedOrFederatedIdMapping(c, Entity.User, "user_id");
m.AddColumnMappingLookup("user_id", "name", Entity.User, c);
m.AddDeptIdAndNameMapping(c);
m.AddFacultyIdAndNameMapping(c);
m.AddStaffIdAndNameMapping(c);
m.AddStudentIdAndNameMapping(c);
m.AddBooleanMapping("active");
m.AddBooleanMapping("booking_admin");
m.AddAuditMapping(c);
m.AddRemainingSimpleMappings(Columns);
return m;
}
