Attachment 71428 Details for Bug 20144 – Bug 20144: [sql_modes] Shorten aqbudgets.budget_code

[patch] Bug 20144: [sql_modes] Shorten aqbudgets.budget_code

Bug-20144-sqlmodes-Shorten-aqbudgetsbudgetcode.patch (text/plain), 4.35 KB, created by Julian Maurice on 2018-02-12 10:25:48 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Julian Maurice

Created: 2018-02-12 10:25:48 UTC

Size: 4.35 KB

patch

obsolete

>From 04f92c678024c10a07e6e015c587032db67fbbbf Mon Sep 17 00:00:00 2001
>From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
>Date: Mon, 5 Feb 2018 17:31:34 -0300
>Subject: [PATCH] Bug 20144: [sql_modes] Shorten aqbudgets.budget_code
>
>Fix for:
>Data too long for column 'budget_code'
>
>Signed-off-by: Josef Moravec <josef.moravec@gmail.com>
>Signed-off-by: Julian Maurice <julian.maurice@biblibre.com>
>---
> t/db_dependent/Acquisition.t                             | 4 ++--
> t/db_dependent/Acquisition/GetBasketsInfosByBookseller.t | 4 ++--
> t/db_dependent/Acquisition/GetOrdersByBiblionumber.t     | 4 ++--
> t/db_dependent/Acquisition/Invoices.t                    | 4 ++--
> t/db_dependent/Acquisition/NewOrder.t                    | 4 ++--
> t/db_dependent/Acquisition/OrderUsers.t                  | 4 ++--
> 6 files changed, 12 insertions(+), 12 deletions(-)
>
>diff --git a/t/db_dependent/Acquisition.t b/t/db_dependent/Acquisition.t
>index 62a9a76b5a..0475872fb9 100755
>--- a/t/db_dependent/Acquisition.t
>+++ b/t/db_dependent/Acquisition.t
>@@ -154,8 +154,8 @@ my $bpid=AddBudgetPeriod({
> 
> my $budgetid = C4::Budgets::AddBudget(
>     {
>-        budget_code => "budget_code_test_getordersbybib",
>-        budget_name => "budget_name_test_getordersbybib",
>+        budget_code => "budget_code_test_1",
>+        budget_name => "budget_name_test_1",
>         budget_period_id => $bpid,
>     }
> );
>diff --git a/t/db_dependent/Acquisition/GetBasketsInfosByBookseller.t b/t/db_dependent/Acquisition/GetBasketsInfosByBookseller.t
>index 84ac14add9..20bcb0b59f 100644
>--- a/t/db_dependent/Acquisition/GetBasketsInfosByBookseller.t
>+++ b/t/db_dependent/Acquisition/GetBasketsInfosByBookseller.t
>@@ -33,8 +33,8 @@ ok($basketno = NewBasket($supplierid, 1), 'NewBasket(  $supplierid , 1  ) return
> 
> my $budgetid = C4::Budgets::AddBudget(
>     {
>-        budget_code => 'budget_code_test_getordersbybib',
>-        budget_name => 'budget_name_test_getordersbybib',
>+        budget_code => 'budget_code_test_1',
>+        budget_name => 'budget_name_test_1',
>     }
> );
> my $budget = C4::Budgets::GetBudget( $budgetid );
>diff --git a/t/db_dependent/Acquisition/GetOrdersByBiblionumber.t b/t/db_dependent/Acquisition/GetOrdersByBiblionumber.t
>index d01aeff3c2..b622ced624 100644
>--- a/t/db_dependent/Acquisition/GetOrdersByBiblionumber.t
>+++ b/t/db_dependent/Acquisition/GetOrdersByBiblionumber.t
>@@ -32,8 +32,8 @@ my $basketno = C4::Acquisition::NewBasket(
> 
> my $budgetid = C4::Budgets::AddBudget(
>     {
>-        budget_code => "budget_code_test_getordersbybib",
>-        budget_name => "budget_name_test_getordersbybib",
>+        budget_code => "budget_code_test",
>+        budget_name => "budget_name_test",
>     }
> );
> 
>diff --git a/t/db_dependent/Acquisition/Invoices.t b/t/db_dependent/Acquisition/Invoices.t
>index c30898465a..b472ce7d16 100644
>--- a/t/db_dependent/Acquisition/Invoices.t
>+++ b/t/db_dependent/Acquisition/Invoices.t
>@@ -37,8 +37,8 @@ my $basket   = GetBasket($basketno);
> 
> my $budgetid = C4::Budgets::AddBudget(
>     {
>-        budget_code => "budget_code_test_getordersbybib",
>-        budget_name => "budget_name_test_getordersbybib",
>+        budget_code => "budget_code_test",
>+        budget_name => "budget_name_test",
>     }
> );
> my $budget = C4::Budgets::GetBudget( $budgetid );
>diff --git a/t/db_dependent/Acquisition/NewOrder.t b/t/db_dependent/Acquisition/NewOrder.t
>index cee35f7353..b327a8d878 100644
>--- a/t/db_dependent/Acquisition/NewOrder.t
>+++ b/t/db_dependent/Acquisition/NewOrder.t
>@@ -32,8 +32,8 @@ my $basketno = C4::Acquisition::NewBasket(
> 
> my $budgetid = C4::Budgets::AddBudget(
>     {
>-        budget_code => "budget_code_test_getordersbybib",
>-        budget_name => "budget_name_test_getordersbybib",
>+        budget_code => "budget_code_test",
>+        budget_name => "budget_name_test",
>     }
> );
> 
>diff --git a/t/db_dependent/Acquisition/OrderUsers.t b/t/db_dependent/Acquisition/OrderUsers.t
>index 2581edc60c..5b142f75b4 100644
>--- a/t/db_dependent/Acquisition/OrderUsers.t
>+++ b/t/db_dependent/Acquisition/OrderUsers.t
>@@ -34,8 +34,8 @@ my $basketno = NewBasket( $bookseller->id, 1 );
> 
> my $budgetid = C4::Budgets::AddBudget(
>     {
>-        budget_code => "budget_code_test_getordersbybib",
>-        budget_name => "budget_name_test_getordersbybib",
>+        budget_code => "budget_code_test",
>+        budget_name => "budget_name_test",
>     }
> );
> my $budget = C4::Budgets::GetBudget($budgetid);
>-- 
>2.14.2

Actions: View | Diff | Splinter Review

Attachments on bug 20144: 71410 | 71411 | 71412 | 71413 | 71414 | 71415 | 71416 | 71417 | 71418 | 71419 | 71420 | 71421 | 71422 | 71423 | 71424 | 71425 | 71427 | 71428 | 71429 | 71430 | 71431 | 71432 | 71434 | 71435 | 71436 | 71437 | 71438 | 71440 | 71441 | 71442 | 71443 | 71444 | 71445 | 71446 | 71447 | 71448 | 71449 | 71450 | 71451 | 71452 | 71453 | 71454 | 71455 | 71456 | 71457 | 71458 | 71459 | 71460 | 71461 | 71462 | 71463 | 71467 | 71564