Bugzilla – Attachment 192047 Details for
Bug 41182
SUSHI harvest should send a full date
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 41182: Database changes
Bug-41182-Database-changes.patch (text/plain), 2.82 KB, created by
Nick Clemens (kidclamp)
on 2026-01-26 17:02:01 UTC
(
hide
)
Description:
Bug 41182: Database changes
Filename:
MIME Type:
Creator:
Nick Clemens (kidclamp)
Created:
2026-01-26 17:02:01 UTC
Size:
2.82 KB
patch
obsolete
>From 5608146f8d9391e3961bbedf9fb79f41346eff22 Mon Sep 17 00:00:00 2001 >From: Nick Clemens <nick@bywatersolutions.com> >Date: Mon, 26 Jan 2026 16:10:45 +0000 >Subject: [PATCH] Bug 41182: Database changes > >--- > .../definitions/erm_usage_data_provider.yaml | 9 ++++++++ > .../data/mysql/atomicupdate/bug_41182.pl | 22 +++++++++++++++++++ > installer/data/mysql/kohastructure.sql | 1 + > 3 files changed, 32 insertions(+) > create mode 100755 installer/data/mysql/atomicupdate/bug_41182.pl > >diff --git a/api/v1/swagger/definitions/erm_usage_data_provider.yaml b/api/v1/swagger/definitions/erm_usage_data_provider.yaml >index ed6bdfe5700..18de380f71f 100644 >--- a/api/v1/swagger/definitions/erm_usage_data_provider.yaml >+++ b/api/v1/swagger/definitions/erm_usage_data_provider.yaml >@@ -68,6 +68,15 @@ properties: > type: > - string > - "null" >+ dateformat: >+ description: date format of the harvester >+ type: >+ - string >+ - "null" >+ enum: >+ - yyyy-mm >+ - yyyy-mm-dd >+ - null > report_types: > description: report types of the harvester > type: >diff --git a/installer/data/mysql/atomicupdate/bug_41182.pl b/installer/data/mysql/atomicupdate/bug_41182.pl >new file mode 100755 >index 00000000000..5924e82b56e >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/bug_41182.pl >@@ -0,0 +1,22 @@ >+use Modern::Perl; >+use Koha::Installer::Output qw(say_warning say_success say_info); >+ >+return { >+ bug_number => "41182", >+ description => "Add dateformat to ERM data providers", >+ up => sub { >+ my ($args) = @_; >+ my ( $dbh, $out ) = @$args{qw(dbh out)}; >+ >+ unless ( column_exists( 'erm_usage_data_providers', 'dateformat' ) ) { >+ $dbh->do( >+ q{ >+ ALTER TABLE erm_usage_data_providers >+ ADD COLUMN `dateformat` enum('yyyy-mm','yyyy-mm-dd') COLLATE utf8mb4_unicode_ci DEFAULT 'yyyy-mm' COMMENT 'dateformat' AFTER `requestor_email` >+ } >+ ); >+ say $out "Added column 'erm_usage_data_providers.dateformat'"; >+ >+ } >+ }, >+}; >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index 733015e6e22..3f69b140c0a 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -3275,6 +3275,7 @@ CREATE TABLE `erm_usage_data_providers` ( > `api_key` text DEFAULT NULL COMMENT 'SUSHI API key', > `requestor_name` varchar(80) DEFAULT NULL COMMENT 'requestor name', > `requestor_email` varchar(80) DEFAULT NULL COMMENT 'requestor email', >+ `dateformat` enum('yyyy-mm','yyyy-mm-dd') DEFAULT 'yyyy-mm' COMMENT 'dateformat', > `report_types` varchar(255) DEFAULT NULL COMMENT 'report types provided by the harvester', > `service_platform` varchar(80) DEFAULT NULL COMMENT 'platform if provider requires it', > PRIMARY KEY (`erm_usage_data_provider_id`) >-- >2.39.5
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 41182
:
189044
|
190713
|
192041
|
192042
|
192043
|
192044
|
192045
|
192046
| 192047 |
192048
|
192049
|
192050