fix: pr reviewers and assignees script version error (#7645) (#7647)
* fix: pr reviewers and assignees script version error
* fix: adapt pg test
Co-authored-by: abeizn <zikuan.an@merico.dev>
diff --git a/backend/core/models/migrationscripts/20240531_add_pr_assignees_and_reviewers.go b/backend/core/models/migrationscripts/20240531_add_pr_assignees_and_reviewers.go
index fa852c9..d7cbd9f 100644
--- a/backend/core/models/migrationscripts/20240531_add_pr_assignees_and_reviewers.go
+++ b/backend/core/models/migrationscripts/20240531_add_pr_assignees_and_reviewers.go
@@ -35,7 +35,7 @@
}
func (*addPrAssigneeAndReviewer) Version() uint64 {
- return 20250531000041
+ return 20240531000041
}
func (*addPrAssigneeAndReviewer) Name() string {
diff --git a/backend/core/models/migrationscripts/20240607_modify_pr_assignees_and_reviewers_id.go b/backend/core/models/migrationscripts/20240607_modify_pr_assignees_and_reviewers_id.go
index adfe318..3d144d3 100644
--- a/backend/core/models/migrationscripts/20240607_modify_pr_assignees_and_reviewers_id.go
+++ b/backend/core/models/migrationscripts/20240607_modify_pr_assignees_and_reviewers_id.go
@@ -28,7 +28,17 @@
func (u *modifyPrAssigneeAndReviewerId) Up(basicRes context.BasicRes) errors.Error {
db := basicRes.GetDal()
- err := db.DropTables(&archived.PullRequestAssignee{}, &archived.PullRequestReviewer{})
+ err := db.Exec(`delete from _devlake_migration_history
+ where script_version='20250531000041' and script_name='add pull_request_reviewers and pull_request_assignees tables'`)
+ if err != nil {
+ return err
+ }
+ err = db.Exec(`delete from _devlake_migration_history
+ where script_version='20250607000041' and script_name='modify pull_request_reviewers and pull_request_assignees id columns'`)
+ if err != nil {
+ return err
+ }
+ err = db.DropTables(&archived.PullRequestAssignee{}, &archived.PullRequestReviewer{})
if err != nil {
return err
}
@@ -40,7 +50,7 @@
}
func (*modifyPrAssigneeAndReviewerId) Version() uint64 {
- return 20250607000041
+ return 20240607000041
}
func (*modifyPrAssigneeAndReviewerId) Name() string {
