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.AddFederatedIdMapping("booking_id"); m.AddUserIdAndNameMapping(c); m.AddDeptIdAndNameMapping(c); m.AddEventCatIdAndNameMapping(c); m.AddBooleanMapping("add_me"); m.AddAuditMapping(c); m.AddOriginMapping(); m.AddRemainingSimpleMappings(Columns); return(m); }