From b97e4d716654f3bbbacff84a8d03813c270fc054 Mon Sep 17 00:00:00 2001 From: Alex Buckley Date: Tue, 12 May 2020 02:57:20 +0000 Subject: [PATCH] Bug 25460: Update OAI sets when adding/editing/deleting item records Also adds syspref to optionally choose to embed item information in record when adding/editing bibliographic and item records. Test plan: 1. Enable OAI-PMH and OAI-PMH:AutoUpdateSets sysprefs 2. Create a biblio record with 1 item with CCODE of NFIC 3. In Administration > OAI Sets configuration create a set and define the mapping: Field: 952, Subfield: 8, Operator: is equal to, Value: FIC 4. Run the build_oai_sets.pl script: cd misc/migration_tools sudo koha-shell ./build_oai_sets.pl -i 5. Check what items are in the OAI set: sudo koha-mysql select * from oai_sets_biblios; 6. Observe your bib from step 2 is not in the set 7. [ITEM EDIT] Edit the item to have CCODE of FIC repeat step 5 and observe biblio is still not in OAI set 8. [ITEM ADD] Add a new item with CCODE of FIC and repeat step 5 and observe biblio still not in OAI set 9. [ITEM DELETE] Delete one of your 2 items and repeat step 5 and observe biblio still not in OAI set 10. Apply patch, update database and restart plack (instruction below on the latter 2 actions): cd installer/data/mysql sudo koha-shell ./updatedatabase.pl sudo koha-plack --restart 11. Enable new syspref OAI-PMH:AutoUpdateSetsEmbedItemData 12. [ITEM ADD] Repeat step 8 and observe biblio is now in the OAI set 13. [ITEM EDIT] Edit both items to have a CCODE of NFIC and repeat step 5 and observe bib now not in set 14. [ITEM EDIT] Edit one of the items to have CCODE of FIC and repeat step 5 and observe bib now in set 15. [ITEM DELETE] Delete all items off bib and repeat step 5 and observe bib no longer in set Sponsored-By: Catalyst IT Signed-off-by: David Nind Signed-off-by: David Nind --- C4/OAI/Sets.pm | 7 +++++++ cataloguing/additem.pl | 8 ++++++++ installer/data/mysql/.updatedatabase.pl.swp | Bin 0 -> 28672 bytes ...add_oai-PMH:AutoUpdateSetsEmbedItemData_syspref.perl | 9 +++++++++ installer/data/mysql/sysprefs.sql | 3 ++- .../prog/en/modules/admin/preferences/web_services.pref | 9 ++++++++- 6 files changed, 34 insertions(+), 2 deletions(-) create mode 100644 installer/data/mysql/.updatedatabase.pl.swp create mode 100644 installer/data/mysql/atomicupdate/bug_25460-add_oai-PMH:AutoUpdateSetsEmbedItemData_syspref.perl diff --git a/C4/OAI/Sets.pm b/C4/OAI/Sets.pm index 2d96fb14e6..0ecdc77b7d 100644 --- a/C4/OAI/Sets.pm +++ b/C4/OAI/Sets.pm @@ -609,6 +609,13 @@ sub UpdateOAISetsBiblio { return unless($biblionumber and $record); + if (C4::Context->preference('OAI-PMH:AutoUpdateSetsEmbedItemData')) { + C4::Biblio::EmbedItemsInMarcBiblio({ + marc_record => $record, + biblionumber => $biblionumber + }); + } + my $sets_biblios; my @sets = CalcOAISetsBiblio($record); foreach (@sets) { diff --git a/cataloguing/additem.pl b/cataloguing/additem.pl index bb578a1bf3..cbebad21fb 100755 --- a/cataloguing/additem.pl +++ b/cataloguing/additem.pl @@ -769,6 +769,7 @@ if ($op eq "additem") { } $nextop="additem"; } elsif ($op eq "delinkitem"){ + my $analyticfield = '773'; if ($marcflavour eq 'MARC21' || $marcflavour eq 'NORMARC'){ $analyticfield = '773'; @@ -784,6 +785,13 @@ if ($op eq "additem") { my $modbibresult = ModBiblio($record, $biblionumber,''); } +# update OAI-PMH sets +if ($op) { + if (C4::Context->preference("OAI-PMH:AutoUpdateSets")) { + C4::OAI::Sets::UpdateOAISetsBiblio($biblionumber, $record); + } +} + # #------------------------------------------------------------------------------- # build screen with existing items. and "new" one diff --git a/installer/data/mysql/.updatedatabase.pl.swp b/installer/data/mysql/.updatedatabase.pl.swp new file mode 100644 index 0000000000000000000000000000000000000000..61306b23aac6b6d8829b2ac12665a61cbf607292 GIT binary patch literal 28672 zcmeI4d3+qzk;jM2kQgu+2sb=S0*$bB+4w-Rg~!s!9xRQ-XyglHYmOeNqnYV(caMbD zHV~F&6G(tf;@uE73nU9HM@SY3hCm3{E{T_A34tUWA>l{}hdIK1*iOCaUs>vcaO~!f zeD>4xp_rcjzN%NRUcIB$?M^o>i*>7c4NW2X>=z2%aKp`OzP)WqXxAm7&`4^~P8D5E zKJqhc4W+WiNZLB>Ba4MjhrvdzkjYy`qtPrnZYrNQ?8a=$O*IzAoOSuea*2Kz`b0YA z7!9TTN1F|35P={9pC|(Rgl5fbt_=0+s%h$gsr{cwD<~91Ac#N^fgl1w1cC?z5eOm> zL?DR3|Bnc`rQJejP*Zk8b55=D4tBwB{@xwGFRAqo_?n#g9^g0c?H$~N-^{n|@ILK0 z|Bm4AgD=4O`A}s2_rTl0#{_>DJPE#8@OQxD;FEXt4%q(N;ETXl3jP*&EBM8NzX^UM z_%8&11AIF8Yl6QHUb#4D~$PYeDccmn#9l@UmKLz|6!JiZLPnzTvWcz;* z_B#ZB7M%UtAo%aWIe+gL{CD8of0Ot0*Z&MS_fJCbr@{G({bIqN0$+&szasdP;KzeE z?d7lkx8PmiS;2n;-VFYI!Jh!<{&`aHUxP1%{-K}o4mkdggLC~W1%C{j$H(P@KMKzN zJuLVm;ImQxq|f^6|CQjag8ven$5%=4Uw|)x{o4h97`&6~pX{&yA@FYSF2R2;>|Z4K zgWxAY|4G4r2G0329rHBD{{e6wKW7U5KSKX8!S4s>@zJ!8zkUA=eggbEOYr-^JHT%h z{J+3s;5!800zMyn$-dqJx9_LmCxf3Y_)ox31b%bR7|ImZ{_P-0x{tpO#EjY*Ta>1_wUj+NF3w|{?kKZ|;^VfeB zIFHY=;Qt2B@w;B|E5ReE{|&*f0O#>D=U{*RmxJ^Ac!uEr3f>F*n+5+4cr*B(hxqM( z8~iBnd4gXCz6^Ys;Fp5W1ix1BOTamPPYC`m;2fXB5B2-^EpX1S)q?*scpUX#C-}wS zVet0_|0X!+Pt9Te`Y!@M0s4;M-vG~nUn}@Of%Ez}^>Dxae+2J`enId};M~5u1phiX z_y2xJ`0alUJO%p$f`1kKRPZ|m{|9jH|D%rd+rJQ;9G7*WgR1=YVfF)GDGJ!`boM^& z2(9VEDDldaQ0Qfn$4M?Dxs+rh$p(@L$qw2d-AXb_axzH|$^Ik{(Y|aGNsc5-qDY>i zz2a|4enavg$(KpaBUwmtBFQc!A(EG9&$^Z5QIbbUwvgOO@;#DENiHDSKr%$Kh9pL^ zgk%oM?j*aBJV5*IACu_)_ZZ2kB&$ifNxDcDlguTVPVy#QBRo&?1j)}xt|Up5tR-1P z(nQioQcZF&$?hcE=(B$G+*q3f_qNG>8-L9!3Y zCb~AR&*M}1c5 zH}siO17>zWjil_%P|6O^npvmfJxLYs@9LTnQuL|Gribd=vR1gNJrRv0qbeC$)D=|& zj^Q|_RdfbaSd{BX^z@<>7pkgj4VgI=Za==IrQIsJ#%XSSTgf(ZhHVrxM!0I3VQXtu zb!xs!(gP$;&aw+hD_$;yYdRKkYaOzeU$+n`;cq}4a$!LN@ zF`;-aqgz*WDJ+#R44AG_D3%Lp!yeE<_|#S+9UZE@C*GG#L}KwIg`IrbS;<;6of}>| zb3k?WB%-m!akVtMQiTW7W;##7^lGhBiD+ju5skM;`xFrMnJm;3R~^x=DD`i9q^~{F z5mj`izqdp8IL@&D)yg*NGqyp`+bDO)P}Eh1IapM~#+b5-YGO40@9mvvjbrOIyID57 z5}FTf^#mi-pStz_vY)E)6Ixz0Mklu3QDJKT#OT-k?*gE^aiSR&p7^VdJEFt3N|AiN z(~JL7W6TNHPH5`RG^s`6RjVv%D0+6v?{$l^s2}Z7(=leKQA1@?#ah=ZJD$EOXBzoz zgJ=*kWZ=W99Z-GIq^}(d!hMuu?f#RhGttwnbVZI@zJxN>J8l@SdclWTpTKtpEbE)1+CgI*e3a zjhgO|@FWz{s+MgIn#ELpEoOL{(m#HQpn1MpC5((^XDjm$>r&>XY|37%U={~e&bA7n zP~OT={a*j9PoyZrqqc3?8>yluvQx8RL369BR=IqcqU$KD?3T)I#Wh;?q&IZRo53-j zYMolOplx-HW9Dhf4=py_o|3EA#BjxecbaO^Ep;+OMj=HOm(p{LEiD~*P_e#^=8$k* zeVfO_WI4pkgkB%@Aefn4!ZG_JWf&(&a&PNwr=>8Vxs7dE&Ey=KP#W6~{(XV-3{pov{@( zgz8n2)}69r*s5R-4!J6AP_31xLUq@tl%AN`hZ)MTFs0c>ek>FsJ=IBF*3#0KFWaTo z2`73}l&I@QPqB@HHDauFZNoTK=SRt~^ORVWT?H#!&KsVQ?nt7&rNuL~qPt6l)gnq} zdn{VaSXu4Jf;LrKc60M;74@mE*3!@wcIM_vy^_+ z&y)x$HE3B`WoC_(-rQL^+GOejswJh;smyShmO!#IWYRz}3r0hOPOL@cL8mckby)Pr z#%lVVqDPGfy@{*R8H%>AMa!jRG7L3;$aPCCjg6zDqYZ<_a)V_LHs;NYQKbEDo3^%+ zTICE?+|ps74O7M-hsjCGq7rSBa+P>3j`yp@M$xcoj_NJbrY)noJTny^{yf&}w->3b z;if2Ubfw+VMEjCRoc8Cju2^!Vq9UEKWIWo}r}u{{qIx5VWURfvE0R#X{fXY5zG#E$ zqvp`!PwLBK$t6AgNfn8&RLdiY1X)_yT8RM7iprpHS9~@LrMyWk8BN*xL2um_Qm!N% z1vE?3gKehE^eDFOI=wv{vPzW>b#?EJnzZ?#PNK}um1#zzl9i^0sYfUkY(-g0GiaS2 z@+wd1Vk^!fszsaYq%o=btei^@&@Zc8q^u&9R%OsCGhSZJ;wU4eGbkWrgUaiCAWLMN zwj3YZ6)NSZlI|Q@A+jnxHlejS?TZ6nS}VCsdnfAc@i6E{r;6FeN`Ga|98HhZV%3|n zU9P$kyDl?r)6_BEGM!s`5Y^LqRwx%ucTA_5PI#^BRPu;cPn!JNX)Vdq8lYlHHM6Oi z{@Pbf^CNYJld;W`t7zrP3_F#Sv5j?Qlib7ZfChk72?fuUI*mH8G^zf|BlR|!o7Px% z?8dZNY}6BB$Ss{wx&Kd>la>)su_ zzg$!0&;K*Q`T2}11V00upD%e+@YBKDFu!zF`|WQ8uK_<-@D1R{fL|y0dZGVw!T(0+ zza{vX&_4o>@b&3w;I*iKq2Qz7$AS+EJ|gP>ir{6zuNT|}Z-o6{3hsb&d?z7L?7t1Z z2>Km@uLI}jht3ha1fGEY(}G(MWa^%uc;{`jik1#koQpA|e0&g)YbI)d#FgU^8e z>4JYAd@=adf}7xLz+V-72%MiE>Y>{m`or}Pg0J&VhrT0t4m<^ZV4Zis`UW`1zbtqb zoc()H@C^7`*l#+{Z$Ayb8vFvmQ{Wu`7X%*wUk?3V{2`0|UkiQ;_?3dM0q6R6MMtsz zso**2uMvDTILGH6!A}A2hW@mA?||*E0$&PV6nrK4O7L3*UjfeXpGx;D^oQ*)2akKF zLnXnNfph-cE_grq3g}P8Kxg|&@DA|L3*IN}Unh71ybJofHhBkZ|737}elIR~FF5z# zWrFvBbAD_SJPywBP2xdTuD=_c^Y^=gcM1KyF%hu-QgF@>L-3QpqiFwKg2%ww|2=2< zOXMPI47(4>|_XyqzJ|BFK$l$u&ifZv@D^~+ zzuN>q0i4@+&^*8WdEh+$O~L1auR{Cp6?_gj=hw6o{Pt&qb9_z{{CMy_*uP)!S>PG) zX>{*Xe|UV%1n2miEqF6HkDvPlZvyA|>4zI8+HVAB|IZS<0i4J8uLQ3L=kYlg1BLyc zA?n{C_;m2J=T_)p!H)yy{G7YM?|&Wm5cIzxco>}XFVyDOuLU1~e!t+yg7f(Nf#Ao0 z^Zsnl6aDsUz~NRXCU`YC$NwC`t3>^e3qB2;^P^#*zkUTCLHkAoKN_6(SDOVt3Y_zQ zyWmHH^ZmtsRK)#%1UROh&?SN&4vuLp^pN0(fph%#LZI3Hq2QeVs{}s;oX6K@!4C%S zM0^fw_YT8xZ^;aNeKXEck)oShhmDVI#oy4-oaw7JMpr5Bys%`2OH0gKrUh zKkxzY!!b~~{wd(x|LXL?GGz-r#BIe_im&;Jp8SQ}EA%4?=$s zjtc|xuq)a{y+3>l-MTpcLC@AvoKKEzYsX*?^eNgZ1)PV|MO6g^|ynkQ2&L3 zZv$Tq{;J^bgY*2=jg2nbe-E73=S_mY3(oO-S@3tj&qVzTaiPKX-v)QU?-2Yg!Drz@ zf%V@6$FdN*Lhv`hIe(uK{B>{>^)JOhXZx>#kAUAO_#eSHf*;rG9kBkZLjOv^UlIIB z1d{b%2Iu|5*93nFoY&VE1>Xw30sciWk+c05!FhiEk>D?Y!|jm5MvC>H2j~1K3H}^7 z=l2%D{{TJ!{|>@HXZz2BbN`hE|2;V8@8g314xHD|8U%{%KLgJ5<9flL2Iu(yTJWd9 zOYnaVHWF-q63$P-_Z5QUbnq2KAc#N^fgl1w1cC?z5eOm>L?DR3UvUKVzyCM)rGIBn zqW}Fr@9%fe!EGexk(^7?MKYOW50clY>{gPeNFE^BLh=)mdr7pNJ4k|05P={9K?H&b z1Q7@#5JVt|KoEf-0zm|V2m}%Mi$;LnV&c-XMBdB7y#MQ0tk?#<_@by^45NP;d3v?Q z`pV%4iZpvgJgN&Hd#tL#iwf3yub@)%7sxl6sT%!H{aad=MH787dgoM~^4<@n-;DMN z-g`r@MiX^}D&E2EX8nqau&OE1JDx1Z$d12L=X6zQT(M$BqkapCc2>V0K)<#tpSMQ! tD>w2cz4Q#PtDtu?WR1L`-`_AgM6Z0%FJ_tBJZG+=_X(8rOLFMi|4&*H2O9tY literal 0 HcmV?d00001 diff --git a/installer/data/mysql/atomicupdate/bug_25460-add_oai-PMH:AutoUpdateSetsEmbedItemData_syspref.perl b/installer/data/mysql/atomicupdate/bug_25460-add_oai-PMH:AutoUpdateSetsEmbedItemData_syspref.perl new file mode 100644 index 0000000000..7798c5c6d3 --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_25460-add_oai-PMH:AutoUpdateSetsEmbedItemData_syspref.perl @@ -0,0 +1,9 @@ +$DBversion = 'XXX'; +if ( CheckVersion($DBversion) ) { + $dbh->do(q{INSERT IGNORE INTO systempreferences (variable, value, options, explanation, type) VALUES ('OAI-PMH:AutoUpdateSetEmbedItemData', '0', '', 'Embed item information when automatically updating OAI sets. Requires OAI-PMH:AutoUpdateSets syspref to be enabled', 'YesNo') }); + + $dbh->do(q{ UPDATE systempreferences SET explanation = 'Automatically update OAI sets when a bibliographic or item record is created or updated' WHERE variable = 'OAI-PMH:AutoUpdateSets' }); + + SetVersion( $DBversion ); + print "Upgrade to $DBversion done (Bug 25460 - Update OAI set when adding/editing/deleting item records)\n"; +} diff --git a/installer/data/mysql/sysprefs.sql b/installer/data/mysql/sysprefs.sql index 3b96afd0a7..f476f31283 100644 --- a/installer/data/mysql/sysprefs.sql +++ b/installer/data/mysql/sysprefs.sql @@ -361,7 +361,8 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('numSearchRSSResults','50',NULL,'Specify the maximum number of results to display on a RSS page of results','Integer'), ('OAI-PMH','0',NULL,'if ON, OAI-PMH server is enabled','YesNo'), ('OAI-PMH:archiveID','KOHA-OAI-TEST',NULL,'OAI-PMH archive identification','Free'), -('OAI-PMH:AutoUpdateSets','0','','Automatically update OAI sets when a bibliographic record is created or updated','YesNo'), +('OAI-PMH:AutoUpdateSets','0','','Automatically update OAI sets when a bibliographic or item record is created or updated','YesNo'), +('OAI-PMH:AutoUpdateSetEmbedItemData', '0', '', 'Embed item information when automatically updating OAI sets. Requires OAI-PMH:AutoUpdateSets syspref to be enabled', 'YesNo'), ('OAI-PMH:ConfFile','',NULL,'If empty, Koha OAI Server operates in normal mode, otherwise it operates in extended mode.','File'), ('OAI-PMH:DeletedRecord','persistent','Koha\'s deletedbiblio table will never be deleted (persistent), might be deleted (transient), or will never have any data in it (no)','transient|persistent|no','Choice'), ('OAI-PMH:MaxCount','50',NULL,'OAI-PMH maximum number of records by answer to ListRecords and ListIdentifiers queries','Integer'), diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/web_services.pref b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/web_services.pref index 9493aede10..3d5e7a9c63 100644 --- a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/web_services.pref +++ b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/web_services.pref @@ -64,7 +64,14 @@ Web services: choices: yes: Enable no: Disable - - automatic update of OAI-PMH sets when a bibliographic record is created or updated. + - automatic update of OAI-PMH sets when a bibliographic or item record is created or updated + - + - pref: "OAI-PMH:AutoUpdateSetsEmbedItemData" + choices: + yes: Enable + no: Disable + - embedding of item data when automatically updating OAI-PMH sets. + -
NOTE: This needs OAI-PMH:AutoUpdateSets syspref to be enabled." - - Koha's deletedbiblio table - pref: "OAI-PMH:DeletedRecord" -- 2.11.0