1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
|
import supabase from './supabase';
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;
}
interface NewUserPreferences {
updated_at?: string;
pinned_hololive_streams?: string[];
hide_missing_badges?: boolean;
badge_wall_css?: string;
biography?: string;
}
export const getUserPreferences = async (userId: number) => {
const { data, error } = await supabase.from('user_preferences').select('*').eq('user_id', userId);
if (error || data.length === 0 || data[0].user_id !== userId) return null;
return data[0] as UserPreferences;
};
export const setUserPreferences = async (userId: number, preferences: NewUserPreferences) => {
const userPreferences = await getUserPreferences(userId);
const { data, error } = await supabase
.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 : '')
},
{ 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);
if (!userPreferences) return null;
const pinnedStreams = userPreferences.pinned_hololive_streams;
const index = pinnedStreams.indexOf(streamId);
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
});
};
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
});
};
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! */"
});
};
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'
});
};
|