From d65ce8288bbda3cb6e0b37613c29d7bf52703ba7 Mon Sep 17 00:00:00 2001 From: Ariel Costas Guerrero Date: Fri, 12 Dec 2025 08:56:32 +0100 Subject: Some rework on the ServiceViewer (which will be repurposed for live multi-GTFS serving) --- src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/GtfsRoute.cs | 12 ++++++++---- 1 file changed, 8 insertions(+), 4 deletions(-) (limited to 'src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/GtfsRoute.cs') diff --git a/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/GtfsRoute.cs b/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/GtfsRoute.cs index 261e183..c34353c 100644 --- a/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/GtfsRoute.cs +++ b/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/GtfsRoute.cs @@ -1,26 +1,30 @@ using System.ComponentModel.DataAnnotations; using System.ComponentModel.DataAnnotations.Schema; using Costasdev.ServiceViewer.Data.Gtfs.Enums; +using Microsoft.EntityFrameworkCore; namespace Costasdev.ServiceViewer.Data.Gtfs; -[Table("routes")] +[Table("gtfs_routes")] +[PrimaryKey(nameof(Id), nameof(FeedId))] public class GtfsRoute { - [Key] [Column("route_id")] [MaxLength(255)] public required string Id { get; set; } public string SafeId => Id.Replace(" ", "_").Replace("-", "_"); + [Column("feed_id")]public int FeedId { get; set; } + [ForeignKey(nameof(FeedId))] public required Feed Feed { get; set; } + [Column("agency_id")] - [ForeignKey(nameof(GtfsAgency))] + [ForeignKey(nameof(Agency))] [MaxLength(255)] public required string AgencyId { get; set; } [ForeignKey(nameof(AgencyId))] - public GtfsAgency GtfsAgency { get; set; } = null!; + public GtfsAgency Agency { get; set; } = null!; /// /// Short name of a route. Often a short, abstract identifier (e.g., "32", "100X", "Green") -- cgit v1.3