From eae5d24d9e79e59a19d4721caaeaa0ca650ecb33 Mon Sep 17 00:00:00 2001 From: Fuwn Date: Sun, 1 Mar 2026 16:20:51 -0800 Subject: chore(biome): drop formatter style overrides --- src/lib/Database/IDB/activities.ts | 24 +-- src/lib/Database/IDB/chapters.ts | 24 +-- src/lib/Database/IDB/tracker.ts | 26 +-- src/lib/Database/IDB/user.ts | 26 +-- src/lib/Database/SB/User/badges.ts | 215 +++++++++++++----------- src/lib/Database/SB/User/configuration.ts | 67 ++++---- src/lib/Database/SB/User/notifications.ts | 55 ++++--- src/lib/Database/SB/User/preferences.ts | 262 +++++++++++++++++------------- src/lib/Database/SB/badges.ts | 69 ++++---- src/lib/Database/SB/events.ts | 51 +++--- src/lib/Database/SB/groups.ts | 41 ++--- src/lib/Database/sb.ts | 4 +- 12 files changed, 480 insertions(+), 384 deletions(-) (limited to 'src/lib/Database') diff --git a/src/lib/Database/IDB/activities.ts b/src/lib/Database/IDB/activities.ts index d58e97a5..3aaf1d61 100644 --- a/src/lib/Database/IDB/activities.ts +++ b/src/lib/Database/IDB/activities.ts @@ -1,22 +1,22 @@ -import type { ActivitiesPage } from '$lib/Data/AniList/activity'; -import Dexie, { type Table } from 'dexie'; +import type { ActivitiesPage } from "$lib/Data/AniList/activity"; +import Dexie, { type Table } from "dexie"; export interface ActivityPage { - page: number; - data: ActivitiesPage; + page: number; + data: ActivitiesPage; } export class ActivityDatabase extends Dexie { - activities: Table; + activities: Table; - constructor() { - super('activities'); - this.version(1).stores({ - activities: 'page, data' - }); + constructor() { + super("activities"); + this.version(1).stores({ + activities: "page, data", + }); - this.activities = this.table('activities'); - } + this.activities = this.table("activities"); + } } export const database = new ActivityDatabase(); diff --git a/src/lib/Database/IDB/chapters.ts b/src/lib/Database/IDB/chapters.ts index 571c16e1..56ac379b 100644 --- a/src/lib/Database/IDB/chapters.ts +++ b/src/lib/Database/IDB/chapters.ts @@ -1,22 +1,22 @@ -import Dexie, { type Table } from 'dexie'; +import Dexie, { type Table } from "dexie"; export interface Chapter { - id: number; - chapters: number | null; - volumes: number | null; + id: number; + chapters: number | null; + volumes: number | null; } export class ChapterDatabase extends Dexie { - chapters: Table; + chapters: Table; - constructor() { - super('chapters'); - this.version(1).stores({ - chapters: 'id, chapters, volumes' - }); + constructor() { + super("chapters"); + this.version(1).stores({ + chapters: "id, chapters, volumes", + }); - this.chapters = this.table('chapters'); - } + this.chapters = this.table("chapters"); + } } export const database = new ChapterDatabase(); diff --git a/src/lib/Database/IDB/tracker.ts b/src/lib/Database/IDB/tracker.ts index 4c3b116a..bb7d2f27 100644 --- a/src/lib/Database/IDB/tracker.ts +++ b/src/lib/Database/IDB/tracker.ts @@ -1,23 +1,23 @@ -import Dexie, { type Table } from 'dexie'; +import Dexie, { type Table } from "dexie"; export interface TrackerEntry { - id: string; - url: string; - title: string; - progress: number; + id: string; + url: string; + title: string; + progress: number; } export class TrackerDatabase extends Dexie { - entries: Table; + entries: Table; - constructor() { - super('tracker'); - this.version(1).stores({ - entries: 'id, url, title, progress' - }); + constructor() { + super("tracker"); + this.version(1).stores({ + entries: "id, url, title, progress", + }); - this.entries = this.table('entries'); - } + this.entries = this.table("entries"); + } } export const database = new TrackerDatabase(); diff --git a/src/lib/Database/IDB/user.ts b/src/lib/Database/IDB/user.ts index b1a1b936..1158a8ff 100644 --- a/src/lib/Database/IDB/user.ts +++ b/src/lib/Database/IDB/user.ts @@ -1,23 +1,23 @@ -import type { AniListAuthorisation } from '$lib/Data/AniList/identity'; -import Dexie, { type Table } from 'dexie'; +import type { AniListAuthorisation } from "$lib/Data/AniList/identity"; +import Dexie, { type Table } from "dexie"; export interface User { - id: number; - user: AniListAuthorisation; - lastNotificationID: number | null; + id: number; + user: AniListAuthorisation; + lastNotificationID: number | null; } export class UserDatabase extends Dexie { - users: Table; + users: Table; - constructor() { - super('users'); - this.version(1).stores({ - users: 'id, user, lastNotificationID' - }); + constructor() { + super("users"); + this.version(1).stores({ + users: "id, user, lastNotificationID", + }); - this.users = this.table('users'); - } + this.users = this.table("users"); + } } export const database = new UserDatabase(); diff --git a/src/lib/Database/SB/User/badges.ts b/src/lib/Database/SB/User/badges.ts index dd6c158e..685e7809 100644 --- a/src/lib/Database/SB/User/badges.ts +++ b/src/lib/Database/SB/User/badges.ts @@ -1,124 +1,157 @@ -import { databaseTimeToDate } from '$lib/Utility/time'; -import sb from '../../sb'; +import { databaseTimeToDate } from "$lib/Utility/time"; +import sb from "../../sb"; export interface Badge { - id: number; - post: string; - image: string; - hidden: boolean; - shadow_hidden: boolean; - click_count: number; - time?: string; - description?: string | null; - category?: string | null; - source?: string | null; - designer?: string | null; + id: number; + post: string; + image: string; + hidden: boolean; + shadow_hidden: boolean; + click_count: number; + time?: string; + description?: string | null; + category?: string | null; + source?: string | null; + designer?: string | null; } export interface BadgeInput { - post?: string; - image?: string; - description?: string | null; - time?: string; - category?: string | null; - hidden?: boolean; - source?: string | null; - designer?: string | null; + post?: string; + image?: string; + description?: string | null; + time?: string; + category?: string | null; + hidden?: boolean; + source?: string | null; + designer?: string | null; } const getPagination = (page: number, size: number) => { - const from = page ? page * (size ? +size : 3) : 0; + const from = page ? page * (size ? +size : 3) : 0; - return { from, to: page ? from + size - 1 : size - 1 }; + return { from, to: page ? from + size - 1 : size - 1 }; }; -export const getUserBadges = async (userId: number, page = 0, size = -1): Promise => { - const { from, to } = getPagination(page, size); - let query = sb.from('user_badges').select('*').eq('user_id', userId); +export const getUserBadges = async ( + userId: number, + page = 0, + size = -1, +): Promise => { + const { from, to } = getPagination(page, size); + let query = sb.from("user_badges").select("*").eq("user_id", userId); - if (size !== -1) query = query.range(from, to); + if (size !== -1) query = query.range(from, to); - const { data, error } = await query; + const { data, error } = await query; - if (error) return []; + if (error) return []; - return data.sort((a, b) => - databaseTimeToDate((a as Badge).time ?? '').getTime() > - databaseTimeToDate((b as Badge).time ?? '').getTime() - ? -1 - : 1 - ) as Badge[]; + return data.sort((a, b) => + databaseTimeToDate((a as Badge).time ?? "").getTime() > + databaseTimeToDate((b as Badge).time ?? "").getTime() + ? -1 + : 1, + ) as Badge[]; }; export const addUserBadge = async (userId: number, badge: BadgeInput) => { - const { post, image, description, time, category, hidden, source, designer } = badge; - - if (post === undefined || image === undefined) return; - - if (time) { - await sb.from('user_badges').insert({ - user_id: userId, - post, - image, - description, - time, - category, - hidden, - source, - designer - }); - } else { - await sb - .from('user_badges') - .insert({ user_id: userId, post, image, description, category, hidden, source, designer }); - } + const { post, image, description, time, category, hidden, source, designer } = + badge; + + if (post === undefined || image === undefined) return; + + if (time) { + await sb.from("user_badges").insert({ + user_id: userId, + post, + image, + description, + time, + category, + hidden, + source, + designer, + }); + } else { + 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 sb.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: BadgeInput) => { - if (badge.post === undefined || badge.image === undefined) return; - - await sb - .from('user_badges') - .update({ - post: badge.post, - image: badge.image, - description: badge.description, - category: badge.category, - time: badge.time, - hidden: badge.hidden, - source: badge.source, - designer: badge.designer - }) - .eq('id', id) - .eq('user_id', userId); +export const updateUserBadge = async ( + userId: number, + id: number, + badge: BadgeInput, +) => { + if (badge.post === undefined || badge.image === undefined) return; + + await sb + .from("user_badges") + .update({ + post: badge.post, + image: badge.image, + description: badge.description, + category: badge.category, + time: badge.time, + hidden: badge.hidden, + source: badge.source, + designer: badge.designer, + }) + .eq("id", id) + .eq("user_id", userId); }; -export const renameCategory = async (userId: number, oldName: string, newName: string) => - await sb - .from('user_badges') - .update({ category: newName }) - .eq('category', oldName) - .eq('user_id', userId); +export const renameCategory = async ( + userId: number, + oldName: string, + newName: string, +) => + await sb + .from("user_badges") + .update({ category: newName }) + .eq("category", oldName) + .eq("user_id", userId); export const removeAllUserBadges = async (userId: number) => - await sb.from('user_badges').delete().eq('user_id', userId); - -export const migrateCategory = async (userId: number, oldName: string, newName: string) => - await sb - .from('user_badges') - .update({ category: newName }) - .eq('category', oldName) - .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 sb + .from("user_badges") + .update({ category: newName }) + .eq("category", oldName) + .eq("user_id", userId); export const setShadowHidden = async (userId: number, shadowHide: boolean) => - await sb.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 (id: number, shadowHide: boolean) => - await sb.from('user_badges').update({ shadow_hidden: shadowHide }).eq('id', id); + await sb + .from("user_badges") + .update({ shadow_hidden: shadowHide }) + .eq("id", id); export const incrementClickCount = async (id: number) => - await sb.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/SB/User/configuration.ts b/src/lib/Database/SB/User/configuration.ts index ab1373da..6007e41b 100644 --- a/src/lib/Database/SB/User/configuration.ts +++ b/src/lib/Database/SB/User/configuration.ts @@ -1,47 +1,56 @@ -import sb from '../../sb'; +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; +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; }; 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 b30896a2..75dd5941 100644 --- a/src/lib/Database/SB/User/notifications.ts +++ b/src/lib/Database/SB/User/notifications.ts @@ -1,38 +1,45 @@ -import sb from '../../sb'; +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); +export const deleteUserSubscription = async ( + userId: number, + fingerprint: string, +) => + 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 d773d898..f0a49397 100644 --- a/src/lib/Database/SB/User/preferences.ts +++ b/src/lib/Database/SB/User/preferences.ts @@ -1,156 +1,186 @@ -import sb from '../../sb'; +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; +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; }; -export const toggleHololiveStreamPinning = async (userId: number, streamId: string) => { - const userPreferences = await getUserPreferences(userId); +export const toggleHololiveStreamPinning = async ( + userId: number, + streamId: string, +) => { + 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); - - 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 - }); + 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, + }); }; 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); +export const togglePinnedBadgeWallCategory = async ( + userId: number, + category: string, +) => { + 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); - - 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 - }); +export const setPinnedBadgeWallCategories = async ( + userId: number, + categories: string[], +) => { + const userPreferences = await getUserPreferences(userId); + + 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, + }); }; diff --git a/src/lib/Database/SB/badges.ts b/src/lib/Database/SB/badges.ts index 27f8d13c..a287f01b 100644 --- a/src/lib/Database/SB/badges.ts +++ b/src/lib/Database/SB/badges.ts @@ -1,48 +1,57 @@ -import sb from '../sb'; +import sb from "../sb"; interface Badge { - id: number; - created_at: string; - updated_at: string; - image_url: string; - image_artist: string; - description: string; - event: number; - group: number; + id: number; + created_at: string; + updated_at: string; + image_url: string; + image_artist: string; + description: string; + event: number; + group: number; } interface NewBadge { - updated_at?: string; - image_url: string; - image_artist: string; - description: string; + updated_at?: string; + image_url: string; + image_artist: string; + description: string; } interface GetBy { - event?: number; - group?: number; + event?: number; + group?: number; } export const getBadges = async (getBy?: GetBy) => { - let data: unknown[] | null = null; - let error: unknown = null; - - if (getBy?.event) [data, error] = await sb.from('badges').select('*').eq('event', getBy.event); - else if (getBy?.group) - [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[]; + let data: unknown[] | null = null; + let error: unknown = null; + + if (getBy?.event) + [data, error] = await sb + .from("badges") + .select("*") + .eq("event", getBy.event); + else if (getBy?.group) + [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 sb.from('badges').insert(badge); +export const createBadge = async (badge: NewBadge) => + await sb.from("badges").insert(badge); -export const deleteBadge = async (id: number) => await sb.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(); + if (!badge.updated_at) badge.updated_at = new Date().toISOString(); - return await sb.from('badges').update(badge).eq('id', id); + return await sb.from("badges").update(badge).eq("id", id); }; diff --git a/src/lib/Database/SB/events.ts b/src/lib/Database/SB/events.ts index aa914f95..de213185 100644 --- a/src/lib/Database/SB/events.ts +++ b/src/lib/Database/SB/events.ts @@ -1,45 +1,50 @@ -import type { Group } from '$lib/Database/SB/groups'; -import sb from '../sb'; +import type { Group } from "$lib/Database/SB/groups"; +import sb from "../sb"; export interface Event { - id: number; - created_at: string; - updated_at: string; - title: string; - description: string; - group: Group; - banner: string; - anilist_url: string; + id: number; + created_at: string; + updated_at: string; + title: string; + description: string; + group: Group; + banner: string; + anilist_url: string; } interface NewEvent { - updated_at?: string; - title: string; - description: string; + updated_at?: string; + title: string; + description: string; } export const getEvents = async () => { - const { data, error } = await sb.from('events').select('*, group:groups(*)'); + const { data, error } = await sb.from("events").select("*, group:groups(*)"); - if (error) return []; + if (error) return []; - return data as Event[]; + return data as Event[]; }; export const getGroupEvents = async (group: string) => { - const { data, error } = await sb.from('events').select('*').eq('group', group); + const { data, error } = await sb + .from("events") + .select("*") + .eq("group", group); - if (error) return []; + if (error) return []; - return data as Event[]; + return data as Event[]; }; -export const createEvent = async (event: NewEvent) => await sb.from('events').insert(event); +export const createEvent = async (event: NewEvent) => + await sb.from("events").insert(event); -export const deleteEvent = async (id: number) => await sb.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(); + if (!event.updated_at) event.updated_at = new Date().toISOString(); - return await sb.from('events').update(event).eq('id', id); + return await sb.from("events").update(event).eq("id", id); }; diff --git a/src/lib/Database/SB/groups.ts b/src/lib/Database/SB/groups.ts index 92afc80c..8cecb08f 100644 --- a/src/lib/Database/SB/groups.ts +++ b/src/lib/Database/SB/groups.ts @@ -1,32 +1,35 @@ -import sb from '../sb'; +import sb from "../sb"; export interface Group { - id: number; - created_at: string; - updated_at?: string; - members: number[]; - avatar: string; - banner: string; - description?: string; - name: string; - anilist_id: number; - anilist_username: string; - badge?: string; - badge_description?: string; + id: number; + created_at: string; + updated_at?: string; + members: number[]; + avatar: string; + banner: string; + description?: string; + name: string; + anilist_id: number; + anilist_username: string; + badge?: string; + badge_description?: string; } export const getGroups = async () => { - const { data, error } = await sb.from('groups').select('*'); + const { data, error } = await sb.from("groups").select("*"); - if (error) return []; + if (error) return []; - return data as Group[]; + return data as Group[]; }; export const getGroup = async (slug: string) => { - const { data, error } = await sb.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; + if (error || data.length === 0) return null; - return data[0] as Group; + return data[0] as Group; }; diff --git a/src/lib/Database/sb.ts b/src/lib/Database/sb.ts index 96fc65da..d5b39a98 100644 --- a/src/lib/Database/sb.ts +++ b/src/lib/Database/sb.ts @@ -1,5 +1,5 @@ -import { createClient } from '@supabase/supabase-js'; -import { SUPABASE_URL, SUPABASE_ANON_KEY } from '$env/static/private'; +import { createClient } from "@supabase/supabase-js"; +import { SUPABASE_URL, SUPABASE_ANON_KEY } from "$env/static/private"; const sb = createClient(SUPABASE_URL, SUPABASE_ANON_KEY); -- cgit v1.2.3