feat: WIP: Map github logins

When github is used for login, we want to create
a mapping to a regular user in our database.
This is mainly so that we don't have to change the PK in our database or add a column to it.

1 files changed, 22 insertions, 0 deletions

diff --git a/src/server/Utilities/ConnectionStrings.cs b/src/server/Utilities/ConnectionStrings.cs
new file mode 100644
index 0000000..8ea8f70
--- /dev/null
+++ b/src/server/Utilities/ConnectionStrings.cs
@@ -0,0 +1,22 @@
+namespace IOL.BookmarkThing.Server.Utilities;
+
+public static class ConnectionStrings
+{
+	public static string AppDatabaseConnectionString(IConfiguration Configuration) {
+		var host = Configuration.GetValue<string>("DB_HOST");
+		var port = Configuration.GetValue<string>("DB_PORT");
+		var database = Configuration.GetValue<string>("DB_NAME");
+		var user = Configuration.GetValue<string>("DB_USER");
+		var password = Configuration.GetValue<string>("DB_PASSWORD");
+		return $"Server={host};Port={port};Database={database};User Id={user};Password={password}";
+	}
+
+	public static string QuartzDatabaseConnectionString(IConfiguration Configuration) {
+		var host = Configuration.GetValue<string>("QUARTZ_DB_HOST");
+		var port = Configuration.GetValue<string>("QUARTZ_DB_PORT");
+		var database = Configuration.GetValue<string>("QUARTZ_DB_NAME");
+		var user = Configuration.GetValue<string>("QUARTZ_DB_USER");
+		var password = Configuration.GetValue<string>("QUARTZ_DB_PASSWORD");
+		return $"Server={host};Port={port};Database={database};User Id={user};Password={password}";
+	}
+}