What's Changed
- Add risk assessment metadata by @slominskir in #32
Oracle DB Migration Notes
alter table SIM_OWNER.SOFTWARE add OPS_IMPACT SMALLINT DEFAULT 3 NOT NULL;
alter table SIM_OWNER.SOFTWARE add PAST_DOWNTIME SMALLINT DEFAULT 3 NOT NULL;
alter table SIM_OWNER.SOFTWARE add DEBUGGABILITY_N_TESTING SMALLINT DEFAULT 3 NOT NULL;
alter table SIM_OWNER.SOFTWARE add CODE_COMPLEXITY SMALLINT DEFAULT 3 NOT NULL;
alter table SIM_OWNER.SOFTWARE add DOCUMENTATION_GAPS SMALLINT DEFAULT 3 NOT NULL;
alter table SIM_OWNER.SOFTWARE add ESOTERICISM SMALLINT DEFAULT 3 NOT NULL;
alter table SIM_OWNER.SOFTWARE add DOWN_PROBABILITY SMALLINT GENERATED ALWAYS AS ((PAST_DOWNTIME + DEBUGGABILITY_N_TESTING + CODE_COMPLEXITY + DOCUMENTATION_GAPS + ESOTERICISM) / 5) VIRTUAL;
alter table SIM_OWNER.SOFTWARE add DOWNTIME_RISK SMALLINT GENERATED ALWAYS AS (((PAST_DOWNTIME + DEBUGGABILITY_N_TESTING + CODE_COMPLEXITY + DOCUMENTATION_GAPS + ESOTERICISM) / 5) + OPS_IMPACT) VIRTUAL;
alter table SIM_OWNER.SOFTWARE add CONSTRAINT SOFTWARE_CK3 CHECK (OPS_IMPACT IN (1, 2, 3, 4, 5));
alter table SIM_OWNER.SOFTWARE add CONSTRAINT SOFTWARE_CK4 CHECK (PAST_DOWNTIME IN (1, 2, 3, 4, 5));
alter table SIM_OWNER.SOFTWARE add CONSTRAINT SOFTWARE_CK5 CHECK (DEBUGGABILITY_N_TESTING IN (1, 2, 3, 4, 5));
alter table SIM_OWNER.SOFTWARE add CONSTRAINT SOFTWARE_CK6 CHECK (CODE_COMPLEXITY IN (1, 2, 3, 4, 5));
alter table SIM_OWNER.SOFTWARE add CONSTRAINT SOFTWARE_CK7 CHECK (DOCUMENTATION_GAPS IN (1, 2, 3, 4, 5));
alter table SIM_OWNER.SOFTWARE add CONSTRAINT SOFTWARE_CK8 CHECK (ESOTERICISM IN (1, 2, 3, 4, 5));
Full Changelog: v2.1.1...v2.2.0
Contributors
slominskir