aboutsummaryrefslogtreecommitdiff
path: root/src/lib/Database
diff options
context:
space:
mode:
authorFuwn <[email protected]>2024-10-09 00:41:20 -0700
committerFuwn <[email protected]>2024-10-09 00:41:43 -0700
commit998b63a35256ac985a5a2714dd1ca451af4dfd8a (patch)
tree50796121a9d5ab0330fdc5d7e098bda2860d9726 /src/lib/Database
parentfeat(graphql): add badgeCount field (diff)
downloaddue.moe-998b63a35256ac985a5a2714dd1ca451af4dfd8a.tar.xz
due.moe-998b63a35256ac985a5a2714dd1ca451af4dfd8a.zip
chore(prettier): use spaces instead of tabs
Diffstat (limited to 'src/lib/Database')
-rw-r--r--src/lib/Database/IDB/activities.ts20
-rw-r--r--src/lib/Database/IDB/chapters.ts22
-rw-r--r--src/lib/Database/IDB/user.ts22
-rw-r--r--src/lib/Database/SB/User/badges.ts2
-rw-r--r--src/lib/Database/SB/User/configuration.ts54
-rw-r--r--src/lib/Database/SB/User/notifications.ts44
-rw-r--r--src/lib/Database/SB/User/preferences.ts216
-rw-r--r--src/lib/Database/SB/badges.ts46
-rw-r--r--src/lib/Database/SB/events.ts38
-rw-r--r--src/lib/Database/SB/groups.ts36
10 files changed, 250 insertions, 250 deletions
diff --git a/src/lib/Database/IDB/activities.ts b/src/lib/Database/IDB/activities.ts
index 6a505ff3..d58e97a5 100644
--- a/src/lib/Database/IDB/activities.ts
+++ b/src/lib/Database/IDB/activities.ts
@@ -2,21 +2,21 @@ 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<ActivityPage>;
+ activities: Table<ActivityPage>;
- 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 0f77f0a0..571c16e1 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';
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<Chapter>;
+ chapters: Table<Chapter>;
- 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/user.ts b/src/lib/Database/IDB/user.ts
index e7285a07..b1a1b936 100644
--- a/src/lib/Database/IDB/user.ts
+++ b/src/lib/Database/IDB/user.ts
@@ -2,22 +2,22 @@ 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<User>;
+ users: Table<User>;
- 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 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
+ });
};
diff --git a/src/lib/Database/SB/badges.ts b/src/lib/Database/SB/badges.ts
index f67ffe97..b710eb86 100644
--- a/src/lib/Database/SB/badges.ts
+++ b/src/lib/Database/SB/badges.ts
@@ -1,39 +1,39 @@
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, error;
+ let data, error;
- 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 (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 [];
+ if (error) return [];
- return data as Badge[];
+ return data as Badge[];
};
export const createBadge = async (badge: NewBadge) => await sb.from('badges').insert(badge);
@@ -41,7 +41,7 @@ export const createBadge = async (badge: NewBadge) => await sb.from('badges').in
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 4691f158..b7e2bb85 100644
--- a/src/lib/Database/SB/events.ts
+++ b/src/lib/Database/SB/events.ts
@@ -2,36 +2,36 @@ import type Group from '$lib/Events/Group.svelte';
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);
@@ -39,7 +39,7 @@ export const createEvent = async (event: NewEvent) => await sb.from('events').in
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 90bee45f..92afc80c 100644
--- a/src/lib/Database/SB/groups.ts
+++ b/src/lib/Database/SB/groups.ts
@@ -1,32 +1,32 @@
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;
};