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 store_test
import (
"testing"
"github.com/google/go-cmp/cmp"
"github.com/stretchr/testify/require"
"google.golang.org/protobuf/testing/protocmp"
"github.com/bytebase/bytebase/backend/common"
storepb "github.com/bytebase/bytebase/backend/generated-go/store"
"github.com/bytebase/bytebase/backend/store"
)
func TestGetExportSetting(t *testing.T) {
t.Parallel()
fixture := newStorePostgresFixture(t, "")
ctx, s := fixture.ctx, fixture.store
setting, err := s.GetExportSetting(ctx, "default")
require.NoError(t, err)
require.Empty(t, cmp.Diff(&storepb.ExportSetting{}, setting, protocmp.Transform()), "a workspace has no row until a destination is configured")
want := &storepb.ExportSetting{Sharepoint: &storepb.SharePointSetting{TenantId: "tenant", ClientId: "client", ClientSecret: "secret"}}
_, err = s.UpsertSetting(ctx, &store.SettingMessage{
Name: storepb.SettingName_EXPORT,
Workspace: "default",
Value: want,
})
require.NoError(t, err)
setting, err = s.GetExportSetting(ctx, "default")
require.NoError(t, err)
require.Empty(t, cmp.Diff(want, setting, protocmp.Transform()))
}
func TestGetWorkspaceQueryDataPolicy(t *testing.T) {
t.Parallel()
fixture := newStorePostgresFixture(t, "")
ctx, s := fixture.ctx, fixture.store
policy, err := s.GetWorkspaceQueryDataPolicy(ctx, "default")
require.NoError(t, err)
require.False(t, policy.GetDisableDownload(), "a workspace without a policy allows download")
_, err = s.CreatePolicy(ctx, &store.PolicyMessage{
Workspace: "default",
ResourceType: storepb.Policy_PROJECT,
Resource: common.FormatProject("default"),
Type: storepb.Policy_QUERY_DATA,
Payload: `{"disableDownload":true}`,
Enforce: true,
})
require.NoError(t, err)
policy, err = s.GetWorkspaceQueryDataPolicy(ctx, "default")
require.NoError(t, err)
require.False(t, policy.GetDisableDownload(), "a project policy does not set the workspace policy")
_, err = s.CreatePolicy(ctx, &store.PolicyMessage{
Workspace: "default",
ResourceType: storepb.Policy_WORKSPACE,
Resource: common.FormatWorkspace("default"),
Type: storepb.Policy_QUERY_DATA,
Payload: `{"disableDownload":true}`,
Enforce: true,
})
require.NoError(t, err)
policy, err = s.GetWorkspaceQueryDataPolicy(ctx, "default")
require.NoError(t, err)
require.True(t, policy.GetDisableDownload())
}