Spaces:
Sleeping
Sleeping
File size: 4,119 Bytes
097eaf0 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 | import { Response } from "express";
import { RequestWithAuth, ErrorResponse } from "./types";
import { supabase_rr_service } from "../../services/supabase";
import { logger as _logger } from "../../lib/logger";
const ACTIVITY_WINDOW_HOURS = 24;
const DEFAULT_LIMIT = 50;
const MAX_LIMIT = 100;
function encodeCursor(createdAt: string, id: string): string {
return Buffer.from(`${createdAt}:${id}`).toString("base64url");
}
function decodeCursor(
cursor: string,
): { createdAt: string; id: string } | null {
try {
const decoded = Buffer.from(cursor, "base64url").toString();
const sepIdx = decoded.lastIndexOf(":");
if (sepIdx === -1) return null;
const createdAt = decoded.slice(0, sepIdx);
const id = decoded.slice(sepIdx + 1);
if (!createdAt || !id) return null;
return { createdAt, id };
} catch {
return null;
}
}
const VALID_ENDPOINTS = [
"scrape",
"crawl",
"batch_scrape",
"search",
"extract",
"llmstxt",
"deep_research",
"map",
"agent",
"browser",
"interact",
] as const;
type ActivityEndpoint = (typeof VALID_ENDPOINTS)[number];
interface ActivityItem {
id: string;
endpoint: ActivityEndpoint;
api_version: string;
created_at: string;
target: string | null;
}
interface ActivityResponse {
success: true;
data: ActivityItem[];
cursor: string | null;
has_more: boolean;
}
export async function activityController(
req: RequestWithAuth,
res: Response<ActivityResponse | ErrorResponse>,
) {
const logger = _logger.child({
module: "activity",
method: "activityController",
teamId: req.auth.team_id,
});
// Parse and validate query params
const endpoint = req.query.endpoint as string | undefined;
if (endpoint && !VALID_ENDPOINTS.includes(endpoint as ActivityEndpoint)) {
return res.status(400).json({
success: false,
error: `Invalid endpoint filter. Must be one of: ${VALID_ENDPOINTS.join(", ")}`,
});
}
let limit = parseInt(req.query.limit as string, 10);
if (isNaN(limit) || limit < 1) {
limit = DEFAULT_LIMIT;
}
limit = Math.min(limit, MAX_LIMIT);
const rawCursor = req.query.cursor as string | undefined;
const cursor = rawCursor ? decodeCursor(rawCursor) : null;
if (rawCursor && !cursor) {
return res.status(400).json({
success: false,
error: "Invalid cursor.",
});
}
// Build query
const windowStart = new Date(
Date.now() - ACTIVITY_WINDOW_HOURS * 60 * 60 * 1000,
).toISOString();
let query = supabase_rr_service
.from("requests")
.select("id, kind, api_version, created_at, target_hint")
.eq("team_id", req.auth.team_id)
.gte("created_at", windowStart)
.order("created_at", { ascending: false })
.order("id", { ascending: false })
.limit(limit + 1); // fetch one extra to determine has_more
if (endpoint) {
query = query.eq("kind", endpoint);
}
if (cursor) {
// For keyset pagination: fetch rows where (created_at, id) < (cursor.createdAt, cursor.id)
// This translates to: created_at < cursor OR (created_at = cursor AND id < cursor.id)
query = query.or(
`created_at.lt.${cursor.createdAt},and(created_at.eq.${cursor.createdAt},id.lt.${cursor.id})`,
);
}
const { data, error } = await query;
if (error) {
logger.error("Failed to fetch activity", { error });
return res.status(500).json({
success: false,
error: "Failed to fetch activity.",
});
}
const hasMore = (data?.length ?? 0) > limit;
const items = hasMore ? data!.slice(0, limit) : (data ?? []);
const responseData: ActivityItem[] = items.map((row: any) => ({
id: row.id,
endpoint: row.kind,
api_version: row.api_version,
created_at: row.created_at,
target: row.target_hint,
}));
const lastItem =
hasMore && responseData.length > 0
? responseData[responseData.length - 1]
: null;
const nextCursor = lastItem
? encodeCursor(lastItem.created_at, lastItem.id)
: null;
return res.status(200).json({
success: true,
data: responseData,
cursor: nextCursor,
has_more: hasMore,
});
}
|