From 9bb7875afa6bb5cb7f84358e9621e2e0ca91981f Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Tue, 1 Mar 2016 17:06:30 -0500 Subject: [PATCH] LP#1549505: Streamline the population views a bit more, and make them easier to replace Signed-off-by: Mike Rylander --- .../src/sql/Pg/upgrade/XXXX.schema.statisitcal-ratings.sql | 12 ++++-------- 1 file changed, 4 insertions(+), 8 deletions(-) diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.statisitcal-ratings.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.statisitcal-ratings.sql index d91bcc80d2..232c06d0c6 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.statisitcal-ratings.sql +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.statisitcal-ratings.sql @@ -150,7 +150,7 @@ CREATE TABLE rating.record_badge_score ( CREATE INDEX record_badge_score_badge_idx ON rating.record_badge_score (badge); CREATE INDEX record_badge_score_record_idx ON rating.record_badge_score (record); -CREATE VIEW rating.generic_bib_population_global AS +CREATE OR REPLACE VIEW rating.generic_bib_population_global AS WITH org_scope AS ( SELECT id, array_agg(tree) AS orgs @@ -165,14 +165,13 @@ CREATE VIEW rating.generic_bib_population_global AS badge_data.id AS badge, s.orgs FROM biblio.record_entry b - JOIN metabib.record_attr_vector_list r ON (b.id = r.source) JOIN rating.badge badge_data ON ( badge_data.circ_mod_filter IS NULL AND (badge_data.src_filter IS NULL OR b.source = badge_data.src_filter) ) JOIN org_scope s ON (badge_data.scope = s.id); -CREATE VIEW rating.generic_bib_population_by_copy AS +CREATE OR REPLACE VIEW rating.generic_bib_population_by_copy AS WITH org_scope AS ( SELECT id, array_agg(tree) AS orgs @@ -187,7 +186,6 @@ CREATE VIEW rating.generic_bib_population_by_copy AS badge_data.id AS badge, s.orgs FROM biblio.record_entry b - JOIN metabib.record_attr_vector_list r ON (b.id = r.source) JOIN asset.call_number cn ON (cn.record = b.id AND NOT cn.deleted) JOIN asset.copy cp ON (cp.call_number = cn.id AND NOT cp.deleted) JOIN org_scope s ON (cn.owning_lib = ANY (s.orgs)) @@ -199,7 +197,7 @@ CREATE VIEW rating.generic_bib_population_by_copy AS LEFT JOIN asset.copy_location_group_map lg ON (cp.location = lg.location) WHERE (badge_data.loc_grp_filter IS NULL OR lg.lgroup = badge_data.loc_grp_filter); -CREATE VIEW rating.generic_bib_population_by_uri AS +CREATE OR REPLACE VIEW rating.generic_bib_population_by_uri AS WITH org_scope AS ( SELECT id, array_agg(tree) AS orgs @@ -214,7 +212,6 @@ CREATE VIEW rating.generic_bib_population_by_uri AS badge_data.id AS badge, s.orgs FROM biblio.record_entry b - JOIN metabib.record_attr_vector_list r ON (b.id = r.source) JOIN asset.call_number cn ON (cn.record = b.id AND cn.label = '##URI##' AND NOT cn.deleted) JOIN asset.uri_call_number_map urim ON (urim.call_number = cn.id) JOIN asset.uri uri ON (urim.uri = uri.id AND uri.active) @@ -225,7 +222,7 @@ CREATE VIEW rating.generic_bib_population_by_uri AS AND (badge_data.src_filter IS NULL OR b.source = badge_data.src_filter) ); -CREATE VIEW rating.generic_bib_population_by_copy_or_uri AS +CREATE OR REPLACE VIEW rating.generic_bib_population_by_copy_or_uri AS WITH org_scope AS ( SELECT id, array_agg(tree) AS orgs @@ -240,7 +237,6 @@ CREATE VIEW rating.generic_bib_population_by_copy_or_uri AS badge_data.id AS badge, s.orgs FROM biblio.record_entry b - JOIN metabib.record_attr_vector_list r ON (b.id = r.source) JOIN asset.call_number cn ON (cn.record = b.id AND NOT cn.deleted) JOIN org_scope s ON (cn.owning_lib = ANY (s.orgs)) JOIN rating.badge badge_data ON ( -- 2.11.0