Attachment 117443 Details for Bug 27808 – Bug 27808: DB changes - adjust items.onloan when needed

[patch] Bug 27808: DB changes - adjust items.onloan when needed

Bug-27808-DB-changes---adjust-itemsonloan-when-nee.patch (text/plain), 1.02 KB, created by Jonathan Druart on 2021-03-01 12:35:47 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Jonathan Druart

Created: 2021-03-01 12:35:47 UTC

Size: 1.02 KB

patch

obsolete

>From b904f8aff07373f1c6353bc2318e1cc96c008df4 Mon Sep 17 00:00:00 2001
>From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
>Date: Mon, 1 Mar 2021 13:34:56 +0100
>Subject: [PATCH] Bug 27808: DB changes - adjust items.onloan when needed
>
>---
> installer/data/mysql/atomicupdate/bug_27808.perl | 12 ++++++++++++
> 1 file changed, 12 insertions(+)
> create mode 100644 installer/data/mysql/atomicupdate/bug_27808.perl
>
>diff --git a/installer/data/mysql/atomicupdate/bug_27808.perl b/installer/data/mysql/atomicupdate/bug_27808.perl
>new file mode 100644
>index 0000000000..0cf95a5158
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/bug_27808.perl
>@@ -0,0 +1,12 @@
>+$DBversion = 'XXX'; # will be replaced by the RM
>+if( CheckVersion( $DBversion ) ) {
>+
>+    $dbh->do(q|
>+        UPDATE items
>+        LEFT JOIN issues ON issues.itemnumber=items.itemnumber
>+        SET items.onloan=CAST(issues.date_due AS DATE)
>+        WHERE items.onloan IS NULL
>+    |);
>+
>+    NewVersion( $DBversion, 27808, "Adjust items.onloan if needed");
>+}
>-- 
>2.20.1

Actions: View | Diff | Splinter Review

Attachments on bug 27808: 117380 | 117381 | 117382 | 117384 | 117385 | 117386 | 117387 | 117398 | 117399 | 117400 | 117443 | 117445 | 117446 | 117454 | 117456