BlueGit

timfa bluegit

Files

bluegit / internal / store / admins.go

admins.go

admins.go 1.8 KiB Download Raw
1package store
2
3import (
4 "context"
5 "errors"
6)
7
8// Fouten bij het wijzigen van beheerdersrechten.
9var (
10 ErrSelfDemote = errors.New("you cannot remove your own admin rights")
11 ErrLastAdmin = errors.New("there must always be at least one admin")
12)
13
14// ListUsers geeft alle gebruikers op naam.
15func (s *Store) ListUsers(ctx context.Context) ([]User, error) {
16 rows, err := s.db.QueryContext(ctx, `SELECT `+userCols+` FROM users ORDER BY username`)
17 if err != nil {
18 return nil, err
19 }
20 defer rows.Close()
21 var out []User
22 for rows.Next() {
23 u, err := scanUser(rows)
24 if err != nil {
25 return nil, err
26 }
27 out = append(out, u)
28 }
29 return out, rows.Err()
30}
31
32// CountAdmins telt de sitebeheerders.
33func (s *Store) CountAdmins(ctx context.Context) (int, error) {
34 var n int
35 err := s.db.QueryRowContext(ctx, `SELECT COUNT(*) FROM users WHERE instance_admin = 1`).Scan(&n)
36 return n, err
37}
38
39// SetInstanceAdmin geeft of ontneemt beheerdersrechten. by mag zichzelf
40// niet degraderen, en er blijft altijd minstens één beheerder over.
41func (s *Store) SetInstanceAdmin(ctx context.Context, by, target int64, admin bool) (User, error) {
42 if !admin && by == target {
43 return User{}, ErrSelfDemote
44 }
45 tx, err := s.db.BeginTx(ctx, nil)
46 if err != nil {
47 return User{}, err
48 }
49 defer tx.Rollback()
50 if !admin {
51 var n int
52 if err := tx.QueryRowContext(ctx, `SELECT COUNT(*) FROM users WHERE instance_admin = 1 AND id <> ?`, target).Scan(&n); err != nil {
53 return User{}, err
54 }
55 if n == 0 {
56 return User{}, ErrLastAdmin
57 }
58 }
59 res, err := tx.ExecContext(ctx, `UPDATE users SET instance_admin = ? WHERE id = ?`, boolInt(admin), target)
60 if err != nil {
61 return User{}, err
62 }
63 if n, _ := res.RowsAffected(); n == 0 {
64 return User{}, errNotFound
65 }
66 if err := tx.Commit(); err != nil {
67 return User{}, err
68 }
69 return s.UserByID(ctx, target)
70}