Attachment 136786 Details for Bug 30889 – Bug 30889: (follow-up) Add context field to background_jobs

[patch] Bug 30889: (follow-up) Add context field to background_jobs

Bug-30889-follow-up-Add-context-field-to-backgroun.patch (text/plain), 2.07 KB, created by Tomás Cohen Arazi (tcohen) on 2022-06-30 14:57:05 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Tomás Cohen Arazi (tcohen)

Created: 2022-06-30 14:57:05 UTC

Size: 2.07 KB

patch

obsolete

>From eceea1bb3a1cd124ea423122f40a1157c97bf626 Mon Sep 17 00:00:00 2001
>From: Martin Renvoize <martin.renvoize@ptfs-europe.com>
>Date: Fri, 10 Jun 2022 14:06:22 +0100
>Subject: [PATCH] Bug 30889: (follow-up) Add context field to background_jobs
>
>This patch adds a new 'context' field to the background_jobs table to
>record the context in which the job was queued.
>
>Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
>Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
>---
> installer/data/mysql/atomicupdate/bug_30889.pl | 15 +++++++++++++++
> installer/data/mysql/kohastructure.sql         |  1 +
> 2 files changed, 16 insertions(+)
> create mode 100644 installer/data/mysql/atomicupdate/bug_30889.pl
>
>diff --git a/installer/data/mysql/atomicupdate/bug_30889.pl b/installer/data/mysql/atomicupdate/bug_30889.pl
>new file mode 100644
>index 0000000000..d58a352f9c
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/bug_30889.pl
>@@ -0,0 +1,15 @@
>+use Modern::Perl;
>+
>+return {
>+    bug_number => "30889",
>+    description => "Add context to background_jobs",
>+    up => sub {
>+        my ($args) = @_;
>+        my ($dbh, $out) = @$args{qw(dbh out)};
>+
>+        unless( column_exists( 'background_jobs', 'context') ) {
>+            $dbh->do(q{ ALTER TABLE background_jobs ADD `context` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL AFTER `data` });
>+            say $out "field added";
>+        }
>+    },
>+};
>diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
>index 0d009afe59..eee3fe4a8f 100644
>--- a/installer/data/mysql/kohastructure.sql
>+++ b/installer/data/mysql/kohastructure.sql
>@@ -984,6 +984,7 @@ CREATE TABLE `background_jobs` (
>   `type` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
>   `queue` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'default' COMMENT 'Name of the queue the job is sent to',
>   `data` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
>+  `context` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
>   `enqueued_on` datetime DEFAULT NULL,
>   `started_on` datetime DEFAULT NULL,
>   `ended_on` datetime DEFAULT NULL,
>-- 
>2.34.1

Actions: View | Diff | Splinter Review

Attachments on bug 30889: 135759 | 135760 | 135932 | 135933 | 135934 | 135935 | 135936 | 136294 | 136295 | 136296 | 136297 | 136298 | 136299 | 136375 | 136376 | 136784 | 136785 | 136786 | 136787 | 136788 | 136789 | 136790 | 136791 | 136792 | 136904 | 136948