diff options
Diffstat (limited to 'src/lib/Database/SB/User/badges.ts')
| -rw-r--r-- | src/lib/Database/SB/User/badges.ts | 213 |
1 files changed, 122 insertions, 91 deletions
diff --git a/src/lib/Database/SB/User/badges.ts b/src/lib/Database/SB/User/badges.ts index dd6c158e..026ca98f 100644 --- a/src/lib/Database/SB/User/badges.ts +++ b/src/lib/Database/SB/User/badges.ts @@ -1,124 +1,155 @@ -import { databaseTimeToDate } from '$lib/Utility/time'; -import sb from '../../sb'; +import { databaseTimeToDate } from "$lib/Utility/time"; +import sb from "../../sb.server"; 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 (!Number.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 }); |