Bugzilla – Attachment 147608 Details for
Bug 30069
Add edifact_messages to cleanup_database.pl
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 30069: (QA follow-up) Rebase and add filter
Bug-30069-QA-follow-up-Rebase-and-add-filter.patch (text/plain), 1.67 KB, created by
Kyle M Hall (khall)
on 2023-03-02 13:00:15 UTC
(
hide
)
Description:
Bug 30069: (QA follow-up) Rebase and add filter
Filename:
MIME Type:
Creator:
Kyle M Hall (khall)
Created:
2023-03-02 13:00:15 UTC
Size:
1.67 KB
patch
obsolete
>From 81c35da4c39a96939940988fbd7f661667b448e0 Mon Sep 17 00:00:00 2001 >From: Matt Blenkinsop <matt.blenkinsop@ptfs-europe.com> >Date: Wed, 1 Mar 2023 15:13:48 +0000 >Subject: [PATCH] Bug 30069: (QA follow-up) Rebase and add filter > >This patch now checks the status of messages and ignores any message >with a status of 'new'. It is also rebased to account for changes made >to cleanup_database.pl in bug 17350. > >Test plan: >1) Ensure you have some EDI orders or even just some dummy messages in the edifact_messages table with a mixture of statuses including 'new' >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 >7) Confirm that no messages marked 'new' have been deleted > >Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> >--- > misc/cronjobs/cleanup_database.pl | 1 + > 1 file changed, 1 insertion(+) > >diff --git a/misc/cronjobs/cleanup_database.pl b/misc/cronjobs/cleanup_database.pl >index c1a6614bcc..b1a4e53539 100755 >--- a/misc/cronjobs/cleanup_database.pl >+++ b/misc/cronjobs/cleanup_database.pl >@@ -902,6 +902,7 @@ sub PurgeEdifactMessages { > SELECT id > FROM edifact_messages > WHERE transfer_date < date_sub(curdate(), INTERVAL ? DAY) >+ AND status != 'new'; > } > ); > $sth->execute($days) or die $dbh->errstr; >-- >2.30.2
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 30069
:
146690
|
146694
|
146976
|
146977
|
147564
|
147606
|
147607
| 147608 |
147609