Attachment 144648 Details for Bug 31028 – Bug 31028: DBIC Schema update

[patch] Bug 31028: DBIC Schema update

Bug-31028-DBIC-Schema-update.patch (text/plain), 9.62 KB, created by Martin Renvoize (ashimema) on 2022-12-16 11:29:47 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Martin Renvoize (ashimema)

Created: 2022-12-16 11:29:47 UTC

Size: 9.62 KB

patch

obsolete

>From 5fb23416856646d33a0d98bbd5cb143dc77338c9 Mon Sep 17 00:00:00 2001
>From: Martin Renvoize <martin.renvoize@ptfs-europe.com>
>Date: Tue, 25 Oct 2022 13:04:33 +0100
>Subject: [PATCH] Bug 31028: DBIC Schema update
>
>Signed-off-by: David Nind <david@davidnind.com>
>Signed-off-by: Helen Oliver <HOliver@tavi-port.ac.uk>
>---
> Koha/Schema/Result/Biblio.pm       |  19 ++-
> Koha/Schema/Result/Borrower.pm     |  45 ++++++
> Koha/Schema/Result/Ticket.pm       | 215 +++++++++++++++++++++++++++++
> Koha/Schema/Result/TicketUpdate.pm | 152 ++++++++++++++++++++
> 4 files changed, 429 insertions(+), 2 deletions(-)
> create mode 100644 Koha/Schema/Result/Ticket.pm
> create mode 100644 Koha/Schema/Result/TicketUpdate.pm
>
>diff --git a/Koha/Schema/Result/Biblio.pm b/Koha/Schema/Result/Biblio.pm
>index 2d9abfb7e02..baa2ebb7a4e 100644
>--- a/Koha/Schema/Result/Biblio.pm
>+++ b/Koha/Schema/Result/Biblio.pm
>@@ -540,6 +540,21 @@ __PACKAGE__->has_many(
>   { cascade_copy => 0, cascade_delete => 0 },
> );
> 
>+=head2 tickets
>+
>+Type: has_many
>+
>+Related object: L<Koha::Schema::Result::Ticket>
>+
>+=cut
>+
>+__PACKAGE__->has_many(
>+  "tickets",
>+  "Koha::Schema::Result::Ticket",
>+  { "foreign.biblio_id" => "self.biblionumber" },
>+  { cascade_copy => 0, cascade_delete => 0 },
>+);
>+
> =head2 tmp_holdsqueues
> 
> Type: has_many
>@@ -571,8 +586,8 @@ __PACKAGE__->has_many(
> );
> 
> 
>-# Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-07-13 12:25:59
>-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:C1RZYgDcw6WrZ5laTaKV6w
>+# Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-11-09 09:18:58
>+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:joWQt2obRJMmiTLIvatB5Q
> 
> __PACKAGE__->has_many(
>   "biblioitem",
>diff --git a/Koha/Schema/Result/Borrower.pm b/Koha/Schema/Result/Borrower.pm
>index f32bb51afda..1e286836502 100644
>--- a/Koha/Schema/Result/Borrower.pm
>+++ b/Koha/Schema/Result/Borrower.pm
>@@ -1932,6 +1932,51 @@ __PACKAGE__->has_many(
>   { cascade_copy => 0, cascade_delete => 0 },
> );
> 
>+=head2 ticket_updates
>+
>+Type: has_many
>+
>+Related object: L<Koha::Schema::Result::TicketUpdate>
>+
>+=cut
>+
>+__PACKAGE__->has_many(
>+  "ticket_updates",
>+  "Koha::Schema::Result::TicketUpdate",
>+  { "foreign.user_id" => "self.borrowernumber" },
>+  { cascade_copy => 0, cascade_delete => 0 },
>+);
>+
>+=head2 tickets_reporters
>+
>+Type: has_many
>+
>+Related object: L<Koha::Schema::Result::Ticket>
>+
>+=cut
>+
>+__PACKAGE__->has_many(
>+  "tickets_reporters",
>+  "Koha::Schema::Result::Ticket",
>+  { "foreign.reporter_id" => "self.borrowernumber" },
>+  { cascade_copy => 0, cascade_delete => 0 },
>+);
>+
>+=head2 tickets_resolvers
>+
>+Type: has_many
>+
>+Related object: L<Koha::Schema::Result::Ticket>
>+
>+=cut
>+
>+__PACKAGE__->has_many(
>+  "tickets_resolvers",
>+  "Koha::Schema::Result::Ticket",
>+  { "foreign.resolver_id" => "self.borrowernumber" },
>+  { cascade_copy => 0, cascade_delete => 0 },
>+);
>+
> =head2 tmp_holdsqueues
> 
> Type: has_many
>diff --git a/Koha/Schema/Result/Ticket.pm b/Koha/Schema/Result/Ticket.pm
>new file mode 100644
>index 00000000000..d45e542d441
>--- /dev/null
>+++ b/Koha/Schema/Result/Ticket.pm
>@@ -0,0 +1,215 @@
>+use utf8;
>+package Koha::Schema::Result::Ticket;
>+
>+# Created by DBIx::Class::Schema::Loader
>+# DO NOT MODIFY THE FIRST PART OF THIS FILE
>+
>+=head1 NAME
>+
>+Koha::Schema::Result::Ticket
>+
>+=cut
>+
>+use strict;
>+use warnings;
>+
>+use base 'DBIx::Class::Core';
>+
>+=head1 TABLE: C<tickets>
>+
>+=cut
>+
>+__PACKAGE__->table("tickets");
>+
>+=head1 ACCESSORS
>+
>+=head2 id
>+
>+  data_type: 'integer'
>+  is_auto_increment: 1
>+  is_nullable: 0
>+
>+primary key
>+
>+=head2 reporter_id
>+
>+  data_type: 'integer'
>+  default_value: 0
>+  is_foreign_key: 1
>+  is_nullable: 0
>+
>+id of the patron who reported the ticket
>+
>+=head2 reported_date
>+
>+  data_type: 'timestamp'
>+  datetime_undef_if_invalid: 1
>+  default_value: current_timestamp
>+  is_nullable: 0
>+
>+date and time this ticket was reported
>+
>+=head2 title
>+
>+  data_type: 'text'
>+  is_nullable: 0
>+
>+ticket title
>+
>+=head2 body
>+
>+  data_type: 'text'
>+  is_nullable: 0
>+
>+ticket details
>+
>+=head2 resolver_id
>+
>+  data_type: 'integer'
>+  is_foreign_key: 1
>+  is_nullable: 1
>+
>+id of the user who resolved the ticket
>+
>+=head2 resolved_date
>+
>+  data_type: 'datetime'
>+  datetime_undef_if_invalid: 1
>+  is_nullable: 1
>+
>+date and time this ticket was resolved
>+
>+=head2 biblio_id
>+
>+  data_type: 'integer'
>+  is_foreign_key: 1
>+  is_nullable: 1
>+
>+id of biblio linked
>+
>+=cut
>+
>+__PACKAGE__->add_columns(
>+  "id",
>+  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
>+  "reporter_id",
>+  {
>+    data_type      => "integer",
>+    default_value  => 0,
>+    is_foreign_key => 1,
>+    is_nullable    => 0,
>+  },
>+  "reported_date",
>+  {
>+    data_type => "timestamp",
>+    datetime_undef_if_invalid => 1,
>+    default_value => \"current_timestamp",
>+    is_nullable => 0,
>+  },
>+  "title",
>+  { data_type => "text", is_nullable => 0 },
>+  "body",
>+  { data_type => "text", is_nullable => 0 },
>+  "resolver_id",
>+  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
>+  "resolved_date",
>+  {
>+    data_type => "datetime",
>+    datetime_undef_if_invalid => 1,
>+    is_nullable => 1,
>+  },
>+  "biblio_id",
>+  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
>+);
>+
>+=head1 PRIMARY KEY
>+
>+=over 4
>+
>+=item * L</id>
>+
>+=back
>+
>+=cut
>+
>+__PACKAGE__->set_primary_key("id");
>+
>+=head1 RELATIONS
>+
>+=head2 biblio
>+
>+Type: belongs_to
>+
>+Related object: L<Koha::Schema::Result::Biblio>
>+
>+=cut
>+
>+__PACKAGE__->belongs_to(
>+  "biblio",
>+  "Koha::Schema::Result::Biblio",
>+  { biblionumber => "biblio_id" },
>+  {
>+    is_deferrable => 1,
>+    join_type     => "LEFT",
>+    on_delete     => "CASCADE",
>+    on_update     => "CASCADE",
>+  },
>+);
>+
>+=head2 reporter
>+
>+Type: belongs_to
>+
>+Related object: L<Koha::Schema::Result::Borrower>
>+
>+=cut
>+
>+__PACKAGE__->belongs_to(
>+  "reporter",
>+  "Koha::Schema::Result::Borrower",
>+  { borrowernumber => "reporter_id" },
>+  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
>+);
>+
>+=head2 resolver
>+
>+Type: belongs_to
>+
>+Related object: L<Koha::Schema::Result::Borrower>
>+
>+=cut
>+
>+__PACKAGE__->belongs_to(
>+  "resolver",
>+  "Koha::Schema::Result::Borrower",
>+  { borrowernumber => "resolver_id" },
>+  {
>+    is_deferrable => 1,
>+    join_type     => "LEFT",
>+    on_delete     => "CASCADE",
>+    on_update     => "CASCADE",
>+  },
>+);
>+
>+=head2 ticket_updates
>+
>+Type: has_many
>+
>+Related object: L<Koha::Schema::Result::TicketUpdate>
>+
>+=cut
>+
>+__PACKAGE__->has_many(
>+  "ticket_updates",
>+  "Koha::Schema::Result::TicketUpdate",
>+  { "foreign.ticket_id" => "self.id" },
>+  { cascade_copy => 0, cascade_delete => 0 },
>+);
>+
>+
>+# Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-10-24 21:15:34
>+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:0Nm+y1BHJicrpeq3kuU1VA
>+
>+
>+# You can replace this text with custom code or comments, and it will be preserved on regeneration
>+1;
>diff --git a/Koha/Schema/Result/TicketUpdate.pm b/Koha/Schema/Result/TicketUpdate.pm
>new file mode 100644
>index 00000000000..edbc984ee42
>--- /dev/null
>+++ b/Koha/Schema/Result/TicketUpdate.pm
>@@ -0,0 +1,152 @@
>+use utf8;
>+package Koha::Schema::Result::TicketUpdate;
>+
>+# Created by DBIx::Class::Schema::Loader
>+# DO NOT MODIFY THE FIRST PART OF THIS FILE
>+
>+=head1 NAME
>+
>+Koha::Schema::Result::TicketUpdate
>+
>+=cut
>+
>+use strict;
>+use warnings;
>+
>+use base 'DBIx::Class::Core';
>+
>+=head1 TABLE: C<ticket_updates>
>+
>+=cut
>+
>+__PACKAGE__->table("ticket_updates");
>+
>+=head1 ACCESSORS
>+
>+=head2 id
>+
>+  data_type: 'integer'
>+  is_auto_increment: 1
>+  is_nullable: 0
>+
>+primary key
>+
>+=head2 ticket_id
>+
>+  data_type: 'integer'
>+  is_foreign_key: 1
>+  is_nullable: 0
>+
>+id of catalog ticket the update relates to
>+
>+=head2 user_id
>+
>+  data_type: 'integer'
>+  default_value: 0
>+  is_foreign_key: 1
>+  is_nullable: 0
>+
>+id of the user who logged the update
>+
>+=head2 public
>+
>+  data_type: 'tinyint'
>+  default_value: 0
>+  is_nullable: 0
>+
>+boolean flag to denote whether this update is public
>+
>+=head2 date
>+
>+  data_type: 'timestamp'
>+  datetime_undef_if_invalid: 1
>+  default_value: current_timestamp
>+  is_nullable: 0
>+
>+date and time this update was logged
>+
>+=head2 message
>+
>+  data_type: 'text'
>+  is_nullable: 0
>+
>+update message content
>+
>+=cut
>+
>+__PACKAGE__->add_columns(
>+  "id",
>+  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
>+  "ticket_id",
>+  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
>+  "user_id",
>+  {
>+    data_type      => "integer",
>+    default_value  => 0,
>+    is_foreign_key => 1,
>+    is_nullable    => 0,
>+  },
>+  "public",
>+  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
>+  "date",
>+  {
>+    data_type => "timestamp",
>+    datetime_undef_if_invalid => 1,
>+    default_value => \"current_timestamp",
>+    is_nullable => 0,
>+  },
>+  "message",
>+  { data_type => "text", is_nullable => 0 },
>+);
>+
>+=head1 PRIMARY KEY
>+
>+=over 4
>+
>+=item * L</id>
>+
>+=back
>+
>+=cut
>+
>+__PACKAGE__->set_primary_key("id");
>+
>+=head1 RELATIONS
>+
>+=head2 ticket
>+
>+Type: belongs_to
>+
>+Related object: L<Koha::Schema::Result::Ticket>
>+
>+=cut
>+
>+__PACKAGE__->belongs_to(
>+  "ticket",
>+  "Koha::Schema::Result::Ticket",
>+  { id => "ticket_id" },
>+  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
>+);
>+
>+=head2 user
>+
>+Type: belongs_to
>+
>+Related object: L<Koha::Schema::Result::Borrower>
>+
>+=cut
>+
>+__PACKAGE__->belongs_to(
>+  "user",
>+  "Koha::Schema::Result::Borrower",
>+  { borrowernumber => "user_id" },
>+  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
>+);
>+
>+
>+# Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-10-24 18:31:28
>+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:8YG3jhlqbHWptc28pvBmrg
>+
>+
>+# You can replace this text with custom code or comments, and it will be preserved on regeneration
>+1;
>-- 
>2.39.0

Actions: View | Diff | Splinter Review

Attachments on bug 31028: 137412 | 139222 | 139223 | 139224 | 139225 | 139226 | 139227 | 139228 | 139229 | 139230 | 139231 | 139232 | 139233 | 139234 | 139235 | 139236 | 139237 | 139238 | 139572 | 139573 | 139574 | 139575 | 139576 | 139577 | 139578 | 139579 | 139580 | 139581 | 139582 | 139583 | 139584 | 139585 | 139586 | 139587 | 139588 | 139589 | 139590 | 139591 | 140289 | 140290 | 140291 | 140292 | 140293 | 140294 | 140295 | 140296 | 140297 | 140298 | 140299 | 140300 | 140301 | 140302 | 140303 | 140304 | 140305 | 140306 | 140307 | 140308 | 140436 | 140437 | 140438 | 140439 | 140440 | 140441 | 140442 | 140443 | 140444 | 140445 | 140446 | 140447 | 140448 | 140449 | 140450 | 140451 | 140452 | 140453 | 140454 | 140455 | 140764 | 140765 | 140766 | 140767 | 140768 | 140769 | 140770 | 140771 | 140772 | 140773 | 140774 | 140775 | 140776 | 140777 | 140778 | 140779 | 140780 | 140781 | 140782 | 140783 | 140793 | 140929 | 140930 | 140931 | 140932 | 140933 | 140934 | 140935 | 140936 | 140937 | 140938 | 140939 | 140940 | 140941 | 140942 | 140943 | 140944 | 140945 | 140946 | 140947 | 140948 | 140949 | 140950 | 141133 | 141134 | 141135 | 141136 | 141137 | 141138 | 141139 | 141140 | 141141 | 141142 | 141143 | 141144 | 141145 | 141146 | 141147 | 141148 | 141149 | 141150 | 141151 | 141152 | 141153 | 141154 | 141440 | 141441 | 141442 | 141443 | 141444 | 141445 | 141446 | 141447 | 141448 | 141449 | 141450 | 141451 | 141452 | 141453 | 141454 | 141455 | 141456 | 141457 | 141458 | 141459 | 141460 | 142164 | 142165 | 142166 | 142167 | 142168 | 142169 | 142170 | 142171 | 142172 | 142173 | 142174 | 142175 | 142177 | 142179 | 142180 | 142181 | 142182 | 142183 | 142184 | 142185 | 142186 | 142187 | 142188 | 142189 | 142190 | 142191 | 142616 | 142617 | 142618 | 142619 | 142620 | 142621 | 142622 | 142623 | 142624 | 142625 | 142626 | 142627 | 142932 | 142933 | 142934 | 142935 | 142936 | 142937 | 142938 | 142939 | 142940 | 142941 | 142942 | 142943 | 142944 | 142945 | 142946 | 142947 | 142948 | 142949 | 143238 | 143239 | 143240 | 143241 | 143242 | 143243 | 143244 | 143245 | 143246 | 143247 | 143248 | 143249 | 143250 | 143251 | 143252 | 143253 | 143254 | 143255 | 143256 | 143257 | 143302 | 143303 | 143304 | 143305 | 143306 | 143307 | 143308 | 143309 | 143310 | 143311 | 143312 | 143313 | 143314 | 143315 | 143316 | 143317 | 143318 | 143319 | 143320 | 143321 | 143322 | 143323 | 143324 | 143325 | 143326 | 143327 | 143328 | 143329 | 143330 | 143331 | 143332 | 143333 | 143334 | 143335 | 143336 | 143337 | 143338 | 143339 | 143340 | 143341 | 143470 | 143471 | 143472 | 143473 | 143474 | 143475 | 143476 | 143477 | 143478 | 143479 | 143480 | 143481 | 143482 | 143483 | 143484 | 143485 | 143486 | 143487 | 143488 | 143489 | 143490 | 143647 | 143648 | 143649 | 143650 | 143651 | 143652 | 143653 | 143654 | 143655 | 143656 | 143657 | 143658 | 143659 | 143660 | 143661 | 143662 | 143663 | 143664 | 143665 | 143666 | 143667 | 143708 | 143709 | 143710 | 143711 | 143712 | 143713 | 143714 | 143715 | 143716 | 143717 | 143718 | 143719 | 143720 | 143721 | 143722 | 143723 | 143724 | 143725 | 143726 | 143727 | 144647 | 144648 | 144649 | 144650 | 144651 | 144652 | 144653 | 144654 | 144655 | 144656 | 144657 | 144658 | 144659 | 144660 | 144661 | 144662 | 144663 | 144664 | 144665 | 144666 | 144667 | 144668 | 145542 | 146214 | 146215 | 146216 | 146217 | 146218 | 146219 | 146220 | 146221 | 146222 | 146223 | 146224 | 146225 | 146226 | 146227 | 146228 | 146229 | 146230 | 146231 | 146232 | 146233 | 146234 | 146235 | 146236 | 146237 | 146238 | 146239 | 146240 | 146241 | 146242 | 146243 | 146244 | 146245 | 146246 | 146247 | 146248 | 146249 | 146250 | 146251 | 146252 | 146253 | 146254 | 146255 | 146256 | 146257 | 146258 | 146259 | 146260 | 146261 | 146262 | 146697 | 146870 | 146871 | 146872 | 146873 | 146874 | 146875 | 146876 | 146877 | 146878 | 146879 | 146880 | 146881 | 146882 | 146883 | 146884 | 146885 | 146886 | 146887 | 146888 | 146889 | 146890 | 146891 | 146892 | 146893 | 146894 | 146895 | 146896 | 147797 | 147840 | 147841 | 147844 | 147859 | 147860 | 147861 | 147866 | 148673 | 149931