app "minidesk" model Ticket { id ID title string @min(3) @max(120) description text status string @enum("open", "closed") = "open" owner UserID @index attachment File? tags []string = []string{} createdAt Time = now() updatedAt Time = now() } model Comment { id ID ticket TicketID @index author UserID @index body text @min(1) createdAt Time = now() } model Notification { id ID user UserID @index title string body text read bool = false createdAt Time = now() } type CreateTicketInput struct { title string @min(3) @max(120) description text attachment File? = nil } type TicketDetails struct { ticket Ticket comments []Comment } event TicketCreated { ticket TicketID owner UserID title string at Time = now() } event CommentAdded { ticket TicketID comment CommentID author UserID owner UserID at Time = now() } event TicketClosed { ticket TicketID owner UserID at Time = now() } // @api POST /tickets // @auth user // @cache invalidate ListTickets func CreateTicket(input CreateTicketInput) Ticket { saved := storage.save(input.attachment) ticket := database.tickets.create(Ticket{ title: input.title, description: input.description, owner: auth.user.id, attachment: saved, tags: []string{}, }) emit(TicketCreated{ ticket: ticket.id, owner: auth.user.id, title: ticket.title, }) return ticket } // @api GET /tickets // @auth user // @cache 30s key=user,params func ListTickets(status string? = nil) []Ticket { query := database.tickets. where(owner == auth.user.id). order(createdAt, desc) if status != nil { query = query.where(status == status) } return query.limit(50).all() } // @api GET /tickets/:id // @auth user owns Ticket.owner func GetTicket(id ID) TicketDetails { ticket := database.tickets.get(id) comments := database.comments. where(ticket == id). order(createdAt, asc). all() return TicketDetails{ ticket: ticket, comments: comments, } } // @api POST /tickets/:id/comments // @auth user owns Ticket.owner // @cache invalidate GetTicket func AddComment(id ID, body text) Comment { ticket := database.tickets.get(id) comment := database.comments.create(Comment{ ticket: ticket.id, author: auth.user.id, body: body, }) ticket.updatedAt = now() database.tickets.update(ticket) emit(CommentAdded{ ticket: ticket.id, comment: comment.id, author: auth.user.id, owner: ticket.owner, }) return comment } // @api POST /tickets/:id/close // @auth user owns Ticket.owner // @cache invalidate ListTickets, GetTicket func CloseTicket(id ID) Ticket { ticket := database.tickets.get(id) if ticket.status == "closed" { fail.conflict("Ticket is already closed") } ticket.status = "closed" ticket.updatedAt = now() updated := database.tickets.update(ticket) emit(TicketClosed{ ticket: updated.id, owner: updated.owner, }) return updated } // @api GET /notifications // @auth user // @cache 15s key=user func ListNotifications() []Notification { return database.notifications. where(user == auth.user.id). order(createdAt, desc). limit(20). all() } // @on TicketCreated // @once key=e.ticket func NotifyTicketCreated(e TicketCreated) { database.notifications.create(Notification{ user: e.owner, title: "Ticket created", body: "Your ticket was created: " + e.title, }) } // @on CommentAdded // @once key=e.comment func NotifyCommentAdded(e CommentAdded) { database.notifications.create(Notification{ user: e.owner, title: "New comment", body: "A new comment was added to your ticket.", }) } // @on TicketClosed // @once key=e.ticket func NotifyTicketClosed(e TicketClosed) { database.notifications.create(Notification{ user: e.owner, title: "Ticket closed", body: "Your ticket has been closed.", }) } // @job every 1d func CleanupOldReadNotifications() { database.notifications. where(read == true). where(createdAt < now() - 30d). delete() }