Bug 14469 - Script to delete Z39.50 results from the reservoir
Summary: Script to delete Z39.50 results from the reservoir
Status: CLOSED INVALID
Alias: None
Product: Koha
Classification: Unclassified
Component: Z39.50 / SRU / OpenSearch Servers (show other bugs)
Version: Main
Hardware: All All
: P5 - low enhancement (vote)
Assignee: Mirko Tietgen
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-06-28 10:04 UTC by Mirko Tietgen
Modified: 2016-06-21 21:37 UTC (History)
1 user (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments
Bug 14469 - Script to delete Z39.50 results from the reservoir (3.24 KB, patch)
2015-06-28 10:31 UTC, Mirko Tietgen
Details | Diff | Splinter Review
Bug 14469 - Script to delete Z39.50 results from the reservoir (3.21 KB, patch)
2015-06-28 10:35 UTC, Mirko Tietgen
Details | Diff | Splinter Review

Note You need to log in before you can comment on or make changes to this bug.
Description Mirko Tietgen 2015-06-28 10:04:20 UTC
With every Z39.50 search, the reservoir gets filled with results that can't be deleted. There should be a script to delete all z39.50 related entries from the reservoir.
Comment 1 Mirko Tietgen 2015-06-28 10:31:23 UTC Comment hidden (obsolete)
Comment 2 Mirko Tietgen 2015-06-28 10:35:13 UTC
Created attachment 40704 [details] [review]
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.
Comment 3 Marcel de Rooy 2015-06-28 12:44:26 UTC
This is already done by cleanup_database.pl
Comment 4 Mirko Tietgen 2015-06-28 12:57:06 UTC
(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.