http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14469 --- Comment #1 from Mirko Tietgen <mirko@abunchofthings.net> --- Created attachment 40703 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=40703&action=edit Bug 14469 - Script to delete Z39.50 results from the reservoir With every Z39.50 search, the reservoir gets filled with results. This script is supposed to delete all entries from z39.50 results from the reservoir. Test plan: - stage a mrc file for import - do a z3950 search - do a cataloguing search for something that will show results of both the staged mrc and the z3950 results, find results for both types in the reservoir part of the page - run this script - repeat the search, observe that results from mrc are still in the reservoir but those from z3950 are gone - check db for records from z3950 batches: SELECT import_record_id, import_batches.batch_type, import_batches.file_name FROM import_records JOIN import_batches USING (import_batch_id) WHERE batch_type LIKE 'z3950'; There should not be any results. - check db for batches from z3950: SELECT * FROM import_batches WHERE batch_type LIKE 'z3950'; There should not be any results. -- You are receiving this mail because: You are watching all bug changes.

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14469 Mirko Tietgen <mirko@abunchofthings.net> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #40703|0 |1 is obsolete| | --- Comment #2 from Mirko Tietgen <mirko@abunchofthings.net> --- Created attachment 40704 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=40704&action=edit Bug 14469 - Script to delete Z39.50 results from the reservoir With every Z39.50 search, the reservoir gets filled with results. This script is supposed to delete all entries from z39.50 results from the reservoir. Test plan: - stage a mrc file for import - do a z3950 search - do a cataloguing search for something that will show results of both the staged mrc and the z3950 results, find results for both types in the reservoir part of the page - run this script - repeat the search, observe that results from mrc are still in the reservoir but those from z3950 are gone - check db for records from z3950 batches: SELECT import_record_id, import_batches.batch_type, import_batches.file_name FROM import_records JOIN import_batches USING (import_batch_id) WHERE batch_type LIKE 'z3950'; There should not be any results. - check db for batches from z3950: SELECT * FROM import_batches WHERE batch_type LIKE 'z3950'; There should not be any results. -- You are receiving this mail because: You are watching all bug changes.

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14469 Mirko Tietgen <mirko@abunchofthings.net> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |INVALID Status|Needs Signoff |RESOLVED --- Comment #4 from Mirko Tietgen <mirko@abunchofthings.net> --- (In reply to Marcel de Rooy from comment #3)

This is already done by cleanup_database.pl

Oh! Looks like I misunderstood the comment on Bug 3069. Thanks. -- You are receiving this mail because: You are watching all bug changes.