GrottoCenter / grottocenter-api
91%
develop: 91%

LAST BUILD BRANCH: feat/1887-audit
DEFAULT BRANCH: develop
Repo Added
Files 592
Badge
Embed ▾
README BADGES
x

If you need to use a raster PNG badge, change the '.svg' to '.png' in the link

Markdown

Textile

RDoc

HTML

Rst

LAST BUILD ON BRANCH docs/migration-ordering
branch: docs/migration-ordering
CHANGE BRANCH
x

coverage: 90.594% (-0.005%) from 90.599%
42721455104

Pull #1988

github

ClemRz 
docs(db): convert values in the sync trigger, add NOT NULL without a scan

- Type change: convert like the backfill, nullable old column when not reversible
- NOT NULL via CHECK NOT VALID, VALIDATE, SET NOT NULL, under lock_timeout
Pull Request #1988: docs(db): order and locking rules for hand-applied prod migrations

7214 of 8306 branches covered (86.85%)

Branch coverage included in aggregate %.

13128 of 14148 relevant lines covered (92.79%)

243598.07 hits per line

Relevant lines Covered
14148 RELEVANT LINES 13128 COVERED LINES
243598.07 HITS PER LINE
Source Files on docs/migration-ordering

Recent builds

Builds Branch Commit Type Ran Committer Via Coverage
42721455104 docs/migration-ordering docs(db): convert values in the sync trigger, add NOT NULL without a scan - Type change: convert like the backfill, nullable old column when not reversible - NOT NULL via CHECK NOT VALID, VALIDATE, SET NOT NULL, under lock_timeout Pull #1988 ClemRz github
90.59
42683767299 docs/migration-ordering docs(db): split the expand/contract steps and handle column defaults - New column without DEFAULT and old DEFAULT dropped so the unsent column arrives NULL - INSERT rule keyed on NULL, UPDATE rule on IS DISTINCT FROM - Steps 1-3 as nested bullets Pull #1988 ClemRz github
90.59
42683330633 docs/migration-ordering docs(db): make the expand/contract sync trigger copy only the written side - Guard each direction with IS DISTINCT FROM on UPDATE, copy the set column on INSERT push ClemRz github
90.59
42682276526 docs/migration-ordering docs(db): order the sync trigger before the backfill in expand/contract - Old to new sync is always needed; nullable old column replaces only new to old Pull #1988 ClemRz github
90.6
42681319614 docs/migration-ordering docs(db): tighten expand/contract steps and name the refresh variants - Sync trigger works both ways, wait for the deploy, drop trigger with the old column - Say which refresh takes ~30 min (plain) and which ~45 min (CONCURRENTLY) Pull #1988 ClemRz github
90.6
42680387151 docs/migration-ordering docs(db): address review of the migration ordering rules - Split removals from renames and type changes (expand/contract) - Require nullable or DEFAULT on new columns - Prefer REFRESH CONCURRENTLY, spell out the view swap (indexes, grants, lock_t... Pull #1988 ClemRz github
90.59
42377748502 docs/migration-ordering docs(db): order and locking rules for hand-applied prod migrations - Deploy before migrating when a column goes away - Never refresh a live-read materialized view non-concurrently - Avoid the 04:20 UTC cron refresh and the Saturday maintenance wi... Pull #1988 ClemRz github
90.6
See All Builds (2069)