criticalityintegerrequiredHow critical it is, 1 the most
Becomes the column criticality of workload.
Written at commons/data/models/operations/mod.ts:139
A job, query set or service the platform runs, with who owns it, how often it runs and how critical it is: the register that capacity, cost and recovery are planned from
Model operations. Written in commons/data/models/operations/mod.ts:139. Identified by workloadId.
criticalityintegerrequiredHow critical it is, 1 the most
Becomes the column criticality of workload.
Written at commons/data/models/operations/mod.ts:139
nametextrequiredownertextrequiredWho owns it
Becomes the column owner of workload.
Written at commons/data/models/operations/mod.ts:139
scheduletextrequiredWhen it runs, in words or a cron
Becomes the column schedule of workload.
Written at commons/data/models/operations/mod.ts:139
workloadIdidentifierrequiredWhat identifies the workload
Becomes the column workload_id of workload.
Written at commons/data/models/operations/mod.ts:139
Projects to the table workload with the primary key workload_id.
| Column | Type | Null | Role | From |
|---|---|---|---|---|
criticality | integer | false | attribute | workload.criticality |
name | text | false | attribute | workload.name |
owner | text | false | attribute | workload.owner |
schedule | text | false | attribute | workload.schedule |
workload_id | text | false | attribute | workload.workloadId |
CREATE TABLE IF NOT EXISTS "workload" (
"workload_id" VARCHAR NOT NULL PRIMARY KEY,
"name" VARCHAR NOT NULL,
"owner" VARCHAR NOT NULL,
"schedule" VARCHAR NOT NULL,
"criticality" INTEGER NOT NULL,
CONSTRAINT "workload_name_uq" UNIQUE ("name")
);CREATE TABLE IF NOT EXISTS "workload" (
"workload_id" TEXT NOT NULL PRIMARY KEY,
"name" TEXT NOT NULL,
"owner" TEXT NOT NULL,
"schedule" TEXT NOT NULL,
"criticality" INTEGER NOT NULL,
CONSTRAINT "workload_name_uq" UNIQUE ("name")
);CREATE TABLE IF NOT EXISTS "workload" (
"workload_id" TEXT NOT NULL PRIMARY KEY,
"name" TEXT NOT NULL,
"owner" TEXT NOT NULL,
"schedule" TEXT NOT NULL,
"criticality" INTEGER NOT NULL,
CONSTRAINT "workload_name_uq" UNIQUE ("name")
);Read and written from TypeScript with the types the model gives: import { workload } from "@intellectual-frontiers/data/sql/typed/models". Generated in commons/data/sql/typed/models/operations.auto.ts: do not edit.
import { from } from "@intellectual-frontiers/data/sql/typed";
import { workload } from "@intellectual-frontiers/data/sql/typed/models";
const rows = await from(workload).select((s) => ({ workloadId: s.workload.workloadId, name: s.workload.name })).run(runner);