Open-ILS/src/sql/Pg/t/lp1756912_unapi_feed_copy_counts_include_preflib.pg

   1 BEGIN;
   2
   3 SELECT plan(2);
   4
   5 INSERT INTO biblio.record_entry (marc, last_xact_id)
   6 VALUES ('<record xmlns="http://www.loc.gov/MARC21/slim"/>', 'test_lp1756912');
   7
   8 SELECT cmp_ok(
   9     (
  10         SELECT ARRAY_LENGTH(XPATH(
  11             '/marc:collection/marc:record/marc:holdings/marc:counts/marc:count[@type="pref_lib"]',
  12             unapi.biblio_record_entry_feed(
  13                 ('{' || CURRVAL('biblio.record_entry_id_seq') || '}')::BIGINT[], 'marcxml',
  14                 '{holdings_xml,mra,acp,acnp,acns,bmp,cbs}', 'SYS1', '1', 'acn=>5,acp=>5',
  15                 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
  16                 5
  17             ),
  18             ARRAY[ARRAY['marc', 'http://www.loc.gov/MARC21/slim']]
  19         ), 1)
  20     ),
  21     '>',
  22     0,
  23     'unapi.biblio_record_entry_feed includes pref_lib holdings counts'
  24 );
  25
  26 SELECT cmp_ok(
  27     (
  28         SELECT ARRAY_LENGTH(XPATH(
  29             '/marc:collection/marc:record/marc:holdings/marc:counts/marc:count[@type="pref_lib"]',
  30             unapi.metabib_virtual_record_feed(
  31                 ('{' || metarecord || '}')::BIGINT[], 'marcxml',
  32                 '{holdings_xml,mra,acp,acnp,acns,bmp,cbs}', 'SYS1', '1', 'acn=>5,acp=>5',
  33                 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
  34                 5
  35             ),
  36             ARRAY[ARRAY['marc', 'http://www.loc.gov/MARC21/slim']]
  37         ), 1)
  38         FROM metabib.metarecord_source_map
  39         WHERE source = CURRVAL('biblio.record_entry_id_seq')
  40     ),
  41     '>',
  42     0,
  43     'unapi.metabib_virtual_record_feed includes pref_lib holdings counts'
  44 );
  45
  46 ROLLBACK;