Skip to content

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

2.3 KB
Raw Blame
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())
}