From 655fc3ad3b0faeec16e6bf70360ae9ccad642d2a Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Thu, 2 Oct 2025 22:02:34 +0000 Subject: [PATCH] Add creation of a NONE person to the conversion --- conversion/clean.sql | 4 +++- conversion/load_data.sql | 3 ++- 2 files changed, 5 insertions(+), 2 deletions(-) diff --git a/conversion/clean.sql b/conversion/clean.sql index 0010e14..b494b28 100644 --- a/conversion/clean.sql +++ b/conversion/clean.sql @@ -43,7 +43,9 @@ INSERT INTO people (person, name, description) , ('KW', 'KW', '') , ('SF', 'SF', '') , ('ICG', 'ICG', '') - , ('UNK', 'Unknown', 'The unknown person'); + , ('UNK', 'Unknown', 'The unknown person') + , ('NONE', 'No person' + , 'Used when a person is required, but nobody filled the role'); -- -- Clean the unknown individuals diff --git a/conversion/load_data.sql b/conversion/load_data.sql index a437855..91abd99 100644 --- a/conversion/load_data.sql +++ b/conversion/load_data.sql @@ -283,4 +283,5 @@ SELECT upper( -- problem #31) -- Make the unknown person unusable. UPDATE people SET active = FALSE - WHERE person = 'UNK'; + WHERE person = 'UNK' + OR person = 'NONE'; -- 2.34.1