Database creation tools

1 files changed, 13 insertions, 1 deletions

diff --git a/plugins/VNLib.Plugins.Essentials.Content.Routing/src/PageRouterEntry.cs b/plugins/VNLib.Plugins.Essentials.Content.Routing/src/PageRouterEntry.cs
index 0c04047..e71ee6b 100644
--- a/plugins/VNLib.Plugins.Essentials.Content.Routing/src/PageRouterEntry.cs
+++ b/plugins/VNLib.Plugins.Essentials.Content.Routing/src/PageRouterEntry.cs
@@ -23,12 +23,14 @@
 */
 
 using System;
+using System.Threading.Tasks;
 using System.ComponentModel.Design;
 
 using VNLib.Utils.Logging;
 using VNLib.Plugins.Attributes;
 using VNLib.Plugins.Extensions.Loading;
-
+using VNLib.Plugins.Extensions.Loading.Sql;
+using VNLib.Plugins.Essentials.Content.Routing.Model;
 
 namespace VNLib.Plugins.Essentials.Content.Routing
 {
@@ -49,6 +51,10 @@ namespace VNLib.Plugins.Essentials.Content.Routing
         {
             //Init router
             PageRouter = this.GetOrCreateSingleton<Router>();
+
+            //Schedule the db creation
+            _ = this.ObserveWork(OnDbCreationAsync, 500);
+
             Log.Information("Plugin loaded");
         }
 
@@ -65,5 +71,11 @@ namespace VNLib.Plugins.Essentials.Content.Routing
                 Log.Information("Routing table reset");
             }
         }
+
+        private async Task OnDbCreationAsync()
+        {
+            //Create the router
+            await this.EnsureDbCreatedAsync<RoutingContext>(null);
+        }
     }
 }