-
Notifications
You must be signed in to change notification settings - Fork 238
/
db.go
150 lines (122 loc) · 3.07 KB
/
db.go
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
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
package postgres
import (
"context"
"fmt"
"github.com/spf13/cobra"
fly "github.com/superfly/fly-go"
"github.com/superfly/flyctl/agent"
"github.com/superfly/flyctl/flypg"
"github.com/superfly/flyctl/internal/appconfig"
"github.com/superfly/flyctl/internal/command"
"github.com/superfly/flyctl/internal/command/apps"
"github.com/superfly/flyctl/internal/config"
"github.com/superfly/flyctl/internal/flag"
"github.com/superfly/flyctl/internal/flyutil"
mach "github.com/superfly/flyctl/internal/machine"
"github.com/superfly/flyctl/internal/render"
"github.com/superfly/flyctl/iostreams"
)
func newDb() *cobra.Command {
const (
short = "Manage databases in a cluster"
long = short + "\n"
)
cmd := command.New("db", short, long, nil)
cmd.AddCommand(
newListDbs(),
)
flag.Add(cmd, flag.JSONOutput())
return cmd
}
func newListDbs() *cobra.Command {
const (
short = "list databases"
long = short + "\n"
usage = "list"
)
cmd := command.New(usage, short, long, runListDbs,
command.RequireSession,
command.RequireAppName,
)
cmd.Aliases = []string{"ls"}
flag.Add(
cmd,
flag.App(),
flag.AppConfig(),
)
return cmd
}
func runListDbs(ctx context.Context) error {
var (
client = flyutil.ClientFromContext(ctx)
appName = appconfig.NameFromContext(ctx)
)
app, err := client.GetAppCompact(ctx, appName)
if err != nil {
return fmt.Errorf("failed retrieving app %s: %w", appName, err)
}
if !app.IsPostgresApp() {
return fmt.Errorf("app %s is not a postgres app", appName)
}
ctx, err = apps.BuildContext(ctx, app)
if err != nil {
return err
}
return runMachineListDbs(ctx, app)
}
func runMachineListDbs(ctx context.Context, app *fly.AppCompact) error {
var (
MinPostgresHaVersion = "0.0.19"
MinPostgresFlexVersion = "0.0.3"
MinPostgresStandaloneVersion = "0.0.7"
)
machines, err := mach.ListActive(ctx)
if err != nil {
return fmt.Errorf("machines could not be retrieved %w", err)
}
if len(machines) == 0 {
return fmt.Errorf("no 6pn ips founds for %s app", app.Name)
}
if err := hasRequiredVersionOnMachines(machines, MinPostgresHaVersion, MinPostgresFlexVersion, MinPostgresStandaloneVersion); err != nil {
return err
}
leader, err := pickLeader(ctx, machines)
if err != nil {
return err
}
return listDBs(ctx, leader.PrivateIP)
}
func listDBs(ctx context.Context, leaderIP string) error {
var (
dialer = agent.DialerFromContext(ctx)
io = iostreams.FromContext(ctx)
cfg = config.FromContext(ctx)
)
pgclient := flypg.NewFromInstance(leaderIP, dialer)
databases, err := pgclient.ListDatabases(ctx)
if err != nil {
return err
}
if len(databases) == 0 {
fmt.Fprintf(io.Out, "No databases found\n")
return nil
}
if cfg.JSONOutput {
return render.JSON(io.Out, databases)
}
rows := make([][]string, len(databases))
for _, db := range databases {
var users string
for index, name := range db.Users {
users += name
if index < len(db.Users)-1 {
users += ", "
}
}
rows = append(rows, []string{
db.Name,
users,
})
}
return render.Table(io.Out, "", rows, "Name", "Users")
}