[Koha-bugs] [Bug 7240] New: Cleaning up import tables and action_log

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7240

             Bug #: 7240
           Summary: Cleaning up import tables and action_log
    Classification: Unclassified
 Change sponsored?: ---
           Product: Koha
           Version: master
          Platform: All
        OS/Version: All
            Status: NEW
          Severity: enhancement
          Priority: P5 - low
         Component: Command-line Utilities
        AssignedTo: gmcharlt at gmail.com
        ReportedBy: m.de.rooy at rijksmuseum.nl
         QAContact: ian.walls at bywatersolutions.com


I already asked on dev list:
> Is anyone of you using code to periodically purge records from 
> import_records, import_biblios, import_batches and/or action_logs ?
> 
> If so, would it be an idea to include such code into 
> cleanup_database.pl in misc/cronjobs ?

Response of Paul on dev list:
+1 Sounds a very good idea. We have already made a dirty mysql "truncate xxx"
on some setups IIRC. Would be better to have it in cleanup_database.

I also agree it should be driven by a parameter, like the number in days to
keep/clean. Something like cleanup_database --import 90 --action_logs 180 (90
days for import_* tables and 180 for action logs in this example)

And if no parameter are given, either do nothing or remove after a default
duration (30 for import ? 90 for action_logs ?)


Will be sending a proposed patch.

-- 
Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are watching all bug changes.