Matt Aitken
6cf86d5916
* Delete v2 Stripe routes * Delete v2 billing/usage pages * Delete v2 integration pages * Delete v2 project pages * Deleted a load of components and services * Deleted a load more components, presenters and services * Deleted another 100 files or so… * Removed old v2 paths * Removed named icons from form titles * Removed more string icons * Delete NamedIcon * Fixed some type errors * Delete endpointApi * Removed v2 from core/sdk * Post merge fixes * added explicit return types * using the new sdk export without v3 * Delete old v2 file * Added explicit return types because TS was complaining… * Don’t export RuntimeEnvironmentType from two core files. Was causing TS issue * Fix for removal of NamedIcon in new route * Removed strange eslintrc rule * Use the new redis client --------- Co-authored-by: James Ritchie <james@trigger.dev>
22 lines
703 B
TypeScript
22 lines
703 B
TypeScript
import type { TaskTriggerSource } from "@trigger.dev/database";
|
|
import { PrismaClientOrTransaction, sqlDatabaseSchema } from "~/db.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, projectId: string) {
|
|
return prisma.$queryRaw<
|
|
{
|
|
slug: string;
|
|
triggerSource: TaskTriggerSource;
|
|
}[]
|
|
>`
|
|
SELECT DISTINCT(slug), "triggerSource"
|
|
FROM ${sqlDatabaseSchema}."BackgroundWorkerTask"
|
|
WHERE "projectId" = ${projectId}
|
|
ORDER BY slug ASC;`;
|
|
}
|