Method CountWebhooksByUser

internal/identity/webhooks.go:306–315

CountWebhooksByUser returns the total number of webhooks (enabled + disabled) the user owns. Used by CreateWebhook to enforce the per-user cap from account_limits.max_webhooks.

(ctx context.Context, userID string)

// disabled) the user owns. Used by CreateWebhook to enforce the
// per-user cap from account_limits.max_webhooks.
func (s *Store) CountWebhooksByUser(ctx context.Context, userID string) (int, error) {
	var n int
	err := s.pool.QueryRow(ctx,
		`SELECT COUNT(*) FROM webhooks WHERE user_id = $1`, userID,
	).Scan(&n)
	if err != nil {
		return 0, err
	}
	return n, nil
}

// MaxWebhooksForUser returns the per-user cap from account_limits.
// Users without an account_limits row default to 50 — the column