Rename a lot of stuff, add Santiago real time

14 files changed, 0 insertions, 411 deletions

diff --git a/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/Enums/DirectionId.cs b/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/Enums/DirectionId.cs
deleted file mode 100644
index cbcf80b..0000000
--- a/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/Enums/DirectionId.cs
+++ /dev/null
@@ -1,7 +0,0 @@
-namespace Costasdev.ServiceViewer.Data.Gtfs.Enums;
-
-public enum DirectionId
-{
-    Outbound = 0,
-    Inbound = 1
-}
diff --git a/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/Enums/ExceptionType.cs b/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/Enums/ExceptionType.cs
deleted file mode 100644
index 0ad0345..0000000
--- a/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/Enums/ExceptionType.cs
+++ /dev/null
@@ -1,7 +0,0 @@
-namespace Costasdev.ServiceViewer.Data.Gtfs.Enums;
-
-public enum ExceptionType
-{
-    Added = 1,
-    Removed = 2
-}
diff --git a/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/Enums/RouteType.cs b/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/Enums/RouteType.cs
deleted file mode 100644
index e19d02a..0000000
--- a/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/Enums/RouteType.cs
+++ /dev/null
@@ -1,15 +0,0 @@
-namespace Costasdev.ServiceViewer.Data.Gtfs.Enums;
-
-public enum RouteType
-{
-    Tram = 0,
-    Subway = 1,
-    Rail = 2,
-    Bus = 3,
-    Ferry = 4,
-    CableTram = 5,
-    AerialLift = 6,
-    Funicular = 7,
-    Trolleybus = 11,
-    Monorail = 12
-}
diff --git a/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/Enums/TripBikesAllowed.cs b/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/Enums/TripBikesAllowed.cs
deleted file mode 100644
index 838bc81..0000000
--- a/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/Enums/TripBikesAllowed.cs
+++ /dev/null
@@ -1,8 +0,0 @@
-namespace Costasdev.ServiceViewer.Data.Gtfs.Enums;
-
-public enum TripBikesAllowed
-{
-    Empty = 0,
-    CanAccommodate = 1,
-    NotAllowed = 2
-}
diff --git a/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/Enums/TripWheelchairAccessible.cs b/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/Enums/TripWheelchairAccessible.cs
deleted file mode 100644
index e84b699..0000000
--- a/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/Enums/TripWheelchairAccessible.cs
+++ /dev/null
@@ -1,8 +0,0 @@
-namespace Costasdev.ServiceViewer.Data.Gtfs.Enums;
-
-public enum TripWheelchairAccessible
-{
-    Empty = 0,
-    CanAccommodate = 1,
-    NotAccessible = 2
-}
diff --git a/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/Enums/WheelchairBoarding.cs b/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/Enums/WheelchairBoarding.cs
deleted file mode 100644
index 3cc550f..0000000
--- a/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/Enums/WheelchairBoarding.cs
+++ /dev/null
@@ -1,8 +0,0 @@
-namespace Costasdev.ServiceViewer.Data.Gtfs.Enums;
-
-public enum WheelchairBoarding
-{
-    Unknown = 0,
-    SomeVehicles = 1,
-    NotPossible = 2
-}
diff --git a/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/Feed.cs b/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/Feed.cs
deleted file mode 100644
index 065250b..0000000
--- a/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/Feed.cs
+++ /dev/null
@@ -1,21 +0,0 @@
-using System.ComponentModel.DataAnnotations;
-using System.ComponentModel.DataAnnotations.Schema;
-
-namespace Costasdev.ServiceViewer.Data.Gtfs;
-
-[Table("feeds")]
-public class Feed
-{
-    /// <summary>
-    /// Auto-incrementing ID value for each feed, to identify it and its version
-    /// </summary>
-    [Key]
-    public int Id { get; set; }
-
-    [MaxLength(32)] public string ShortName { get; set; }
-    [MaxLength(32)] public string LongName { get; set; }
-    [MaxLength(255)] public string DownloadUrl { get; set; }
-    [MaxLength(32)] public string Etag { get; set; }
-
-    public DateTime InsertedAt { get; set; }
-}
diff --git a/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/GtfsAgency.cs b/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/GtfsAgency.cs
deleted file mode 100644
index 89b5518..0000000
--- a/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/GtfsAgency.cs
+++ /dev/null
@@ -1,46 +0,0 @@
-using System.ComponentModel.DataAnnotations;
-using System.ComponentModel.DataAnnotations.Schema;
-using Microsoft.EntityFrameworkCore;
-
-namespace Costasdev.ServiceViewer.Data.Gtfs;
-
-[Table("gtfs_agencies")]
-[PrimaryKey(nameof(Id), nameof(FeedId))]
-public class GtfsAgency
-{
-    [Key]
-    [Column("agency_id")]
-    [MaxLength(255)]
-    public required string Id { get; set; }
-
-    [Column("feed_id")] public int FeedId { get; set; }
-    [ForeignKey(nameof(FeedId))] public required Feed Feed { get; set; }
-
-    [Column("agency_name")]
-    [MaxLength(255)]
-    public string Name { get; set; } = string.Empty;
-
-    [Column("agency_url")]
-    [MaxLength(255)]
-    public string Url { get; set; } = string.Empty;
-
-    [Column("agency_timezone")]
-    [MaxLength(50)]
-    public string Timezone { get; set; } = string.Empty;
-
-    [Column("agency_lang")]
-    [MaxLength(5)]
-    public string Language { get; set; } = string.Empty;
-
-    [Column("agency_phone")]
-    [MaxLength(30)]
-    public string? Phone { get; set; } = string.Empty;
-
-    [Column("agency_email")]
-    [MaxLength(255)]
-    public string? Email { get; set; } = string.Empty;
-
-    [Column("agency_fare_url")]
-    [MaxLength(255)]
-    public string? FareUrl { get; set; } = string.Empty;
-}
diff --git a/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/GtfsCalendar.cs b/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/GtfsCalendar.cs
deleted file mode 100644
index cfb144c..0000000
--- a/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/GtfsCalendar.cs
+++ /dev/null
@@ -1,45 +0,0 @@
-using System.ComponentModel.DataAnnotations;
-using System.ComponentModel.DataAnnotations.Schema;
-using Microsoft.EntityFrameworkCore;
-
-namespace Costasdev.ServiceViewer.Data.Gtfs;
-
-[Table("gtfs_calendar")]
-[PrimaryKey(nameof(ServiceId), nameof(FeedId))]
-public class GtfsCalendar
-{
-    [Key]
-    [Column("service_id")]
-    [MaxLength(32)]
-    public string ServiceId { get; set; } = null!;
-
-    [Column("feed_id")] public int FeedId { get; set; }
-    [ForeignKey(nameof(FeedId))] public required Feed Feed { get; set; }
-
-    [Column("monday")]
-    public bool Monday { get; set; }
-
-    [Column("tuesday")]
-    public bool Tuesday { get; set; }
-
-    [Column("wednesday")]
-    public bool Wednesday { get; set; }
-
-    [Column("thursday")]
-    public bool Thursday { get; set; }
-
-    [Column("friday")]
-    public bool Friday { get; set; }
-
-    [Column("saturday")]
-    public bool Saturday { get; set; }
-
-    [Column("sunday")]
-    public bool Sunday { get; set; }
-
-    [Column("start_date")]
-    public DateOnly StartDate { get; set; }
-
-    [Column("end_date")]
-    public DateOnly EndDate { get; set; }
-}
diff --git a/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/GtfsCalendarDate.cs b/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/GtfsCalendarDate.cs
deleted file mode 100644
index 1543ef5..0000000
--- a/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/GtfsCalendarDate.cs
+++ /dev/null
@@ -1,24 +0,0 @@
-using System.ComponentModel.DataAnnotations;
-using System.ComponentModel.DataAnnotations.Schema;
-using Costasdev.ServiceViewer.Data.Gtfs.Enums;
-using Microsoft.EntityFrameworkCore;
-
-namespace Costasdev.ServiceViewer.Data.Gtfs;
-
-[Table("gtfs_calendar_dates")]
-[PrimaryKey(nameof(ServiceId), nameof(Date), nameof(FeedId))]
-public class GtfsCalendarDate
-{
-    [Column("service_id")]
-    [MaxLength(32)]
-    public required string ServiceId { get; set; }
-
-    [Column("date")]
-    public required DateTime Date { get; set; }
-
-    [Column("feed_id")] public int FeedId { get; set; }
-    [ForeignKey(nameof(FeedId))] public required Feed Feed { get; set; }
-
-    [Column("exception_type")]
-    public required ExceptionType ExceptionType { get; set; }
-}
diff --git a/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/GtfsRoute.cs b/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/GtfsRoute.cs
deleted file mode 100644
index c34353c..0000000
--- a/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/GtfsRoute.cs
+++ /dev/null
@@ -1,70 +0,0 @@
-using System.ComponentModel.DataAnnotations;
-using System.ComponentModel.DataAnnotations.Schema;
-using Costasdev.ServiceViewer.Data.Gtfs.Enums;
-using Microsoft.EntityFrameworkCore;
-
-namespace Costasdev.ServiceViewer.Data.Gtfs;
-
-[Table("gtfs_routes")]
-[PrimaryKey(nameof(Id), nameof(FeedId))]
-public class GtfsRoute
-{
-    [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(Agency))]
-    [MaxLength(255)]
-    public required string AgencyId { get; set; }
-
-    [ForeignKey(nameof(AgencyId))]
-    public GtfsAgency Agency { get; set; } = null!;
-
-    /// <summary>
-    /// Short name of a route. Often a short, abstract identifier (e.g., "32", "100X", "Green")
-    /// that riders use to identify a route. Both route_short_name and route_long_name may be defined.
-    /// </summary>
-    [Column("route_short_name")]
-    [MaxLength(32)]
-    public string ShortName { get; set; } = string.Empty;
-
-    /// <summary>
-    /// Full name of a route. This name is generally more descriptive than the route_short_name and often
-    /// includes the route's destination or stop. Both route_short_name and route_long_name may be defined.
-    /// </summary>
-    [Column("route_long_name")]
-    [MaxLength(255)]
-    public string LongName { get; set; } = string.Empty;
-
-    [Column("route_desc")]
-    [MaxLength(255)]
-    public string? Description { get; set; } = string.Empty;
-
-    [Column("route_type")]
-    public RouteType Type { get; set; } = RouteType.Bus;
-
-    [Column("route_url")]
-    [MaxLength(255)]
-    public string? Url { get; set; } = string.Empty;
-
-    [Column("route_color")]
-    [MaxLength(7)]
-    public string? Color { get; set; } = string.Empty;
-
-    [Column("route_text_color")]
-    [MaxLength(7)]
-    public string? TextColor { get; set; } = string.Empty;
-
-    /// <summary>
-    /// Orders the routes in a way which is ideal for presentation to customers.
-    /// Routes with smaller route_sort_order values should be displayed first.
-    /// </summary>
-    [Column("route_sort_order")]
-    public int SortOrder { get; set; } = 1;
-}
diff --git a/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/GtfsStop.cs b/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/GtfsStop.cs
deleted file mode 100644
index f604c5f..0000000
--- a/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/GtfsStop.cs
+++ /dev/null
@@ -1,51 +0,0 @@
-using System.ComponentModel.DataAnnotations;
-using System.ComponentModel.DataAnnotations.Schema;
-using Costasdev.ServiceViewer.Data.Gtfs.Enums;
-using Microsoft.EntityFrameworkCore;
-using NetTopologySuite.Geometries;
-
-namespace Costasdev.ServiceViewer.Data.Gtfs;
-
-[Table("gtfs_stops")]
-[PrimaryKey(nameof(Id), nameof(FeedId))]
-public class GtfsStop
-{
-    [Column("stop_id")]
-    [MaxLength(32)]
-    public required string Id { get; set; }
-
-    [Column("feed_id")]public int FeedId { get; set; }
-    [ForeignKey(nameof(FeedId))] public required Feed Feed { get; set; }
-
-    [Column("stop_code")]
-    [MaxLength(32)]
-    public string Code { get; set; } = string.Empty;
-
-    [Column("stop_name")]
-    [MaxLength(255)]
-    public string Name { get; set; } = string.Empty;
-
-    [Column("stop_desc")]
-    [MaxLength(255)]
-    public string? Description { get; set; }
-
-    [Column("stop_pos")]
-    public Point? Position { get; set; }
-
-    [Column("stop_url")]
-    [MaxLength(255)]
-    public string? Url { get; set; }
-
-    [Column("stop_timezone")]
-    [MaxLength(50)]
-    public string? Timezone { get; set; }
-
-    [Column("wheelchair_boarding")]
-    public WheelchairBoarding WheelchairBoarding { get; set; } = WheelchairBoarding.Unknown;
-
-    // [Column("location_type")]
-    // public int LocationType { get; set; }
-    //
-    // [Column("parent_station")]
-    // public int? ParentStationId { get; set; }
-}
diff --git a/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/GtfsStopTime.cs b/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/GtfsStopTime.cs
deleted file mode 100644
index 9599947..0000000
--- a/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/GtfsStopTime.cs
+++ /dev/null
@@ -1,44 +0,0 @@
-using System.ComponentModel.DataAnnotations;
-using System.ComponentModel.DataAnnotations.Schema;
-using Costasdev.ServiceViewer.Data.Extensions;
-using Microsoft.EntityFrameworkCore;
-
-namespace Costasdev.ServiceViewer.Data.Gtfs;
-
-[Table("gtfs_stop_times")]
-[PrimaryKey(nameof(TripId), nameof(StopSequence), nameof(FeedId))]
-public class GtfsStopTime
-{
-    [Column("trip_id")]
-    [ForeignKey("TripId")]
-    [MaxLength(32)]
-    public string TripId { get; set; } = null!;
-
-    [Column("feed_id")]public int FeedId { get; set; }
-    [ForeignKey(nameof(FeedId))] public required Feed Feed { get; set; }
-
-    [ForeignKey(nameof(TripId))] public GtfsTrip GtfsTrip { get; set; } = null!;
-
-    [Column("arrival_time")] public string Arrival { get; set; }
-    public TimeSpan ArrivalTime => TimeSpan.FromGtfsTime(Arrival);
-
-    [Column("departure_time")] public string Departure { get; set; }
-    public TimeSpan DepartureTime => TimeSpan.FromGtfsTime(Departure);
-
-    [Column("stop_id")]
-    [ForeignKey(nameof(GtfsStop))]
-    [MaxLength(32)]
-    public required string StopId { get; set; }
-
-    [ForeignKey(nameof(StopId))] public GtfsStop GtfsStop { get; set; } = null!;
-
-    [Column("stop_sequence")] public int StopSequence { get; set; } = 0;
-
-    // [Column("pickup_type")]
-    // public int? PickupType { get; set; }
-    //
-    // [Column("drop_off_type")]
-    // public int? DropOffType { get; set; }
-
-    [Column("shape_dist_traveled")] public double? ShapeDistTraveled { get; set; } = null!;
-}
diff --git a/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/GtfsTrip.cs b/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/GtfsTrip.cs
deleted file mode 100644
index 3614120..0000000
--- a/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/GtfsTrip.cs
+++ /dev/null
@@ -1,57 +0,0 @@
-using System.ComponentModel.DataAnnotations;
-using System.ComponentModel.DataAnnotations.Schema;
-using Costasdev.ServiceViewer.Data.Gtfs.Enums;
-using Microsoft.EntityFrameworkCore;
-
-namespace Costasdev.ServiceViewer.Data.Gtfs;
-
-[Table("gtfs_trips")]
-[PrimaryKey(nameof(Id), nameof(FeedId))]
-public class GtfsTrip
-{
-    [Column("trip_id")] [MaxLength(32)] public string Id { get; set; } = null!;
-
-    [Column("feed_id")] public int FeedId { get; set; }
-    [ForeignKey(nameof(FeedId))] public required Feed Feed { get; set; }
-
-    [Column("route_id")]
-    [MaxLength(32)]
-    [ForeignKey(nameof(Route))]
-    public string RouteId { get; set; } = null!;
-
-    [ForeignKey(nameof(RouteId))] public GtfsRoute Route { get; set; } = null!;
-
-    [Column("service_id")] [MaxLength(32)] public string ServiceId { get; set; } = null!;
-
-    [Column("trip_headsign")]
-    [MaxLength(255)]
-    public string? TripHeadsign { get; set; }
-
-    [Column("trip_short_name")]
-    [MaxLength(255)]
-    public string? TripShortName { get; set; }
-
-    [Column("direction_id")] public DirectionId DirectionId { get; set; } = DirectionId.Outbound;
-
-    /// <summary>
-    /// Identifies the block to which the trip belongs. A block consists of a single trip or many
-    /// sequential trips made using the same vehicle, defined by shared service days and block_id.
-    /// A block_id may have trips with different service days, making distinct blocks.
-    /// </summary>
-    [Column("block_id")]
-    [MaxLength(32)]
-    public string? BlockId { get; set; }
-
-    /// <summary>
-    /// Identifies a geospatial shape describing the vehicle travel path for a trip.
-    /// </summary>
-    /// <remarks>To be implemented: will be stored as a GeoJSON file instead of database records.</remarks>
-    [Column("shape_id")]
-    [MaxLength(32)]
-    public string? ShapeId { get; set; }
-
-    [Column("trip_wheelchair_accessible")]
-    public TripWheelchairAccessible TripWheelchairAccessible { get; set; } = TripWheelchairAccessible.Empty;
-
-    [Column("trip_bikes_allowed")] public TripBikesAllowed TripBikesAllowed { get; set; } = TripBikesAllowed.Empty;
-}