Open-ILS/src/sql/Pg/upgrade/0260.data.acq.po_activate_and_jedi.sql

   1 BEGIN;
   2
   3 INSERT INTO config.upgrade_log (version) VALUES ('0260');
   4
   5 INSERT INTO action_trigger.validator (module, description)
   6     VALUES (
   7         'Acq::PurchaseOrderEDIRequired',
   8         oils_i18n_gettext(
   9             'Acq::PurchaseOrderEDIRequired',
  10             'Purchase order is delivered via EDI',
  11             'atval',
  12             'description'
  13         )
  14     );
  15
  16 INSERT INTO action_trigger.reactor (module, description)
  17     VALUES (
  18         'GeneratePurchaseOrderJEDI',
  19         oils_i18n_gettext(
  20             'GeneratePurchaseOrderJEDI',
  21             'Creates purchase order JEDI (JSON EDI) for subsequent EDI processing',
  22             'atreact',
  23             'description'
  24         )
  25     );
  26
  27 UPDATE action_trigger.hook
  28     SET
  29         key = 'acqpo.activated',
  30         passive = FALSE,
  31         description = oils_i18n_gettext(
  32             'acqpo.activated',
  33             'Purchase order was activated',
  34             'ath',
  35             'description'
  36         )
  37     WHERE key = 'format.po.jedi';
  38
  39 UPDATE action_trigger.event_definition
  40     SET
  41         hook = 'acqpo.activated',
  42         validator = 'Acq::PurchaseOrderEDIRequired',
  43         reactor = 'GeneratePurchaseOrderJEDI'
  44     WHERE id = 23;
  45
  46 COMMIT;
  47