Press n or j to go to the next uncovered block, b, p or k for the previous block.
| 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 159 | 1x 1x 24x 24x 24x 3x 21x 21x 24x 3x 18x 24x 24x 24x 16x 15x 15x 15x 7x 15x 3x 15x 15x 15x 4x 15x 4x 14x 1x 14x 13x 13x 4x 13x 13x 5x 5x | import { Hono } from "hono";
import type { Dal } from "../../dal";
import type { Services } from "../../services";
import { MARKETPLACE } from "../../lib/cache";
import { getYesterdayIST } from "../../lib/analytics/date-helpers";
import { queryProStats, queryProjectStats } from "../../lib/analytics/queries";
import {
writeProDaily,
writeProjectDaily,
updateProSummaries,
} from "../../lib/analytics/writers";
import { getValidIds } from "../../lib/analytics";
import { logger } from "../../lib/logger";
type Env = {
Bindings: CloudflareBindings;
Variables: {
user: { id: string; name: string; email: string } | null;
session: unknown;
dal: Dal;
services: Services;
cache: import("../../lib/cache").DualCache;
};
};
const analyticsRoutes = new Hono<Env>();
/**
* POST /api/admin/analytics/sync
* Manually trigger analytics sync (Analytics Engine → D1).
* Optional query param: ?date=YYYY-MM-DD (defaults to yesterday IST)
*/
analyticsRoutes.post("/sync", async (c) => {
const accountId = c.env.CLOUDFLARE_ACCOUNT_ID;
const apiToken = c.env.CLOUDFLARE_API_TOKEN;
if (!accountId || !apiToken) {
return c.json(
{
success: false,
error: {
code: "MISSING_CONFIG",
message:
"CLOUDFLARE_ACCOUNT_ID and CLOUDFLARE_API_TOKEN are not configured",
},
},
500,
);
}
const dateParam = c.req.query("date");
const date = dateParam || getYesterdayIST();
// Validate date format
if (!/^\d{4}-\d{2}-\d{2}$/.test(date)) {
return c.json(
{
success: false,
error: {
code: "INVALID_DATE",
message: "Date must be in YYYY-MM-DD format",
},
},
400,
);
}
const dataset = c.env.ANALYTICS_DATASET || "dr-local-events";
try {
logger.info(`[Analytics Sync] Manual trigger for date: ${date}`);
const proStats = await queryProStats(
accountId,
apiToken,
dataset,
date,
);
const projectStats = await queryProjectStats(
accountId,
apiToken,
dataset,
date,
);
// Filter out stale IDs not present in D1 to avoid FK violations
const validProIds = await getValidIds(c.env.DB, "pros");
const validProjectIds = await getValidIds(c.env.DB, "projects");
const filteredProStats = proStats.filter((s) =>
validProIds.has(s.pro_id),
);
const filteredProjectStats = projectStats.filter(
(s) =>
validProjectIds.has(s.project_id) &&
validProIds.has(s.pro_id),
);
const skippedPros = proStats.length - filteredProStats.length;
const skippedProjects =
projectStats.length - filteredProjectStats.length;
if (skippedPros > 0 || skippedProjects > 0) {
logger.info(
`[Analytics Sync] Skipped ${skippedPros} pro rows and ${skippedProjects} project rows (stale IDs not in D1)`,
);
}
if (filteredProStats.length > 0) {
await writeProDaily(c.env.DB, filteredProStats, date);
}
if (filteredProjectStats.length > 0) {
await writeProjectDaily(c.env.DB, filteredProjectStats, date);
}
await updateProSummaries(c.env.DB);
// Invalidate cached stats for synced pros so the dashboard shows fresh data
const cache = c.get("cache");
await Promise.all(
filteredProStats.map((v) =>
cache.delete(MARKETPLACE.proStats(v.pro_id)),
),
);
logger.info(
`[Analytics Sync] Manual sync complete. Pros: ${filteredProStats.length} (${skippedPros} skipped), Projects: ${filteredProjectStats.length} (${skippedProjects} skipped)`,
);
return c.json({
success: true,
data: {
date,
pros: filteredProStats.length,
projects: filteredProjectStats.length,
skipped: { pros: skippedPros, projects: skippedProjects },
},
});
} catch (error) {
logger.error("[Analytics Sync] Manual sync error:", error);
return c.json(
{
success: false,
error: {
code: "SYNC_FAILED",
message:
error instanceof Error
? error.message
: "Analytics sync failed",
},
},
500,
);
}
});
export default analyticsRoutes;
|