From b1550b56be07536c9ed07c4a29fb3bb71f345c9e Mon Sep 17 00:00:00 2001 From: Jake Mannens Date: Wed, 6 Nov 2024 12:24:08 +1100 Subject: Migration --- Migrations/20241106012338_Bart.Designer.cs | 307 +++++++++++++++++++++++++++++ Migrations/20241106012338_Bart.cs | 95 +++++++++ Migrations/PagerContextModelSnapshot.cs | 85 ++++++++ 3 files changed, 487 insertions(+) create mode 100644 Migrations/20241106012338_Bart.Designer.cs create mode 100644 Migrations/20241106012338_Bart.cs diff --git a/Migrations/20241106012338_Bart.Designer.cs b/Migrations/20241106012338_Bart.Designer.cs new file mode 100644 index 0000000..15acd57 --- /dev/null +++ b/Migrations/20241106012338_Bart.Designer.cs @@ -0,0 +1,307 @@ +// +using System; +using System.Collections.Generic; +using Microsoft.EntityFrameworkCore; +using Microsoft.EntityFrameworkCore.Infrastructure; +using Microsoft.EntityFrameworkCore.Migrations; +using Microsoft.EntityFrameworkCore.Storage.ValueConversion; +using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata; +using PagerParser; + +#nullable disable + +namespace PagerParser.Migrations +{ + [DbContext(typeof(PagerContext))] + [Migration("20241106012338_Bart")] + partial class Bart + { + /// + protected override void BuildTargetModel(ModelBuilder modelBuilder) + { +#pragma warning disable 612, 618 + modelBuilder + .HasAnnotation("ProductVersion", "8.0.8") + .HasAnnotation("Relational:MaxIdentifierLength", 63); + + NpgsqlModelBuilderExtensions.UseIdentityByDefaultColumns(modelBuilder); + + modelBuilder.Entity("PagerParser.Bart.BartAvailabilityRecord", b => + { + b.Property("BartAvailabilityRecordId") + .ValueGeneratedOnAdd() + .HasColumnType("integer"); + + NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("BartAvailabilityRecordId")); + + b.Property("CreatedByBartMemberId") + .HasColumnType("integer"); + + b.Property("CreatedOn") + .HasColumnType("timestamp with time zone"); + + b.Property("IsDefault") + .HasColumnType("boolean"); + + b.Property("MemberBartMemberId") + .HasColumnType("integer"); + + b.Property("ModifiedByBartMemberId") + .HasColumnType("integer"); + + b.Property("ModifiedOn") + .HasColumnType("timestamp with time zone"); + + b.Property("Status") + .HasColumnType("integer"); + + b.Property("Timestamp") + .HasColumnType("timestamp with time zone"); + + b.HasKey("BartAvailabilityRecordId"); + + b.HasIndex("CreatedByBartMemberId"); + + b.HasIndex("MemberBartMemberId"); + + b.HasIndex("ModifiedByBartMemberId"); + + b.ToTable("BartAvailabilityRecords"); + }); + + modelBuilder.Entity("PagerParser.Bart.BartMember", b => + { + b.Property("BartMemberId") + .ValueGeneratedOnAdd() + .HasColumnType("integer"); + + NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("BartMemberId")); + + b.Property("MemberName") + .IsRequired() + .HasColumnType("text"); + + b.HasKey("BartMemberId"); + + b.HasIndex("MemberName"); + + b.ToTable("BartMembers"); + }); + + modelBuilder.Entity("PagerParser.GpsPosition", b => + { + b.Property("GpsPositionId") + .ValueGeneratedOnAdd() + .HasColumnType("integer"); + + NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("GpsPositionId")); + + b.Property("Latitude") + .HasColumnType("double precision"); + + b.Property("Longitude") + .HasColumnType("double precision"); + + b.HasKey("GpsPositionId"); + + b.ToTable("GpsPositions"); + }); + + modelBuilder.Entity("PagerParser.Handlers.DiscordAlertChannel", b => + { + b.Property("DiscordAlertChannelId") + .ValueGeneratedOnAdd() + .HasColumnType("integer"); + + NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("DiscordAlertChannelId")); + + b.Property("ChannelId") + .HasColumnType("numeric(20,0)"); + + b.Property("GuildId") + .HasColumnType("numeric(20,0)"); + + b.Property("RequireMention") + .HasColumnType("boolean"); + + b.HasKey("DiscordAlertChannelId"); + + b.HasIndex("GuildId") + .IsUnique(); + + b.ToTable("DiscordAlertChannels"); + }); + + modelBuilder.Entity("PagerParser.Handlers.DiscordAlertSubscription", b => + { + b.Property("DiscordAlertSubscriptionId") + .ValueGeneratedOnAdd() + .HasColumnType("integer"); + + NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("DiscordAlertSubscriptionId")); + + b.Property("GuildId") + .HasColumnType("numeric(20,0)"); + + b.Property("PageDestination") + .IsRequired() + .HasColumnType("text"); + + b.Property("PrincipalId") + .HasColumnType("numeric(20,0)"); + + b.Property("PrincipalType") + .HasColumnType("integer"); + + b.HasKey("DiscordAlertSubscriptionId"); + + b.HasIndex("GuildId"); + + b.ToTable("DiscordAlertSubscriptions"); + }); + + modelBuilder.Entity("PagerParser.PagerMessage", b => + { + b.Property("PagerMessageId") + .ValueGeneratedOnAdd() + .HasColumnType("integer"); + + NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("PagerMessageId")); + + b.Property("Message") + .IsRequired() + .HasColumnType("text"); + + b.Property("Timestamp") + .HasColumnType("timestamp with time zone"); + + b.HasKey("PagerMessageId"); + + b.HasIndex("Message"); + + b.ToTable("PagerMessages"); + }); + + modelBuilder.Entity("PagerParser.ParsedPagerMessage", b => + { + b.Property("ParsedPagerMessageId") + .ValueGeneratedOnAdd() + .HasColumnType("integer"); + + NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("ParsedPagerMessageId")); + + b.Property("AlertLevel") + .HasColumnType("integer"); + + b.Property("AssignmentArea") + .IsRequired() + .HasColumnType("text"); + + b.Property("AttendingServices") + .HasColumnType("integer"); + + b.Property("Description") + .IsRequired() + .HasColumnType("text"); + + b.Property("FireGroundChannel") + .HasColumnType("integer"); + + b.Property("FirecomJobNo") + .HasColumnType("integer"); + + b.Property("GpsPositionId") + .HasColumnType("integer"); + + b.Property("GridReference") + .HasColumnType("integer"); + + b.Property("JobType") + .IsRequired() + .HasColumnType("text"); + + b.Property("MapGrid") + .HasColumnType("text"); + + b.Property("MapNo") + .HasColumnType("integer"); + + b.Property("MapType") + .HasColumnType("integer"); + + b.Property("Note") + .HasColumnType("text"); + + b.Property("PageDestination") + .IsRequired() + .HasColumnType("text"); + + b.Property>("PagedServices") + .IsRequired() + .HasColumnType("text[]"); + + b.Property("PagerMessage") + .HasColumnType("integer"); + + b.HasKey("ParsedPagerMessageId"); + + b.HasIndex("FirecomJobNo"); + + b.HasIndex("GpsPositionId"); + + b.HasIndex("PageDestination"); + + b.HasIndex("PagerMessage") + .IsUnique(); + + b.ToTable("ParsedPagerMessages"); + }); + + modelBuilder.Entity("PagerParser.Bart.BartAvailabilityRecord", b => + { + b.HasOne("PagerParser.Bart.BartMember", "CreatedBy") + .WithMany() + .HasForeignKey("CreatedByBartMemberId"); + + b.HasOne("PagerParser.Bart.BartMember", "Member") + .WithMany() + .HasForeignKey("MemberBartMemberId") + .OnDelete(DeleteBehavior.Cascade) + .IsRequired(); + + b.HasOne("PagerParser.Bart.BartMember", "ModifiedBy") + .WithMany() + .HasForeignKey("ModifiedByBartMemberId"); + + b.Navigation("CreatedBy"); + + b.Navigation("Member"); + + b.Navigation("ModifiedBy"); + }); + + modelBuilder.Entity("PagerParser.ParsedPagerMessage", b => + { + b.HasOne("PagerParser.GpsPosition", "GpsPosition") + .WithMany() + .HasForeignKey("GpsPositionId"); + + b.HasOne("PagerParser.PagerMessage", "OriginalMessage") + .WithOne("ParsedMessage") + .HasForeignKey("PagerParser.ParsedPagerMessage", "PagerMessage") + .OnDelete(DeleteBehavior.Cascade) + .IsRequired(); + + b.Navigation("GpsPosition"); + + b.Navigation("OriginalMessage"); + }); + + modelBuilder.Entity("PagerParser.PagerMessage", b => + { + b.Navigation("ParsedMessage"); + }); +#pragma warning restore 612, 618 + } + } +} diff --git a/Migrations/20241106012338_Bart.cs b/Migrations/20241106012338_Bart.cs new file mode 100644 index 0000000..8174579 --- /dev/null +++ b/Migrations/20241106012338_Bart.cs @@ -0,0 +1,95 @@ +using System; +using Microsoft.EntityFrameworkCore.Migrations; +using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata; + +#nullable disable + +namespace PagerParser.Migrations +{ + /// + public partial class Bart : Migration + { + /// + protected override void Up(MigrationBuilder migrationBuilder) + { + migrationBuilder.CreateTable( + name: "BartMembers", + columns: table => new + { + BartMemberId = table.Column(type: "integer", nullable: false) + .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn), + MemberName = table.Column(type: "text", nullable: false) + }, + constraints: table => + { + table.PrimaryKey("PK_BartMembers", x => x.BartMemberId); + }); + + migrationBuilder.CreateTable( + name: "BartAvailabilityRecords", + columns: table => new + { + BartAvailabilityRecordId = table.Column(type: "integer", nullable: false) + .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn), + Timestamp = table.Column(type: "timestamp with time zone", nullable: false), + MemberBartMemberId = table.Column(type: "integer", nullable: false), + Status = table.Column(type: "integer", nullable: false), + IsDefault = table.Column(type: "boolean", nullable: false), + ModifiedOn = table.Column(type: "timestamp with time zone", nullable: true), + ModifiedByBartMemberId = table.Column(type: "integer", nullable: true), + CreatedOn = table.Column(type: "timestamp with time zone", nullable: true), + CreatedByBartMemberId = table.Column(type: "integer", nullable: true) + }, + constraints: table => + { + table.PrimaryKey("PK_BartAvailabilityRecords", x => x.BartAvailabilityRecordId); + table.ForeignKey( + name: "FK_BartAvailabilityRecords_BartMembers_CreatedByBartMemberId", + column: x => x.CreatedByBartMemberId, + principalTable: "BartMembers", + principalColumn: "BartMemberId"); + table.ForeignKey( + name: "FK_BartAvailabilityRecords_BartMembers_MemberBartMemberId", + column: x => x.MemberBartMemberId, + principalTable: "BartMembers", + principalColumn: "BartMemberId", + onDelete: ReferentialAction.Cascade); + table.ForeignKey( + name: "FK_BartAvailabilityRecords_BartMembers_ModifiedByBartMemberId", + column: x => x.ModifiedByBartMemberId, + principalTable: "BartMembers", + principalColumn: "BartMemberId"); + }); + + migrationBuilder.CreateIndex( + name: "IX_BartAvailabilityRecords_CreatedByBartMemberId", + table: "BartAvailabilityRecords", + column: "CreatedByBartMemberId"); + + migrationBuilder.CreateIndex( + name: "IX_BartAvailabilityRecords_MemberBartMemberId", + table: "BartAvailabilityRecords", + column: "MemberBartMemberId"); + + migrationBuilder.CreateIndex( + name: "IX_BartAvailabilityRecords_ModifiedByBartMemberId", + table: "BartAvailabilityRecords", + column: "ModifiedByBartMemberId"); + + migrationBuilder.CreateIndex( + name: "IX_BartMembers_MemberName", + table: "BartMembers", + column: "MemberName"); + } + + /// + protected override void Down(MigrationBuilder migrationBuilder) + { + migrationBuilder.DropTable( + name: "BartAvailabilityRecords"); + + migrationBuilder.DropTable( + name: "BartMembers"); + } + } +} diff --git a/Migrations/PagerContextModelSnapshot.cs b/Migrations/PagerContextModelSnapshot.cs index 4ff5dc3..1d86420 100644 --- a/Migrations/PagerContextModelSnapshot.cs +++ b/Migrations/PagerContextModelSnapshot.cs @@ -23,6 +23,68 @@ namespace PagerParser.Migrations NpgsqlModelBuilderExtensions.UseIdentityByDefaultColumns(modelBuilder); + modelBuilder.Entity("PagerParser.Bart.BartAvailabilityRecord", b => + { + b.Property("BartAvailabilityRecordId") + .ValueGeneratedOnAdd() + .HasColumnType("integer"); + + NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("BartAvailabilityRecordId")); + + b.Property("CreatedByBartMemberId") + .HasColumnType("integer"); + + b.Property("CreatedOn") + .HasColumnType("timestamp with time zone"); + + b.Property("IsDefault") + .HasColumnType("boolean"); + + b.Property("MemberBartMemberId") + .HasColumnType("integer"); + + b.Property("ModifiedByBartMemberId") + .HasColumnType("integer"); + + b.Property("ModifiedOn") + .HasColumnType("timestamp with time zone"); + + b.Property("Status") + .HasColumnType("integer"); + + b.Property("Timestamp") + .HasColumnType("timestamp with time zone"); + + b.HasKey("BartAvailabilityRecordId"); + + b.HasIndex("CreatedByBartMemberId"); + + b.HasIndex("MemberBartMemberId"); + + b.HasIndex("ModifiedByBartMemberId"); + + b.ToTable("BartAvailabilityRecords"); + }); + + modelBuilder.Entity("PagerParser.Bart.BartMember", b => + { + b.Property("BartMemberId") + .ValueGeneratedOnAdd() + .HasColumnType("integer"); + + NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("BartMemberId")); + + b.Property("MemberName") + .IsRequired() + .HasColumnType("text"); + + b.HasKey("BartMemberId"); + + b.HasIndex("MemberName"); + + b.ToTable("BartMembers"); + }); + modelBuilder.Entity("PagerParser.GpsPosition", b => { b.Property("GpsPositionId") @@ -192,6 +254,29 @@ namespace PagerParser.Migrations b.ToTable("ParsedPagerMessages"); }); + modelBuilder.Entity("PagerParser.Bart.BartAvailabilityRecord", b => + { + b.HasOne("PagerParser.Bart.BartMember", "CreatedBy") + .WithMany() + .HasForeignKey("CreatedByBartMemberId"); + + b.HasOne("PagerParser.Bart.BartMember", "Member") + .WithMany() + .HasForeignKey("MemberBartMemberId") + .OnDelete(DeleteBehavior.Cascade) + .IsRequired(); + + b.HasOne("PagerParser.Bart.BartMember", "ModifiedBy") + .WithMany() + .HasForeignKey("ModifiedByBartMemberId"); + + b.Navigation("CreatedBy"); + + b.Navigation("Member"); + + b.Navigation("ModifiedBy"); + }); + modelBuilder.Entity("PagerParser.ParsedPagerMessage", b => { b.HasOne("PagerParser.GpsPosition", "GpsPosition") -- cgit v1.3