-
Notifications
You must be signed in to change notification settings - Fork 235
/
connect.go
119 lines (101 loc) · 2.91 KB
/
connect.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
package postgres
import (
"context"
"fmt"
"os"
"github.com/docker/docker/pkg/ioutils"
"github.com/mattn/go-colorable"
"github.com/spf13/cobra"
fly "github.com/superfly/fly-go"
"github.com/superfly/fly-go/flaps"
"github.com/superfly/flyctl/agent"
"github.com/superfly/flyctl/internal/appconfig"
"github.com/superfly/flyctl/internal/command"
"github.com/superfly/flyctl/internal/command/apps"
"github.com/superfly/flyctl/internal/command/ssh"
"github.com/superfly/flyctl/internal/flag"
)
func newConnect() *cobra.Command {
const (
short = "Connect to the Postgres console"
long = short + "\n"
usage = "connect"
)
cmd := command.New(usage, short, long, runConnect,
command.RequireSession,
command.RequireAppName,
)
flag.Add(cmd,
flag.App(),
flag.AppConfig(),
flag.String{
Name: "database",
Shorthand: "d",
Description: "The name of the database you would like to connect to",
Default: "postgres",
},
flag.String{
Name: "user",
Shorthand: "u",
Description: "The postgres user to connect with",
Default: "postgres",
},
flag.String{
Name: "password",
Shorthand: "p",
Description: "The postgres user password",
},
)
return cmd
}
func runConnect(ctx context.Context) error {
var (
client = fly.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 runMachineConnect(ctx, app)
}
func runMachineConnect(ctx context.Context, app *fly.AppCompact) error {
var (
MinPostgresHaVersion = "0.0.9"
MinPostgresFlexVersion = "0.0.3"
MinPostgresStandaloneVersion = "0.0.4"
database = flag.GetString(ctx, "database")
user = flag.GetString(ctx, "user")
password = flag.GetString(ctx, "password")
)
flapsClient := flaps.FromContext(ctx)
machines, err := flapsClient.ListActive(ctx)
if err != nil {
return fmt.Errorf("machines could not be retrieved %w", err)
}
if err := hasRequiredVersionOnMachines(machines, MinPostgresHaVersion, MinPostgresFlexVersion, MinPostgresStandaloneVersion); err != nil {
return err
}
leader, err := pickLeader(ctx, machines)
if err != nil {
return err
}
return ssh.SSHConnect(&ssh.SSHParams{
Ctx: ctx,
Org: app.Organization,
Dialer: agent.DialerFromContext(ctx),
App: app.Name,
Username: ssh.DefaultSshUsername,
Cmd: fmt.Sprintf("connect %s %s %s", database, user, password),
Stdin: os.Stdin,
Stdout: ioutils.NewWriteCloserWrapper(colorable.NewColorableStdout(), func() error { return nil }),
Stderr: ioutils.NewWriteCloserWrapper(colorable.NewColorableStderr(), func() error { return nil }),
}, leader.PrivateIP)
}