code.gitea.io/gitea@v1.21.7/models/migrations/v1_7/v75.go (about)

     1  // Copyright 2018 The Gitea Authors. All rights reserved.
     2  // SPDX-License-Identifier: MIT
     3  
     4  package v1_7 //nolint
     5  
     6  import (
     7  	"xorm.io/builder"
     8  	"xorm.io/xorm"
     9  )
    10  
    11  func ClearNonusedData(x *xorm.Engine) error {
    12  	condDelete := func(colName string) builder.Cond {
    13  		return builder.NotIn(colName, builder.Select("id").From("`user`"))
    14  	}
    15  
    16  	if _, err := x.Exec(builder.Delete(condDelete("uid")).From("team_user")); err != nil {
    17  		return err
    18  	}
    19  
    20  	if _, err := x.Exec(builder.Delete(condDelete("user_id")).From("collaboration")); err != nil {
    21  		return err
    22  	}
    23  
    24  	if _, err := x.Exec(builder.Delete(condDelete("user_id")).From("stopwatch")); err != nil {
    25  		return err
    26  	}
    27  
    28  	if _, err := x.Exec(builder.Delete(condDelete("owner_id")).From("gpg_key")); err != nil {
    29  		return err
    30  	}
    31  	return nil
    32  }