refactor(supabase): move app access to service role

9 files changed, 19 insertions, 14 deletions

diff --git a/src/lib/Database/SB/User/badges.ts b/src/lib/Database/SB/User/badges.ts
index 5d7d4899..026ca98f 100644
--- a/src/lib/Database/SB/User/badges.ts
+++ b/src/lib/Database/SB/User/badges.ts
@@ -1,5 +1,5 @@
 import { databaseTimeToDate } from "$lib/Utility/time";
-import sb from "../../sb";
+import sb from "../../sb.server";
 
 export interface Badge {
 	id: number;
@@ -87,7 +87,7 @@ export const addUserBadge = async (userId: number, badge: BadgeInput) => {
 };
 
 export const removeUserBadge = async (userId: number, id: number) => {
-	if (!isNaN(id))
+	if (!Number.isNaN(id))
 		await sb.from("user_badges").delete().eq("id", id).eq("user_id", userId);
 };
 
diff --git a/src/lib/Database/SB/User/configuration.ts b/src/lib/Database/SB/User/configuration.ts
index 6007e41b..09c74c6c 100644
--- a/src/lib/Database/SB/User/configuration.ts
+++ b/src/lib/Database/SB/User/configuration.ts
@@ -1,4 +1,4 @@
-import sb from "../../sb";
+import sb from "../../sb.server";
 
 interface UserConfiguration {
 	user_id: number;
diff --git a/src/lib/Database/SB/User/notifications.ts b/src/lib/Database/SB/User/notifications.ts
index 75dd5941..058171a9 100644
--- a/src/lib/Database/SB/User/notifications.ts
+++ b/src/lib/Database/SB/User/notifications.ts
@@ -1,4 +1,4 @@
-import sb from "../../sb";
+import sb from "../../sb.server";
 
 export interface UserNotifications {
 	created_at: string;
diff --git a/src/lib/Database/SB/User/preferences.ts b/src/lib/Database/SB/User/preferences.ts
index f0a49397..fcffbff2 100644
--- a/src/lib/Database/SB/User/preferences.ts
+++ b/src/lib/Database/SB/User/preferences.ts
@@ -1,4 +1,4 @@
-import sb from "../../sb";
+import sb from "../../sb.server";
 
 export interface UserPreferences {
 	created_at: string;
diff --git a/src/lib/Database/SB/badges.ts b/src/lib/Database/SB/badges.ts
index a287f01b..79a05d3d 100644
--- a/src/lib/Database/SB/badges.ts
+++ b/src/lib/Database/SB/badges.ts
@@ -1,4 +1,4 @@
-import sb from "../sb";
+import sb from "../sb.server";
 
 interface Badge {
 	id: number;
diff --git a/src/lib/Database/SB/events.ts b/src/lib/Database/SB/events.ts
index de213185..f386391c 100644
--- a/src/lib/Database/SB/events.ts
+++ b/src/lib/Database/SB/events.ts
@@ -1,5 +1,5 @@
 import type { Group } from "$lib/Database/SB/groups";
-import sb from "../sb";
+import sb from "../sb.server";
 
 export interface Event {
 	id: number;
diff --git a/src/lib/Database/SB/groups.ts b/src/lib/Database/SB/groups.ts
index 8cecb08f..4ff0d316 100644
--- a/src/lib/Database/SB/groups.ts
+++ b/src/lib/Database/SB/groups.ts
@@ -1,4 +1,4 @@
-import sb from "../sb";
+import sb from "../sb.server";
 
 export interface Group {
 	id: number;
diff --git a/src/lib/Database/sb.server.ts b/src/lib/Database/sb.server.ts
new file mode 100644
index 00000000..f380f98f
--- /dev/null
+++ b/src/lib/Database/sb.server.ts
@@ -0,0 +1,11 @@
+import { createClient } from "@supabase/supabase-js";
+import { SUPABASE_SERVICE_ROLE_KEY, SUPABASE_URL } from "$env/static/private";
+
+const sb = createClient(SUPABASE_URL, SUPABASE_SERVICE_ROLE_KEY, {
+	auth: {
+		autoRefreshToken: false,
+		persistSession: false,
+	},
+});
+
+export default sb;
diff --git a/src/lib/Database/sb.ts b/src/lib/Database/sb.ts
deleted file mode 100644
index d5b39a98..00000000
--- a/src/lib/Database/sb.ts
+++ /dev/null
@@ -1,6 +0,0 @@
-import { createClient } from "@supabase/supabase-js";
-import { SUPABASE_URL, SUPABASE_ANON_KEY } from "$env/static/private";
-
-const sb = createClient(SUPABASE_URL, SUPABASE_ANON_KEY);
-
-export default sb;