Eric Allam
79b6053e13
Replace the expensive DISTINCT query for task filter dropdowns with a dedicated TaskIdentifier registry table backed by Redis. Environments migrate automatically on their next deploy, with a transparent fallback to the legacy query for unmigrated environments. Also fixes duplicate dropdown entries when a task changes trigger source, and adds active/archived grouping for removed tasks. Moves BackgroundWorkerTask reads in the trigger hot path to the read replica.
25 lines
884 B
TypeScript
25 lines
884 B
TypeScript
import type { TaskTriggerSource } from "@trigger.dev/database";
|
|
import { PrismaClientOrTransaction, sqlDatabaseSchema } from "~/db.server";
|
|
|
|
export { getTaskIdentifiers } from "~/services/taskIdentifierRegistry.server";
|
|
export type { TaskIdentifierEntry } from "~/services/taskIdentifierCache.server";
|
|
|
|
/**
|
|
*
|
|
* @param prisma An efficient query to get all task identifiers for a project.
|
|
* It has indexes for fast performance.
|
|
* It does NOT care about versions, so includes all tasks ever created.
|
|
*/
|
|
export function getAllTaskIdentifiers(prisma: PrismaClientOrTransaction, environmentId: string) {
|
|
return prisma.$queryRaw<
|
|
{
|
|
slug: string;
|
|
triggerSource: TaskTriggerSource;
|
|
}[]
|
|
>`
|
|
SELECT DISTINCT(slug), "triggerSource"
|
|
FROM ${sqlDatabaseSchema}."BackgroundWorkerTask"
|
|
WHERE "runtimeEnvironmentId" = ${environmentId}
|
|
ORDER BY slug ASC;`;
|
|
}
|