mirror of
https://github.com/Dvorinka/Primora.git
synced 2026-10-28 15:51:23 +00:00
Tomas Dvorak
e25eb92339
- core.integrations (migration 00005) with AES-256-GCM-encrypted credentials (PRIMORA_ENCRYPTION_KEY, hex/base64, dev fallback); has_credentials serialization only — secrets never leave the server - /projects/:id/integrations list/create/delete/test; health check hits the stored base URL with a 5s timeout and records status - Rybbit connector: GET …/integrations/:id/analytics proxies /api/organizations + /api/sites/* server-side into a normalized shape - core.webhooks + core.webhook_deliveries; CRUD, deliveries, test, and POST …/deploy-markers. Events: issue.created (new fingerprint on ingest), deploy.marker, webhook.test. X-Primora-Signature HMAC-SHA256 over the raw body; in-process dispatcher, 3 attempts, quadratic backoff, 10s timeout, pending-scan on boot - HTTPS enforced for public targets; HTTP allowed for loopback/private/ self-hosted sinks - Integrations page (connectors + webhooks tabs, inline analytics, delivery log, secret-shown-once), demo-mode stubs - 12 new primora_* MCP tools - workspace 0.4.0 Authored By: TDvorak <[email protected]>
34 lines
650 B
SQL
34 lines
650 B
SQL
-- name: ListIntegrations :many
|
|
SELECT * FROM core.integrations
|
|
WHERE project_id = $1
|
|
ORDER BY name ASC;
|
|
|
|
-- name: GetIntegrationByID :one
|
|
SELECT * FROM core.integrations
|
|
WHERE id = $1;
|
|
|
|
-- name: CreateIntegration :one
|
|
INSERT INTO core.integrations (
|
|
project_id,
|
|
type,
|
|
name,
|
|
base_url,
|
|
config,
|
|
credentials,
|
|
created_by_user_id
|
|
) VALUES ($1, $2, $3, $4, $5, $6, $7)
|
|
RETURNING *;
|
|
|
|
-- name: DeleteIntegration :one
|
|
DELETE FROM core.integrations
|
|
WHERE id = $1
|
|
AND project_id = $2
|
|
RETURNING *;
|
|
|
|
-- name: UpdateIntegrationHealth :exec
|
|
UPDATE core.integrations
|
|
SET status = $2,
|
|
last_health_at = NOW(),
|
|
updated_at = NOW()
|
|
WHERE id = $1;
|