package store import ( "context" "database/sql" "errors" "gitlab.com/Timfa/bluegit/internal/access" "gitlab.com/Timfa/bluegit/internal/i18n" ) // TransferGroupOwner maakt toID de eigenaar. De vorige eigenaar blijft beheerder. // toID moet al lid zijn. func (s *Store) TransferGroupOwner(ctx context.Context, groupID, fromID, toID int64) error { if fromID == 0 || toID == 0 || fromID == toID { return i18n.E("err.ownerSame") } g, err := s.GroupByID(ctx, groupID) if err != nil { return err } if g.OwnerID != fromID { return i18n.E("err.ownerOnly") } var role string err = s.db.QueryRowContext(ctx, `SELECT role FROM group_members WHERE group_id = ? AND user_id = ?`, groupID, toID).Scan(&role) if errors.Is(err, sql.ErrNoRows) { return i18n.E("err.ownerMember") } if err != nil { return err } tx, err := s.db.BeginTx(ctx, nil) if err != nil { return err } defer func() { _ = tx.Rollback() }() if _, err := tx.ExecContext(ctx, `UPDATE groups SET owner_id = ? WHERE id = ?`, toID, groupID); err != nil { return err } if _, err := tx.ExecContext(ctx, `INSERT INTO group_members (group_id, user_id, role) VALUES (?, ?, ?) ON CONFLICT(group_id, user_id) DO UPDATE SET role = ?`, groupID, fromID, string(access.RoleMaintainer), string(access.RoleMaintainer)); err != nil { return err } if _, err := tx.ExecContext(ctx, `UPDATE group_members SET role = ? WHERE group_id = ? AND user_id = ?`, string(access.RoleMaintainer), groupID, toID); err != nil { return err } return tx.Commit() }