package store import ( "context" "errors" ) // Fouten bij het wijzigen van beheerdersrechten. var ( ErrSelfDemote = errors.New("you cannot remove your own admin rights") ErrLastAdmin = errors.New("there must always be at least one admin") ) // ListUsers geeft alle gebruikers op naam. func (s *Store) ListUsers(ctx context.Context) ([]User, error) { rows, err := s.db.QueryContext(ctx, `SELECT `+userCols+` FROM users ORDER BY username`) if err != nil { return nil, err } defer rows.Close() var out []User for rows.Next() { u, err := scanUser(rows) if err != nil { return nil, err } out = append(out, u) } return out, rows.Err() } // CountAdmins telt de sitebeheerders. func (s *Store) CountAdmins(ctx context.Context) (int, error) { var n int err := s.db.QueryRowContext(ctx, `SELECT COUNT(*) FROM users WHERE instance_admin = 1`).Scan(&n) return n, err } // SetInstanceAdmin geeft of ontneemt beheerdersrechten. by mag zichzelf // niet degraderen, en er blijft altijd minstens één beheerder over. func (s *Store) SetInstanceAdmin(ctx context.Context, by, target int64, admin bool) (User, error) { if !admin && by == target { return User{}, ErrSelfDemote } tx, err := s.db.BeginTx(ctx, nil) if err != nil { return User{}, err } defer tx.Rollback() if !admin { var n int if err := tx.QueryRowContext(ctx, `SELECT COUNT(*) FROM users WHERE instance_admin = 1 AND id <> ?`, target).Scan(&n); err != nil { return User{}, err } if n == 0 { return User{}, ErrLastAdmin } } res, err := tx.ExecContext(ctx, `UPDATE users SET instance_admin = ? WHERE id = ?`, boolInt(admin), target) if err != nil { return User{}, err } if n, _ := res.RowsAffected(); n == 0 { return User{}, errNotFound } if err := tx.Commit(); err != nil { return User{}, err } return s.UserByID(ctx, target) }