| 1 | package store |
| 2 | |
| 3 | import ( |
| 4 | "context" |
| 5 | "errors" |
| 6 | ) |
| 7 | |
| 8 | // Fouten bij het wijzigen van beheerdersrechten. |
| 9 | var ( |
| 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. |
| 15 | func (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. |
| 33 | func (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. |
| 41 | func (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 | } |