From 385e11f950a1f91aecc109e0a057036409f1ed07 Mon Sep 17 00:00:00 2001 From: Victor Grousset/tuxayo Date: Tue, 17 Nov 2020 13:37:48 +0100 Subject: [PATCH] Bug 18050: DBIC Signed-off-by: Victor Grousset/tuxayo --- Koha/Schema/Result/Aqbudget.pm | 27 ++++++++++++++++++++++++--- Koha/Schema/Result/Aqbudgetperiod.pm | 21 +++++++++++++++++++-- 2 files changed, 43 insertions(+), 5 deletions(-) diff --git a/Koha/Schema/Result/Aqbudget.pm b/Koha/Schema/Result/Aqbudget.pm index 1cdb64c31d..612b4bc047 100644 --- a/Koha/Schema/Result/Aqbudget.pm +++ b/Koha/Schema/Result/Aqbudget.pm @@ -88,6 +88,7 @@ __PACKAGE__->table("aqbudgets"); =head2 budget_period_id data_type: 'integer' + is_foreign_key: 1 is_nullable: 1 =head2 sort1_authcat @@ -157,7 +158,7 @@ __PACKAGE__->add_columns( is_nullable => 0, }, "budget_period_id", - { data_type => "integer", is_nullable => 1 }, + { data_type => "integer", is_foreign_key => 1, is_nullable => 1 }, "sort1_authcat", { data_type => "varchar", is_nullable => 1, size => 80 }, "sort2_authcat", @@ -257,6 +258,26 @@ __PACKAGE__->has_many( { cascade_copy => 0, cascade_delete => 0 }, ); +=head2 budget_period + +Type: belongs_to + +Related object: L + +=cut + +__PACKAGE__->belongs_to( + "budget_period", + "Koha::Schema::Result::Aqbudgetperiod", + { budget_period_id => "budget_period_id" }, + { + is_deferrable => 1, + join_type => "LEFT", + on_delete => "CASCADE", + on_update => "CASCADE", + }, +); + =head2 suggestions Type: has_many @@ -298,8 +319,8 @@ Composing rels: L -> borrowernumber __PACKAGE__->many_to_many("borrowernumbers", "aqbudgetborrowers", "borrowernumber"); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-07-16 13:50:45 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:zB7ox8a4KdDGq5fsbQfLGQ +# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-11-17 12:22:27 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:unur5fA8ERmVpNrqQonzMw # You can replace this text with custom content, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/Aqbudgetperiod.pm b/Koha/Schema/Result/Aqbudgetperiod.pm index 1d76ec00d9..2084cee3d9 100644 --- a/Koha/Schema/Result/Aqbudgetperiod.pm +++ b/Koha/Schema/Result/Aqbudgetperiod.pm @@ -110,9 +110,26 @@ __PACKAGE__->add_columns( __PACKAGE__->set_primary_key("budget_period_id"); +=head1 RELATIONS -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:M13qdhmXgKilais2IFkXFw +=head2 aqbudgets + +Type: has_many + +Related object: L + +=cut + +__PACKAGE__->has_many( + "aqbudgets", + "Koha::Schema::Result::Aqbudget", + { "foreign.budget_period_id" => "self.budget_period_id" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + + +# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-11-17 12:22:27 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ZGB3UE086op5QfScg9l2TQ # You can replace this text with custom content, and it will be preserved on regeneration -- 2.39.5