// Copyright 2025 The Forgejo Authors. All rights reserved.
// SPDX-License-Identifier: GPL-3.0-or-later

package forgejo_migrations

import (
	"fmt"

	"xorm.io/xorm"
	"xorm.io/xorm/schemas"
)

func init() {
	registerMigration(&Migration{
		Description: "remove from table repository fields num_issues, num_closed_issues, num_pulls, num_closed_pulls",
		Upgrade:     removeRepositoryIssueStatFields,
	})
}

func removeRepositoryIssueStatFields(x *xorm.Engine) error {
	switch x.Dialect().URI().DBType {
	case schemas.SQLITE:
		// Can't drop multiple columns in one statement in SQLite.
		_, err := x.Exec("ALTER TABLE `repository` DROP COLUMN num_issues")
		if err != nil {
			return err
		}
		_, err = x.Exec("ALTER TABLE `repository` DROP COLUMN num_closed_issues")
		if err != nil {
			return err
		}
		_, err = x.Exec("ALTER TABLE `repository` DROP COLUMN num_pulls")
		if err != nil {
			return err
		}
		_, err = x.Exec("ALTER TABLE `repository` DROP COLUMN num_closed_pulls")
		if err != nil {
			return err
		}
	case schemas.MYSQL, schemas.POSTGRES:
		_, err := x.Exec("ALTER TABLE `repository` DROP COLUMN num_issues, DROP COLUMN num_closed_issues, DROP COLUMN num_pulls, DROP COLUMN num_closed_pulls")
		if err != nil {
			return err
		}
	default:
		return fmt.Errorf("unsupported db dialect type %v", x.Dialect().URI().DBType)
	}
	return nil
}