diff options
| author | Fuwn <[email protected]> | 2024-10-09 00:41:20 -0700 |
|---|---|---|
| committer | Fuwn <[email protected]> | 2024-10-09 00:41:43 -0700 |
| commit | 998b63a35256ac985a5a2714dd1ca451af4dfd8a (patch) | |
| tree | 50796121a9d5ab0330fdc5d7e098bda2860d9726 /src/lib/Database/SB/User | |
| parent | feat(graphql): add badgeCount field (diff) | |
| download | due.moe-998b63a35256ac985a5a2714dd1ca451af4dfd8a.tar.xz due.moe-998b63a35256ac985a5a2714dd1ca451af4dfd8a.zip | |
chore(prettier): use spaces instead of tabs
Diffstat (limited to 'src/lib/Database/SB/User')
| -rw-r--r-- | src/lib/Database/SB/User/badges.ts | 2 | ||||
| -rw-r--r-- | src/lib/Database/SB/User/configuration.ts | 54 | ||||
| -rw-r--r-- | src/lib/Database/SB/User/notifications.ts | 44 | ||||
| -rw-r--r-- | src/lib/Database/SB/User/preferences.ts | 216 |
4 files changed, 158 insertions, 158 deletions
diff --git a/src/lib/Database/SB/User/badges.ts b/src/lib/Database/SB/User/badges.ts index bea8f3e3..be866acc 100644 --- a/src/lib/Database/SB/User/badges.ts +++ b/src/lib/Database/SB/User/badges.ts @@ -22,7 +22,7 @@ export const getUserBadges = async (userId: number): Promise<Badge[]> => { return data.sort((a, b) => databaseTimeToDate((a as Badge).time ?? '').getTime() > - databaseTimeToDate((b as Badge).time ?? '').getTime() + databaseTimeToDate((b as Badge).time ?? '').getTime() ? -1 : 1 ) as Badge[]; diff --git a/src/lib/Database/SB/User/configuration.ts b/src/lib/Database/SB/User/configuration.ts index b889e95c..ab1373da 100644 --- a/src/lib/Database/SB/User/configuration.ts +++ b/src/lib/Database/SB/User/configuration.ts @@ -1,47 +1,47 @@ import sb from '../../sb'; interface UserConfiguration { - user_id: number; - configuration: object; - created_at: string; - updated_at: string; + user_id: number; + configuration: object; + created_at: string; + updated_at: string; } interface NewUserConfiguration { - configuration: object; - updated_at?: string; + configuration: object; + updated_at?: string; } export const getUserConfiguration = async (userId: number) => { - const { data, error } = await sb.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; + if (error || data.length === 0 || data[0].user_id !== userId) return null; - return data[0] as UserConfiguration; + return data[0] as UserConfiguration; }; export const setUserConfiguration = async (userId: number, configuration: NewUserConfiguration) => { - const { data, error } = await sb - .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; + const { data, error } = await sb + .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 sb.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; + if (error || !data) return null; - return data; + return data; }; diff --git a/src/lib/Database/SB/User/notifications.ts b/src/lib/Database/SB/User/notifications.ts index add0c8a8..b30896a2 100644 --- a/src/lib/Database/SB/User/notifications.ts +++ b/src/lib/Database/SB/User/notifications.ts @@ -1,38 +1,38 @@ import sb from '../../sb'; export interface UserNotifications { - created_at: string; - updated_at: string; - user_id: number; - subscription: JSON; - fingerprint: string; + created_at: string; + updated_at: string; + user_id: number; + subscription: JSON; + fingerprint: string; } export const getUserSubscription = async (userId: number) => - await sb.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 sb.from('user_notifications').select('*'); + const { data, error } = await sb.from('user_notifications').select('*'); - if (error) return []; + if (error) return []; - return data as UserNotifications[]; + return data as UserNotifications[]; }; export const deleteUserSubscription = async (userId: number, fingerprint: string) => - await sb.from('user_notifications').delete().eq('user_id', userId).eq('fingerprint', fingerprint); + await sb.from('user_notifications').delete().eq('user_id', userId).eq('fingerprint', fingerprint); export const setUserSubscription = async ( - userId: number, - subscription: JSON, - fingerprint: string + userId: number, + subscription: JSON, + fingerprint: string ) => - await sb.from('user_notifications').upsert( - { - user_id: userId, - updated_at: new Date().toISOString(), - subscription: subscription, - fingerprint - }, - { onConflict: 'user_id' } - ); + await sb.from('user_notifications').upsert( + { + user_id: userId, + updated_at: new Date().toISOString(), + subscription: subscription, + fingerprint + }, + { onConflict: 'user_id' } + ); diff --git a/src/lib/Database/SB/User/preferences.ts b/src/lib/Database/SB/User/preferences.ts index e08d1e48..d773d898 100644 --- a/src/lib/Database/SB/User/preferences.ts +++ b/src/lib/Database/SB/User/preferences.ts @@ -1,156 +1,156 @@ import sb from '../../sb'; export interface UserPreferences { - created_at: string; - updated_at: string; - user_id: number; - pinned_hololive_streams: string[]; - hide_missing_badges: boolean; - biography: string | null; - badge_wall_css: string; - hide_awc_badges: boolean; - pinned_badge_wall_categories: string[]; + created_at: string; + updated_at: string; + user_id: number; + pinned_hololive_streams: string[]; + hide_missing_badges: boolean; + biography: string | null; + badge_wall_css: string; + hide_awc_badges: boolean; + pinned_badge_wall_categories: string[]; } interface NewUserPreferences { - updated_at?: string; - pinned_hololive_streams?: string[]; - hide_missing_badges?: boolean; - badge_wall_css?: string; - biography?: string; - hide_awc_badges?: boolean; - pinned_badge_wall_categories?: string[]; + updated_at?: string; + pinned_hololive_streams?: string[]; + hide_missing_badges?: boolean; + badge_wall_css?: string; + biography?: string; + hide_awc_badges?: boolean; + pinned_badge_wall_categories?: string[]; } export const getUserPreferences = async (userId: number) => { - const { data, error } = await sb.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; + if (error || data.length === 0 || data[0].user_id !== userId) return null; - return data[0] as UserPreferences; + return data[0] as UserPreferences; }; export const setUserPreferences = async (userId: number, preferences: NewUserPreferences) => { - const userPreferences = await getUserPreferences(userId); - const { data, error } = await sb - .from('user_preferences') - .upsert( - { - user_id: userId, - updated_at: preferences.updated_at || new Date().toISOString(), - pinned_hololive_streams: - preferences.pinned_hololive_streams || - (userPreferences ? userPreferences.pinned_hololive_streams : []), - hide_missing_badges: preferences.hide_missing_badges || false, - biography: preferences.biography || (userPreferences ? userPreferences.biography : null), - badge_wall_css: - preferences.badge_wall_css || (userPreferences ? userPreferences.badge_wall_css : ''), - hide_awc_badges: preferences.hide_awc_badges || false, - pinned_badge_wall_categories: - preferences.pinned_badge_wall_categories || - (userPreferences ? userPreferences.pinned_badge_wall_categories : '') - }, - { onConflict: 'user_id' } - ) - .select(); - - if (error || !data || (data as []).length === 0) return null; - - return data[0] as UserPreferences; + const userPreferences = await getUserPreferences(userId); + const { data, error } = await sb + .from('user_preferences') + .upsert( + { + user_id: userId, + updated_at: preferences.updated_at || new Date().toISOString(), + pinned_hololive_streams: + preferences.pinned_hololive_streams || + (userPreferences ? userPreferences.pinned_hololive_streams : []), + hide_missing_badges: preferences.hide_missing_badges || false, + biography: preferences.biography || (userPreferences ? userPreferences.biography : null), + badge_wall_css: + preferences.badge_wall_css || (userPreferences ? userPreferences.badge_wall_css : ''), + hide_awc_badges: preferences.hide_awc_badges || false, + pinned_badge_wall_categories: + preferences.pinned_badge_wall_categories || + (userPreferences ? userPreferences.pinned_badge_wall_categories : '') + }, + { onConflict: 'user_id' } + ) + .select(); + + if (error || !data || (data as []).length === 0) return null; + + return data[0] as UserPreferences; }; export const toggleHololiveStreamPinning = async (userId: number, streamId: string) => { - const userPreferences = await getUserPreferences(userId); + const userPreferences = await getUserPreferences(userId); - if (!userPreferences) return null; + if (!userPreferences) return null; - const pinnedStreams = userPreferences.pinned_hololive_streams; - const index = pinnedStreams.indexOf(streamId); + const pinnedStreams = userPreferences.pinned_hololive_streams; + const index = pinnedStreams.indexOf(streamId); - if (index === -1) pinnedStreams.push(streamId); - else pinnedStreams.splice(index, 1); + if (index === -1) pinnedStreams.push(streamId); + else pinnedStreams.splice(index, 1); - return await setUserPreferences(userId, { - updated_at: new Date().toISOString(), - pinned_hololive_streams: pinnedStreams, - hide_missing_badges: userPreferences.hide_missing_badges - }); + return await setUserPreferences(userId, { + updated_at: new Date().toISOString(), + pinned_hololive_streams: pinnedStreams, + hide_missing_badges: userPreferences.hide_missing_badges + }); }; export const toggleHideMissingBadges = async (userId: number) => { - const userPreferences = await getUserPreferences(userId); + const userPreferences = await getUserPreferences(userId); - return await setUserPreferences(userId, { - updated_at: new Date().toISOString(), - pinned_hololive_streams: userPreferences ? userPreferences.pinned_hololive_streams : [], - hide_missing_badges: userPreferences ? !userPreferences.hide_missing_badges : false - }); + return await setUserPreferences(userId, { + updated_at: new Date().toISOString(), + pinned_hololive_streams: userPreferences ? userPreferences.pinned_hololive_streams : [], + hide_missing_badges: userPreferences ? !userPreferences.hide_missing_badges : false + }); }; export const toggleHideAWCBadges = async (userId: number) => { - const userPreferences = await getUserPreferences(userId); + const userPreferences = await getUserPreferences(userId); - return await setUserPreferences(userId, { - updated_at: new Date().toISOString(), - hide_awc_badges: userPreferences ? !userPreferences.hide_awc_badges : false - }); + return await setUserPreferences(userId, { + updated_at: new Date().toISOString(), + hide_awc_badges: userPreferences ? !userPreferences.hide_awc_badges : false + }); }; export const setCSS = async (userId: number, css: string) => { - const userPreferences = await getUserPreferences(userId); - - return await setUserPreferences(userId, { - updated_at: new Date().toISOString(), - pinned_hololive_streams: userPreferences ? userPreferences.pinned_hololive_streams : [], - hide_missing_badges: userPreferences ? userPreferences.hide_missing_badges : false, - badge_wall_css: - css || - "/* Use classes and IDs such as .badges, #badges, .badge, or standard elements like body and details, or anything, as long as it's valid CSS! */" - }); + const userPreferences = await getUserPreferences(userId); + + return await setUserPreferences(userId, { + updated_at: new Date().toISOString(), + pinned_hololive_streams: userPreferences ? userPreferences.pinned_hololive_streams : [], + hide_missing_badges: userPreferences ? userPreferences.hide_missing_badges : false, + badge_wall_css: + css || + "/* Use classes and IDs such as .badges, #badges, .badge, or standard elements like body and details, or anything, as long as it's valid CSS! */" + }); }; export const setBiography = async (userId: number, biography: string) => { - const userPreferences = await getUserPreferences(userId); - - return await setUserPreferences(userId, { - updated_at: new Date().toISOString(), - pinned_hololive_streams: userPreferences ? userPreferences.pinned_hololive_streams : [], - hide_missing_badges: userPreferences ? userPreferences.hide_missing_badges : false, - badge_wall_css: userPreferences ? userPreferences.badge_wall_css : '', - biography: biography || '\n' - }); + const userPreferences = await getUserPreferences(userId); + + return await setUserPreferences(userId, { + updated_at: new Date().toISOString(), + pinned_hololive_streams: userPreferences ? userPreferences.pinned_hololive_streams : [], + hide_missing_badges: userPreferences ? userPreferences.hide_missing_badges : false, + badge_wall_css: userPreferences ? userPreferences.badge_wall_css : '', + biography: biography || '\n' + }); }; export const togglePinnedBadgeWallCategory = async (userId: number, category: string) => { - const userPreferences = await getUserPreferences(userId); + const userPreferences = await getUserPreferences(userId); - if (!userPreferences) return null; + if (!userPreferences) return null; - const pinnedCategories = userPreferences.pinned_badge_wall_categories; - const index = pinnedCategories.indexOf(category); + const pinnedCategories = userPreferences.pinned_badge_wall_categories; + const index = pinnedCategories.indexOf(category); - if (index === -1) pinnedCategories.push(category); - else pinnedCategories.splice(index, 1); + if (index === -1) pinnedCategories.push(category); + else pinnedCategories.splice(index, 1); - return await setUserPreferences(userId, { - updated_at: new Date().toISOString(), - pinned_hololive_streams: userPreferences.pinned_hololive_streams, - hide_missing_badges: userPreferences.hide_missing_badges, - badge_wall_css: userPreferences.badge_wall_css, - pinned_badge_wall_categories: pinnedCategories - }); + return await setUserPreferences(userId, { + updated_at: new Date().toISOString(), + pinned_hololive_streams: userPreferences.pinned_hololive_streams, + hide_missing_badges: userPreferences.hide_missing_badges, + badge_wall_css: userPreferences.badge_wall_css, + pinned_badge_wall_categories: pinnedCategories + }); }; export const setPinnedBadgeWallCategories = async (userId: number, categories: string[]) => { - const userPreferences = await getUserPreferences(userId); + const userPreferences = await getUserPreferences(userId); - if (!userPreferences) return null; + if (!userPreferences) return null; - return await setUserPreferences(userId, { - updated_at: new Date().toISOString(), - pinned_hololive_streams: userPreferences.pinned_hololive_streams, - hide_missing_badges: userPreferences.hide_missing_badges, - badge_wall_css: userPreferences.badge_wall_css, - pinned_badge_wall_categories: categories - }); + return await setUserPreferences(userId, { + updated_at: new Date().toISOString(), + pinned_hololive_streams: userPreferences.pinned_hololive_streams, + hide_missing_badges: userPreferences.hide_missing_badges, + badge_wall_css: userPreferences.badge_wall_css, + pinned_badge_wall_categories: categories + }); }; |