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
import (
"context"
"github.com/pkg/errors"
"google.golang.org/protobuf/encoding/protojson"
storepb "github.com/bytebase/bytebase/backend/generated-go/store"
)
// SignalChannel is the PostgreSQL NOTIFY channel for HA coordination.
const SignalChannel = "bytebase_signal"
// SendSignal sends a notification to the bytebase_signal channel.
func (s *Store) SendSignal(ctx context.Context, signalType storepb.Signal_Type, projectID string, uid int64, approvalInputVersion *int64) error {
signal := &storepb.Signal{
Type: signalType,
Uid: uid,
Project: projectID,
}
if approvalInputVersion != nil {
signal.ApprovalInputVersion = *approvalInputVersion
}
payload, err := protojson.Marshal(signal)
if err != nil {
return errors.Wrap(err, "failed to marshal signal payload")
}
_, err = s.GetDB().ExecContext(ctx, "SELECT pg_notify($1, $2)", SignalChannel, string(payload))
return errors.Wrap(err, "failed to send signal")
}