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
|
// Copyright 2019-2025 The Wait4X Authors
//
// Licensed under the Apache License, Version 2.0 (the "License");
// you may not use this file except in compliance with the License.
// You may obtain a copy of the License at
//
// http://www.apache.org/licenses/LICENSE-2.0
//
// Unless required by applicable law or agreed to in writing, software
// distributed under the License is distributed on an "AS IS" BASIS,
// WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
// See the License for the specific language governing permissions and
// limitations under the License.
//go:build !disable_postgresql
// Package cmd provides the command-line interface for the Wait4X application.
package cmd
import (
"errors"
"fmt"
"github.com/go-logr/logr"
"github.com/spf13/cobra"
"wait4x.dev/v3/checker"
"wait4x.dev/v3/checker/postgresql"
"wait4x.dev/v3/internal/contextutil"
"wait4x.dev/v3/waiter"
)
// NewPostgresqlCommand creates a new postgresql sub-command
func NewPostgresqlCommand() *cobra.Command {
postgresqlCommand := &cobra.Command{
Use: "postgresql DSN... [flags] [-- command [args...]]",
Aliases: []string{"postgres", "postgre"},
Short: "Check PostgreSQL connection",
Args: func(_ *cobra.Command, args []string) error {
if len(args) < 1 {
return errors.New("DSN is required argument for the postgresql command")
}
return nil
},
Example: `
# Checking PostgreSQL TCP connection
wait4x postgresql postgres://bob:secret@1.2.3.4:5432/mydb?sslmode=verify-full
`,
RunE: runPostgresql,
}
postgresqlCommand.Flags().String("expect-table", "", "Expect a table to exist in the database")
return postgresqlCommand
}
func runPostgresql(cmd *cobra.Command, args []string) error {
logger, err := logr.FromContext(cmd.Context())
if err != nil {
return fmt.Errorf("unable to get logger from context: %w", err)
}
expectTable, err := cmd.Flags().GetString("expect-table")
if err != nil {
return fmt.Errorf("failed to parse --expect-table flag: %w", err)
}
// ArgsLenAtDash returns -1 when -- was not specified
if i := cmd.ArgsLenAtDash(); i != -1 {
args = args[:i]
}
checkers := make([]checker.Checker, len(args))
for i, arg := range args {
checkers[i] = postgresql.New(arg, postgresql.WithExpectTable(expectTable))
}
return waiter.WaitParallelContext(
cmd.Context(),
checkers,
waiter.WithTimeout(contextutil.GetTimeout(cmd.Context())),
waiter.WithInterval(contextutil.GetInterval(cmd.Context())),
waiter.WithInvertCheck(contextutil.GetInvertCheck(cmd.Context())),
waiter.WithBackoffPolicy(contextutil.GetBackoffPolicy(cmd.Context())),
waiter.WithBackoffCoefficient(contextutil.GetBackoffCoefficient(cmd.Context())),
waiter.WithBackoffExponentialMaxInterval(contextutil.GetBackoffExponentialMaxInterval(cmd.Context())),
waiter.WithLogger(logger),
)
}
|