Method migrateDB

database/sql/sql.go:797–886

()

}

func (s *sqlDatabase) migrateDB() error {
	// Drop obsolete indexes
	s.dropIndexIfExists(&Organization{}, "idx_organizations_name")
	s.dropIndexIfExists(&Repository{}, "idx_owner")

	// Run cascade migration
	if err := s.cascadeMigration(); err != nil {
		return fmt.Errorf("error running cascade migration: %w", err)
	}

	// Migrate pool null IDs
	if err := s.migratePoolNullIDs(); err != nil {
		return err
	}

	// Migrate workflows
	if err := s.migrateWorkflow(); err != nil {
		return fmt.Errorf("error migrating workflows: %w", err)
	}

	// Migrate GitHub endpoint type
	if err := s.migrateGithubEndpointType(); err != nil {
		return err
	}

	// Check if we need to migrate credentials and templates
	needsCredentialMigration, migrateTemplates, hasMinAgeField, hasAgentURL := s.preMigrationChecks()

	// Run main schema migration
	s.conn.Exec("PRAGMA foreign_keys = OFF")
	if err := s.conn.AutoMigrate(
		&User{},
		&GithubEndpoint{},
		&GithubCredentials{},
		&GiteaCredentials{},
		&Tag{},
		&Template{},
		&Pool{},
		&Repository{},
		&Organization{},
		&Enterprise{},
		&EnterpriseEvent{},
		&OrganizationEvent{},
		&RepositoryEvent{},
		&Address{},
		&InstanceStatusUpdate{},
		&Instance{},
		&ControllerInfo{},
		&WorkflowJob{},
		&ScaleSet{},
	); err != nil {
		return fmt.Errorf("error running auto migrate: %w", err)
	}

	// Migrate file object tables in the attached objectsdb schema
	if err := s.migrateFileObjects(); err != nil {
		return fmt.Errorf("error migrating file objects: %w", err)
	}