Attachment 175152 Details for Bug 38256 – Bug 38256: DBIC files

[patch] Bug 38256: DBIC files

Bug-38256-DBIC-files.patch (text/plain), 2.69 KB, created by Matt Blenkinsop on 2024-12-04 10:19:09 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Matt Blenkinsop

Created: 2024-12-04 10:19:09 UTC

Size: 2.69 KB

patch

obsolete

>From cdfcb527f9a768dd2e6f35a639d66e21e5aea081 Mon Sep 17 00:00:00 2001
>From: Matt Blenkinsop <matt.blenkinsop@ptfs-europe.com>
>Date: Thu, 24 Oct 2024 14:00:15 +0000
>Subject: [PATCH] Bug 38256: DBIC files
>
>(cherry picked from commit c3ce31be20b5e593b4793eb500ae1183d9773e8b)
>---
> Koha/Schema/Result/Aqbookseller.pm         | 15 ++++++++++
> Koha/Schema/Result/ErmUsageDataProvider.pm | 34 ++++++++++++++++++++--
> 2 files changed, 47 insertions(+), 2 deletions(-)
>
>diff --git a/Koha/Schema/Result/Aqbookseller.pm b/Koha/Schema/Result/Aqbookseller.pm
>index 8b52c7b92c8..4ee68a1f931 100644
>--- a/Koha/Schema/Result/Aqbookseller.pm
>+++ b/Koha/Schema/Result/Aqbookseller.pm
>@@ -474,6 +474,21 @@ __PACKAGE__->has_many(
>   { cascade_copy => 0, cascade_delete => 0 },
> );
> 
>+=head2 erm_usage_data_providers
>+
>+Type: has_many
>+
>+Related object: L<Koha::Schema::Result::ErmUsageDataProvider>
>+
>+=cut
>+
>+__PACKAGE__->has_many(
>+  "erm_usage_data_providers",
>+  "Koha::Schema::Result::ErmUsageDataProvider",
>+  { "foreign.vendor_id" => "self.id" },
>+  { cascade_copy => 0, cascade_delete => 0 },
>+);
>+
> =head2 invoiceprice
> 
> Type: belongs_to
>diff --git a/Koha/Schema/Result/ErmUsageDataProvider.pm b/Koha/Schema/Result/ErmUsageDataProvider.pm
>index 6ab2ce6f410..e4351a50238 100644
>--- a/Koha/Schema/Result/ErmUsageDataProvider.pm
>+++ b/Koha/Schema/Result/ErmUsageDataProvider.pm
>@@ -150,6 +150,14 @@ report types provided by the harvester
> 
> platform if provider requires it
> 
>+=head2 vendor_id
>+
>+  data_type: 'integer'
>+  is_foreign_key: 1
>+  is_nullable: 1
>+
>+foreign key to aqbooksellers
>+
> =cut
> 
> __PACKAGE__->add_columns(
>@@ -185,6 +193,8 @@ __PACKAGE__->add_columns(
>   { data_type => "varchar", is_nullable => 1, size => 255 },
>   "service_platform",
>   { data_type => "varchar", is_nullable => 1, size => 80 },
>+  "vendor_id",
>+  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
> );
> 
> =head1 PRIMARY KEY
>@@ -337,9 +347,29 @@ __PACKAGE__->has_many(
>   { cascade_copy => 0, cascade_delete => 0 },
> );
> 
>+=head2 vendor
>+
>+Type: belongs_to
>+
>+Related object: L<Koha::Schema::Result::Aqbookseller>
>+
>+=cut
>+
>+__PACKAGE__->belongs_to(
>+  "vendor",
>+  "Koha::Schema::Result::Aqbookseller",
>+  { id => "vendor_id" },
>+  {
>+    is_deferrable => 1,
>+    join_type     => "LEFT",
>+    on_delete     => "SET NULL",
>+    on_update     => "CASCADE",
>+  },
>+);
>+
> 
>-# Created by DBIx::Class::Schema::Loader v0.07051 @ 2024-09-27 15:57:24
>-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:YyiiRHSl3tJTzuLsoy9oPw
>+# Created by DBIx::Class::Schema::Loader v0.07051 @ 2024-10-24 10:43:00
>+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:A3fbITzckWWhFnS0Yeclpg
> 
> # __PACKAGE__->add_columns(
> #     '+active' => { is_boolean => 1 }
>-- 
>2.39.3 (Apple Git-146)

Actions: View | Diff | Splinter Review

Attachments on bug 38256: 175150 | 175151 | 175152 | 175153