1 -- VIEWS for the oai service
4 -- The view presents a lean table with unique bre.tc-numbers for oai paging;
5 CREATE VIEW oai.biblio AS
8 bre.edit_date AT TIME ZONE 'UTC' AS datestamp,
11 biblio.record_entry bre
15 -- The view presents a lean table with unique are.tc-numbers for oai paging;
16 CREATE VIEW oai.authority AS
19 are.edit_date AT TIME ZONE 'UTC' AS datestamp,
20 are.deleted AS deleted
22 authority.record_entry AS are
26 CREATE OR REPLACE function oai.bib_is_visible_at_org_by_copy(bib BIGINT, org INT) RETURNS BOOL AS $F$
27 WITH corgs AS (SELECT array_agg(id) AS list FROM actor.org_unit_descendants(org))
28 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)
29 $F$ LANGUAGE SQL STABLE;
31 CREATE OR REPLACE function oai.bib_is_visible_at_org_by_luri(bib BIGINT, org INT) RETURNS BOOL AS $F$
32 WITH lorgs AS(SELECT array_agg(id) AS list FROM actor.org_unit_ancestors(org))
33 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)
34 $F$ LANGUAGE SQL STABLE;
36 CREATE OR REPLACE function oai.bib_is_visible_by_source(bib BIGINT, src TEXT) RETURNS BOOL AS $F$
37 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)
38 $F$ LANGUAGE SQL STABLE;
40 CREATE OR REPLACE function oai.auth_is_visible_by_axis(auth BIGINT, ax TEXT) RETURNS BOOL AS $F$
41 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))
42 $F$ LANGUAGE SQL STABLE;