IF Commons GitHub

release

concept

One version of an artifact (a pipeline, a model, a schema) that was cut for release, with when and what evidence it carries

Model operations. Written in commons/data/models/operations/mod.ts:121. Identified by releaseId.

Governance: attributes

artifacttextrequired

What was released

Becomes the column artifact of release.

Written at commons/data/models/operations/mod.ts:121

cutAtinstantrequired

When it was cut

Becomes the column cut_at of release.

Written at commons/data/models/operations/mod.ts:121

evidenceReftextoptional

The test run or report that backs it

Becomes the column evidence_ref of release.

Written at commons/data/models/operations/mod.ts:121

releaseIdidentifierrequired

What identifies the release

Becomes the column release_id of release.

Written at commons/data/models/operations/mod.ts:121

versiontextrequired

Its version

Becomes the column version of release.

Written at commons/data/models/operations/mod.ts:121

Logical: the table

Projects to the table release with the primary key release_id.

ColumnTypeNullRoleFrom
artifacttextfalseattributerelease.artifact
cut_attimestampfalseattributerelease.cutAt
evidence_reftexttrueattributerelease.evidenceRef
release_idtextfalseattributerelease.releaseId
versiontextfalseattributerelease.version

Physical: SQL

CREATE TABLE IF NOT EXISTS "release" (
    "release_id" VARCHAR NOT NULL PRIMARY KEY,
    "artifact" VARCHAR NOT NULL,
    "version" VARCHAR NOT NULL,
    "cut_at" TIMESTAMPTZ NOT NULL,
    "evidence_ref" VARCHAR,
    CONSTRAINT "release_artifact_version_uq" UNIQUE ("artifact", "version")
);

Physical: the typed table

Read and written from TypeScript with the types the model gives: import { release } 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 { release } from "@intellectual-frontiers/data/sql/typed/models";

const rows = await from(release).select((s) => ({ releaseId: s.release.releaseId, artifact: s.release.artifact })).run(runner);

Titles, headings, exports, tables, columns and requirements. Esc closes.