diff options
Diffstat (limited to 'src/Costasdev.Busurbano.ServiceViewer/Data/Migrations')
3 files changed, 0 insertions, 1409 deletions
diff --git a/src/Costasdev.Busurbano.ServiceViewer/Data/Migrations/20251211153852_Initial.Designer.cs b/src/Costasdev.Busurbano.ServiceViewer/Data/Migrations/20251211153852_Initial.Designer.cs deleted file mode 100644 index 79f3e87..0000000 --- a/src/Costasdev.Busurbano.ServiceViewer/Data/Migrations/20251211153852_Initial.Designer.cs +++ /dev/null @@ -1,547 +0,0 @@ -// <auto-generated /> -using System; -using Costasdev.ServiceViewer.Data; -using Microsoft.EntityFrameworkCore; -using Microsoft.EntityFrameworkCore.Infrastructure; -using Microsoft.EntityFrameworkCore.Migrations; -using Microsoft.EntityFrameworkCore.Storage.ValueConversion; -using NetTopologySuite.Geometries; -using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata; - -#nullable disable - -namespace Data.Migrations -{ - [DbContext(typeof(AppDbContext))] - [Migration("20251211153852_Initial")] - partial class Initial - { - /// <inheritdoc /> - protected override void BuildTargetModel(ModelBuilder modelBuilder) - { -#pragma warning disable 612, 618 - modelBuilder - .HasAnnotation("ProductVersion", "10.0.1") - .HasAnnotation("Relational:MaxIdentifierLength", 63); - - NpgsqlModelBuilderExtensions.HasPostgresExtension(modelBuilder, "postgis"); - NpgsqlModelBuilderExtensions.UseIdentityByDefaultColumns(modelBuilder); - - modelBuilder.Entity("Costasdev.ServiceViewer.Data.Gtfs.Feed", b => - { - b.Property<int>("Id") - .ValueGeneratedOnAdd() - .HasColumnType("integer"); - - NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id")); - - b.Property<string>("DownloadUrl") - .IsRequired() - .HasMaxLength(255) - .HasColumnType("character varying(255)"); - - b.Property<string>("Etag") - .IsRequired() - .HasMaxLength(32) - .HasColumnType("character varying(32)"); - - b.Property<DateTime>("InsertedAt") - .HasColumnType("timestamp with time zone"); - - b.Property<string>("LongName") - .IsRequired() - .HasMaxLength(32) - .HasColumnType("character varying(32)"); - - b.Property<string>("ShortName") - .IsRequired() - .HasMaxLength(32) - .HasColumnType("character varying(32)"); - - b.HasKey("Id"); - - b.ToTable("feeds"); - }); - - modelBuilder.Entity("Costasdev.ServiceViewer.Data.Gtfs.GtfsAgency", b => - { - b.Property<string>("Id") - .HasMaxLength(255) - .HasColumnType("character varying(255)") - .HasColumnName("agency_id"); - - b.Property<int>("FeedId") - .HasColumnType("integer") - .HasColumnName("feed_id"); - - b.Property<string>("Email") - .HasMaxLength(255) - .HasColumnType("character varying(255)") - .HasColumnName("agency_email"); - - b.Property<string>("FareUrl") - .HasMaxLength(255) - .HasColumnType("character varying(255)") - .HasColumnName("agency_fare_url"); - - b.Property<string>("Language") - .IsRequired() - .HasMaxLength(5) - .HasColumnType("character varying(5)") - .HasColumnName("agency_lang"); - - b.Property<string>("Name") - .IsRequired() - .HasMaxLength(255) - .HasColumnType("character varying(255)") - .HasColumnName("agency_name"); - - b.Property<string>("Phone") - .HasMaxLength(30) - .HasColumnType("character varying(30)") - .HasColumnName("agency_phone"); - - b.Property<string>("Timezone") - .IsRequired() - .HasMaxLength(50) - .HasColumnType("character varying(50)") - .HasColumnName("agency_timezone"); - - b.Property<string>("Url") - .IsRequired() - .HasMaxLength(255) - .HasColumnType("character varying(255)") - .HasColumnName("agency_url"); - - b.HasKey("Id", "FeedId"); - - b.HasIndex("FeedId"); - - b.ToTable("gtfs_agencies"); - }); - - modelBuilder.Entity("Costasdev.ServiceViewer.Data.Gtfs.GtfsCalendar", b => - { - b.Property<string>("ServiceId") - .HasMaxLength(32) - .HasColumnType("character varying(32)") - .HasColumnName("service_id"); - - b.Property<int>("FeedId") - .HasColumnType("integer") - .HasColumnName("feed_id"); - - b.Property<DateOnly>("EndDate") - .HasColumnType("date") - .HasColumnName("end_date"); - - b.Property<bool>("Friday") - .HasColumnType("boolean") - .HasColumnName("friday"); - - b.Property<bool>("Monday") - .HasColumnType("boolean") - .HasColumnName("monday"); - - b.Property<bool>("Saturday") - .HasColumnType("boolean") - .HasColumnName("saturday"); - - b.Property<DateOnly>("StartDate") - .HasColumnType("date") - .HasColumnName("start_date"); - - b.Property<bool>("Sunday") - .HasColumnType("boolean") - .HasColumnName("sunday"); - - b.Property<bool>("Thursday") - .HasColumnType("boolean") - .HasColumnName("thursday"); - - b.Property<bool>("Tuesday") - .HasColumnType("boolean") - .HasColumnName("tuesday"); - - b.Property<bool>("Wednesday") - .HasColumnType("boolean") - .HasColumnName("wednesday"); - - b.HasKey("ServiceId", "FeedId"); - - b.HasIndex("FeedId"); - - b.ToTable("gtfs_calendar"); - }); - - modelBuilder.Entity("Costasdev.ServiceViewer.Data.Gtfs.GtfsCalendarDate", b => - { - b.Property<string>("ServiceId") - .HasMaxLength(32) - .HasColumnType("character varying(32)") - .HasColumnName("service_id"); - - b.Property<DateTime>("Date") - .HasColumnType("timestamp with time zone") - .HasColumnName("date"); - - b.Property<int>("FeedId") - .HasColumnType("integer") - .HasColumnName("feed_id"); - - b.Property<int>("ExceptionType") - .HasColumnType("integer") - .HasColumnName("exception_type"); - - b.HasKey("ServiceId", "Date", "FeedId"); - - b.HasIndex("FeedId"); - - b.ToTable("gtfs_calendar_dates"); - }); - - modelBuilder.Entity("Costasdev.ServiceViewer.Data.Gtfs.GtfsRoute", b => - { - b.Property<string>("Id") - .HasMaxLength(255) - .HasColumnType("character varying(255)") - .HasColumnName("route_id"); - - b.Property<int>("FeedId") - .HasColumnType("integer") - .HasColumnName("feed_id"); - - b.Property<string>("AgencyId") - .IsRequired() - .HasMaxLength(255) - .HasColumnType("character varying(255)") - .HasColumnName("agency_id"); - - b.Property<string>("Color") - .HasMaxLength(7) - .HasColumnType("character varying(7)") - .HasColumnName("route_color"); - - b.Property<string>("Description") - .HasMaxLength(255) - .HasColumnType("character varying(255)") - .HasColumnName("route_desc"); - - b.Property<string>("LongName") - .IsRequired() - .HasMaxLength(255) - .HasColumnType("character varying(255)") - .HasColumnName("route_long_name"); - - b.Property<string>("ShortName") - .IsRequired() - .HasMaxLength(32) - .HasColumnType("character varying(32)") - .HasColumnName("route_short_name"); - - b.Property<int>("SortOrder") - .HasColumnType("integer") - .HasColumnName("route_sort_order"); - - b.Property<string>("TextColor") - .HasMaxLength(7) - .HasColumnType("character varying(7)") - .HasColumnName("route_text_color"); - - b.Property<int>("Type") - .HasColumnType("integer") - .HasColumnName("route_type"); - - b.Property<string>("Url") - .HasMaxLength(255) - .HasColumnType("character varying(255)") - .HasColumnName("route_url"); - - b.HasKey("Id", "FeedId"); - - b.HasIndex("FeedId"); - - b.HasIndex("AgencyId", "FeedId"); - - b.ToTable("gtfs_routes"); - }); - - modelBuilder.Entity("Costasdev.ServiceViewer.Data.Gtfs.GtfsStop", b => - { - b.Property<string>("Id") - .HasMaxLength(32) - .HasColumnType("character varying(32)") - .HasColumnName("stop_id"); - - b.Property<int>("FeedId") - .HasColumnType("integer") - .HasColumnName("feed_id"); - - b.Property<string>("Code") - .IsRequired() - .HasMaxLength(32) - .HasColumnType("character varying(32)") - .HasColumnName("stop_code"); - - b.Property<string>("Description") - .HasMaxLength(255) - .HasColumnType("character varying(255)") - .HasColumnName("stop_desc"); - - b.Property<string>("Name") - .IsRequired() - .HasMaxLength(255) - .HasColumnType("character varying(255)") - .HasColumnName("stop_name"); - - b.Property<Point>("Position") - .HasColumnType("geometry") - .HasColumnName("stop_pos"); - - b.Property<string>("Timezone") - .HasMaxLength(50) - .HasColumnType("character varying(50)") - .HasColumnName("stop_timezone"); - - b.Property<string>("Url") - .HasMaxLength(255) - .HasColumnType("character varying(255)") - .HasColumnName("stop_url"); - - b.Property<int>("WheelchairBoarding") - .HasColumnType("integer") - .HasColumnName("wheelchair_boarding"); - - b.HasKey("Id", "FeedId"); - - b.HasIndex("FeedId"); - - b.ToTable("gtfs_stops"); - }); - - modelBuilder.Entity("Costasdev.ServiceViewer.Data.Gtfs.GtfsStopTime", b => - { - b.Property<string>("TripId") - .HasMaxLength(32) - .HasColumnType("character varying(32)") - .HasColumnName("trip_id"); - - b.Property<int>("StopSequence") - .HasColumnType("integer") - .HasColumnName("stop_sequence"); - - b.Property<int>("FeedId") - .HasColumnType("integer") - .HasColumnName("feed_id"); - - b.Property<string>("Arrival") - .IsRequired() - .HasColumnType("text") - .HasColumnName("arrival_time"); - - b.Property<string>("Departure") - .IsRequired() - .HasColumnType("text") - .HasColumnName("departure_time"); - - b.Property<double?>("ShapeDistTraveled") - .HasColumnType("double precision") - .HasColumnName("shape_dist_traveled"); - - b.Property<string>("StopId") - .IsRequired() - .HasMaxLength(32) - .HasColumnType("character varying(32)") - .HasColumnName("stop_id"); - - b.HasKey("TripId", "StopSequence", "FeedId"); - - b.HasIndex("FeedId"); - - b.HasIndex("StopId", "FeedId"); - - b.HasIndex("TripId", "FeedId"); - - b.ToTable("gtfs_stop_times"); - }); - - modelBuilder.Entity("Costasdev.ServiceViewer.Data.Gtfs.GtfsTrip", b => - { - b.Property<string>("Id") - .HasMaxLength(32) - .HasColumnType("character varying(32)") - .HasColumnName("trip_id"); - - b.Property<int>("FeedId") - .HasColumnType("integer") - .HasColumnName("feed_id"); - - b.Property<string>("BlockId") - .HasMaxLength(32) - .HasColumnType("character varying(32)") - .HasColumnName("block_id"); - - b.Property<int>("DirectionId") - .HasColumnType("integer") - .HasColumnName("direction_id"); - - b.Property<string>("RouteId") - .IsRequired() - .HasMaxLength(32) - .HasColumnType("character varying(32)") - .HasColumnName("route_id"); - - b.Property<string>("ServiceId") - .IsRequired() - .HasMaxLength(32) - .HasColumnType("character varying(32)") - .HasColumnName("service_id"); - - b.Property<string>("ShapeId") - .HasMaxLength(32) - .HasColumnType("character varying(32)") - .HasColumnName("shape_id"); - - b.Property<int>("TripBikesAllowed") - .ValueGeneratedOnAdd() - .HasColumnType("integer") - .HasDefaultValue(0) - .HasColumnName("trip_bikes_allowed"); - - b.Property<string>("TripHeadsign") - .HasMaxLength(255) - .HasColumnType("character varying(255)") - .HasColumnName("trip_headsign"); - - b.Property<string>("TripShortName") - .HasMaxLength(255) - .HasColumnType("character varying(255)") - .HasColumnName("trip_short_name"); - - b.Property<int>("TripWheelchairAccessible") - .ValueGeneratedOnAdd() - .HasColumnType("integer") - .HasDefaultValue(0) - .HasColumnName("trip_wheelchair_accessible"); - - b.HasKey("Id", "FeedId"); - - b.HasIndex("FeedId"); - - b.HasIndex("RouteId", "FeedId"); - - b.ToTable("gtfs_trips"); - }); - - modelBuilder.Entity("Costasdev.ServiceViewer.Data.Gtfs.GtfsAgency", b => - { - b.HasOne("Costasdev.ServiceViewer.Data.Gtfs.Feed", "Feed") - .WithMany() - .HasForeignKey("FeedId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.Navigation("Feed"); - }); - - modelBuilder.Entity("Costasdev.ServiceViewer.Data.Gtfs.GtfsCalendar", b => - { - b.HasOne("Costasdev.ServiceViewer.Data.Gtfs.Feed", "Feed") - .WithMany() - .HasForeignKey("FeedId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.Navigation("Feed"); - }); - - modelBuilder.Entity("Costasdev.ServiceViewer.Data.Gtfs.GtfsCalendarDate", b => - { - b.HasOne("Costasdev.ServiceViewer.Data.Gtfs.Feed", "Feed") - .WithMany() - .HasForeignKey("FeedId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.Navigation("Feed"); - }); - - modelBuilder.Entity("Costasdev.ServiceViewer.Data.Gtfs.GtfsRoute", b => - { - b.HasOne("Costasdev.ServiceViewer.Data.Gtfs.Feed", "Feed") - .WithMany() - .HasForeignKey("FeedId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.HasOne("Costasdev.ServiceViewer.Data.Gtfs.GtfsAgency", "Agency") - .WithMany() - .HasForeignKey("AgencyId", "FeedId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.Navigation("Agency"); - - b.Navigation("Feed"); - }); - - modelBuilder.Entity("Costasdev.ServiceViewer.Data.Gtfs.GtfsStop", b => - { - b.HasOne("Costasdev.ServiceViewer.Data.Gtfs.Feed", "Feed") - .WithMany() - .HasForeignKey("FeedId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.Navigation("Feed"); - }); - - modelBuilder.Entity("Costasdev.ServiceViewer.Data.Gtfs.GtfsStopTime", b => - { - b.HasOne("Costasdev.ServiceViewer.Data.Gtfs.Feed", "Feed") - .WithMany() - .HasForeignKey("FeedId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.HasOne("Costasdev.ServiceViewer.Data.Gtfs.GtfsStop", "GtfsStop") - .WithMany() - .HasForeignKey("StopId", "FeedId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.HasOne("Costasdev.ServiceViewer.Data.Gtfs.GtfsTrip", "GtfsTrip") - .WithMany() - .HasForeignKey("TripId", "FeedId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.Navigation("Feed"); - - b.Navigation("GtfsStop"); - - b.Navigation("GtfsTrip"); - }); - - modelBuilder.Entity("Costasdev.ServiceViewer.Data.Gtfs.GtfsTrip", b => - { - b.HasOne("Costasdev.ServiceViewer.Data.Gtfs.Feed", "Feed") - .WithMany() - .HasForeignKey("FeedId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.HasOne("Costasdev.ServiceViewer.Data.Gtfs.GtfsRoute", "Route") - .WithMany() - .HasForeignKey("RouteId", "FeedId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.Navigation("Feed"); - - b.Navigation("Route"); - }); -#pragma warning restore 612, 618 - } - } -} diff --git a/src/Costasdev.Busurbano.ServiceViewer/Data/Migrations/20251211153852_Initial.cs b/src/Costasdev.Busurbano.ServiceViewer/Data/Migrations/20251211153852_Initial.cs deleted file mode 100644 index 5a75d40..0000000 --- a/src/Costasdev.Busurbano.ServiceViewer/Data/Migrations/20251211153852_Initial.cs +++ /dev/null @@ -1,318 +0,0 @@ -using System; -using Microsoft.EntityFrameworkCore.Migrations; -using NetTopologySuite.Geometries; -using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata; - -#nullable disable - -namespace Data.Migrations -{ - /// <inheritdoc /> - public partial class Initial : Migration - { - /// <inheritdoc /> - protected override void Up(MigrationBuilder migrationBuilder) - { - migrationBuilder.AlterDatabase() - .Annotation("Npgsql:PostgresExtension:postgis", ",,"); - - migrationBuilder.CreateTable( - name: "feeds", - columns: table => new - { - Id = table.Column<int>(type: "integer", nullable: false) - .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn), - ShortName = table.Column<string>(type: "character varying(32)", maxLength: 32, nullable: false), - LongName = table.Column<string>(type: "character varying(32)", maxLength: 32, nullable: false), - DownloadUrl = table.Column<string>(type: "character varying(255)", maxLength: 255, nullable: false), - Etag = table.Column<string>(type: "character varying(32)", maxLength: 32, nullable: false), - InsertedAt = table.Column<DateTime>(type: "timestamp with time zone", nullable: false) - }, - constraints: table => - { - table.PrimaryKey("PK_feeds", x => x.Id); - }); - - migrationBuilder.CreateTable( - name: "gtfs_agencies", - columns: table => new - { - agency_id = table.Column<string>(type: "character varying(255)", maxLength: 255, nullable: false), - feed_id = table.Column<int>(type: "integer", nullable: false), - agency_name = table.Column<string>(type: "character varying(255)", maxLength: 255, nullable: false), - agency_url = table.Column<string>(type: "character varying(255)", maxLength: 255, nullable: false), - agency_timezone = table.Column<string>(type: "character varying(50)", maxLength: 50, nullable: false), - agency_lang = table.Column<string>(type: "character varying(5)", maxLength: 5, nullable: false), - agency_phone = table.Column<string>(type: "character varying(30)", maxLength: 30, nullable: true), - agency_email = table.Column<string>(type: "character varying(255)", maxLength: 255, nullable: true), - agency_fare_url = table.Column<string>(type: "character varying(255)", maxLength: 255, nullable: true) - }, - constraints: table => - { - table.PrimaryKey("PK_gtfs_agencies", x => new { x.agency_id, x.feed_id }); - table.ForeignKey( - name: "FK_gtfs_agencies_feeds_feed_id", - column: x => x.feed_id, - principalTable: "feeds", - principalColumn: "Id", - onDelete: ReferentialAction.Cascade); - }); - - migrationBuilder.CreateTable( - name: "gtfs_calendar", - columns: table => new - { - service_id = table.Column<string>(type: "character varying(32)", maxLength: 32, nullable: false), - feed_id = table.Column<int>(type: "integer", nullable: false), - monday = table.Column<bool>(type: "boolean", nullable: false), - tuesday = table.Column<bool>(type: "boolean", nullable: false), - wednesday = table.Column<bool>(type: "boolean", nullable: false), - thursday = table.Column<bool>(type: "boolean", nullable: false), - friday = table.Column<bool>(type: "boolean", nullable: false), - saturday = table.Column<bool>(type: "boolean", nullable: false), - sunday = table.Column<bool>(type: "boolean", nullable: false), - start_date = table.Column<DateOnly>(type: "date", nullable: false), - end_date = table.Column<DateOnly>(type: "date", nullable: false) - }, - constraints: table => - { - table.PrimaryKey("PK_gtfs_calendar", x => new { x.service_id, x.feed_id }); - table.ForeignKey( - name: "FK_gtfs_calendar_feeds_feed_id", - column: x => x.feed_id, - principalTable: "feeds", - principalColumn: "Id", - onDelete: ReferentialAction.Cascade); - }); - - migrationBuilder.CreateTable( - name: "gtfs_calendar_dates", - columns: table => new - { - service_id = table.Column<string>(type: "character varying(32)", maxLength: 32, nullable: false), - date = table.Column<DateTime>(type: "timestamp with time zone", nullable: false), - feed_id = table.Column<int>(type: "integer", nullable: false), - exception_type = table.Column<int>(type: "integer", nullable: false) - }, - constraints: table => - { - table.PrimaryKey("PK_gtfs_calendar_dates", x => new { x.service_id, x.date, x.feed_id }); - table.ForeignKey( - name: "FK_gtfs_calendar_dates_feeds_feed_id", - column: x => x.feed_id, - principalTable: "feeds", - principalColumn: "Id", - onDelete: ReferentialAction.Cascade); - }); - - migrationBuilder.CreateTable( - name: "gtfs_stops", - columns: table => new - { - stop_id = table.Column<string>(type: "character varying(32)", maxLength: 32, nullable: false), - feed_id = table.Column<int>(type: "integer", nullable: false), - stop_code = table.Column<string>(type: "character varying(32)", maxLength: 32, nullable: false), - stop_name = table.Column<string>(type: "character varying(255)", maxLength: 255, nullable: false), - stop_desc = table.Column<string>(type: "character varying(255)", maxLength: 255, nullable: true), - stop_pos = table.Column<Point>(type: "geometry", nullable: true), - stop_url = table.Column<string>(type: "character varying(255)", maxLength: 255, nullable: true), - stop_timezone = table.Column<string>(type: "character varying(50)", maxLength: 50, nullable: true), - wheelchair_boarding = table.Column<int>(type: "integer", nullable: false) - }, - constraints: table => - { - table.PrimaryKey("PK_gtfs_stops", x => new { x.stop_id, x.feed_id }); - table.ForeignKey( - name: "FK_gtfs_stops_feeds_feed_id", - column: x => x.feed_id, - principalTable: "feeds", - principalColumn: "Id", - onDelete: ReferentialAction.Cascade); - }); - - migrationBuilder.CreateTable( - name: "gtfs_routes", - columns: table => new - { - route_id = table.Column<string>(type: "character varying(255)", maxLength: 255, nullable: false), - feed_id = table.Column<int>(type: "integer", nullable: false), - agency_id = table.Column<string>(type: "character varying(255)", maxLength: 255, nullable: false), - route_short_name = table.Column<string>(type: "character varying(32)", maxLength: 32, nullable: false), - route_long_name = table.Column<string>(type: "character varying(255)", maxLength: 255, nullable: false), - route_desc = table.Column<string>(type: "character varying(255)", maxLength: 255, nullable: true), - route_type = table.Column<int>(type: "integer", nullable: false), - route_url = table.Column<string>(type: "character varying(255)", maxLength: 255, nullable: true), - route_color = table.Column<string>(type: "character varying(7)", maxLength: 7, nullable: true), - route_text_color = table.Column<string>(type: "character varying(7)", maxLength: 7, nullable: true), - route_sort_order = table.Column<int>(type: "integer", nullable: false) - }, - constraints: table => - { - table.PrimaryKey("PK_gtfs_routes", x => new { x.route_id, x.feed_id }); - table.ForeignKey( - name: "FK_gtfs_routes_feeds_feed_id", - column: x => x.feed_id, - principalTable: "feeds", - principalColumn: "Id", - onDelete: ReferentialAction.Cascade); - table.ForeignKey( - name: "FK_gtfs_routes_gtfs_agencies_agency_id_feed_id", - columns: x => new { x.agency_id, x.feed_id }, - principalTable: "gtfs_agencies", - principalColumns: new[] { "agency_id", "feed_id" }, - onDelete: ReferentialAction.Cascade); - }); - - migrationBuilder.CreateTable( - name: "gtfs_trips", - columns: table => new - { - trip_id = table.Column<string>(type: "character varying(32)", maxLength: 32, nullable: false), - feed_id = table.Column<int>(type: "integer", nullable: false), - route_id = table.Column<string>(type: "character varying(32)", maxLength: 32, nullable: false), - service_id = table.Column<string>(type: "character varying(32)", maxLength: 32, nullable: false), - trip_headsign = table.Column<string>(type: "character varying(255)", maxLength: 255, nullable: true), - trip_short_name = table.Column<string>(type: "character varying(255)", maxLength: 255, nullable: true), - direction_id = table.Column<int>(type: "integer", nullable: false), - block_id = table.Column<string>(type: "character varying(32)", maxLength: 32, nullable: true), - shape_id = table.Column<string>(type: "character varying(32)", maxLength: 32, nullable: true), - trip_wheelchair_accessible = table.Column<int>(type: "integer", nullable: false, defaultValue: 0), - trip_bikes_allowed = table.Column<int>(type: "integer", nullable: false, defaultValue: 0) - }, - constraints: table => - { - table.PrimaryKey("PK_gtfs_trips", x => new { x.trip_id, x.feed_id }); - table.ForeignKey( - name: "FK_gtfs_trips_feeds_feed_id", - column: x => x.feed_id, - principalTable: "feeds", - principalColumn: "Id", - onDelete: ReferentialAction.Cascade); - table.ForeignKey( - name: "FK_gtfs_trips_gtfs_routes_route_id_feed_id", - columns: x => new { x.route_id, x.feed_id }, - principalTable: "gtfs_routes", - principalColumns: new[] { "route_id", "feed_id" }, - onDelete: ReferentialAction.Cascade); - }); - - migrationBuilder.CreateTable( - name: "gtfs_stop_times", - columns: table => new - { - trip_id = table.Column<string>(type: "character varying(32)", maxLength: 32, nullable: false), - feed_id = table.Column<int>(type: "integer", nullable: false), - stop_sequence = table.Column<int>(type: "integer", nullable: false), - arrival_time = table.Column<string>(type: "text", nullable: false), - departure_time = table.Column<string>(type: "text", nullable: false), - stop_id = table.Column<string>(type: "character varying(32)", maxLength: 32, nullable: false), - shape_dist_traveled = table.Column<double>(type: "double precision", nullable: true) - }, - constraints: table => - { - table.PrimaryKey("PK_gtfs_stop_times", x => new { x.trip_id, x.stop_sequence, x.feed_id }); - table.ForeignKey( - name: "FK_gtfs_stop_times_feeds_feed_id", - column: x => x.feed_id, - principalTable: "feeds", - principalColumn: "Id", - onDelete: ReferentialAction.Cascade); - table.ForeignKey( - name: "FK_gtfs_stop_times_gtfs_stops_stop_id_feed_id", - columns: x => new { x.stop_id, x.feed_id }, - principalTable: "gtfs_stops", - principalColumns: new[] { "stop_id", "feed_id" }, - onDelete: ReferentialAction.Cascade); - table.ForeignKey( - name: "FK_gtfs_stop_times_gtfs_trips_trip_id_feed_id", - columns: x => new { x.trip_id, x.feed_id }, - principalTable: "gtfs_trips", - principalColumns: new[] { "trip_id", "feed_id" }, - onDelete: ReferentialAction.Cascade); - }); - - migrationBuilder.CreateIndex( - name: "IX_gtfs_agencies_feed_id", - table: "gtfs_agencies", - column: "feed_id"); - - migrationBuilder.CreateIndex( - name: "IX_gtfs_calendar_feed_id", - table: "gtfs_calendar", - column: "feed_id"); - - migrationBuilder.CreateIndex( - name: "IX_gtfs_calendar_dates_feed_id", - table: "gtfs_calendar_dates", - column: "feed_id"); - - migrationBuilder.CreateIndex( - name: "IX_gtfs_routes_agency_id_feed_id", - table: "gtfs_routes", - columns: new[] { "agency_id", "feed_id" }); - - migrationBuilder.CreateIndex( - name: "IX_gtfs_routes_feed_id", - table: "gtfs_routes", - column: "feed_id"); - - migrationBuilder.CreateIndex( - name: "IX_gtfs_stop_times_feed_id", - table: "gtfs_stop_times", - column: "feed_id"); - - migrationBuilder.CreateIndex( - name: "IX_gtfs_stop_times_stop_id_feed_id", - table: "gtfs_stop_times", - columns: new[] { "stop_id", "feed_id" }); - - migrationBuilder.CreateIndex( - name: "IX_gtfs_stop_times_trip_id_feed_id", - table: "gtfs_stop_times", - columns: new[] { "trip_id", "feed_id" }); - - migrationBuilder.CreateIndex( - name: "IX_gtfs_stops_feed_id", - table: "gtfs_stops", - column: "feed_id"); - - migrationBuilder.CreateIndex( - name: "IX_gtfs_trips_feed_id", - table: "gtfs_trips", - column: "feed_id"); - - migrationBuilder.CreateIndex( - name: "IX_gtfs_trips_route_id_feed_id", - table: "gtfs_trips", - columns: new[] { "route_id", "feed_id" }); - } - - /// <inheritdoc /> - protected override void Down(MigrationBuilder migrationBuilder) - { - migrationBuilder.DropTable( - name: "gtfs_calendar"); - - migrationBuilder.DropTable( - name: "gtfs_calendar_dates"); - - migrationBuilder.DropTable( - name: "gtfs_stop_times"); - - migrationBuilder.DropTable( - name: "gtfs_stops"); - - migrationBuilder.DropTable( - name: "gtfs_trips"); - - migrationBuilder.DropTable( - name: "gtfs_routes"); - - migrationBuilder.DropTable( - name: "gtfs_agencies"); - - migrationBuilder.DropTable( - name: "feeds"); - } - } -} diff --git a/src/Costasdev.Busurbano.ServiceViewer/Data/Migrations/AppDbContextModelSnapshot.cs b/src/Costasdev.Busurbano.ServiceViewer/Data/Migrations/AppDbContextModelSnapshot.cs deleted file mode 100644 index feb3813..0000000 --- a/src/Costasdev.Busurbano.ServiceViewer/Data/Migrations/AppDbContextModelSnapshot.cs +++ /dev/null @@ -1,544 +0,0 @@ -// <auto-generated /> -using System; -using Costasdev.ServiceViewer.Data; -using Microsoft.EntityFrameworkCore; -using Microsoft.EntityFrameworkCore.Infrastructure; -using Microsoft.EntityFrameworkCore.Storage.ValueConversion; -using NetTopologySuite.Geometries; -using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata; - -#nullable disable - -namespace Data.Migrations -{ - [DbContext(typeof(AppDbContext))] - partial class AppDbContextModelSnapshot : ModelSnapshot - { - protected override void BuildModel(ModelBuilder modelBuilder) - { -#pragma warning disable 612, 618 - modelBuilder - .HasAnnotation("ProductVersion", "10.0.1") - .HasAnnotation("Relational:MaxIdentifierLength", 63); - - NpgsqlModelBuilderExtensions.HasPostgresExtension(modelBuilder, "postgis"); - NpgsqlModelBuilderExtensions.UseIdentityByDefaultColumns(modelBuilder); - - modelBuilder.Entity("Costasdev.ServiceViewer.Data.Gtfs.Feed", b => - { - b.Property<int>("Id") - .ValueGeneratedOnAdd() - .HasColumnType("integer"); - - NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id")); - - b.Property<string>("DownloadUrl") - .IsRequired() - .HasMaxLength(255) - .HasColumnType("character varying(255)"); - - b.Property<string>("Etag") - .IsRequired() - .HasMaxLength(32) - .HasColumnType("character varying(32)"); - - b.Property<DateTime>("InsertedAt") - .HasColumnType("timestamp with time zone"); - - b.Property<string>("LongName") - .IsRequired() - .HasMaxLength(32) - .HasColumnType("character varying(32)"); - - b.Property<string>("ShortName") - .IsRequired() - .HasMaxLength(32) - .HasColumnType("character varying(32)"); - - b.HasKey("Id"); - - b.ToTable("feeds"); - }); - - modelBuilder.Entity("Costasdev.ServiceViewer.Data.Gtfs.GtfsAgency", b => - { - b.Property<string>("Id") - .HasMaxLength(255) - .HasColumnType("character varying(255)") - .HasColumnName("agency_id"); - - b.Property<int>("FeedId") - .HasColumnType("integer") - .HasColumnName("feed_id"); - - b.Property<string>("Email") - .HasMaxLength(255) - .HasColumnType("character varying(255)") - .HasColumnName("agency_email"); - - b.Property<string>("FareUrl") - .HasMaxLength(255) - .HasColumnType("character varying(255)") - .HasColumnName("agency_fare_url"); - - b.Property<string>("Language") - .IsRequired() - .HasMaxLength(5) - .HasColumnType("character varying(5)") - .HasColumnName("agency_lang"); - - b.Property<string>("Name") - .IsRequired() - .HasMaxLength(255) - .HasColumnType("character varying(255)") - .HasColumnName("agency_name"); - - b.Property<string>("Phone") - .HasMaxLength(30) - .HasColumnType("character varying(30)") - .HasColumnName("agency_phone"); - - b.Property<string>("Timezone") - .IsRequired() - .HasMaxLength(50) - .HasColumnType("character varying(50)") - .HasColumnName("agency_timezone"); - - b.Property<string>("Url") - .IsRequired() - .HasMaxLength(255) - .HasColumnType("character varying(255)") - .HasColumnName("agency_url"); - - b.HasKey("Id", "FeedId"); - - b.HasIndex("FeedId"); - - b.ToTable("gtfs_agencies"); - }); - - modelBuilder.Entity("Costasdev.ServiceViewer.Data.Gtfs.GtfsCalendar", b => - { - b.Property<string>("ServiceId") - .HasMaxLength(32) - .HasColumnType("character varying(32)") - .HasColumnName("service_id"); - - b.Property<int>("FeedId") - .HasColumnType("integer") - .HasColumnName("feed_id"); - - b.Property<DateOnly>("EndDate") - .HasColumnType("date") - .HasColumnName("end_date"); - - b.Property<bool>("Friday") - .HasColumnType("boolean") - .HasColumnName("friday"); - - b.Property<bool>("Monday") - .HasColumnType("boolean") - .HasColumnName("monday"); - - b.Property<bool>("Saturday") - .HasColumnType("boolean") - .HasColumnName("saturday"); - - b.Property<DateOnly>("StartDate") - .HasColumnType("date") - .HasColumnName("start_date"); - - b.Property<bool>("Sunday") - .HasColumnType("boolean") - .HasColumnName("sunday"); - - b.Property<bool>("Thursday") - .HasColumnType("boolean") - .HasColumnName("thursday"); - - b.Property<bool>("Tuesday") - .HasColumnType("boolean") - .HasColumnName("tuesday"); - - b.Property<bool>("Wednesday") - .HasColumnType("boolean") - .HasColumnName("wednesday"); - - b.HasKey("ServiceId", "FeedId"); - - b.HasIndex("FeedId"); - - b.ToTable("gtfs_calendar"); - }); - - modelBuilder.Entity("Costasdev.ServiceViewer.Data.Gtfs.GtfsCalendarDate", b => - { - b.Property<string>("ServiceId") - .HasMaxLength(32) - .HasColumnType("character varying(32)") - .HasColumnName("service_id"); - - b.Property<DateTime>("Date") - .HasColumnType("timestamp with time zone") - .HasColumnName("date"); - - b.Property<int>("FeedId") - .HasColumnType("integer") - .HasColumnName("feed_id"); - - b.Property<int>("ExceptionType") - .HasColumnType("integer") - .HasColumnName("exception_type"); - - b.HasKey("ServiceId", "Date", "FeedId"); - - b.HasIndex("FeedId"); - - b.ToTable("gtfs_calendar_dates"); - }); - - modelBuilder.Entity("Costasdev.ServiceViewer.Data.Gtfs.GtfsRoute", b => - { - b.Property<string>("Id") - .HasMaxLength(255) - .HasColumnType("character varying(255)") - .HasColumnName("route_id"); - - b.Property<int>("FeedId") - .HasColumnType("integer") - .HasColumnName("feed_id"); - - b.Property<string>("AgencyId") - .IsRequired() - .HasMaxLength(255) - .HasColumnType("character varying(255)") - .HasColumnName("agency_id"); - - b.Property<string>("Color") - .HasMaxLength(7) - .HasColumnType("character varying(7)") - .HasColumnName("route_color"); - - b.Property<string>("Description") - .HasMaxLength(255) - .HasColumnType("character varying(255)") - .HasColumnName("route_desc"); - - b.Property<string>("LongName") - .IsRequired() - .HasMaxLength(255) - .HasColumnType("character varying(255)") - .HasColumnName("route_long_name"); - - b.Property<string>("ShortName") - .IsRequired() - .HasMaxLength(32) - .HasColumnType("character varying(32)") - .HasColumnName("route_short_name"); - - b.Property<int>("SortOrder") - .HasColumnType("integer") - .HasColumnName("route_sort_order"); - - b.Property<string>("TextColor") - .HasMaxLength(7) - .HasColumnType("character varying(7)") - .HasColumnName("route_text_color"); - - b.Property<int>("Type") - .HasColumnType("integer") - .HasColumnName("route_type"); - - b.Property<string>("Url") - .HasMaxLength(255) - .HasColumnType("character varying(255)") - .HasColumnName("route_url"); - - b.HasKey("Id", "FeedId"); - - b.HasIndex("FeedId"); - - b.HasIndex("AgencyId", "FeedId"); - - b.ToTable("gtfs_routes"); - }); - - modelBuilder.Entity("Costasdev.ServiceViewer.Data.Gtfs.GtfsStop", b => - { - b.Property<string>("Id") - .HasMaxLength(32) - .HasColumnType("character varying(32)") - .HasColumnName("stop_id"); - - b.Property<int>("FeedId") - .HasColumnType("integer") - .HasColumnName("feed_id"); - - b.Property<string>("Code") - .IsRequired() - .HasMaxLength(32) - .HasColumnType("character varying(32)") - .HasColumnName("stop_code"); - - b.Property<string>("Description") - .HasMaxLength(255) - .HasColumnType("character varying(255)") - .HasColumnName("stop_desc"); - - b.Property<string>("Name") - .IsRequired() - .HasMaxLength(255) - .HasColumnType("character varying(255)") - .HasColumnName("stop_name"); - - b.Property<Point>("Position") - .HasColumnType("geometry") - .HasColumnName("stop_pos"); - - b.Property<string>("Timezone") - .HasMaxLength(50) - .HasColumnType("character varying(50)") - .HasColumnName("stop_timezone"); - - b.Property<string>("Url") - .HasMaxLength(255) - .HasColumnType("character varying(255)") - .HasColumnName("stop_url"); - - b.Property<int>("WheelchairBoarding") - .HasColumnType("integer") - .HasColumnName("wheelchair_boarding"); - - b.HasKey("Id", "FeedId"); - - b.HasIndex("FeedId"); - - b.ToTable("gtfs_stops"); - }); - - modelBuilder.Entity("Costasdev.ServiceViewer.Data.Gtfs.GtfsStopTime", b => - { - b.Property<string>("TripId") - .HasMaxLength(32) - .HasColumnType("character varying(32)") - .HasColumnName("trip_id"); - - b.Property<int>("StopSequence") - .HasColumnType("integer") - .HasColumnName("stop_sequence"); - - b.Property<int>("FeedId") - .HasColumnType("integer") - .HasColumnName("feed_id"); - - b.Property<string>("Arrival") - .IsRequired() - .HasColumnType("text") - .HasColumnName("arrival_time"); - - b.Property<string>("Departure") - .IsRequired() - .HasColumnType("text") - .HasColumnName("departure_time"); - - b.Property<double?>("ShapeDistTraveled") - .HasColumnType("double precision") - .HasColumnName("shape_dist_traveled"); - - b.Property<string>("StopId") - .IsRequired() - .HasMaxLength(32) - .HasColumnType("character varying(32)") - .HasColumnName("stop_id"); - - b.HasKey("TripId", "StopSequence", "FeedId"); - - b.HasIndex("FeedId"); - - b.HasIndex("StopId", "FeedId"); - - b.HasIndex("TripId", "FeedId"); - - b.ToTable("gtfs_stop_times"); - }); - - modelBuilder.Entity("Costasdev.ServiceViewer.Data.Gtfs.GtfsTrip", b => - { - b.Property<string>("Id") - .HasMaxLength(32) - .HasColumnType("character varying(32)") - .HasColumnName("trip_id"); - - b.Property<int>("FeedId") - .HasColumnType("integer") - .HasColumnName("feed_id"); - - b.Property<string>("BlockId") - .HasMaxLength(32) - .HasColumnType("character varying(32)") - .HasColumnName("block_id"); - - b.Property<int>("DirectionId") - .HasColumnType("integer") - .HasColumnName("direction_id"); - - b.Property<string>("RouteId") - .IsRequired() - .HasMaxLength(32) - .HasColumnType("character varying(32)") - .HasColumnName("route_id"); - - b.Property<string>("ServiceId") - .IsRequired() - .HasMaxLength(32) - .HasColumnType("character varying(32)") - .HasColumnName("service_id"); - - b.Property<string>("ShapeId") - .HasMaxLength(32) - .HasColumnType("character varying(32)") - .HasColumnName("shape_id"); - - b.Property<int>("TripBikesAllowed") - .ValueGeneratedOnAdd() - .HasColumnType("integer") - .HasDefaultValue(0) - .HasColumnName("trip_bikes_allowed"); - - b.Property<string>("TripHeadsign") - .HasMaxLength(255) - .HasColumnType("character varying(255)") - .HasColumnName("trip_headsign"); - - b.Property<string>("TripShortName") - .HasMaxLength(255) - .HasColumnType("character varying(255)") - .HasColumnName("trip_short_name"); - - b.Property<int>("TripWheelchairAccessible") - .ValueGeneratedOnAdd() - .HasColumnType("integer") - .HasDefaultValue(0) - .HasColumnName("trip_wheelchair_accessible"); - - b.HasKey("Id", "FeedId"); - - b.HasIndex("FeedId"); - - b.HasIndex("RouteId", "FeedId"); - - b.ToTable("gtfs_trips"); - }); - - modelBuilder.Entity("Costasdev.ServiceViewer.Data.Gtfs.GtfsAgency", b => - { - b.HasOne("Costasdev.ServiceViewer.Data.Gtfs.Feed", "Feed") - .WithMany() - .HasForeignKey("FeedId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.Navigation("Feed"); - }); - - modelBuilder.Entity("Costasdev.ServiceViewer.Data.Gtfs.GtfsCalendar", b => - { - b.HasOne("Costasdev.ServiceViewer.Data.Gtfs.Feed", "Feed") - .WithMany() - .HasForeignKey("FeedId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.Navigation("Feed"); - }); - - modelBuilder.Entity("Costasdev.ServiceViewer.Data.Gtfs.GtfsCalendarDate", b => - { - b.HasOne("Costasdev.ServiceViewer.Data.Gtfs.Feed", "Feed") - .WithMany() - .HasForeignKey("FeedId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.Navigation("Feed"); - }); - - modelBuilder.Entity("Costasdev.ServiceViewer.Data.Gtfs.GtfsRoute", b => - { - b.HasOne("Costasdev.ServiceViewer.Data.Gtfs.Feed", "Feed") - .WithMany() - .HasForeignKey("FeedId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.HasOne("Costasdev.ServiceViewer.Data.Gtfs.GtfsAgency", "Agency") - .WithMany() - .HasForeignKey("AgencyId", "FeedId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.Navigation("Agency"); - - b.Navigation("Feed"); - }); - - modelBuilder.Entity("Costasdev.ServiceViewer.Data.Gtfs.GtfsStop", b => - { - b.HasOne("Costasdev.ServiceViewer.Data.Gtfs.Feed", "Feed") - .WithMany() - .HasForeignKey("FeedId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.Navigation("Feed"); - }); - - modelBuilder.Entity("Costasdev.ServiceViewer.Data.Gtfs.GtfsStopTime", b => - { - b.HasOne("Costasdev.ServiceViewer.Data.Gtfs.Feed", "Feed") - .WithMany() - .HasForeignKey("FeedId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.HasOne("Costasdev.ServiceViewer.Data.Gtfs.GtfsStop", "GtfsStop") - .WithMany() - .HasForeignKey("StopId", "FeedId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.HasOne("Costasdev.ServiceViewer.Data.Gtfs.GtfsTrip", "GtfsTrip") - .WithMany() - .HasForeignKey("TripId", "FeedId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.Navigation("Feed"); - - b.Navigation("GtfsStop"); - - b.Navigation("GtfsTrip"); - }); - - modelBuilder.Entity("Costasdev.ServiceViewer.Data.Gtfs.GtfsTrip", b => - { - b.HasOne("Costasdev.ServiceViewer.Data.Gtfs.Feed", "Feed") - .WithMany() - .HasForeignKey("FeedId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.HasOne("Costasdev.ServiceViewer.Data.Gtfs.GtfsRoute", "Route") - .WithMany() - .HasForeignKey("RouteId", "FeedId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.Navigation("Feed"); - - b.Navigation("Route"); - }); -#pragma warning restore 612, 618 - } - } -} |