Some rework on the ServiceViewer (which will be repurposed for live multi-GTFS serving)

1 files changed, 0 insertions, 398 deletions

diff --git a/src/Costasdev.Busurbano.ServiceViewer/Data/Migrations/20250821135143_InitialGtfsData.Designer.cs b/src/Costasdev.Busurbano.ServiceViewer/Data/Migrations/20250821135143_InitialGtfsData.Designer.cs
deleted file mode 100644
index d123034..0000000
--- a/src/Costasdev.Busurbano.ServiceViewer/Data/Migrations/20250821135143_InitialGtfsData.Designer.cs
+++ /dev/null
@@ -1,398 +0,0 @@
-// <auto-generated />
-using System;
-using Costasdev.Busurbano.Database;
-using Costasdev.ServiceViewer;
-using Costasdev.ServiceViewer.Data;
-using Microsoft.EntityFrameworkCore;
-using Microsoft.EntityFrameworkCore.Infrastructure;
-using Microsoft.EntityFrameworkCore.Migrations;
-using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
-
-#nullable disable
-
-namespace Costasdev.Busurbano.Database.Migrations
-{
-    [DbContext(typeof(AppDbContext))]
-    [Migration("20250821135143_InitialGtfsData")]
-    partial class InitialGtfsData
-    {
-        /// <inheritdoc />
-        protected override void BuildTargetModel(ModelBuilder modelBuilder)
-        {
-#pragma warning disable 612, 618
-            modelBuilder
-                .HasAnnotation("ProductVersion", "9.0.8")
-                .HasAnnotation("Relational:MaxIdentifierLength", 64);
-
-            modelBuilder.Entity("Costasdev.Busurbano.Database.Gtfs.Agency", b =>
-                {
-                    b.Property<string>("Id")
-                        .HasMaxLength(255)
-                        .HasColumnType("varchar(255)")
-                        .HasColumnName("agency_id");
-
-                    b.Property<string>("Email")
-                        .HasMaxLength(255)
-                        .HasColumnType("varchar(255)")
-                        .HasColumnName("agency_email");
-
-                    b.Property<string>("FareUrl")
-                        .HasMaxLength(255)
-                        .HasColumnType("varchar(255)")
-                        .HasColumnName("agency_fare_url");
-
-                    b.Property<string>("Language")
-                        .IsRequired()
-                        .HasMaxLength(5)
-                        .HasColumnType("varchar(5)")
-                        .HasColumnName("agency_lang");
-
-                    b.Property<string>("Name")
-                        .IsRequired()
-                        .HasMaxLength(255)
-                        .HasColumnType("varchar(255)")
-                        .HasColumnName("agency_name");
-
-                    b.Property<string>("Phone")
-                        .HasMaxLength(30)
-                        .HasColumnType("varchar(30)")
-                        .HasColumnName("agency_phone");
-
-                    b.Property<string>("Timezone")
-                        .IsRequired()
-                        .HasMaxLength(50)
-                        .HasColumnType("varchar(50)")
-                        .HasColumnName("agency_timezone");
-
-                    b.Property<string>("Url")
-                        .IsRequired()
-                        .HasMaxLength(255)
-                        .HasColumnType("varchar(255)")
-                        .HasColumnName("agency_url");
-
-                    b.HasKey("Id");
-
-                    b.ToTable("agencies");
-                });
-
-            modelBuilder.Entity("Costasdev.Busurbano.Database.Gtfs.Calendar", b =>
-                {
-                    b.Property<string>("ServiceId")
-                        .HasMaxLength(32)
-                        .HasColumnType("varchar(32)")
-                        .HasColumnName("service_id");
-
-                    b.Property<DateOnly>("EndDate")
-                        .HasColumnType("date")
-                        .HasColumnName("end_date");
-
-                    b.Property<bool>("Friday")
-                        .HasColumnType("tinyint(1)")
-                        .HasColumnName("friday");
-
-                    b.Property<bool>("Monday")
-                        .HasColumnType("tinyint(1)")
-                        .HasColumnName("monday");
-
-                    b.Property<bool>("Saturday")
-                        .HasColumnType("tinyint(1)")
-                        .HasColumnName("saturday");
-
-                    b.Property<DateOnly>("StartDate")
-                        .HasColumnType("date")
-                        .HasColumnName("start_date");
-
-                    b.Property<bool>("Sunday")
-                        .HasColumnType("tinyint(1)")
-                        .HasColumnName("sunday");
-
-                    b.Property<bool>("Thursday")
-                        .HasColumnType("tinyint(1)")
-                        .HasColumnName("thursday");
-
-                    b.Property<bool>("Tuesday")
-                        .HasColumnType("tinyint(1)")
-                        .HasColumnName("tuesday");
-
-                    b.Property<bool>("Wednesday")
-                        .HasColumnType("tinyint(1)")
-                        .HasColumnName("wednesday");
-
-                    b.HasKey("ServiceId");
-
-                    b.ToTable("calendar");
-                });
-
-            modelBuilder.Entity("Costasdev.Busurbano.Database.Gtfs.CalendarDate", b =>
-                {
-                    b.Property<string>("ServiceId")
-                        .HasMaxLength(32)
-                        .HasColumnType("varchar(32)")
-                        .HasColumnName("service_id");
-
-                    b.Property<DateOnly>("Date")
-                        .HasColumnType("date")
-                        .HasColumnName("date");
-
-                    b.Property<int>("ExceptionType")
-                        .HasColumnType("int")
-                        .HasColumnName("exception_type");
-
-                    b.HasKey("ServiceId", "Date");
-
-                    b.ToTable("calendar_dates");
-                });
-
-            modelBuilder.Entity("Costasdev.Busurbano.Database.Gtfs.Route", b =>
-                {
-                    b.Property<string>("Id")
-                        .HasMaxLength(255)
-                        .HasColumnType("varchar(255)")
-                        .HasColumnName("route_id");
-
-                    b.Property<string>("AgencyId")
-                        .IsRequired()
-                        .HasMaxLength(255)
-                        .HasColumnType("varchar(255)")
-                        .HasColumnName("agency_id");
-
-                    b.Property<string>("Color")
-                        .HasMaxLength(7)
-                        .HasColumnType("varchar(7)")
-                        .HasColumnName("route_color");
-
-                    b.Property<string>("Description")
-                        .HasMaxLength(255)
-                        .HasColumnType("varchar(255)")
-                        .HasColumnName("route_desc");
-
-                    b.Property<string>("LongName")
-                        .IsRequired()
-                        .HasMaxLength(255)
-                        .HasColumnType("varchar(255)")
-                        .HasColumnName("route_long_name");
-
-                    b.Property<string>("ShortName")
-                        .IsRequired()
-                        .HasMaxLength(32)
-                        .HasColumnType("varchar(32)")
-                        .HasColumnName("route_short_name");
-
-                    b.Property<int>("SortOrder")
-                        .HasColumnType("int")
-                        .HasColumnName("route_sort_order");
-
-                    b.Property<string>("TextColor")
-                        .HasMaxLength(7)
-                        .HasColumnType("varchar(7)")
-                        .HasColumnName("route_text_color");
-
-                    b.Property<int>("Type")
-                        .HasColumnType("int")
-                        .HasColumnName("route_type");
-
-                    b.Property<string>("Url")
-                        .HasMaxLength(255)
-                        .HasColumnType("varchar(255)")
-                        .HasColumnName("route_url");
-
-                    b.HasKey("Id");
-
-                    b.HasIndex("AgencyId");
-
-                    b.ToTable("routes");
-                });
-
-            modelBuilder.Entity("Costasdev.Busurbano.Database.Gtfs.Stop", b =>
-                {
-                    b.Property<string>("Id")
-                        .HasMaxLength(32)
-                        .HasColumnType("varchar(32)")
-                        .HasColumnName("stop_id");
-
-                    b.Property<string>("Code")
-                        .IsRequired()
-                        .HasMaxLength(32)
-                        .HasColumnType("varchar(32)")
-                        .HasColumnName("stop_code");
-
-                    b.Property<string>("Description")
-                        .HasMaxLength(255)
-                        .HasColumnType("varchar(255)")
-                        .HasColumnName("stop_desc");
-
-                    b.Property<double>("Latitude")
-                        .HasColumnType("double")
-                        .HasColumnName("stop_lat");
-
-                    b.Property<double>("Longitude")
-                        .HasColumnType("double")
-                        .HasColumnName("stop_lon");
-
-                    b.Property<string>("Name")
-                        .IsRequired()
-                        .HasMaxLength(255)
-                        .HasColumnType("varchar(255)")
-                        .HasColumnName("stop_name");
-
-                    b.Property<string>("Timezone")
-                        .HasMaxLength(50)
-                        .HasColumnType("varchar(50)")
-                        .HasColumnName("stop_timezone");
-
-                    b.Property<string>("Url")
-                        .HasMaxLength(255)
-                        .HasColumnType("varchar(255)")
-                        .HasColumnName("stop_url");
-
-                    b.Property<int>("WheelchairBoarding")
-                        .HasColumnType("int")
-                        .HasColumnName("wheelchair_boarding");
-
-                    b.HasKey("Id");
-
-                    b.ToTable("stops");
-                });
-
-            modelBuilder.Entity("Costasdev.Busurbano.Database.Gtfs.StopTime", b =>
-                {
-                    b.Property<string>("TripId")
-                        .HasMaxLength(32)
-                        .HasColumnType("varchar(32)")
-                        .HasColumnName("trip_id");
-
-                    b.Property<int>("StopSequence")
-                        .HasColumnType("int")
-                        .HasColumnName("stop_sequence");
-
-                    b.Property<TimeOnly>("ArrivalTime")
-                        .HasMaxLength(8)
-                        .HasColumnType("varchar(8)")
-                        .HasColumnName("arrival_time");
-
-                    b.Property<TimeOnly>("DepartureTime")
-                        .HasMaxLength(8)
-                        .HasColumnType("varchar(8)")
-                        .HasColumnName("departure_time");
-
-                    b.Property<double?>("ShapeDistTraveled")
-                        .HasColumnType("double")
-                        .HasColumnName("shape_dist_traveled");
-
-                    b.Property<string>("StopId")
-                        .IsRequired()
-                        .HasMaxLength(32)
-                        .HasColumnType("varchar(32)")
-                        .HasColumnName("stop_id");
-
-                    b.HasKey("TripId", "StopSequence");
-
-                    b.HasIndex("StopId");
-
-                    b.ToTable("stop_times");
-                });
-
-            modelBuilder.Entity("Costasdev.Busurbano.Database.Gtfs.Trip", b =>
-                {
-                    b.Property<string>("TripId")
-                        .HasMaxLength(32)
-                        .HasColumnType("varchar(32)")
-                        .HasColumnName("trip_id");
-
-                    b.Property<string>("BlockId")
-                        .HasMaxLength(32)
-                        .HasColumnType("varchar(32)")
-                        .HasColumnName("block_id");
-
-                    b.Property<int>("DirectionId")
-                        .HasColumnType("int")
-                        .HasColumnName("direction_id");
-
-                    b.Property<string>("RouteId")
-                        .IsRequired()
-                        .HasMaxLength(32)
-                        .HasColumnType("varchar(32)")
-                        .HasColumnName("route_id");
-
-                    b.Property<string>("ServiceId")
-                        .IsRequired()
-                        .HasMaxLength(32)
-                        .HasColumnType("varchar(32)")
-                        .HasColumnName("service_id");
-
-                    b.Property<string>("ShapeId")
-                        .HasMaxLength(32)
-                        .HasColumnType("varchar(32)")
-                        .HasColumnName("shape_id");
-
-                    b.Property<int>("TripBikesAllowed")
-                        .ValueGeneratedOnAdd()
-                        .HasColumnType("int")
-                        .HasDefaultValue(0)
-                        .HasColumnName("trip_bikes_allowed");
-
-                    b.Property<string>("TripHeadsign")
-                        .HasMaxLength(255)
-                        .HasColumnType("varchar(255)")
-                        .HasColumnName("trip_headsign");
-
-                    b.Property<string>("TripShortName")
-                        .HasMaxLength(255)
-                        .HasColumnType("varchar(255)")
-                        .HasColumnName("trip_short_name");
-
-                    b.Property<int>("TripWheelchairAccessible")
-                        .ValueGeneratedOnAdd()
-                        .HasColumnType("int")
-                        .HasDefaultValue(0)
-                        .HasColumnName("trip_wheelchair_accessible");
-
-                    b.HasKey("TripId");
-
-                    b.HasIndex("RouteId");
-
-                    b.ToTable("trips");
-                });
-
-            modelBuilder.Entity("Costasdev.Busurbano.Database.Gtfs.Route", b =>
-                {
-                    b.HasOne("Costasdev.Busurbano.Database.Gtfs.Agency", "Agency")
-                        .WithMany()
-                        .HasForeignKey("AgencyId")
-                        .OnDelete(DeleteBehavior.Cascade)
-                        .IsRequired();
-
-                    b.Navigation("Agency");
-                });
-
-            modelBuilder.Entity("Costasdev.Busurbano.Database.Gtfs.StopTime", b =>
-                {
-                    b.HasOne("Costasdev.Busurbano.Database.Gtfs.Stop", "Stop")
-                        .WithMany()
-                        .HasForeignKey("StopId")
-                        .OnDelete(DeleteBehavior.Cascade)
-                        .IsRequired();
-
-                    b.HasOne("Costasdev.Busurbano.Database.Gtfs.Trip", "Trip")
-                        .WithMany()
-                        .HasForeignKey("TripId")
-                        .OnDelete(DeleteBehavior.Cascade)
-                        .IsRequired();
-
-                    b.Navigation("Stop");
-
-                    b.Navigation("Trip");
-                });
-
-            modelBuilder.Entity("Costasdev.Busurbano.Database.Gtfs.Trip", b =>
-                {
-                    b.HasOne("Costasdev.Busurbano.Database.Gtfs.Route", null)
-                        .WithMany()
-                        .HasForeignKey("RouteId")
-                        .OnDelete(DeleteBehavior.Cascade)
-                        .IsRequired();
-                });
-#pragma warning restore 612, 618
-        }
-    }
-}