Skip to content

@saflib/jobs-db


Variable: jobTable

const jobTable: SQLiteTableWithColumns<{ columns: { attempt: SQLiteColumn<{ baseColumn: never; columnType: "SQLiteInteger"; data: number; dataType: "number"; driverParam: number; enumValues: undefined; generated: undefined; hasDefault: true; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "attempt"; notNull: true; tableName: "job"; }, { }, { }>; authority: SQLiteColumn<{ baseColumn: never; columnType: "SQLiteTextJson"; data: JobAuthority; dataType: "json"; driverParam: string; enumValues: undefined; generated: undefined; hasDefault: false; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "authority"; notNull: true; tableName: "job"; }, { }, { $type: JobAuthority; }>; concurrency_key: SQLiteColumn<{ baseColumn: never; columnType: "SQLiteText"; data: string; dataType: "string"; driverParam: string; enumValues: [string, ...string[]]; generated: undefined; hasDefault: false; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "concurrency_key"; notNull: false; tableName: "job"; }, { }, { length: undefined | number; }>; created_at: SQLiteColumn<{ baseColumn: never; columnType: "SQLiteTimestamp"; data: Date; dataType: "date"; driverParam: number; enumValues: undefined; generated: undefined; hasDefault: false; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "created_at"; notNull: true; tableName: "job"; }, { }, { }>; dedupe_key: SQLiteColumn<{ baseColumn: never; columnType: "SQLiteText"; data: string; dataType: "string"; driverParam: string; enumValues: [string, ...string[]]; generated: undefined; hasDefault: false; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "dedupe_key"; notNull: false; tableName: "job"; }, { }, { length: undefined | number; }>; enqueued_by_operation_id: SQLiteColumn<{ baseColumn: never; columnType: "SQLiteText"; data: string; dataType: "string"; driverParam: string; enumValues: [string, ...string[]]; generated: undefined; hasDefault: false; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "enqueued_by_operation_id"; notNull: true; tableName: "job"; }, { }, { length: undefined | number; }>; finished_at: SQLiteColumn<{ baseColumn: never; columnType: "SQLiteTimestamp"; data: Date; dataType: "date"; driverParam: number; enumValues: undefined; generated: undefined; hasDefault: false; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "finished_at"; notNull: false; tableName: "job"; }, { }, { }>; heartbeat_at: SQLiteColumn<{ baseColumn: never; columnType: "SQLiteTimestamp"; data: Date; dataType: "date"; driverParam: number; enumValues: undefined; generated: undefined; hasDefault: false; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "heartbeat_at"; notNull: false; tableName: "job"; }, { }, { }>; id: SQLiteColumn<{ baseColumn: never; columnType: "SQLiteText"; data: string; dataType: "string"; driverParam: string; enumValues: [string, ...string[]]; generated: undefined; hasDefault: true; hasRuntimeDefault: true; identity: undefined; isAutoincrement: false; isPrimaryKey: true; name: "id"; notNull: true; tableName: "job"; }, { }, { length: undefined | number; }>; max_attempts: SQLiteColumn<{ baseColumn: never; columnType: "SQLiteInteger"; data: number; dataType: "number"; driverParam: number; enumValues: undefined; generated: undefined; hasDefault: false; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "max_attempts"; notNull: true; tableName: "job"; }, { }, { }>; operation_id: SQLiteColumn<{ baseColumn: never; columnType: "SQLiteText"; data: string; dataType: "string"; driverParam: string; enumValues: [string, ...string[]]; generated: undefined; hasDefault: false; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "operation_id"; notNull: true; tableName: "job"; }, { }, { length: undefined | number; }>; original_request_id: SQLiteColumn<{ baseColumn: never; columnType: "SQLiteText"; data: string; dataType: "string"; driverParam: string; enumValues: [string, ...string[]]; generated: undefined; hasDefault: false; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "original_request_id"; notNull: true; tableName: "job"; }, { }, { length: undefined | number; }>; parent_job_id: SQLiteColumn<{ baseColumn: never; columnType: "SQLiteText"; data: string; dataType: "string"; driverParam: string; enumValues: [string, ...string[]]; generated: undefined; hasDefault: false; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "parent_job_id"; notNull: false; tableName: "job"; }, { }, { length: undefined | number; }>; priority: SQLiteColumn<{ baseColumn: never; columnType: "SQLiteInteger"; data: number; dataType: "number"; driverParam: number; enumValues: undefined; generated: undefined; hasDefault: true; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "priority"; notNull: true; tableName: "job"; }, { }, { }>; request: SQLiteColumn<{ baseColumn: never; columnType: "SQLiteTextJson"; data: JobRequest; dataType: "json"; driverParam: string; enumValues: undefined; generated: undefined; hasDefault: false; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "request"; notNull: true; tableName: "job"; }, { }, { $type: JobRequest; }>; result: SQLiteColumn<{ baseColumn: never; columnType: "SQLiteTextJson"; data: null | JobResult; dataType: "json"; driverParam: string; enumValues: undefined; generated: undefined; hasDefault: false; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "result"; notNull: false; tableName: "job"; }, { }, { $type: null | JobResult; }>; run_at: SQLiteColumn<{ baseColumn: never; columnType: "SQLiteTimestamp"; data: Date; dataType: "date"; driverParam: number; enumValues: undefined; generated: undefined; hasDefault: false; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "run_at"; notNull: true; tableName: "job"; }, { }, { }>; started_at: SQLiteColumn<{ baseColumn: never; columnType: "SQLiteTimestamp"; data: Date; dataType: "date"; driverParam: number; enumValues: undefined; generated: undefined; hasDefault: false; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "started_at"; notNull: false; tableName: "job"; }, { }, { }>; status: SQLiteColumn<{ baseColumn: never; columnType: "SQLiteText"; data: "pending" | "running" | "retrying" | "succeeded" | "dead" | "cancelled"; dataType: "string"; driverParam: string; enumValues: ["pending", "running", "retrying", "succeeded", "dead", "cancelled"]; generated: undefined; hasDefault: false; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "status"; notNull: true; tableName: "job"; }, { }, { length: undefined | number; }>; updated_at: SQLiteColumn<{ baseColumn: never; columnType: "SQLiteTimestamp"; data: Date; dataType: "date"; driverParam: number; enumValues: undefined; generated: undefined; hasDefault: false; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "updated_at"; notNull: true; tableName: "job"; }, { }, { }>; user_id: SQLiteColumn<{ baseColumn: never; columnType: "SQLiteText"; data: string; dataType: "string"; driverParam: string; enumValues: [string, ...string[]]; generated: undefined; hasDefault: false; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "user_id"; notNull: true; tableName: "job"; }, { }, { length: undefined | number; }>; }; dialect: "sqlite"; name: "job"; schema: undefined; }>