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
|
package main
import (
"bytes"
"flag"
"fmt"
"testing"
"github.com/stretchr/testify/assert"
"gitlab.com/gitlab-org/gitaly/v15/internal/praefect/config"
"gitlab.com/gitlab-org/gitaly/v15/internal/praefect/datastore/migrations"
"gitlab.com/gitlab-org/gitaly/v15/internal/testhelper/testdb"
)
func TestSubCmdSqlMigrate(t *testing.T) {
db := testdb.New(t)
dbCfg := testdb.GetConfig(t, db.Name)
cfg := config.Config{DB: dbCfg}
migrationCt := len(migrations.All())
for _, tc := range []struct {
desc string
up int
verbose bool
expectedOutput []string
}{
{
desc: "All migrations up",
up: migrationCt,
expectedOutput: []string{"praefect sql-migrate: all migrations are up"},
},
{
desc: "All migrations down",
up: 0,
expectedOutput: []string{
fmt.Sprintf("praefect sql-migrate: migrations to apply: %d", migrationCt),
"20200109161404_hello_world: migrating",
"20200109161404_hello_world: applied (",
fmt.Sprintf("praefect sql-migrate: OK (applied %d migrations)", migrationCt),
},
},
{
desc: "Some migrations down",
up: 10,
expectedOutput: []string{
fmt.Sprintf("praefect sql-migrate: migrations to apply: %d", migrationCt-10),
"20201126165633_repository_assignments_table: migrating",
"20201126165633_repository_assignments_table: applied (",
fmt.Sprintf("praefect sql-migrate: OK (applied %d migrations)", migrationCt-10),
},
},
{
desc: "Verbose output",
up: 0,
verbose: true,
expectedOutput: []string{
fmt.Sprintf("praefect sql-migrate: migrations to apply: %d", migrationCt),
"20200109161404_hello_world: migrating",
"[CREATE TABLE hello_world (id integer)]",
"20200109161404_hello_world: applied (",
fmt.Sprintf("praefect sql-migrate: OK (applied %d migrations)", migrationCt),
},
},
} {
t.Run(tc.desc, func(t *testing.T) {
testdb.SetMigrations(t, db, cfg, tc.up)
var stdout bytes.Buffer
migrateCmd := sqlMigrateSubcommand{w: &stdout, ignoreUnknown: true, verbose: tc.verbose}
assert.NoError(t, migrateCmd.Exec(flag.NewFlagSet("", flag.PanicOnError), cfg))
for _, out := range tc.expectedOutput {
assert.Contains(t, stdout.String(), out)
}
})
}
}
|