From 2d9235070856c0a5032ddf47f7b1dc7cc5cceb60 Mon Sep 17 00:00:00 2001 From: Fuwn Date: Thu, 25 Jul 2024 00:19:44 -0700 Subject: refactor(Database): separate providers --- src/lib/Database/userConfiguration.ts | 50 ----------------------------------- 1 file changed, 50 deletions(-) delete mode 100644 src/lib/Database/userConfiguration.ts (limited to 'src/lib/Database/userConfiguration.ts') diff --git a/src/lib/Database/userConfiguration.ts b/src/lib/Database/userConfiguration.ts deleted file mode 100644 index 6a22105a..00000000 --- a/src/lib/Database/userConfiguration.ts +++ /dev/null @@ -1,50 +0,0 @@ -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; -}; -- cgit v1.2.3