1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
|
// Copyright 2022 The Gogs Authors. All rights reserved.
// Use of this source code is governed by a MIT-style
// license that can be found in the LICENSE file.
package migrations
import (
"testing"
"github.com/stretchr/testify/assert"
"github.com/stretchr/testify/require"
"gogs.io/gogs/internal/dbtest"
)
type actionPreV21 struct {
ID int64 `gorm:"primaryKey"`
UserID int64
OpType int
ActUserID int64
ActUserName string
RepoID int64 `gorm:"index"`
RepoUserName string
RepoName string
RefName string
IsPrivate bool `gorm:"not null;default:FALSE"`
Content string
CreatedUnix int64
}
func (*actionPreV21) TableName() string {
return "action"
}
type actionV21 struct {
ID int64 `gorm:"primaryKey"`
UserID int64 `gorm:"index"`
OpType int
ActUserID int64
ActUserName string
RepoID int64 `gorm:"index"`
RepoUserName string
RepoName string
RefName string
IsPrivate bool `gorm:"not null;default:FALSE"`
Content string
CreatedUnix int64
}
func (*actionV21) TableName() string {
return "action"
}
func TestAddIndexToActionUserID(t *testing.T) {
if testing.Short() {
t.Skip()
}
t.Parallel()
db := dbtest.NewDB(t, "addIndexToActionUserID", new(actionPreV21))
err := db.Create(
&actionPreV21{
ID: 1,
UserID: 1,
OpType: 1,
ActUserID: 1,
ActUserName: "alice",
RepoID: 1,
RepoUserName: "alice",
RepoName: "example",
RefName: "main",
IsPrivate: false,
CreatedUnix: db.NowFunc().Unix(),
},
).Error
require.NoError(t, err)
assert.False(t, db.Migrator().HasIndex(&actionV21{}, "UserID"))
err = addIndexToActionUserID(db)
require.NoError(t, err)
assert.True(t, db.Migrator().HasIndex(&actionV21{}, "UserID"))
// Re-run should be skipped
err = addIndexToActionUserID(db)
require.Equal(t, errMigrationSkipped, err)
}
|