aboutsummaryrefslogtreecommitdiff
path: root/src/lib/Database/SB/User
diff options
context:
space:
mode:
authorFuwn <[email protected]>2026-03-01 16:20:51 -0800
committerFuwn <[email protected]>2026-03-01 16:21:02 -0800
commiteae5d24d9e79e59a19d4721caaeaa0ca650ecb33 (patch)
tree1b685bb248e051dfa26d2bfdebe6689402dd93c5 /src/lib/Database/SB/User
parentchore(tooling): remove legacy eslint and prettier (diff)
downloaddue.moe-eae5d24d9e79e59a19d4721caaeaa0ca650ecb33.tar.xz
due.moe-eae5d24d9e79e59a19d4721caaeaa0ca650ecb33.zip
chore(biome): drop formatter style overrides
Diffstat (limited to 'src/lib/Database/SB/User')
-rw-r--r--src/lib/Database/SB/User/badges.ts215
-rw-r--r--src/lib/Database/SB/User/configuration.ts67
-rw-r--r--src/lib/Database/SB/User/notifications.ts55
-rw-r--r--src/lib/Database/SB/User/preferences.ts262
4 files changed, 339 insertions, 260 deletions
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<Badge[]> => {
- 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<Badge[]> => {
+ 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,
+ });
};