Attachment 92742 Details for Bug 15497 – Bug 15497: Modify schemas

[patch] Bug 15497: Modify schemas

Bug-15497-Modify-schemas.patch (text/plain), 4.71 KB, created by Martin Renvoize (ashimema) on 2019-09-12 15:28:59 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Martin Renvoize (ashimema)

Created: 2019-09-12 15:28:59 UTC

Size: 4.71 KB

patch

obsolete

>From 517279023a33d2803c0566ff0580fb99b1abb441 Mon Sep 17 00:00:00 2001
>From: Martin Renvoize <martin.renvoize@ptfs-europe.com>
>Date: Thu, 12 Sep 2019 16:26:32 +0100
>Subject: [PATCH] Bug 15497: Modify schemas
>
>Sponsored-by: Northeast Kansas Library System
>Sponsored-by: Southeast Kansas Library System
>Sponsored-by: Central Kansas Library System
>Signed-off-by: Jessica Zairo <jzairo@bywatersolutions.com>
>Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
>Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
>---
> Koha/Schema/Result/Branch.pm          | 19 +++++-
> Koha/Schema/Result/Itemtype.pm        | 19 +++++-
> Koha/Schema/Result/ItemtypesBranch.pm | 87 +++++++++++++++++++++++++++
> 3 files changed, 121 insertions(+), 4 deletions(-)
> create mode 100644 Koha/Schema/Result/ItemtypesBranch.pm
>
>diff --git a/Koha/Schema/Result/Branch.pm b/Koha/Schema/Result/Branch.pm
>index b500147ea4..bf8f6d8efc 100644
>--- a/Koha/Schema/Result/Branch.pm
>+++ b/Koha/Schema/Result/Branch.pm
>@@ -541,6 +541,21 @@ __PACKAGE__->has_many(
>   { cascade_copy => 0, cascade_delete => 0 },
> );
> 
>+=head2 itemtypes_branches
>+
>+Type: has_many
>+
>+Related object: L<Koha::Schema::Result::ItemtypesBranch>
>+
>+=cut
>+
>+__PACKAGE__->has_many(
>+  "itemtypes_branches",
>+  "Koha::Schema::Result::ItemtypesBranch",
>+  { "foreign.branchcode" => "self.branchcode" },
>+  { cascade_copy => 0, cascade_delete => 0 },
>+);
>+
> =head2 library_groups
> 
> Type: has_many
>@@ -647,8 +662,8 @@ __PACKAGE__->has_many(
> );
> 
> 
>-# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-04-29 15:02:52
>-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:y+tNq5YiUeUOyAwB4r6GHw
>+# Created by DBIx::Class::Schema::Loader v0.07048 @ 2019-07-04 04:56:47
>+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:15/s0/8d2cNB9YLLlsEY4w
> 
> __PACKAGE__->add_columns(
>     '+pickup_location' => { is_boolean => 1 }
>diff --git a/Koha/Schema/Result/Itemtype.pm b/Koha/Schema/Result/Itemtype.pm
>index f7f4fe1bf6..073c527b7b 100644
>--- a/Koha/Schema/Result/Itemtype.pm
>+++ b/Koha/Schema/Result/Itemtype.pm
>@@ -181,6 +181,21 @@ __PACKAGE__->has_many(
>   { cascade_copy => 0, cascade_delete => 0 },
> );
> 
>+=head2 itemtypes_branches
>+
>+Type: has_many
>+
>+Related object: L<Koha::Schema::Result::ItemtypesBranch>
>+
>+=cut
>+
>+__PACKAGE__->has_many(
>+  "itemtypes_branches",
>+  "Koha::Schema::Result::ItemtypesBranch",
>+  { "foreign.itemtype" => "self.itemtype" },
>+  { cascade_copy => 0, cascade_delete => 0 },
>+);
>+
> =head2 old_reserves
> 
> Type: has_many
>@@ -212,8 +227,8 @@ __PACKAGE__->has_many(
> );
> 
> 
>-# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-04-29 15:02:52
>-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:X7Py35p8kotheBvJjuwDcA
>+# Created by DBIx::Class::Schema::Loader v0.07048 @ 2019-07-04 04:56:48
>+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Qo6jabJSQGeYJ542ebSJfg
> 
> # Use the ItemtypeLocalization view to create the join on localization
> our $LANGUAGE;
>diff --git a/Koha/Schema/Result/ItemtypesBranch.pm b/Koha/Schema/Result/ItemtypesBranch.pm
>new file mode 100644
>index 0000000000..9c54614440
>--- /dev/null
>+++ b/Koha/Schema/Result/ItemtypesBranch.pm
>@@ -0,0 +1,87 @@
>+use utf8;
>+package Koha::Schema::Result::ItemtypesBranch;
>+
>+# Created by DBIx::Class::Schema::Loader
>+# DO NOT MODIFY THE FIRST PART OF THIS FILE
>+
>+=head1 NAME
>+
>+Koha::Schema::Result::ItemtypesBranch
>+
>+=cut
>+
>+use strict;
>+use warnings;
>+
>+use base 'DBIx::Class::Core';
>+
>+=head1 TABLE: C<itemtypes_branches>
>+
>+=cut
>+
>+__PACKAGE__->table("itemtypes_branches");
>+
>+=head1 ACCESSORS
>+
>+=head2 itemtype
>+
>+  data_type: 'varchar'
>+  is_foreign_key: 1
>+  is_nullable: 0
>+  size: 10
>+
>+=head2 branchcode
>+
>+  data_type: 'varchar'
>+  is_foreign_key: 1
>+  is_nullable: 0
>+  size: 10
>+
>+=cut
>+
>+__PACKAGE__->add_columns(
>+  "itemtype",
>+  { data_type => "varchar", is_foreign_key => 1, is_nullable => 0, size => 10 },
>+  "branchcode",
>+  { data_type => "varchar", is_foreign_key => 1, is_nullable => 0, size => 10 },
>+);
>+
>+=head1 RELATIONS
>+
>+=head2 branchcode
>+
>+Type: belongs_to
>+
>+Related object: L<Koha::Schema::Result::Branch>
>+
>+=cut
>+
>+__PACKAGE__->belongs_to(
>+  "branchcode",
>+  "Koha::Schema::Result::Branch",
>+  { branchcode => "branchcode" },
>+  { is_deferrable => 1, on_delete => "CASCADE", on_update => "RESTRICT" },
>+);
>+
>+=head2 itemtype
>+
>+Type: belongs_to
>+
>+Related object: L<Koha::Schema::Result::Itemtype>
>+
>+=cut
>+
>+__PACKAGE__->belongs_to(
>+  "itemtype",
>+  "Koha::Schema::Result::Itemtype",
>+  { itemtype => "itemtype" },
>+  { is_deferrable => 1, on_delete => "CASCADE", on_update => "RESTRICT" },
>+);
>+
>+
>+# Created by DBIx::Class::Schema::Loader v0.07048 @ 2019-07-04 04:56:48
>+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:cBTswjKV8VWN1iueB+PygQ
>+
>+
>+# You can replace this text with custom code or comments, and it will be preserved on regeneration
>+1;
>-- 
>2.20.1

Actions: View | Diff | Splinter Review

Attachments on bug 15497: 91377 | 91378 | 91379 | 91446 | 91450 | 91451 | 91452 | 91469 | 92725 | 92726 | 92727 | 92728 | 92732 | 92735 | 92736 | 92737 | 92738 | 92739 | 92741 | 92742 | 92743 | 92744 | 92745