LP#1482757: Remove 'orphaned_uri_list' and 'NOT cn.deleted' criteria
authorMichele Morgan <mmorgan@noblenet.org>
Fri, 24 Apr 2020 16:43:39 +0000 (12:43 -0400)
committerJason Stephenson <jason@sigio.com>
Thu, 24 Sep 2020 16:28:18 +0000 (12:28 -0400)
commita70e9265b3c789ef3798e7f3899a92005bb3553b
tree6103694e8d976d6dc91d185a953a4cd1e72f0139
parent551e7ef0c2134ff3428ec2d5436613f19e4313ad
LP#1482757: Remove 'orphaned_uri_list' and 'NOT cn.deleted' criteria

Per Dan Wells' suggestions.

1) One possible "crack" I see for data to fall through is the dead map
selector. The "AND cn.label = '##URI##' AND NOT cn.deleted" seems overly
restrictive. Now, I realize we *shouldn't* have mappings to deleted or
non-##URI## call numbers, but it isn't impossible, and I don't think we'd
have harm in leaving those restrictions out. If a map isn't used, let's
get rid of it regardless, I think.

2) (side note) orphaned_uri_list doesn't seems to be used any more, so
should be removed.

Signed-off-by: Michele Morgan <mmorgan@noblenet.org>
Signed-off-by: Jason Stephenson <jason@sigio.com>
Open-ILS/src/sql/Pg/030.schema.metabib.sql
Open-ILS/src/sql/Pg/upgrade/XXXX.function.biblio.extract_located_uris.sql