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 (
"context"
"testing"
"github.com/bytebase/bytebase/backend/common/testcontainer"
"github.com/stretchr/testify/require"
"github.com/bytebase/bytebase/backend/store"
)
func TestTryAdvisoryXactLockWithStringKeyScopesByKey(t *testing.T) {
t.Parallel()
ctx := context.Background()
db, _, _ := testcontainer.NewMetadataDB(t)
tx1, err := db.BeginTx(ctx, nil)
require.NoError(t, err)
defer tx1.Rollback()
tx2, err := db.BeginTx(ctx, nil)
require.NoError(t, err)
defer tx2.Rollback()
tx3, err := db.BeginTx(ctx, nil)
require.NoError(t, err)
defer tx3.Rollback()
acquired, err := store.TryAdvisoryXactLockWithStringKey(ctx, tx1, store.AdvisoryLockKeyVCSProviderUser, "workspace-a")
require.NoError(t, err)
require.True(t, acquired)
acquired, err = store.TryAdvisoryXactLockWithStringKey(ctx, tx2, store.AdvisoryLockKeyVCSProviderUser, "workspace-a")
require.NoError(t, err)
require.False(t, acquired)
acquired, err = store.TryAdvisoryXactLockWithStringKey(ctx, tx3, store.AdvisoryLockKeyVCSProviderUser, "workspace-b")
require.NoError(t, err)
require.True(t, acquired)
}