From a1f0518d0cd123a791adde64f4f11bd8e44276c7 Mon Sep 17 00:00:00 2001
From: ivar <i@oiee.no>
Date: Mon, 20 Oct 2025 00:26:34 +0200
Subject: Initial commit

---
 api/WhatApi/Database.cs | 19 +++++++++++++++++++
 1 file changed, 19 insertions(+)
 create mode 100644 api/WhatApi/Database.cs

(limited to 'api/WhatApi/Database.cs')

diff --git a/api/WhatApi/Database.cs b/api/WhatApi/Database.cs
new file mode 100644
index 0000000..39de79a
--- /dev/null
+++ b/api/WhatApi/Database.cs
@@ -0,0 +1,19 @@
+using Microsoft.EntityFrameworkCore;
+
+namespace WhatApi;
+
+public class Database(DbContextOptions<Database> options) : DbContext(options)
+{
+    public DbSet<Tables.Content> Content { get; set; }
+    public DbSet<Tables.Place> Places { get; set; }
+    protected override void OnModelCreating(ModelBuilder b) {
+        b.HasPostgresExtension("postgis");
+        b.Entity<Tables.Place>(e => {
+            e.Property(x => x.Location).HasColumnType($"geometry(point,{Constants.Wgs84SpatialReferenceId})");
+            e.HasIndex(x => x.Location).HasMethod("gist");
+            e.ToTable("Place");
+        });
+        b.Entity<Tables.Content>();
+        base.OnModelCreating(b);
+    }
+}
\ No newline at end of file
-- 
cgit v1.3