refactor(Database): separate providers

1 files changed, 50 insertions, 0 deletions

diff --git a/src/lib/Database/Supabase/userConfiguration.ts b/src/lib/Database/Supabase/userConfiguration.ts
new file mode 100644
index 00000000..cb2e4060
--- /dev/null
+++ b/src/lib/Database/Supabase/userConfiguration.ts
@@ -0,0 +1,50 @@
+import supabase from '../supabase';
+
+interface UserConfiguration {
+	user_id: number;
+	configuration: object;
+	created_at: string;
+	updated_at: string;
+}
+
+interface NewUserConfiguration {
+	configuration: object;
+	updated_at?: string;
+}
+
+export const getUserConfiguration = async (userId: number) => {
+	const { data, error } = await supabase
+		.from('user_configuration')
+		.select('*')
+		.eq('user_id', userId);
+
+	if (error || data.length === 0 || data[0].user_id !== userId) return null;
+
+	return data[0] as UserConfiguration;
+};
+
+export const setUserConfiguration = async (userId: number, configuration: NewUserConfiguration) => {
+	const { data, error } = await supabase
+		.from('user_configuration')
+		.upsert(
+			{
+				user_id: userId,
+				configuration: configuration.configuration,
+				updated_at: configuration.updated_at || new Date().toISOString()
+			},
+			{ onConflict: 'user_id' }
+		)
+		.select();
+
+	if (error || !data || (data as []).length === 0) return null;
+
+	return data[0].configuration as UserConfiguration;
+};
+
+export const deleteUserConfiguration = async (userId: number) => {
+	const { data, error } = await supabase.from('user_configuration').delete().eq('user_id', userId);
+
+	if (error || !data) return null;
+
+	return data;
+};