Attachment 101751 Details for Bug 24860 – Bug 24860: Update existing Schema files [DO NOT PUSH]

[patch] Bug 24860: Update existing Schema files [DO NOT PUSH]

Bug-24860-Update-existing-Schema-files-DO-NOT-PUSH.patch (text/plain), 4.69 KB, created by Kyle M Hall (khall) on 2020-03-25 18:00:48 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Kyle M Hall (khall)

Created: 2020-03-25 18:00:48 UTC

Size: 4.69 KB

patch

obsolete

>From 8474c8997af542cf83f8e68dd0d70068e94d1793 Mon Sep 17 00:00:00 2001
>From: Kyle M Hall <kyle@bywatersolutions.com>
>Date: Wed, 25 Mar 2020 13:59:43 -0400
>Subject: [PATCH] Bug 24860: Update existing Schema files [DO NOT PUSH]
>
>---
> Koha/Schema/Result/OldReserve.pm | 32 ++++++++++++++++++++++++++++--
> Koha/Schema/Result/Reserve.pm    | 32 ++++++++++++++++++++++++++++--
> Koha/Schema/Result/Volume.pm     | 34 ++++++++++++++++++++++++++++++--
> 3 files changed, 92 insertions(+), 6 deletions(-)
>
>diff --git a/Koha/Schema/Result/OldReserve.pm b/Koha/Schema/Result/OldReserve.pm
>index 85e604d288..8e19252d62 100644
>--- a/Koha/Schema/Result/OldReserve.pm
>+++ b/Koha/Schema/Result/OldReserve.pm
>@@ -46,6 +46,12 @@ __PACKAGE__->table("old_reserves");
>   is_foreign_key: 1
>   is_nullable: 1
> 
>+=head2 volume_id
>+
>+  data_type: 'integer'
>+  is_foreign_key: 1
>+  is_nullable: 1
>+
> =head2 branchcode
> 
>   data_type: 'varchar'
>@@ -155,6 +161,8 @@ __PACKAGE__->add_columns(
>   { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
>   "biblionumber",
>   { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
>+  "volume_id",
>+  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
>   "branchcode",
>   { data_type => "varchar", is_nullable => 1, size => 10 },
>   "notificationdate",
>@@ -297,9 +305,29 @@ __PACKAGE__->belongs_to(
>   },
> );
> 
>+=head2 volume
>+
>+Type: belongs_to
>+
>+Related object: L<Koha::Schema::Result::Volume>
>+
>+=cut
>+
>+__PACKAGE__->belongs_to(
>+  "volume",
>+  "Koha::Schema::Result::Volume",
>+  { id => "volume_id" },
>+  {
>+    is_deferrable => 1,
>+    join_type     => "LEFT",
>+    on_delete     => "SET NULL",
>+    on_update     => "SET NULL",
>+  },
>+);
>+
> 
>-# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-03-18 12:43:15
>-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:4vMUC/1kSr3vgQ7n0Pmuug
>+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-03-25 17:26:16
>+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:hOQW/9nUtYONepwVA5At7A
> 
> sub koha_object_class {
>     'Koha::Old::Hold';
>diff --git a/Koha/Schema/Result/Reserve.pm b/Koha/Schema/Result/Reserve.pm
>index c5460e34da..72e6309d25 100644
>--- a/Koha/Schema/Result/Reserve.pm
>+++ b/Koha/Schema/Result/Reserve.pm
>@@ -49,6 +49,12 @@ __PACKAGE__->table("reserves");
>   is_foreign_key: 1
>   is_nullable: 0
> 
>+=head2 volume_id
>+
>+  data_type: 'integer'
>+  is_foreign_key: 1
>+  is_nullable: 1
>+
> =head2 branchcode
> 
>   data_type: 'varchar'
>@@ -169,6 +175,8 @@ __PACKAGE__->add_columns(
>     is_foreign_key => 1,
>     is_nullable    => 0,
>   },
>+  "volume_id",
>+  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
>   "branchcode",
>   { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 },
>   "notificationdate",
>@@ -336,9 +344,29 @@ __PACKAGE__->belongs_to(
>   },
> );
> 
>+=head2 volume
>+
>+Type: belongs_to
>+
>+Related object: L<Koha::Schema::Result::Volume>
>+
>+=cut
>+
>+__PACKAGE__->belongs_to(
>+  "volume",
>+  "Koha::Schema::Result::Volume",
>+  { id => "volume_id" },
>+  {
>+    is_deferrable => 1,
>+    join_type     => "LEFT",
>+    on_delete     => "SET NULL",
>+    on_update     => "CASCADE",
>+  },
>+);
>+
> 
>-# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-03-18 12:43:15
>-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:VH7h5kYo9WhlGobXb3N3Jg
>+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-03-25 17:26:16
>+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ON4vsC/m5XAuZRyhwaILfg
> 
> __PACKAGE__->belongs_to(
>   "item",
>diff --git a/Koha/Schema/Result/Volume.pm b/Koha/Schema/Result/Volume.pm
>index 4551df3fdd..6444b39410 100644
>--- a/Koha/Schema/Result/Volume.pm
>+++ b/Koha/Schema/Result/Volume.pm
>@@ -120,6 +120,36 @@ __PACKAGE__->belongs_to(
>   { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
> );
> 
>+=head2 old_reserves
>+
>+Type: has_many
>+
>+Related object: L<Koha::Schema::Result::OldReserve>
>+
>+=cut
>+
>+__PACKAGE__->has_many(
>+  "old_reserves",
>+  "Koha::Schema::Result::OldReserve",
>+  { "foreign.volume_id" => "self.id" },
>+  { cascade_copy => 0, cascade_delete => 0 },
>+);
>+
>+=head2 reserves
>+
>+Type: has_many
>+
>+Related object: L<Koha::Schema::Result::Reserve>
>+
>+=cut
>+
>+__PACKAGE__->has_many(
>+  "reserves",
>+  "Koha::Schema::Result::Reserve",
>+  { "foreign.volume_id" => "self.id" },
>+  { cascade_copy => 0, cascade_delete => 0 },
>+);
>+
> =head2 volume_items
> 
> Type: has_many
>@@ -136,8 +166,8 @@ __PACKAGE__->has_many(
> );
> 
> 
>-# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-03-24 19:00:04
>-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:9GITIIWcoQQZqxR09g7NRA
>+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-03-25 17:26:16
>+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:mZvtYuy7RQ4GnakdjMnQ2A
> 
> sub koha_objects_class {
>     'Koha::Biblio::Volumes';
>-- 
>2.21.1 (Apple Git-122.3)

Actions: View | Diff | Splinter Review

Attachments on bug 24860: 100644 | 100645 | 100646 | 100647 | 100648 | 100649 | 100650 | 100651 | 101744 | 101745 | 101746 | 101747 | 101748 | 101749 | 101750 | 101751 | 101827 | 101828 | 101829 | 101830 | 101831 | 101832 | 101833 | 101834 | 101835 | 102230 | 102231 | 102232 | 102233 | 102234 | 102235 | 102236 | 102237 | 102238 | 102239 | 102240 | 102241 | 102242 | 102243 | 102244 | 102245 | 102246 | 102247 | 106589 | 106590 | 106591 | 106592 | 106593 | 106594 | 106595 | 106596 | 106597 | 106682 | 106683 | 106684 | 106685 | 106686 | 106687 | 106688 | 106689 | 106690 | 106742 | 106743 | 106744 | 106745 | 106746 | 106747 | 106748 | 106749 | 106750 | 108458 | 108459 | 108460 | 108461 | 108462 | 108463 | 108464 | 108465 | 108466 | 109097 | 109098 | 109099 | 109100 | 109101 | 109102 | 109103 | 109104 | 109105 | 109171 | 109172 | 109173 | 109174 | 109175 | 109176 | 109177 | 109178 | 109179 | 113616 | 113617 | 113618 | 113619 | 113620 | 113621 | 113622 | 113623 | 113624 | 135922 | 135923 | 135924 | 135925 | 135926 | 135927 | 135928 | 135929 | 135930 | 138221 | 138222 | 138224 | 138225 | 138226 | 138227 | 138228 | 138229 | 138230 | 141214 | 141215 | 141735 | 141736 | 141737 | 141738 | 141739 | 141740 | 141741 | 141742 | 141743 | 141744 | 141745 | 141746 | 141747 | 141748 | 141749 | 141750 | 142413 | 142414 | 142415 | 142416 | 142417 | 142418 | 142419 | 142420 | 142421 | 142422 | 142423 | 142424 | 142425 | 142426 | 142427 | 142428 | 142429 | 142430 | 142827 | 142955 | 142956 | 142957 | 142958 | 142959 | 142960 | 142961 | 142962 | 142963 | 142964 | 142965 | 142966 | 142967 | 142968 | 142969 | 142970 | 142971 | 142972 | 142973 | 142974 | 142975 | 142992 | 142993 | 142994 | 142995 | 142996 | 142997 | 142998 | 142999 | 143000 | 143001 | 143002 | 143003 | 143004 | 143005 | 143006 | 143007 | 143008 | 143009 | 143010 | 143011