Bugzilla – Attachment 139783 Details for
Bug 23681
Make patron restrictions user definable
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 23681: DBIC Schema
Bug-23681-DBIC-Schema.patch (text/plain), 4.53 KB, created by
Martin Renvoize (ashimema)
on 2022-08-25 11:38:23 UTC
(
hide
)
Description:
Bug 23681: DBIC Schema
Filename:
MIME Type:
Creator:
Martin Renvoize (ashimema)
Created:
2022-08-25 11:38:23 UTC
Size:
4.53 KB
patch
obsolete
>From 8a9a4930ec9f58fefe41e41fb61934b0024b09bb Mon Sep 17 00:00:00 2001 >From: Emmi Takkinen <emmi.takkinen@koha-suomi.fi> >Date: Tue, 3 May 2022 13:23:43 +0300 >Subject: [PATCH] Bug 23681: DBIC Schema > >To be able to delete and pass tests we need to declare >koha_object[s]_class to DebarmentType.pm. Otherwise >following error is raised: > >"Can't locate object method "_new_from_dbic" via package >"Koha::DebarmentType" (perhaps you forgot to load "Koha::DebarmentType"?) >at /kohadevbox/koha/Koha/Object.pm line 237" > >Signed-off-by: Katrin Fischer <katrin.fischer@bsz-bw.de> >--- > Koha/Schema/Result/BorrowerDebarment.pm | 34 +++++--- > Koha/Schema/Result/DebarmentType.pm | 102 ++++++++++++++++++++++++ > 2 files changed, 124 insertions(+), 12 deletions(-) > create mode 100644 Koha/Schema/Result/DebarmentType.pm > >diff --git a/Koha/Schema/Result/BorrowerDebarment.pm b/Koha/Schema/Result/BorrowerDebarment.pm >index 4f1921b5dd..7c27d56d30 100644 >--- a/Koha/Schema/Result/BorrowerDebarment.pm >+++ b/Koha/Schema/Result/BorrowerDebarment.pm >@@ -49,12 +49,12 @@ expiration date of the restriction > > =head2 type > >- data_type: 'enum' >- default_value: 'MANUAL' >- extra: {list => ["SUSPENSION","OVERDUES","MANUAL","DISCHARGE"]} >+ data_type: 'varchar' >+ is_foreign_key: 1 > is_nullable: 0 >+ size: 50 > >-type of restriction >+type of restriction, FK to debarment_types.code > > =head2 comment > >@@ -97,12 +97,7 @@ __PACKAGE__->add_columns( > "expiration", > { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, > "type", >- { >- data_type => "enum", >- default_value => "MANUAL", >- extra => { list => ["SUSPENSION", "OVERDUES", "MANUAL", "DISCHARGE"] }, >- is_nullable => 0, >- }, >+ { data_type => "varchar", is_foreign_key => 1, is_nullable => 0, size => 50 }, > "comment", > { data_type => "mediumtext", is_nullable => 1 }, > "manager_id", >@@ -151,9 +146,24 @@ __PACKAGE__->belongs_to( > { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" }, > ); > >+=head2 type >+ >+Type: belongs_to >+ >+Related object: L<Koha::Schema::Result::DebarmentType> >+ >+=cut >+ >+__PACKAGE__->belongs_to( >+ "type", >+ "Koha::Schema::Result::DebarmentType", >+ { code => "type" }, >+ { is_deferrable => 1, on_delete => "NO ACTION", on_update => "CASCADE" }, >+); >+ > >-# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:vQL2xYGB5GI//2l4FdIR9w >+# Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-05-04 11:05:19 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:bxRDwUTv9cZVpDfNDatosQ > > > # You can replace this text with custom code or comments, and it will be preserved on regeneration >diff --git a/Koha/Schema/Result/DebarmentType.pm b/Koha/Schema/Result/DebarmentType.pm >new file mode 100644 >index 0000000000..0f83c3c92b >--- /dev/null >+++ b/Koha/Schema/Result/DebarmentType.pm >@@ -0,0 +1,102 @@ >+use utf8; >+package Koha::Schema::Result::DebarmentType; >+ >+# Created by DBIx::Class::Schema::Loader >+# DO NOT MODIFY THE FIRST PART OF THIS FILE >+ >+=head1 NAME >+ >+Koha::Schema::Result::DebarmentType >+ >+=cut >+ >+use strict; >+use warnings; >+ >+use base 'DBIx::Class::Core'; >+ >+=head1 TABLE: C<debarment_types> >+ >+=cut >+ >+__PACKAGE__->table("debarment_types"); >+ >+=head1 ACCESSORS >+ >+=head2 code >+ >+ data_type: 'varchar' >+ is_nullable: 0 >+ size: 50 >+ >+=head2 display_text >+ >+ data_type: 'text' >+ is_nullable: 0 >+ >+=head2 is_system >+ >+ data_type: 'tinyint' >+ default_value: 0 >+ is_nullable: 0 >+ >+=head2 is_default >+ >+ data_type: 'tinyint' >+ default_value: 0 >+ is_nullable: 0 >+ >+=cut >+ >+__PACKAGE__->add_columns( >+ "code", >+ { data_type => "varchar", is_nullable => 0, size => 50 }, >+ "display_text", >+ { data_type => "text", is_nullable => 0 }, >+ "is_system", >+ { data_type => "tinyint", default_value => 0, is_nullable => 0 }, >+ "is_default", >+ { data_type => "tinyint", default_value => 0, is_nullable => 0 }, >+); >+ >+=head1 PRIMARY KEY >+ >+=over 4 >+ >+=item * L</code> >+ >+=back >+ >+=cut >+ >+__PACKAGE__->set_primary_key("code"); >+ >+=head1 RELATIONS >+ >+=head2 borrower_debarments >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::BorrowerDebarment> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "borrower_debarments", >+ "Koha::Schema::Result::BorrowerDebarment", >+ { "foreign.type" => "self.code" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+ >+# Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-05-04 11:05:19 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:cRSViJItfpT3mxCX82/9eQ >+ >+sub koha_object_class { >+ 'Koha::RestrictionType'; >+} >+sub koha_objects_class { >+ 'Koha::RestrictionTypes'; >+} >+ >+1; >-- >2.20.1
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 23681
:
93769
|
93770
|
93771
|
93772
|
93773
|
93774
|
93775
|
93776
|
93777
|
93778
|
93779
|
93780
|
93781
|
93782
|
93783
|
93784
|
93785
|
93786
|
94862
|
94863
|
94864
|
94865
|
94866
|
94867
|
94868
|
94869
|
94870
|
94896
|
94897
|
94898
|
94899
|
94900
|
94901
|
94902
|
94903
|
94904
|
95148
|
95255
|
95256
|
95257
|
95258
|
95259
|
95260
|
95261
|
95262
|
95263
|
95264
|
99893
|
99894
|
99895
|
99896
|
99897
|
99898
|
99899
|
99900
|
99901
|
99902
|
130373
|
130374
|
130375
|
130376
|
130377
|
130378
|
130379
|
130380
|
130381
|
130382
|
130383
|
130384
|
132302
|
132303
|
132304
|
132305
|
132306
|
132307
|
132308
|
132309
|
132310
|
132311
|
132312
|
132313
|
132314
|
132315
|
132316
|
132318
|
132319
|
132320
|
134512
|
134513
|
134514
|
134515
|
134516
|
134517
|
134518
|
134519
|
134520
|
134521
|
134522
|
134523
|
134524
|
134525
|
134526
|
134527
|
134528
|
134529
|
134580
|
134581
|
134582
|
134583
|
134584
|
134585
|
134586
|
134587
|
134588
|
134589
|
134590
|
134591
|
134592
|
134593
|
134594
|
134595
|
134596
|
134597
|
134598
|
134599
|
134600
|
134601
|
134602
|
134684
|
134685
|
134686
|
134687
|
134688
|
134689
|
134690
|
134691
|
134692
|
134693
|
134694
|
134696
|
134697
|
134698
|
134699
|
134700
|
134701
|
134702
|
134703
|
134704
|
134705
|
134706
|
134707
|
134708
|
136716
|
136717
|
136718
|
136719
|
136720
|
136721
|
136722
|
136723
|
136724
|
136725
|
136726
|
136727
|
136728
|
136729
|
136730
|
136731
|
136732
|
136733
|
136734
|
136735
|
136736
|
136737
|
136738
|
136739
|
137066
|
137067
|
137068
|
137069
|
137070
|
137071
|
137072
|
137073
|
137074
|
137075
|
137076
|
137077
|
137078
|
137079
|
137080
|
137081
|
137082
|
137083
|
137084
|
137085
|
137086
|
137087
|
137088
|
137089
|
137090
|
137091
|
137092
|
137093
|
137094
|
137102
|
137103
|
137104
|
137105
|
137106
|
137107
|
137108
|
137109
|
137110
|
137111
|
137112
|
137113
|
137114
|
137115
|
137116
|
137117
|
137118
|
137119
|
137120
|
137121
|
137122
|
137123
|
137124
|
137125
|
137126
|
137127
|
137128
|
137129
|
137130
|
139250
|
139251
|
139252
|
139253
|
139254
|
139255
|
139256
|
139257
|
139258
|
139259
|
139260
|
139261
|
139262
|
139263
|
139264
|
139265
|
139266
|
139267
|
139268
|
139269
|
139270
|
139271
|
139272
|
139273
|
139509
|
139512
|
139649
|
139717
|
139768
|
139769
|
139770
|
139771
|
139772
|
139773
|
139774
|
139775
|
139776
|
139777
|
139778
|
139779
|
139780
|
139781
|
139782
| 139783 |
139784
|
139785
|
139786
|
139787
|
139788
|
139789
|
139790
|
139791
|
139792
|
139793
|
139794
|
139795