3 INSERT INTO config.upgrade_log (version) VALUES ('0294'); -- phasefx
5 INSERT INTO container.biblio_record_entry_bucket_type( code, label ) VALUES (
9 'Temporary bucket which gets deleted after use.',
15 INSERT INTO action_trigger.cleanup ( module, description ) VALUES (
16 'DeleteTempBiblioBucket',
18 'DeleteTempBiblioBucket',
19 'Deletes a cbreb object used as a target if it has a btype of "temp"',
25 INSERT INTO action_trigger.hook (key,core_type,description,passive) VALUES (
26 'biblio.format.record_entry.email',
29 'biblio.format.record_entry.email',
30 'An email has been requested for one or more biblio record entries.',
37 'biblio.format.record_entry.print',
40 'biblio.format.record_entry.print',
41 'One or more biblio record entries need to be formatted for printing.',
49 INSERT INTO action_trigger.event_definition (
66 'biblio.record_entry.email',
67 'biblio.format.record_entry.email',
70 'DeleteTempBiblioBucket',
71 'DeleteTempBiblioBucket',
76 [%- SET user = target.0.owner -%]
77 To: [%- params.recipient_email || user.email %]
78 From: [%- params.sender_email || default_sender %]
79 Subject: Bibliographic Records
81 [% FOR cbreb IN target %]
82 [% FOR cbrebi IN cbreb.items %]
83 Bib ID# [% cbrebi.target_biblio_record_entry.id %] ISBN: [% crebi.target_biblio_record_entry.simple_record.isbn %]
84 Title: [% cbrebi.target_biblio_record_entry.simple_record.title %]
85 Author: [% cbrebi.target_biblio_record_entry.simple_record.author %]
86 Publication Year: [% cbrebi.target_biblio_record_entry.simple_record.pubdate %]
96 'biblio.record_entry.print',
97 'biblio.format.record_entry.print',
100 'DeleteTempBiblioBucket',
101 'DeleteTempBiblioBucket',
107 <style> li { padding: 8px; margin 5px; }</style>
109 [% FOR cbreb IN target %]
110 [% FOR cbrebi IN cbreb.items %]
111 <li>Bib ID# [% cbrebi.target_biblio_record_entry.id %] ISBN: [% crebi.target_biblio_record_entry.simple_record.isbn %]<br />
112 Title: [% cbrebi.target_biblio_record_entry.simple_record.title %]<br />
113 Author: [% cbrebi.target_biblio_record_entry.simple_record.author %]<br />
114 Publication Year: [% cbrebi.target_biblio_record_entry.simple_record.pubdate %]
124 INSERT INTO action_trigger.environment (
127 ) VALUES -- for fleshing cbreb objects
130 ,( 31, 'items.target_biblio_record_entry' )
131 ,( 31, 'items.target_biblio_record_entry.simple_record' )
132 ,( 31, 'items.target_biblio_record_entry.call_numbers' )
133 ,( 31, 'items.target_biblio_record_entry.fixed_fields' )
134 ,( 31, 'items.target_biblio_record_entry.notes' )
135 ,( 31, 'items.target_biblio_record_entry.full_record_entries' )
138 ,( 32, 'items.target_biblio_record_entry' )
139 ,( 32, 'items.target_biblio_record_entry.simple_record' )
140 ,( 32, 'items.target_biblio_record_entry.call_numbers' )
141 ,( 32, 'items.target_biblio_record_entry.fixed_fields' )
142 ,( 32, 'items.target_biblio_record_entry.notes' )
143 ,( 32, 'items.target_biblio_record_entry.full_record_entries' )
146 -- DELETE FROM action_trigger.environment WHERE event_def IN (31,32); DELETE FROM action_trigger.event where event_def IN (31,32); DELETE FROM action_trigger.event_definition WHERE id IN (31,32); DELETE FROM action_trigger.hook WHERE key IN ('biblio.format.record_entry.email','biblio.format.record_entry.print'); DELETE FROM action_trigger.cleanup WHERE module = 'DeleteTempBiblioBucket'; DELETE FROM container.biblio_record_entry_bucket_item WHERE bucket IN (SELECT id FROM container.biblio_record_entry_bucket WHERE btype = 'temp'); DELETE FROM container.biblio_record_entry_bucket WHERE btype = 'temp'; DELETE FROM container.biblio_record_entry_bucket_type WHERE code = 'temp'; DELETE FROM config.upgrade_log WHERE version = '0294'; -- from testing, this sql will remove these events, etc.