The app you desire, live and yours.

28function M.cancel(event_id)
29  local mine = eql.one("select rsvps { id, status } where .event_id = $id", { id = event_id })
30  if not mine then return end
31  eql("delete rsvps where .id = $id", { id = mine.id })
32  if mine.status ~= "going" then return end
33
34  local next = eql.unscoped([[
35    select rsvps { id, .user_id.email as email, .user_id.name as name,
36      .event_id.title as title, .event_id.starts_at as starts_at, .event_id.venue as venue }
37    where .event_id = $id and .status = "waitlist"
38    order by .created_at, .id
39    limit 1
40  ]], { id = event_id })[1]
41  if not next then return end
42
43  eql.unscoped([[update rsvps set { status: "going" } where .id = $id]], { id = next.id })
44  assert(mail.send {
45    to = next.email,
46    template = "promoted",
47    queue = true,
48    data = {
49      name = next.name:match("^%S+"),
50      title = next.title,
51      when = format.date(next.starts_at, "%A %d %B, %H:%M"),
52      venue = next.venue,
53      event_id = event_id,
54    },
55  })
56end

1schedule = "0 9 * * *" -- every day at 09:00 UTC
2help = "Remind everyone going to tomorrow's events"
3
4function run()
5  local eql = require "effortless.eql"
6  local format = require "effortless.format"
7  local mail = require "effortless.mail"
8
9  local events = eql [[
10    select events { id, title, starts_at, venue, address,
11      rsvps { users { email, name } } where .status = "going" }
12    where date(.starts_at) = date("now", "+1 day")
13  ]]
14
15  local sent = 0
16  for _, event in ipairs(events) do
17    for _, rsvp in ipairs(event.rsvps) do
18      assert(mail.send {
19        to = rsvp.users.email,
20        template = "reminder",
21        queue = true,
22        data = {
23          name = (rsvp.users.name or ""):match("^%S+") or "there",
24          title = event.title,
25          when = format.date(event.starts_at, "%A %d %B, %H:%M"),
26          venue = event.venue,
27          address = event.address,
28          event_id = event.id,
29        },
30      })
31      sent = sent + 1
32    end
33  end
34  return { sent = sent }
35end

67  candidates = {
68    id = t.pk,
69    name = t.text { required = true, label = true },
70    email = t.text { required = true, email = true },
71    opening_id = t.ref "openings" { required = true },
72    interviewer_id = t.ref "users" { required = true, owner = true },
73    stage = t.enum { "applied", "screen", "interview", "offer", "hired", default = "applied" },
74    stage_since = t.datetime,
75    cv = t.file { folder = "cvs", slug = true },
76    created_at = t.now,
77
78    indexes = { "interviewer_id", "stage" },
79  },

17function get(request)
18  local manager = auth.has_role("admin")
19  -- Hiring managers see every candidate on purpose; an interviewer's reads stay scoped to them.
20  local read = manager and eql.unscoped or eql
21  local rows = read([[
22    select candidates { id, name, stage, stage_since, cv, .opening_id.title as opening,
23      .interviewer_id.name as interviewer, count(.notes) as notes }
24    order by .stage_since
25  ]])