[Koha-bugs] [Bug 1084] would be nice to remove records from breeding tables.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=1084 Katrin Fischer katrin.fisc...@bsz-bw.de changed: What|Removed |Added Status|REOPENED|RESOLVED Resolution|--- |FIXED --- Comment #8 from Katrin Fischer katrin.fisc...@bsz-bw.de --- I believe this is fixed by an option of the cleanup_database cronjob: 62--z3950purge records from import tables that are the result 63 of Z39.50 searches Please open a new bug if more functionality is needed. -- You are receiving this mail because: You are the QA Contact for the bug. You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 1084] would be nice to remove records from breeding tables.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=1084 Magnus Enger mag...@enger.priv.no changed: What|Removed |Added CC||mag...@enger.priv.no Blocks||8149 -- You are receiving this mail because: You are the QA Contact for the bug. You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 1084] would be nice to remove records from breeding tables.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=1084 --- Comment #7 from Michael Hafen mdha...@tech.washk12.org --- (In reply to comment #5) well spotted Katrin. This could easily be achieved with the following SQL requests : DELETE FROM import_records WHERE import_batch_id IN (SELECT import_batches.import_batch_id FROM import_batches WHERE import_batches.batch_type =z3950) AND import_records.upload_timestamp= DATE_SUB(now(), INTERVAL 1 DAY); DELETE FROM import_batches WHERE import_batch_id NOT IN (SELECT DISTINCT import_batch_id from import_records); The 1st request deletes all z3950 entries that are older than one day (too much from far, but harmless) The 2nd request deletes the fake batch header that is generated on each z3950 query We can put those SQLs in 2 places: * on any z3950 search = before doing the new search, clean the database. Easy to setup, efficient, although a little loss of performances. I think this loss of performance is small compared to how long z3950 servers answer * add a script to cronjob, that cleans every night. A little bit harder to write, and has to be setup during installation, which put some pain to the sysadmin. I prefer the 1st option, let me know which one you prefer. Either the first option, or adding those sql statements to the cleanup_database script with a default of 1 day. Either of those options would be fine with me. I think I'd prefer having it in cleanup_database if only so the delay to removal can be set by the sysadmin. But I'm fine with which ever gets the job done. -- You are receiving this mail because: You are the QA Contact for the bug. You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 1084] would be nice to remove records from breeding tables.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=1084 Chris Cormack ch...@bigballofwax.co.nz changed: What|Removed |Added CC||ch...@bigballofwax.co.nz --- Comment #6 from Chris Cormack ch...@bigballofwax.co.nz --- First option seems fine by me, as does a simple clean Z39.50 search results button. -- You are receiving this mail because: You are the QA Contact for the bug. You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 1084] would be nice to remove records from breeding tables.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=1084 Paul Poulain paul.poul...@biblibre.com changed: What|Removed |Added Status|NEW |RESOLVED Resolution||FIXED --- Comment #1 from Paul Poulain paul.poul...@biblibre.com 2011-08-02 10:12:44 UTC --- already done (checked in 3.4) -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the QA Contact for the bug. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 1084] would be nice to remove records from breeding tables.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=1084 --- Comment #2 from Katrin Fischer katrin.fisc...@bsz-bw.de 2011-08-02 10:34:48 UTC --- How is it done in 3.4? Is there a way to delete unused records from the breeding tables? -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the QA Contact for the bug. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 1084] would be nice to remove records from breeding tables.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=1084 --- Comment #3 from Paul Poulain paul.poul...@biblibre.com 2011-08-02 11:07:07 UTC --- when you've imported datas in your catalogue, you've a clean link to remove the content of this import -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the QA Contact for the bug. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 1084] would be nice to remove records from breeding tables.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=1084 --- Comment #4 from Katrin Fischer katrin.fisc...@bsz-bw.de 2011-08-02 11:23:07 UTC --- Yes, but by searching Z39.50 targets I thought more than the downloaded record was added to the breeding tables? I see no way to delete those at the moment. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the QA Contact for the bug. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 1084] would be nice to remove records from breeding tables.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=1084 Paul Poulain paul.poul...@biblibre.com changed: What|Removed |Added Status|RESOLVED|REOPENED Resolution|FIXED | --- Comment #5 from Paul Poulain paul.poul...@biblibre.com 2011-08-02 12:46:26 UTC --- well spotted Katrin. This could easily be achieved with the following SQL requests : DELETE FROM import_records WHERE import_batch_id IN (SELECT import_batches.import_batch_id FROM import_batches WHERE import_batches.batch_type =z3950) AND import_records.upload_timestamp= DATE_SUB(now(), INTERVAL 1 DAY); DELETE FROM import_batches WHERE import_batch_id NOT IN (SELECT DISTINCT import_batch_id from import_records); The 1st request deletes all z3950 entries that are older than one day (too much from far, but harmless) The 2nd request deletes the fake batch header that is generated on each z3950 query We can put those SQLs in 2 places: * on any z3950 search = before doing the new search, clean the database. Easy to setup, efficient, although a little loss of performances. I think this loss of performance is small compared to how long z3950 servers answer * add a script to cronjob, that cleans every night. A little bit harder to write, and has to be setup during installation, which put some pain to the sysadmin. I prefer the 1st option, let me know which one you prefer. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the QA Contact for the bug. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/