Function getFlaggedPlugins

apps/cursor/src/data/queries.ts:487–510

()

}

export async function getFlaggedPlugins() {
  const supabase = await createClient();
  const severityRank = { high: 0, medium: 1, low: 2 } as const;

  const { data, error } = await supabase
    .from("plugins")
    .select("*, plugin_components(*)")
    .eq("scan_status", "flagged")
    .order("flagged_at", { ascending: false, nullsFirst: false })
    .limit(500);

  if (error) return { data: null as PluginRow[] | null, error };

  const sorted = (data as PluginRow[] | null)?.slice().sort((a, b) => {
    const aRank = a.flag_severity ? severityRank[a.flag_severity] : 3;
    const bRank = b.flag_severity ? severityRank[b.flag_severity] : 3;
    if (aRank !== bRank) return aRank - bRank;
    const aTime = a.flagged_at ? new Date(a.flagged_at).getTime() : 0;
    const bTime = b.flagged_at ? new Date(b.flagged_at).getTime() : 0;
    return bTime - aTime;
  });

  return { data: sorted ?? null, error: null };
}

export async function getPendingVerificationRequests() {
  const supabase = await createClient();