Function getSecurityFindingById

services/security-auto-analysis/src/db/queries.ts:687–731

(db: WorkerDb, findingId: string)

      END,
      updated_at = now()
    WHERE ${ownerWhereOwnerState(owner)}
  `);
}

export async function markOwnerCreditFailure(db: WorkerDb, owner: QueueOwner): Promise<void> {
  await db
    .update(security_analysis_owner_state)
    .set({
      blocked_until: sql`now() + interval '30 minutes'`.mapWith(String),
      block_reason: 'INSUFFICIENT_CREDITS',
    })
    .where(ownerWhereOwnerState(owner));
}

export async function getSecurityFindingById(db: WorkerDb, findingId: string) {
  const rows = await db
    .select({
      id: security_findings.id,
      platform_integration_id: security_findings.platform_integration_id,
      repo_full_name: security_findings.repo_full_name,
      source: security_findings.source,
      source_id: security_findings.source_id,
      created_at: security_findings.created_at,
      status: security_findings.status,
      severity: security_findings.severity,
      package_name: security_findings.package_name,
      package_ecosystem: security_findings.package_ecosystem,
      dependency_scope: security_findings.dependency_scope,
      cve_id: security_findings.cve_id,
      ghsa_id: security_findings.ghsa_id,
      cwe_ids: security_findings.cwe_ids,
      cvss_score: security_findings.cvss_score,
      dependabot_html_url: security_findings.dependabot_html_url,
      title: security_findings.title,
      description: security_findings.description,
      vulnerable_version_range: security_findings.vulnerable_version_range,
      patched_version: security_findings.patched_version,
      manifest_path: security_findings.manifest_path,
      first_detected_at: security_findings.first_detected_at,
      fixed_at: security_findings.fixed_at,
      sla_due_at: security_findings.sla_due_at,
      raw_data: security_findings.raw_data,
      last_synced_at: security_findings.last_synced_at,
      analysis_status: security_findings.analysis_status,
      analysis: security_findings.analysis,
      analysis_started_at: security_findings.analysis_started_at,
      analysis_completed_at: security_findings.analysis_completed_at,
      session_id: security_findings.session_id,