aboutsummaryrefslogtreecommitdiff
path: root/src/lib/Database
diff options
context:
space:
mode:
authorFuwn <[email protected]>2024-08-24 02:38:40 -0700
committerFuwn <[email protected]>2024-08-24 02:42:01 -0700
commit32c7545faae4f33c94a045408789c9b9ef7de53a (patch)
tree3ce6632bd710b4453749f0e71186027683415843 /src/lib/Database
parentfeat(SequelCatcher): side stories toggle (diff)
downloaddue.moe-32c7545faae4f33c94a045408789c9b9ef7de53a.tar.xz
due.moe-32c7545faae4f33c94a045408789c9b9ef7de53a.zip
refactor(Data): rename database references
Diffstat (limited to 'src/lib/Database')
-rw-r--r--src/lib/Database/IDB/activities.ts (renamed from src/lib/Database/IndexedDB/activities.ts)0
-rw-r--r--src/lib/Database/IDB/chapters.ts (renamed from src/lib/Database/IndexedDB/chapters.ts)0
-rw-r--r--src/lib/Database/IDB/user.ts (renamed from src/lib/Database/IndexedDB/user.ts)0
-rw-r--r--src/lib/Database/SB/User/badges.ts (renamed from src/lib/Database/Supabase/User/badges.ts)24
-rw-r--r--src/lib/Database/SB/User/configuration.ts (renamed from src/lib/Database/Supabase/User/configuration.ts)11
-rw-r--r--src/lib/Database/SB/User/notifications.ts (renamed from src/lib/Database/Supabase/User/notifications.ts)10
-rw-r--r--src/lib/Database/SB/User/preferences.ts (renamed from src/lib/Database/Supabase/User/preferences.ts)6
-rw-r--r--src/lib/Database/SB/badges.ts (renamed from src/lib/Database/Supabase/badges.ts)16
-rw-r--r--src/lib/Database/SB/events.ts (renamed from src/lib/Database/Supabase/events.ts)13
-rw-r--r--src/lib/Database/SB/groups.ts (renamed from src/lib/Database/Supabase/groups.ts)6
-rw-r--r--src/lib/Database/sb.ts (renamed from src/lib/Database/supabase.ts)4
11 files changed, 42 insertions, 48 deletions
diff --git a/src/lib/Database/IndexedDB/activities.ts b/src/lib/Database/IDB/activities.ts
index 6a505ff3..6a505ff3 100644
--- a/src/lib/Database/IndexedDB/activities.ts
+++ b/src/lib/Database/IDB/activities.ts
diff --git a/src/lib/Database/IndexedDB/chapters.ts b/src/lib/Database/IDB/chapters.ts
index 0f77f0a0..0f77f0a0 100644
--- a/src/lib/Database/IndexedDB/chapters.ts
+++ b/src/lib/Database/IDB/chapters.ts
diff --git a/src/lib/Database/IndexedDB/user.ts b/src/lib/Database/IDB/user.ts
index e7285a07..e7285a07 100644
--- a/src/lib/Database/IndexedDB/user.ts
+++ b/src/lib/Database/IDB/user.ts
diff --git a/src/lib/Database/Supabase/User/badges.ts b/src/lib/Database/SB/User/badges.ts
index 25fae9b7..14f848c5 100644
--- a/src/lib/Database/Supabase/User/badges.ts
+++ b/src/lib/Database/SB/User/badges.ts
@@ -1,5 +1,5 @@
import { databaseTimeToDate } from '$lib/Utility/time';
-import supabase from '../../supabase';
+import sb from '../../sb';
export interface Badge {
post?: string;
@@ -16,7 +16,7 @@ export interface Badge {
}
export const getUserBadges = async (userId: number): Promise<Badge[]> => {
- const { data, error } = await supabase.from('user_badges').select('*').eq('user_id', userId);
+ const { data, error } = await sb.from('user_badges').select('*').eq('user_id', userId);
if (error) return [];
@@ -34,7 +34,7 @@ export const addUserBadge = async (userId: number, badge: Badge) => {
if (post === undefined || image === undefined) return;
if (time) {
- await supabase.from('user_badges').insert({
+ await sb.from('user_badges').insert({
user_id: userId,
post,
image,
@@ -46,20 +46,20 @@ export const addUserBadge = async (userId: number, badge: Badge) => {
designer
});
} else {
- await supabase
+ 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 supabase.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: Badge) => {
if (badge.post === undefined || badge.image === undefined) return;
- await supabase
+ await sb
.from('user_badges')
.update({
post: badge.post,
@@ -76,31 +76,31 @@ export const updateUserBadge = async (userId: number, id: number, badge: Badge)
};
export const renameCategory = async (userId: number, oldName: string, newName: string) =>
- await supabase
+ await sb
.from('user_badges')
.update({ category: newName })
.eq('category', oldName)
.eq('user_id', userId);
export const removeAllUserBadges = async (userId: number) =>
- await supabase.from('user_badges').delete().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 supabase
+ await sb
.from('user_badges')
.update({ category: newName })
.eq('category', oldName)
.eq('user_id', userId);
export const setShadowHidden = async (userId: number, shadowHide: boolean) =>
- await supabase.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 (userId: number, id: number, shadowHide: boolean) =>
- await supabase
+ await sb
.from('user_badges')
.update({ shadow_hidden: shadowHide })
.eq('id', id)
.eq('user_id', userId);
export const incrementClickCount = async (id: number) =>
- await supabase.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/Supabase/User/configuration.ts b/src/lib/Database/SB/User/configuration.ts
index 36da1963..b889e95c 100644
--- a/src/lib/Database/Supabase/User/configuration.ts
+++ b/src/lib/Database/SB/User/configuration.ts
@@ -1,4 +1,4 @@
-import supabase from '../../supabase';
+import sb from '../../sb';
interface UserConfiguration {
user_id: number;
@@ -13,10 +13,7 @@ interface NewUserConfiguration {
}
export const getUserConfiguration = async (userId: number) => {
- const { data, error } = await supabase
- .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;
@@ -24,7 +21,7 @@ export const getUserConfiguration = async (userId: number) => {
};
export const setUserConfiguration = async (userId: number, configuration: NewUserConfiguration) => {
- const { data, error } = await supabase
+ const { data, error } = await sb
.from('user_configuration')
.upsert(
{
@@ -42,7 +39,7 @@ export const setUserConfiguration = async (userId: number, configuration: NewUse
};
export const deleteUserConfiguration = async (userId: number) => {
- const { data, error } = await supabase.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;
diff --git a/src/lib/Database/Supabase/User/notifications.ts b/src/lib/Database/SB/User/notifications.ts
index d8cd75ee..b07a0a3a 100644
--- a/src/lib/Database/Supabase/User/notifications.ts
+++ b/src/lib/Database/SB/User/notifications.ts
@@ -1,4 +1,4 @@
-import supabase from '../../supabase';
+import sb from '../../sb';
export interface UserNotifications {
created_at: string;
@@ -8,10 +8,10 @@ export interface UserNotifications {
}
export const getUserSubscription = async (userId: number) =>
- await supabase.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 supabase.from('user_notifications').select('*');
+ const { data, error } = await sb.from('user_notifications').select('*');
if (error) return [];
@@ -19,10 +19,10 @@ export const getUserSubscriptions = async () => {
};
export const deleteUserSubscription = async (userId: number) =>
- await supabase.from('user_notifications').delete().eq('user_id', userId);
+ await sb.from('user_notifications').delete().eq('user_id', userId);
export const setUserSubscription = async (userId: number, subscription: JSON) =>
- await supabase.from('user_notifications').upsert(
+ await sb.from('user_notifications').upsert(
{
user_id: userId,
updated_at: new Date().toISOString(),
diff --git a/src/lib/Database/Supabase/User/preferences.ts b/src/lib/Database/SB/User/preferences.ts
index 0eaebef7..e08d1e48 100644
--- a/src/lib/Database/Supabase/User/preferences.ts
+++ b/src/lib/Database/SB/User/preferences.ts
@@ -1,4 +1,4 @@
-import supabase from '../../supabase';
+import sb from '../../sb';
export interface UserPreferences {
created_at: string;
@@ -23,7 +23,7 @@ interface NewUserPreferences {
}
export const getUserPreferences = async (userId: number) => {
- const { data, error } = await supabase.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;
@@ -32,7 +32,7 @@ export const getUserPreferences = async (userId: number) => {
export const setUserPreferences = async (userId: number, preferences: NewUserPreferences) => {
const userPreferences = await getUserPreferences(userId);
- const { data, error } = await supabase
+ const { data, error } = await sb
.from('user_preferences')
.upsert(
{
diff --git a/src/lib/Database/Supabase/badges.ts b/src/lib/Database/SB/badges.ts
index 022d4d14..f67ffe97 100644
--- a/src/lib/Database/Supabase/badges.ts
+++ b/src/lib/Database/SB/badges.ts
@@ -1,4 +1,4 @@
-import supabase from '../supabase';
+import sb from '../sb';
interface Badge {
id: number;
@@ -26,24 +26,22 @@ interface GetBy {
export const getBadges = async (getBy?: GetBy) => {
let data, error;
- if (getBy?.event)
- [data, error] = await supabase.from('badges').select('*').eq('event', getBy.event);
+ if (getBy?.event) [data, error] = await sb.from('badges').select('*').eq('event', getBy.event);
else if (getBy?.group)
- [data, error] = await supabase.from('badges').select('*').eq('group', getBy.group);
- else [data, error] = await supabase.from('badges').select('*');
+ [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 supabase.from('badges').insert(badge);
+export const createBadge = async (badge: NewBadge) => await sb.from('badges').insert(badge);
-export const deleteBadge = async (id: number) =>
- await supabase.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();
- return await supabase.from('badges').update(badge).eq('id', id);
+ return await sb.from('badges').update(badge).eq('id', id);
};
diff --git a/src/lib/Database/Supabase/events.ts b/src/lib/Database/SB/events.ts
index e87fe011..4691f158 100644
--- a/src/lib/Database/Supabase/events.ts
+++ b/src/lib/Database/SB/events.ts
@@ -1,5 +1,5 @@
import type Group from '$lib/Events/Group.svelte';
-import supabase from '../supabase';
+import sb from '../sb';
export interface Event {
id: number;
@@ -19,7 +19,7 @@ interface NewEvent {
}
export const getEvents = async () => {
- const { data, error } = await supabase.from('events').select('*, group:groups(*)');
+ const { data, error } = await sb.from('events').select('*, group:groups(*)');
if (error) return [];
@@ -27,20 +27,19 @@ export const getEvents = async () => {
};
export const getGroupEvents = async (group: string) => {
- const { data, error } = await supabase.from('events').select('*').eq('group', group);
+ const { data, error } = await sb.from('events').select('*').eq('group', group);
if (error) return [];
return data as Event[];
};
-export const createEvent = async (event: NewEvent) => await supabase.from('events').insert(event);
+export const createEvent = async (event: NewEvent) => await sb.from('events').insert(event);
-export const deleteEvent = async (id: number) =>
- await supabase.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();
- return await supabase.from('events').update(event).eq('id', id);
+ return await sb.from('events').update(event).eq('id', id);
};
diff --git a/src/lib/Database/Supabase/groups.ts b/src/lib/Database/SB/groups.ts
index b2770e4a..90bee45f 100644
--- a/src/lib/Database/Supabase/groups.ts
+++ b/src/lib/Database/SB/groups.ts
@@ -1,4 +1,4 @@
-import supabase from '../supabase';
+import sb from '../sb';
export interface Group {
id: number;
@@ -16,7 +16,7 @@ export interface Group {
}
export const getGroups = async () => {
- const { data, error } = await supabase.from('groups').select('*');
+ const { data, error } = await sb.from('groups').select('*');
if (error) return [];
@@ -24,7 +24,7 @@ export const getGroups = async () => {
};
export const getGroup = async (slug: string) => {
- const { data, error } = await supabase.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;
diff --git a/src/lib/Database/supabase.ts b/src/lib/Database/sb.ts
index ba8cf8d5..96fc65da 100644
--- a/src/lib/Database/supabase.ts
+++ b/src/lib/Database/sb.ts
@@ -1,6 +1,6 @@
import { createClient } from '@supabase/supabase-js';
import { SUPABASE_URL, SUPABASE_ANON_KEY } from '$env/static/private';
-const supabase = createClient(SUPABASE_URL, SUPABASE_ANON_KEY);
+const sb = createClient(SUPABASE_URL, SUPABASE_ANON_KEY);
-export default supabase;
+export default sb;