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
|
import { databaseTimeToDate } from '$lib/Utility/time';
import { Database } from 'bun:sqlite';
export interface Badge {
post?: string;
image?: string;
description?: string;
id?: number;
time?: string;
}
const database = new Database('./data/due_moe.sqlite3', {
create: true
});
database
.query(
`CREATE TABLE IF NOT EXISTS user_badges (
id INTEGER PRIMARY KEY,
user_id INTEGER NOT NULL,
post TEXT(1000) NOT NULL,
image TEXT(1000) NOT NULL,
description TEXT(1000) DEFAULT NULL,
time TIMESTAMP DEFAULT CURRENT_TIMESTAMP
)`
)
.run();
export const getUserBadges = (userId: number): Badge[] => {
return database
.query('SELECT * FROM user_badges WHERE user_id = $userId')
.all({ $userId: String(userId) })
.sort((a, b) =>
databaseTimeToDate((a as Badge).time ?? '').getTime() >
databaseTimeToDate((b as Badge).time ?? '').getTime()
? -1
: 1
) as Badge[];
};
export const addUserBadge = (userId: number, badge: Badge) => {
const { post, image, description, time } = badge;
if (post === undefined || image === undefined) return;
if (time) {
database
.query(
`INSERT INTO user_badges (user_id, post, image, description, time) VALUES (?1, ?2, ?3, ?4, ?5);`
)
.run(userId.toString(), post, image, description || null, time);
} else {
database
.query(`INSERT INTO user_badges (user_id, post, image, description) VALUES (?1, ?2, ?3, ?4);`)
.run(userId.toString(), post, image, description || null);
}
};
export const removeUserBadge = (userId: number, id: number) => {
if (!isNaN(id))
database.query('DELETE FROM user_badges WHERE user_id = $userId AND id = $id').run({
$userId: userId,
$id: id
});
};
export const updateUserBadge = (userId: number, id: number, badge: Badge) => {
if (badge.post === undefined || badge.image === undefined || badge.description === undefined)
return;
database
.query(
'UPDATE user_badges SET post = ?1, image = ?2, description = ?3 WHERE id = ?4 AND user_id = ?5'
)
.run(badge.post || null, badge.image || null, badge.description || null, id, userId);
};
|