From a8417ece5d5d0f75a6215dbfd47f0cc2f691defd Mon Sep 17 00:00:00 2001 From: Fuwn Date: Sun, 11 Feb 2024 15:45:56 -0800 Subject: feat(database): config sync scaffolding --- src/lib/Database/userConfiguration.ts | 29 +++++++++++++++++++++++++++++ 1 file changed, 29 insertions(+) create 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 new file mode 100644 index 00000000..5e2f0c96 --- /dev/null +++ b/src/lib/Database/userConfiguration.ts @@ -0,0 +1,29 @@ +import supabase from './supabase'; + +interface UserConfiguration { + user_id: number; + configuration: any; + created_at: string; + 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: UserConfiguration) => { + const { data, error } = await supabase + .from('user_configuration') + .upsert({ user_id: userId, configuration }); + + if (error || !data || (data as []).length === 0) return null; + + return data[0] as UserConfiguration; +}; -- cgit v1.2.3