a mini social media app for small communities
emmeline.girlkisser.top
1module database
2
3import entity { Notification }
4
5// get_notification_by_id gets a notification by its given id, returns none if
6// the notification does not exist.
7pub fn (app &DatabaseAccess) get_notification_by_id(id int) ?Notification {
8 notifications := sql app.db {
9 select from Notification where id == id
10 } or { [] }
11 if notifications.len != 1 {
12 return none
13 }
14 return notifications[0]
15}
16
17// delete_notification deletes the given notification, returns true if this
18// succeeded and false otherwise.
19pub fn (app &DatabaseAccess) delete_notification(id int) bool {
20 sql app.db {
21 delete from Notification where id == id
22 } or {
23 return false
24 }
25 return true
26}
27
28// delete_notifications_for_user deletes all notifications for the given user,
29// returns true if this succeeded and false otherwise.
30pub fn (app &DatabaseAccess) delete_notifications_for_user(user_id int) bool {
31 sql app.db {
32 delete from Notification where user_id == user_id
33 } or {
34 return false
35 }
36 return true
37}
38
39// get_notifications_for gets a list of notifications for the given user.
40pub fn (app &DatabaseAccess) get_notifications_for(user_id int) []Notification {
41 notifications := sql app.db {
42 select from Notification where user_id == user_id
43 } or { [] }
44 return notifications
45}
46
47// get_notification_count gets the amount of notifications a user has, with a
48// given limit.
49pub fn (app &DatabaseAccess) get_notification_count(user_id int, limit int) int {
50 notifications := sql app.db {
51 select from Notification where user_id == user_id limit limit
52 } or { [] }
53 return notifications.len
54}
55
56// send_notification_to sends a notification to the given user.
57pub fn (app &DatabaseAccess) send_notification_to(user_id int, summary string, body string) {
58 notification := Notification{
59 user_id: user_id
60 summary: summary
61 body: body
62 }
63 sql app.db {
64 insert notification into Notification
65 } or {
66 eprintln('failed to send notification ${notification}')
67 }
68}