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)
}
