Bugzilla – Attachment 106043 Details for
Bug 24151
Add a pseudonymization process for patrons and transactions
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 24151: DBIC changes
Bug-24151-DBIC-changes.patch (text/plain), 5.91 KB, created by
Marcel de Rooy
on 2020-06-19 07:30:48 UTC
(
hide
)
Description:
Bug 24151: DBIC changes
Filename:
MIME Type:
Creator:
Marcel de Rooy
Created:
2020-06-19 07:30:48 UTC
Size:
5.91 KB
patch
obsolete
>From 52942d51bb342cf82bed3091ec0e4981bd175f98 Mon Sep 17 00:00:00 2001 >From: Jonathan Druart <jonathan.druart@bugs.koha-community.org> >Date: Sat, 11 Jan 2020 18:14:55 +0100 >Subject: [PATCH] Bug 24151: DBIC changes >Content-Type: text/plain; charset=utf-8 > >Signed-off-by: Signed-off-by: Sonia Bouis <sonia.bouis@univ-lyon3.fr> > >Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl> >--- > Koha/Schema/Result/BorrowerAttributeType.pm | 27 ++++- > .../Result/PseudonymizedBorrowerAttribute.pm | 114 +++++++++++++++++++++ > Koha/Schema/Result/PseudonymizedTransaction.pm | 19 +++- > 3 files changed, 156 insertions(+), 4 deletions(-) > create mode 100644 Koha/Schema/Result/PseudonymizedBorrowerAttribute.pm > >diff --git a/Koha/Schema/Result/BorrowerAttributeType.pm b/Koha/Schema/Result/BorrowerAttributeType.pm >index 08048b51d4..70abaa3700 100644 >--- a/Koha/Schema/Result/BorrowerAttributeType.pm >+++ b/Koha/Schema/Result/BorrowerAttributeType.pm >@@ -90,6 +90,12 @@ __PACKAGE__->table("borrower_attribute_types"); > is_nullable: 0 > size: 255 > >+=head2 keep_for_pseudonymization >+ >+ data_type: 'tinyint' >+ default_value: 0 >+ is_nullable: 0 >+ > =cut > > __PACKAGE__->add_columns( >@@ -115,6 +121,8 @@ __PACKAGE__->add_columns( > { data_type => "varchar", is_nullable => 1, size => 10 }, > "class", > { data_type => "varchar", default_value => "", is_nullable => 0, size => 255 }, >+ "keep_for_pseudonymization", >+ { data_type => "tinyint", default_value => 0, is_nullable => 0 }, > ); > > =head1 PRIMARY KEY >@@ -161,9 +169,24 @@ __PACKAGE__->has_many( > { cascade_copy => 0, cascade_delete => 0 }, > ); > >+=head2 pseudonymized_borrower_attributes >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::PseudonymizedBorrowerAttribute> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "pseudonymized_borrower_attributes", >+ "Koha::Schema::Result::PseudonymizedBorrowerAttribute", >+ { "foreign.code" => "self.code" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ > >-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-10-25 20:32:12 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:gsPR8PuUUZHFUkr3MIbTpw >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-01-11 18:00:12 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:MMozmna9C3PseXF0Qskznw > > __PACKAGE__->add_columns( > '+keep_for_pseudonymization' => { is_boolean => 1 }, >diff --git a/Koha/Schema/Result/PseudonymizedBorrowerAttribute.pm b/Koha/Schema/Result/PseudonymizedBorrowerAttribute.pm >new file mode 100644 >index 0000000000..788de88ecc >--- /dev/null >+++ b/Koha/Schema/Result/PseudonymizedBorrowerAttribute.pm >@@ -0,0 +1,114 @@ >+use utf8; >+package Koha::Schema::Result::PseudonymizedBorrowerAttribute; >+ >+# Created by DBIx::Class::Schema::Loader >+# DO NOT MODIFY THE FIRST PART OF THIS FILE >+ >+=head1 NAME >+ >+Koha::Schema::Result::PseudonymizedBorrowerAttribute >+ >+=cut >+ >+use strict; >+use warnings; >+ >+use base 'DBIx::Class::Core'; >+ >+=head1 TABLE: C<pseudonymized_borrower_attributes> >+ >+=cut >+ >+__PACKAGE__->table("pseudonymized_borrower_attributes"); >+ >+=head1 ACCESSORS >+ >+=head2 id >+ >+ data_type: 'integer' >+ is_auto_increment: 1 >+ is_nullable: 0 >+ >+=head2 transaction_id >+ >+ data_type: 'integer' >+ is_foreign_key: 1 >+ is_nullable: 0 >+ >+=head2 code >+ >+ data_type: 'varchar' >+ is_foreign_key: 1 >+ is_nullable: 0 >+ size: 10 >+ >+=head2 attribute >+ >+ data_type: 'varchar' >+ is_nullable: 1 >+ size: 255 >+ >+=cut >+ >+__PACKAGE__->add_columns( >+ "id", >+ { data_type => "integer", is_auto_increment => 1, is_nullable => 0 }, >+ "transaction_id", >+ { data_type => "integer", is_foreign_key => 1, is_nullable => 0 }, >+ "code", >+ { data_type => "varchar", is_foreign_key => 1, is_nullable => 0, size => 10 }, >+ "attribute", >+ { data_type => "varchar", is_nullable => 1, size => 255 }, >+); >+ >+=head1 PRIMARY KEY >+ >+=over 4 >+ >+=item * L</id> >+ >+=back >+ >+=cut >+ >+__PACKAGE__->set_primary_key("id"); >+ >+=head1 RELATIONS >+ >+=head2 code >+ >+Type: belongs_to >+ >+Related object: L<Koha::Schema::Result::BorrowerAttributeType> >+ >+=cut >+ >+__PACKAGE__->belongs_to( >+ "code", >+ "Koha::Schema::Result::BorrowerAttributeType", >+ { code => "code" }, >+ { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" }, >+); >+ >+=head2 transaction >+ >+Type: belongs_to >+ >+Related object: L<Koha::Schema::Result::PseudonymizedTransaction> >+ >+=cut >+ >+__PACKAGE__->belongs_to( >+ "transaction", >+ "Koha::Schema::Result::PseudonymizedTransaction", >+ { id => "transaction_id" }, >+ { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" }, >+); >+ >+ >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-01-11 17:12:17 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:q6CTb8kq83p1bEM+ilfAww >+ >+ >+# You can replace this text with custom code or comments, and it will be preserved on regeneration >+1; >diff --git a/Koha/Schema/Result/PseudonymizedTransaction.pm b/Koha/Schema/Result/PseudonymizedTransaction.pm >index 61c3b610e7..ff93ec48ce 100644 >--- a/Koha/Schema/Result/PseudonymizedTransaction.pm >+++ b/Koha/Schema/Result/PseudonymizedTransaction.pm >@@ -272,6 +272,21 @@ __PACKAGE__->belongs_to( > { is_deferrable => 1, on_delete => "RESTRICT", on_update => "RESTRICT" }, > ); > >+=head2 pseudonymized_borrower_attributes >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::PseudonymizedBorrowerAttribute> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "pseudonymized_borrower_attributes", >+ "Koha::Schema::Result::PseudonymizedBorrowerAttribute", >+ { "foreign.transaction_id" => "self.id" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ > =head2 transaction_branchcode > > Type: belongs_to >@@ -293,8 +308,8 @@ __PACKAGE__->belongs_to( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-01-11 16:08:51 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:r3YdoQ6TKEF0THmeXHvRwA >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-01-11 17:12:17 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:bzHjcKCHYf+bixeA1dhKIQ > > > # You can replace this text with custom code or comments, and it will be preserved on regeneration >-- >2.11.0
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 24151
:
95959
|
95960
|
95961
|
95962
|
95963
|
95964
|
95965
|
95966
|
95967
|
95968
|
95969
|
95970
|
95971
|
95972
|
95973
|
95974
|
95975
|
95976
|
97240
|
97241
|
97242
|
97243
|
97244
|
97245
|
97246
|
97247
|
97248
|
97249
|
97250
|
97251
|
97252
|
101034
|
101035
|
101036
|
101037
|
101038
|
101039
|
101040
|
101041
|
101042
|
101043
|
101044
|
101045
|
101046
|
101047
|
101048
|
101049
|
105801
|
105802
|
105803
|
105804
|
105805
|
105806
|
105807
|
105808
|
105809
|
105810
|
105811
|
105812
|
105813
|
105814
|
105815
|
105816
|
106032
|
106033
|
106034
|
106035
|
106036
|
106037
|
106038
|
106039
|
106040
|
106041
|
106042
| 106043 |
106044
|
106045
|
106046
|
106047
|
106048
|
106049
|
106195
|
106255
|
107127
|
107225