From 7c6009abd22d8461039be15d0fd069a460340585 Mon Sep 17 00:00:00 2001 From: Jake Mannens Date: Fri, 20 Sep 2024 16:13:30 +1000 Subject: v0.1 --- Migrations/20230705160931_Initial.Designer.cs | 159 ++++++++++++++++++++++++++ Migrations/20230705160931_Initial.cs | 115 +++++++++++++++++++ Migrations/PagerContextModelSnapshot.cs | 156 +++++++++++++++++++++++++ 3 files changed, 430 insertions(+) create mode 100644 Migrations/20230705160931_Initial.Designer.cs create mode 100644 Migrations/20230705160931_Initial.cs create mode 100644 Migrations/PagerContextModelSnapshot.cs (limited to 'Migrations') diff --git a/Migrations/20230705160931_Initial.Designer.cs b/Migrations/20230705160931_Initial.Designer.cs new file mode 100644 index 0000000..598258f --- /dev/null +++ b/Migrations/20230705160931_Initial.Designer.cs @@ -0,0 +1,159 @@ +// +using System; +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("20230705160931_Initial")] + partial class Initial + { + /// + protected override void BuildTargetModel(ModelBuilder modelBuilder) + { +#pragma warning disable 612, 618 + modelBuilder + .HasAnnotation("ProductVersion", "7.0.8") + .HasAnnotation("Relational:MaxIdentifierLength", 63); + + NpgsqlModelBuilderExtensions.UseIdentityByDefaultColumns(modelBuilder); + + 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.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("MelwaysGrid") + .HasColumnType("text"); + + b.Property("MelwaysMapNo") + .HasColumnType("integer"); + + b.Property("Note") + .HasColumnType("text"); + + b.Property("PageDestination") + .IsRequired() + .HasColumnType("text"); + + b.Property("PagerMessage") + .HasColumnType("integer"); + + b.HasKey("ParsedPagerMessageId"); + + b.HasIndex("FirecomJobNo"); + + b.HasIndex("GpsPositionId"); + + b.HasIndex("PagerMessage") + .IsUnique(); + + b.ToTable("ParsedPagerMessages"); + }); + + 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/20230705160931_Initial.cs b/Migrations/20230705160931_Initial.cs new file mode 100644 index 0000000..9f3068f --- /dev/null +++ b/Migrations/20230705160931_Initial.cs @@ -0,0 +1,115 @@ +using System; +using Microsoft.EntityFrameworkCore.Migrations; +using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata; + +#nullable disable + +namespace PagerParser.Migrations +{ + /// + public partial class Initial : Migration + { + /// + protected override void Up(MigrationBuilder migrationBuilder) + { + migrationBuilder.CreateTable( + name: "GpsPositions", + columns: table => new + { + GpsPositionId = table.Column(type: "integer", nullable: false) + .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn), + Latitude = table.Column(type: "double precision", nullable: false), + Longitude = table.Column(type: "double precision", nullable: false) + }, + constraints: table => + { + table.PrimaryKey("PK_GpsPositions", x => x.GpsPositionId); + }); + + migrationBuilder.CreateTable( + name: "PagerMessages", + columns: table => new + { + PagerMessageId = table.Column(type: "integer", nullable: false) + .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn), + Timestamp = table.Column(type: "timestamp with time zone", nullable: false), + Message = table.Column(type: "text", nullable: false) + }, + constraints: table => + { + table.PrimaryKey("PK_PagerMessages", x => x.PagerMessageId); + }); + + migrationBuilder.CreateTable( + name: "ParsedPagerMessages", + columns: table => new + { + ParsedPagerMessageId = table.Column(type: "integer", nullable: false) + .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn), + FirecomJobNo = table.Column(type: "integer", nullable: false), + AssignmentArea = table.Column(type: "text", nullable: false), + JobType = table.Column(type: "text", nullable: false), + AlertLevel = table.Column(type: "integer", nullable: false), + Description = table.Column(type: "text", nullable: false), + MelwaysMapNo = table.Column(type: "integer", nullable: true), + MelwaysGrid = table.Column(type: "text", nullable: true), + GridReference = table.Column(type: "integer", nullable: true), + AttendingServices = table.Column(type: "integer", nullable: false), + Note = table.Column(type: "text", nullable: true), + FireGroundChannel = table.Column(type: "integer", nullable: true), + PageDestination = table.Column(type: "text", nullable: false), + GpsPositionId = table.Column(type: "integer", nullable: true), + PagerMessage = table.Column(type: "integer", nullable: false) + }, + constraints: table => + { + table.PrimaryKey("PK_ParsedPagerMessages", x => x.ParsedPagerMessageId); + table.ForeignKey( + name: "FK_ParsedPagerMessages_GpsPositions_GpsPositionId", + column: x => x.GpsPositionId, + principalTable: "GpsPositions", + principalColumn: "GpsPositionId"); + table.ForeignKey( + name: "FK_ParsedPagerMessages_PagerMessages_PagerMessage", + column: x => x.PagerMessage, + principalTable: "PagerMessages", + principalColumn: "PagerMessageId", + onDelete: ReferentialAction.Cascade); + }); + + migrationBuilder.CreateIndex( + name: "IX_PagerMessages_Message", + table: "PagerMessages", + column: "Message"); + + migrationBuilder.CreateIndex( + name: "IX_ParsedPagerMessages_FirecomJobNo", + table: "ParsedPagerMessages", + column: "FirecomJobNo"); + + migrationBuilder.CreateIndex( + name: "IX_ParsedPagerMessages_GpsPositionId", + table: "ParsedPagerMessages", + column: "GpsPositionId"); + + migrationBuilder.CreateIndex( + name: "IX_ParsedPagerMessages_PagerMessage", + table: "ParsedPagerMessages", + column: "PagerMessage", + unique: true); + } + + /// + protected override void Down(MigrationBuilder migrationBuilder) + { + migrationBuilder.DropTable( + name: "ParsedPagerMessages"); + + migrationBuilder.DropTable( + name: "GpsPositions"); + + migrationBuilder.DropTable( + name: "PagerMessages"); + } + } +} diff --git a/Migrations/PagerContextModelSnapshot.cs b/Migrations/PagerContextModelSnapshot.cs new file mode 100644 index 0000000..879c13f --- /dev/null +++ b/Migrations/PagerContextModelSnapshot.cs @@ -0,0 +1,156 @@ +// +using System; +using Microsoft.EntityFrameworkCore; +using Microsoft.EntityFrameworkCore.Infrastructure; +using Microsoft.EntityFrameworkCore.Storage.ValueConversion; +using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata; +using PagerParser; + +#nullable disable + +namespace PagerParser.Migrations +{ + [DbContext(typeof(PagerContext))] + partial class PagerContextModelSnapshot : ModelSnapshot + { + protected override void BuildModel(ModelBuilder modelBuilder) + { +#pragma warning disable 612, 618 + modelBuilder + .HasAnnotation("ProductVersion", "7.0.8") + .HasAnnotation("Relational:MaxIdentifierLength", 63); + + NpgsqlModelBuilderExtensions.UseIdentityByDefaultColumns(modelBuilder); + + 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.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("MelwaysGrid") + .HasColumnType("text"); + + b.Property("MelwaysMapNo") + .HasColumnType("integer"); + + b.Property("Note") + .HasColumnType("text"); + + b.Property("PageDestination") + .IsRequired() + .HasColumnType("text"); + + b.Property("PagerMessage") + .HasColumnType("integer"); + + b.HasKey("ParsedPagerMessageId"); + + b.HasIndex("FirecomJobNo"); + + b.HasIndex("GpsPositionId"); + + b.HasIndex("PagerMessage") + .IsUnique(); + + b.ToTable("ParsedPagerMessages"); + }); + + 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 + } + } +} -- cgit v1.3