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
|
// 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.
// Package postgresql provides the PostgreSQL checker for the Wait4X application.
package postgresql
import (
"context"
"testing"
"github.com/stretchr/testify/suite"
"github.com/testcontainers/testcontainers-go"
"github.com/testcontainers/testcontainers-go/log"
"github.com/testcontainers/testcontainers-go/modules/postgres"
"github.com/testcontainers/testcontainers-go/wait"
"wait4x.dev/v3/checker"
)
// PostgreSQLSuite is a test suite for PostgreSQL checker
type PostgreSQLSuite struct {
suite.Suite
container *postgres.PostgresContainer
}
// SetupSuite starts a PostgreSQL container
func (s *PostgreSQLSuite) SetupSuite() {
var err error
s.container, err = postgres.Run(
context.Background(),
"postgres:16-alpine",
testcontainers.WithLogger(log.TestLogger(s.T())),
testcontainers.WithWaitStrategy(wait.ForListeningPort("5432")),
)
s.Require().NoError(err)
}
// TearDownSuite stops the PostgreSQL container
func (s *PostgreSQLSuite) TearDownSuite() {
err := s.container.Terminate(context.Background())
s.Require().NoError(err)
}
// TestIdentity tests the identity of the PostgreSQL checker
func (s *PostgreSQLSuite) TestIdentity() {
chk := New("postgres://bob:secret@1.2.3.4:5432/mydb?sslmode=verify-full")
identity, err := chk.Identity()
s.Require().NoError(err)
s.Assert().Equal("1.2.3.4:5432", identity)
}
// TestInvalidIdentity tests the invalid identity of the PostgreSQL checker
func (s *PostgreSQLSuite) TestInvalidIdentity() {
chk := New("127.0.0.1:5432")
_, err := chk.Identity()
s.Assert().ErrorContains(err, "first path segment in URL cannot contain colon")
}
// TestValidConnection tests the valid connection of the PostgreSQL server
func (s *PostgreSQLSuite) TestInvalidConnection() {
var expectedError *checker.ExpectedError
chk := New("postgres://bob:secret@1.2.3.4:5432/mydb?sslmode=verify-full")
s.Assert().ErrorAs(chk.Check(context.Background()), &expectedError)
}
// TestValidAddress tests the valid address of the PostgreSQL server
func (s *PostgreSQLSuite) TestValidAddress() {
ctx := context.Background()
endpoint, err := s.container.ConnectionString(ctx)
s.Require().NoError(err)
chk := New(endpoint + "sslmode=disable")
s.Assert().Nil(chk.Check(ctx))
}
func (s *PostgreSQLSuite) TestTableNotExists() {
var expectedError *checker.ExpectedError
ctx := context.Background()
endpoint, err := s.container.ConnectionString(ctx)
s.Require().NoError(err)
chk := New(endpoint+"sslmode=disable", WithExpectTable("not_existing_table"))
s.Assert().ErrorAs(chk.Check(ctx), &expectedError)
}
func (s *PostgreSQLSuite) TestExpectTable() {
ctx := context.Background()
endpoint, err := s.container.ConnectionString(ctx)
s.Require().NoError(err)
_, _, err = s.container.Exec(ctx, []string{"psql", `postgresql://postgres:postgres@localhost:5432/postgres`, "-c", "CREATE TABLE my_table (id INT)"})
s.Require().NoError(err)
chk := New(endpoint+"sslmode=disable", WithExpectTable("my_table"))
s.Assert().Nil(chk.Check(ctx))
}
// TestPostgreSQL runs the PostgreSQL test suite
func TestPostgreSQL(t *testing.T) {
suite.Run(t, new(PostgreSQLSuite))
}
|
