diff options
| author | Fuwn <[email protected]> | 2024-08-24 02:38:40 -0700 |
|---|---|---|
| committer | Fuwn <[email protected]> | 2024-08-24 02:42:01 -0700 |
| commit | 32c7545faae4f33c94a045408789c9b9ef7de53a (patch) | |
| tree | 3ce6632bd710b4453749f0e71186027683415843 /src/lib/Database | |
| parent | feat(SequelCatcher): side stories toggle (diff) | |
| download | due.moe-32c7545faae4f33c94a045408789c9b9ef7de53a.tar.xz due.moe-32c7545faae4f33c94a045408789c9b9ef7de53a.zip | |
refactor(Data): rename database references
Diffstat (limited to 'src/lib/Database')
| -rw-r--r-- | src/lib/Database/IDB/activities.ts (renamed from src/lib/Database/IndexedDB/activities.ts) | 0 | ||||
| -rw-r--r-- | src/lib/Database/IDB/chapters.ts (renamed from src/lib/Database/IndexedDB/chapters.ts) | 0 | ||||
| -rw-r--r-- | src/lib/Database/IDB/user.ts (renamed from src/lib/Database/IndexedDB/user.ts) | 0 | ||||
| -rw-r--r-- | src/lib/Database/SB/User/badges.ts (renamed from src/lib/Database/Supabase/User/badges.ts) | 24 | ||||
| -rw-r--r-- | src/lib/Database/SB/User/configuration.ts (renamed from src/lib/Database/Supabase/User/configuration.ts) | 11 | ||||
| -rw-r--r-- | src/lib/Database/SB/User/notifications.ts (renamed from src/lib/Database/Supabase/User/notifications.ts) | 10 | ||||
| -rw-r--r-- | src/lib/Database/SB/User/preferences.ts (renamed from src/lib/Database/Supabase/User/preferences.ts) | 6 | ||||
| -rw-r--r-- | src/lib/Database/SB/badges.ts (renamed from src/lib/Database/Supabase/badges.ts) | 16 | ||||
| -rw-r--r-- | src/lib/Database/SB/events.ts (renamed from src/lib/Database/Supabase/events.ts) | 13 | ||||
| -rw-r--r-- | src/lib/Database/SB/groups.ts (renamed from src/lib/Database/Supabase/groups.ts) | 6 | ||||
| -rw-r--r-- | src/lib/Database/sb.ts (renamed from src/lib/Database/supabase.ts) | 4 |
11 files changed, 42 insertions, 48 deletions
diff --git a/src/lib/Database/IndexedDB/activities.ts b/src/lib/Database/IDB/activities.ts index 6a505ff3..6a505ff3 100644 --- a/src/lib/Database/IndexedDB/activities.ts +++ b/src/lib/Database/IDB/activities.ts diff --git a/src/lib/Database/IndexedDB/chapters.ts b/src/lib/Database/IDB/chapters.ts index 0f77f0a0..0f77f0a0 100644 --- a/src/lib/Database/IndexedDB/chapters.ts +++ b/src/lib/Database/IDB/chapters.ts diff --git a/src/lib/Database/IndexedDB/user.ts b/src/lib/Database/IDB/user.ts index e7285a07..e7285a07 100644 --- a/src/lib/Database/IndexedDB/user.ts +++ b/src/lib/Database/IDB/user.ts diff --git a/src/lib/Database/Supabase/User/badges.ts b/src/lib/Database/SB/User/badges.ts index 25fae9b7..14f848c5 100644 --- a/src/lib/Database/Supabase/User/badges.ts +++ b/src/lib/Database/SB/User/badges.ts @@ -1,5 +1,5 @@ import { databaseTimeToDate } from '$lib/Utility/time'; -import supabase from '../../supabase'; +import sb from '../../sb'; export interface Badge { post?: string; @@ -16,7 +16,7 @@ export interface Badge { } export const getUserBadges = async (userId: number): Promise<Badge[]> => { - const { data, error } = await supabase.from('user_badges').select('*').eq('user_id', userId); + const { data, error } = await sb.from('user_badges').select('*').eq('user_id', userId); if (error) return []; @@ -34,7 +34,7 @@ export const addUserBadge = async (userId: number, badge: Badge) => { if (post === undefined || image === undefined) return; if (time) { - await supabase.from('user_badges').insert({ + await sb.from('user_badges').insert({ user_id: userId, post, image, @@ -46,20 +46,20 @@ export const addUserBadge = async (userId: number, badge: Badge) => { designer }); } else { - await supabase + await sb .from('user_badges') .insert({ user_id: userId, post, image, description, category, hidden, source, designer }); } }; export const removeUserBadge = async (userId: number, id: number) => { - if (!isNaN(id)) await supabase.from('user_badges').delete().eq('id', id).eq('user_id', userId); + if (!isNaN(id)) await sb.from('user_badges').delete().eq('id', id).eq('user_id', userId); }; export const updateUserBadge = async (userId: number, id: number, badge: Badge) => { if (badge.post === undefined || badge.image === undefined) return; - await supabase + await sb .from('user_badges') .update({ post: badge.post, @@ -76,31 +76,31 @@ export const updateUserBadge = async (userId: number, id: number, badge: Badge) }; export const renameCategory = async (userId: number, oldName: string, newName: string) => - await supabase + await sb .from('user_badges') .update({ category: newName }) .eq('category', oldName) .eq('user_id', userId); export const removeAllUserBadges = async (userId: number) => - await supabase.from('user_badges').delete().eq('user_id', userId); + await sb.from('user_badges').delete().eq('user_id', userId); export const migrateCategory = async (userId: number, oldName: string, newName: string) => - await supabase + await sb .from('user_badges') .update({ category: newName }) .eq('category', oldName) .eq('user_id', userId); export const setShadowHidden = async (userId: number, shadowHide: boolean) => - await supabase.from('user_badges').update({ shadow_hidden: shadowHide }).eq('user_id', userId); + await sb.from('user_badges').update({ shadow_hidden: shadowHide }).eq('user_id', userId); export const setShadowHiddenBadge = async (userId: number, id: number, shadowHide: boolean) => - await supabase + await sb .from('user_badges') .update({ shadow_hidden: shadowHide }) .eq('id', id) .eq('user_id', userId); export const incrementClickCount = async (id: number) => - await supabase.rpc('user_badges_increment_click_count', { user_badge_id: id }); + await sb.rpc('user_badges_increment_click_count', { user_badge_id: id }); diff --git a/src/lib/Database/Supabase/User/configuration.ts b/src/lib/Database/SB/User/configuration.ts index 36da1963..b889e95c 100644 --- a/src/lib/Database/Supabase/User/configuration.ts +++ b/src/lib/Database/SB/User/configuration.ts @@ -1,4 +1,4 @@ -import supabase from '../../supabase'; +import sb from '../../sb'; interface UserConfiguration { user_id: number; @@ -13,10 +13,7 @@ interface NewUserConfiguration { } export const getUserConfiguration = async (userId: number) => { - const { data, error } = await supabase - .from('user_configuration') - .select('*') - .eq('user_id', userId); + const { data, error } = await sb.from('user_configuration').select('*').eq('user_id', userId); if (error || data.length === 0 || data[0].user_id !== userId) return null; @@ -24,7 +21,7 @@ export const getUserConfiguration = async (userId: number) => { }; export const setUserConfiguration = async (userId: number, configuration: NewUserConfiguration) => { - const { data, error } = await supabase + const { data, error } = await sb .from('user_configuration') .upsert( { @@ -42,7 +39,7 @@ export const setUserConfiguration = async (userId: number, configuration: NewUse }; export const deleteUserConfiguration = async (userId: number) => { - const { data, error } = await supabase.from('user_configuration').delete().eq('user_id', userId); + const { data, error } = await sb.from('user_configuration').delete().eq('user_id', userId); if (error || !data) return null; diff --git a/src/lib/Database/Supabase/User/notifications.ts b/src/lib/Database/SB/User/notifications.ts index d8cd75ee..b07a0a3a 100644 --- a/src/lib/Database/Supabase/User/notifications.ts +++ b/src/lib/Database/SB/User/notifications.ts @@ -1,4 +1,4 @@ -import supabase from '../../supabase'; +import sb from '../../sb'; export interface UserNotifications { created_at: string; @@ -8,10 +8,10 @@ export interface UserNotifications { } export const getUserSubscription = async (userId: number) => - await supabase.from('user_notifications').select('*').eq('user_id', userId); + await sb.from('user_notifications').select('*').eq('user_id', userId); export const getUserSubscriptions = async () => { - const { data, error } = await supabase.from('user_notifications').select('*'); + const { data, error } = await sb.from('user_notifications').select('*'); if (error) return []; @@ -19,10 +19,10 @@ export const getUserSubscriptions = async () => { }; export const deleteUserSubscription = async (userId: number) => - await supabase.from('user_notifications').delete().eq('user_id', userId); + await sb.from('user_notifications').delete().eq('user_id', userId); export const setUserSubscription = async (userId: number, subscription: JSON) => - await supabase.from('user_notifications').upsert( + await sb.from('user_notifications').upsert( { user_id: userId, updated_at: new Date().toISOString(), diff --git a/src/lib/Database/Supabase/User/preferences.ts b/src/lib/Database/SB/User/preferences.ts index 0eaebef7..e08d1e48 100644 --- a/src/lib/Database/Supabase/User/preferences.ts +++ b/src/lib/Database/SB/User/preferences.ts @@ -1,4 +1,4 @@ -import supabase from '../../supabase'; +import sb from '../../sb'; export interface UserPreferences { created_at: string; @@ -23,7 +23,7 @@ interface NewUserPreferences { } export const getUserPreferences = async (userId: number) => { - const { data, error } = await supabase.from('user_preferences').select('*').eq('user_id', userId); + const { data, error } = await sb.from('user_preferences').select('*').eq('user_id', userId); if (error || data.length === 0 || data[0].user_id !== userId) return null; @@ -32,7 +32,7 @@ export const getUserPreferences = async (userId: number) => { export const setUserPreferences = async (userId: number, preferences: NewUserPreferences) => { const userPreferences = await getUserPreferences(userId); - const { data, error } = await supabase + const { data, error } = await sb .from('user_preferences') .upsert( { diff --git a/src/lib/Database/Supabase/badges.ts b/src/lib/Database/SB/badges.ts index 022d4d14..f67ffe97 100644 --- a/src/lib/Database/Supabase/badges.ts +++ b/src/lib/Database/SB/badges.ts @@ -1,4 +1,4 @@ -import supabase from '../supabase'; +import sb from '../sb'; interface Badge { id: number; @@ -26,24 +26,22 @@ interface GetBy { export const getBadges = async (getBy?: GetBy) => { let data, error; - if (getBy?.event) - [data, error] = await supabase.from('badges').select('*').eq('event', getBy.event); + if (getBy?.event) [data, error] = await sb.from('badges').select('*').eq('event', getBy.event); else if (getBy?.group) - [data, error] = await supabase.from('badges').select('*').eq('group', getBy.group); - else [data, error] = await supabase.from('badges').select('*'); + [data, error] = await sb.from('badges').select('*').eq('group', getBy.group); + else [data, error] = await sb.from('badges').select('*'); if (error) return []; return data as Badge[]; }; -export const createBadge = async (badge: NewBadge) => await supabase.from('badges').insert(badge); +export const createBadge = async (badge: NewBadge) => await sb.from('badges').insert(badge); -export const deleteBadge = async (id: number) => - await supabase.from('badges').delete().eq('id', id); +export const deleteBadge = async (id: number) => await sb.from('badges').delete().eq('id', id); export const updateBadge = async (id: number, badge: NewBadge) => { if (!badge.updated_at) badge.updated_at = new Date().toISOString(); - return await supabase.from('badges').update(badge).eq('id', id); + return await sb.from('badges').update(badge).eq('id', id); }; diff --git a/src/lib/Database/Supabase/events.ts b/src/lib/Database/SB/events.ts index e87fe011..4691f158 100644 --- a/src/lib/Database/Supabase/events.ts +++ b/src/lib/Database/SB/events.ts @@ -1,5 +1,5 @@ import type Group from '$lib/Events/Group.svelte'; -import supabase from '../supabase'; +import sb from '../sb'; export interface Event { id: number; @@ -19,7 +19,7 @@ interface NewEvent { } export const getEvents = async () => { - const { data, error } = await supabase.from('events').select('*, group:groups(*)'); + const { data, error } = await sb.from('events').select('*, group:groups(*)'); if (error) return []; @@ -27,20 +27,19 @@ export const getEvents = async () => { }; export const getGroupEvents = async (group: string) => { - const { data, error } = await supabase.from('events').select('*').eq('group', group); + const { data, error } = await sb.from('events').select('*').eq('group', group); if (error) return []; return data as Event[]; }; -export const createEvent = async (event: NewEvent) => await supabase.from('events').insert(event); +export const createEvent = async (event: NewEvent) => await sb.from('events').insert(event); -export const deleteEvent = async (id: number) => - await supabase.from('events').delete().eq('id', id); +export const deleteEvent = async (id: number) => await sb.from('events').delete().eq('id', id); export const updateEvent = async (id: number, event: NewEvent) => { if (!event.updated_at) event.updated_at = new Date().toISOString(); - return await supabase.from('events').update(event).eq('id', id); + return await sb.from('events').update(event).eq('id', id); }; diff --git a/src/lib/Database/Supabase/groups.ts b/src/lib/Database/SB/groups.ts index b2770e4a..90bee45f 100644 --- a/src/lib/Database/Supabase/groups.ts +++ b/src/lib/Database/SB/groups.ts @@ -1,4 +1,4 @@ -import supabase from '../supabase'; +import sb from '../sb'; export interface Group { id: number; @@ -16,7 +16,7 @@ export interface Group { } export const getGroups = async () => { - const { data, error } = await supabase.from('groups').select('*'); + const { data, error } = await sb.from('groups').select('*'); if (error) return []; @@ -24,7 +24,7 @@ export const getGroups = async () => { }; export const getGroup = async (slug: string) => { - const { data, error } = await supabase.from('groups').select('*').eq('anilist_username', slug); + const { data, error } = await sb.from('groups').select('*').eq('anilist_username', slug); if (error || data.length === 0) return null; diff --git a/src/lib/Database/supabase.ts b/src/lib/Database/sb.ts index ba8cf8d5..96fc65da 100644 --- a/src/lib/Database/supabase.ts +++ b/src/lib/Database/sb.ts @@ -1,6 +1,6 @@ import { createClient } from '@supabase/supabase-js'; import { SUPABASE_URL, SUPABASE_ANON_KEY } from '$env/static/private'; -const supabase = createClient(SUPABASE_URL, SUPABASE_ANON_KEY); +const sb = createClient(SUPABASE_URL, SUPABASE_ANON_KEY); -export default supabase; +export default sb; |