3 files changed, 108 insertions, 0 deletions
diff --git a/VNLib.Plugins.Essentials.Content.Routing/Model/Route.cs b/VNLib.Plugins.Essentials.Content.Routing/Model/Route.cs
new file mode 100644
index 0000000..9af42f1
--- /dev/null
+++ b/VNLib.Plugins.Essentials.Content.Routing/Model/Route.cs
@@ -0,0 +1,47 @@
+using System;
+using System.ComponentModel.DataAnnotations.Schema;
+
+using Microsoft.EntityFrameworkCore;
+
+using VNLib.Plugins.Extensions.Data;
+
+namespace VNLib.Plugins.Essentials.Content.Routing.Model
+{
+    [Index(nameof(Id), IsUnique = true)]
+    internal class Route : DbModelBase
+    {
+        public override string Id { get; set; }
+        public override DateTime Created { get; set; }
+        public override DateTime LastModified { get; set; }
+
+        public string Hostname { get; set; }
+        public string MatchPath { get; set; }
+        [Column("Privilage")]
+        public long _privilage
+        {
+            get => (long)Privilage;
+            set => Privilage = (ulong)value;
+        }
+        [NotMapped]
+        public ulong Privilage { get; set; }
+
+        public string Alternate { get; set; }
+        public FpRoutine Routine { get; set; }       
+
+        /// <summary>
+        /// The processing arguments that match the route
+        /// </summary>
+        [NotMapped]
+        public FileProcessArgs MatchArgs
+        {
+            get
+            {
+                return new FileProcessArgs()
+                {
+                    Alternate = this.Alternate,
+                    Routine = (FpRoutine) Routine
+                };
+            }
+        }
+    }
+}
diff --git a/VNLib.Plugins.Essentials.Content.Routing/Model/RouteStore.cs b/VNLib.Plugins.Essentials.Content.Routing/Model/RouteStore.cs
new file mode 100644
index 0000000..8650f30
--- /dev/null
+++ b/VNLib.Plugins.Essentials.Content.Routing/Model/RouteStore.cs
@@ -0,0 +1,44 @@
+using System;
+using System.Linq;
+
+using Microsoft.EntityFrameworkCore;
+
+using VNLib.Plugins.Extensions.Data;
+
+namespace VNLib.Plugins.Essentials.Content.Routing.Model
+{
+    internal class RouteStore : DbStore<Route>
+    {
+        private readonly DbContextOptions Options;
+
+        public RouteStore(DbContextOptions options)
+        {
+            Options = options;
+        }
+
+        public override string RecordIdBuilder => Guid.NewGuid().ToString("N");
+
+        protected override IQueryable<Route> GetCollectionQueryBuilder(TransactionalDbContext context, params string[] constraints)
+        {
+            string hostname = constraints[0];
+            return from route in context.Set<Route>()
+                   where route.Hostname == hostname
+                   select route;
+        }
+
+        protected override IQueryable<Route> GetSingleQueryBuilder(TransactionalDbContext context, params string[] constraints)
+        {
+            string id = constraints[0];
+            return from route in context.Set<Route>()
+                   where route.Id == id
+                   select route;
+        }
+
+        public override TransactionalDbContext NewContext() => new RoutingContext(Options);
+
+        protected override void OnRecordUpdate(Route newRecord, Route currentRecord)
+        {
+            throw new NotImplementedException();
+        }
+    }
+}
diff --git a/VNLib.Plugins.Essentials.Content.Routing/Model/RoutingContext.cs b/VNLib.Plugins.Essentials.Content.Routing/Model/RoutingContext.cs
new file mode 100644
index 0000000..da62342
--- /dev/null
+++ b/VNLib.Plugins.Essentials.Content.Routing/Model/RoutingContext.cs
@@ -0,0 +1,17 @@
+using System;
+
+using Microsoft.EntityFrameworkCore;
+
+using VNLib.Plugins.Extensions.Data;
+
+namespace VNLib.Plugins.Essentials.Content.Routing.Model
+{
+    internal class RoutingContext : TransactionalDbContext
+    {
+        public DbSet<Route> Routes { get; set; }
+
+        public RoutingContext(DbContextOptions options) :base(options)
+        {
+        }
+    }
+}