public override TableColumnMappings GetColumnMappingsFromStage(DataStoreConfiguration c)
{
// establish the column mappings between the staging tables and this public table
var m = new TableColumnMappings {
EventExpansion = EventExpansionDefinition.Standard
};
m.AddSimpleMapping("timetable_id", "src_timetable_id");
m.AddSimpleMapping("timetable_event_id", "event_id"); // must come before "event_id" mapping
m.AddFederatedIdMapping("event_id");
m.AddEventStartEndTimeMapping("start_time");
m.AddEventStartEndTimeMapping("end_time");
m.AddSpanIdAndNameMapping();
m.AddEventCatIdAndNameMapping(c);
m.AddDeptIdAndNameMapping(c);
m.AddFacultyIdAndNameMapping(c);
m.AddBooleanMapping("global_event");
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.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.Dept, "dept_id");
m.AddFacultyIdAndNameMapping(c);
m.AddStaff1And2IdAndNameMapping(c);
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;
}
