3 SELECT evergreen.upgrade_deps_block_check('1323', :eg_version);
5 -- VIEWS for the oai service
8 -- The view presents a lean table with unique bre.tc-numbers for oai paging;
9 CREATE VIEW oai.biblio AS
12 bre.edit_date AT TIME ZONE 'UTC' AS datestamp,
13 bre.deleted AS deleted
15 biblio.record_entry bre
19 -- The view presents a lean table with unique are.tc-numbers for oai paging;
20 CREATE VIEW oai.authority AS
23 are.edit_date AT TIME ZONE 'UTC' AS datestamp,
24 are.deleted AS deleted
26 authority.record_entry AS are
30 CREATE OR REPLACE function oai.bib_is_visible_at_org_by_copy(bib BIGINT, org INT) RETURNS BOOL AS $F$
31 WITH corgs AS (SELECT array_agg(id) AS list FROM actor.org_unit_descendants(org))
32 SELECT EXISTS (SELECT 1 FROM asset.copy_vis_attr_cache, corgs WHERE vis_attr_vector @@ search.calculate_visibility_attribute_test('circ_lib', corgs.list)::query_int AND bib=record)
33 $F$ LANGUAGE SQL STABLE;
35 CREATE OR REPLACE function oai.bib_is_visible_at_org_by_luri(bib BIGINT, org INT) RETURNS BOOL AS $F$
36 WITH lorgs AS(SELECT array_agg(id) AS list FROM actor.org_unit_ancestors(org))
37 SELECT EXISTS (SELECT 1 FROM biblio.record_entry, lorgs WHERE vis_attr_vector @@ search.calculate_visibility_attribute_test('luri_org', lorgs.list)::query_int AND bib=id)
38 $F$ LANGUAGE SQL STABLE;
40 CREATE OR REPLACE function oai.bib_is_visible_by_source(bib BIGINT, src TEXT) RETURNS BOOL AS $F$
41 SELECT EXISTS (SELECT 1 FROM biblio.record_entry b JOIN config.bib_source s ON (b.source = s.id) WHERE transcendant AND s.source = src AND bib=b.id)
42 $F$ LANGUAGE SQL STABLE;
44 CREATE OR REPLACE function oai.auth_is_visible_by_axis(auth BIGINT, ax TEXT) RETURNS BOOL AS $F$
45 SELECT EXISTS (SELECT 1 FROM authority.browse_axis_authority_field_map m JOIN authority.simple_heading r on (r.atag = m.field AND r.record = auth AND m.axis = ax))
46 $F$ LANGUAGE SQL STABLE;