[Koha-bugs] [Bug 30069] Add edifact_messages to cleanup_database.pl

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Thu Mar 2 14:00:05 CET 2023


https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30069

Kyle M Hall <kyle at bywatersolutions.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
 Attachment #146976|0                           |1
        is obsolete|                            |
 Attachment #146977|0                           |1
        is obsolete|                            |
 Attachment #147564|0                           |1
        is obsolete|                            |

--- Comment #10 from Kyle M Hall <kyle at bywatersolutions.com> ---
Created attachment 147606
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=147606&action=edit
Bug 30069: Add edifact-messages to cleanup_database.pl

This patch allows users to clear out old edifact_messages using the
cleanup_database script. The number of days can either be set in the CLI or the
default value of 365 can be used.

Test plan:
1) Ensure you have some EDI orders or even just some dummy messages in the
edifact_messages table
2) Run perl misc/cronjobs/cleanup_database.pl --edifact-messages 100 --verbose
(Change the number of days according to the data in your table)
3) The response should show a number of messages that would have been deleted
4) Run perl misc/cronjobs/cleanup_database.pl --edifact-messages 100 --verbose
--confirm
5) The response should now show the same number of messages have been deleted
6) Check your edifact_messages table to confirm that the data has been deleted

Sponsored-by: PTFS Europe
Signed-off-by: Katrin Fischer <katrin.fischer.83 at web.de>

Signed-off-by: Kyle M Hall <kyle at bywatersolutions.com>

-- 
You are receiving this mail because:
You are watching all bug changes.


More information about the Koha-bugs mailing list