diff options
| author | Mohamed Bassem <me@mbassem.com> | 2024-10-27 23:37:54 +0000 |
|---|---|---|
| committer | Mohamed Bassem <me@mbassem.com> | 2024-10-27 23:40:10 +0000 |
| commit | a746e9a38e53e4a9114d786c7fb1b3ef4ca67870 (patch) | |
| tree | bf1d819f6faca01bc7c3db1efe91c0879caaf4a8 /packages/queue/schema.ts | |
| parent | eb7da996a7c2d617d276f296cac07a6fd5648664 (diff) | |
| download | karakeep-a746e9a38e53e4a9114d786c7fb1b3ef4ca67870.tar.zst | |
deps: Extract the queue implementation into its own repos
Diffstat (limited to 'packages/queue/schema.ts')
| -rw-r--r-- | packages/queue/schema.ts | 36 |
1 files changed, 0 insertions, 36 deletions
diff --git a/packages/queue/schema.ts b/packages/queue/schema.ts deleted file mode 100644 index 377c6b1c..00000000 --- a/packages/queue/schema.ts +++ /dev/null @@ -1,36 +0,0 @@ -import { index, integer, sqliteTable, text } from "drizzle-orm/sqlite-core"; - -function createdAtField() { - return integer("createdAt", { mode: "timestamp" }) - .notNull() - .$defaultFn(() => new Date()); -} - -export const tasksTable = sqliteTable( - "tasks", - { - id: integer("id").notNull().primaryKey({ autoIncrement: true }), - queue: text("queue").notNull(), - payload: text("payload").notNull(), - createdAt: createdAtField(), - status: text("status", { - enum: ["pending", "running", "pending_retry", "failed"], - }) - .notNull() - .default("pending"), - expireAt: integer("expireAt", { mode: "timestamp" }), - allocationId: text("allocationId").notNull(), - numRunsLeft: integer("numRunsLeft").notNull(), - maxNumRuns: integer("maxNumRuns").notNull(), - }, - (tasks) => ({ - queueIdx: index("tasks_queue_idx").on(tasks.queue), - statusIdx: index("tasks_status_idx").on(tasks.status), - expireAtIdx: index("tasks_expire_at_idx").on(tasks.expireAt), - numRunsLeftIdx: index("tasks_num_runs_left_idx").on(tasks.numRunsLeft), - maxNumRunsIdx: index("tasks_max_num_runs_idx").on(tasks.maxNumRuns), - allocationIdIdx: index("tasks_allocation_id_idx").on(tasks.allocationId), - }), -); - -export type Job = typeof tasksTable.$inferSelect; |
