From 8f6ed2f45a5e0aa7deec28ed9f74d375307c8d53 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Sat, 11 Jan 2020 18:14:55 +0100 Subject: [PATCH] Bug 24151: DBIC changes Signed-off-by: Signed-off-by: Sonia Bouis Signed-off-by: Marcel de Rooy Signed-off-by: Jonathan Druart --- Koha/Schema/Result/BorrowerAttributeType.pm | 27 ++++- .../Result/PseudonymizedBorrowerAttribute.pm | 114 ++++++++++++++++++ .../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 + +=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 + +=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 + +=back + +=cut + +__PACKAGE__->set_primary_key("id"); + +=head1 RELATIONS + +=head2 code + +Type: belongs_to + +Related object: L + +=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 + +=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 + +=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.39.5