Skip to content

Database governance built for humans and agents — controlling changes and access across every major database.

2.4 KB
Raw Blame
package store

import (
	"context"
	"database/sql"
	"testing"

	"github.com/stretchr/testify/require"
)

func TestIsFilePath(t *testing.T) {
	t.Parallel()
	tests := []struct {
		name string
		in   string
		want bool
	}{
		{
			name: "postgres URL",
			in:   "postgres://[email protected]:5432/bytebase",
			want: false,
		},
		{
			name: "postgresql URL",
			in:   "postgresql://[email protected]:5432/bytebase",
			want: false,
		},
		{
			name: "keyword value DSN",
			in:   "host=example.com port=5432 user=bb dbname=bytebase",
			want: false,
		},
		{
			name: "keyword value IAM DSN",
			in:   "host=example.com port=5432 user=bb dbname=bytebase bytebase_aws_rds_iam=true bytebase_aws_region=us-east-1 sslmode=verify-full",
			want: false,
		},
		{
			name: "keyword value GCP IAM DSN",
			in:   "user=bb dbname=bytebase bytebase_gcp_cloud_sql_iam=true bytebase_gcp_cloud_sql_instance_connection_name=project:region:instance",
			want: false,
		},
		{
			name: "keyword value GCP IAM DSN with runtime parameter first",
			in:   "bytebase_gcp_cloud_sql_iam=true bytebase_gcp_cloud_sql_instance_connection_name=project:region:instance user=bb dbname=bytebase",
			want: false,
		},
		{
			name: "keyword value DSN with runtime parameter first",
			in:   "application_name=bytebase host=example.com port=5432 user=bb dbname=bytebase",
			want: false,
		},
		{
			name: "unix socket keyword value DSN",
			in:   "host=/tmp port=5432 user=bb dbname=bytebase",
			want: false,
		},
		{
			name: "file path",
			in:   "/var/run/bytebase/pg-url",
			want: true,
		},
		{
			name: "file path with equals",
			in:   "/var/run/bytebase/pg-url=prod",
			want: true,
		},
	}

	for _, tt := range tests {
		t.Run(tt.name, func(t *testing.T) {
			t.Parallel()
			require.Equal(t, tt.want, isFilePath(tt.in))
		})
	}
}

// TestDBConnectionManagerGetDBAfterClose pins what a runner that outlives the
// server sees: a nil handle here panicked the process instead of erroring.
func TestDBConnectionManagerGetDBAfterClose(t *testing.T) {
	t.Parallel()
	// Nothing connects: sql.Open is lazy, and the test never queries.
	db, err := sql.Open("pgx", "postgresql://user:[email protected]:1/db")
	require.NoError(t, err)
	m := &DBConnectionManager{db: db, stopWatcher: make(chan struct{})}

	require.NoError(t, m.Close())

	require.Same(t, db, m.GetDB())
	require.ErrorContains(t, m.GetDB().PingContext(context.Background()), "database is closed")
	require.NoError(t, m.Close(), "Close is idempotent")
}