Database governance built for humans and agents — controlling changes and access across every major database.
Go cicddata-governancedata-maskingdata-securitydatabase-accessdatabase-governancedevopsdevsecopsflywaygitopsliquibasemongodbmysqloraclepostgresqlschema-migrationssecuritysql-clientsqlservertidb
package model
import (
"testing"
metadatapb "github.com/bytebase/omni/metadata"
"github.com/stretchr/testify/require"
storepb "github.com/bytebase/bytebase/backend/generated-go/store"
)
func TestParsePGConfiguredSearchPath(t *testing.T) {
got := ParsePGConfiguredSearchPath(` "$user" , public, "CamelCase", "schema,with,comma", pg_catalog, 'SingleQuoted', information_schema `)
require.Equal(t, []PGSearchPathItem{
{CurrentUser: true},
{Schema: "public"},
{Schema: "CamelCase"},
{Schema: "schema,with,comma"},
{Schema: "SingleQuoted"},
}, got)
}
func TestResolvePGSearchPath(t *testing.T) {
configured := []PGSearchPathItem{
{CurrentUser: true},
{Schema: "public"},
{Schema: "MissingSchema"},
{Schema: "CamelCase"},
}
schemaSet := map[string]bool{
"alice": true,
"public": true,
"CamelCase": true,
}
got := ResolvePGSearchPath(configured, "alice", func(schema string) bool {
return schemaSet[schema]
})
require.Equal(t, []string{"alice", "public", "CamelCase"}, got)
}
func TestDatabaseMetadataSearchPathHelpers(t *testing.T) {
metadata := &metadatapb.DatabaseSchemaMetadata{
Name: "testdb",
SearchPath: `"$user", public, MissingSchema, "CamelCase"`,
Schemas: []*metadatapb.SchemaMetadata{
{Name: "alice"},
{Name: "public"},
{Name: "CamelCase"},
},
}
db := NewDatabaseMetadata(metadata, nil, nil, storepb.Engine_POSTGRES, true)
require.Equal(t, []PGSearchPathItem{
{CurrentUser: true},
{Schema: "public"},
{Schema: "missingschema"},
{Schema: "CamelCase"},
}, db.GetConfiguredSearchPath())
require.Equal(t, []string{"public", "missingschema", "CamelCase"}, db.GetSearchPath())
require.Equal(t, []string{"alice", "public", "CamelCase"}, db.GetSearchPathForCurrentUser("alice"))
}
func TestDatabaseMetadataSearchPathHelpersSkipMissingCurrentUserSchema(t *testing.T) {
metadata := &metadatapb.DatabaseSchemaMetadata{
Name: "testdb",
SearchPath: `"$user", public, MissingSchema`,
Schemas: []*metadatapb.SchemaMetadata{
{Name: "public"},
},
}
db := NewDatabaseMetadata(metadata, nil, nil, storepb.Engine_POSTGRES, true)
require.Equal(t, []string{"public"}, db.GetSearchPathForCurrentUser("alice"))
}