From 55acc1036b24ee42c36dac192eb88e3aa314b1e4 Mon Sep 17 00:00:00 2001 From: Tomas Cohen Arazi Date: Fri, 14 Nov 2014 09:58:40 -0300 Subject: [PATCH] Bug 11401: DBIx updates Signed-off-by: Tomas Cohen Arazi --- Koha/Schema/Result/Borrower.pm | 19 ++++- Koha/Schema/Result/BorrowerSync.pm | 122 +++++++++++++++++++++++++++++ 2 files changed, 139 insertions(+), 2 deletions(-) create mode 100644 Koha/Schema/Result/BorrowerSync.pm diff --git a/Koha/Schema/Result/Borrower.pm b/Koha/Schema/Result/Borrower.pm index 48102dd742..1c401ad68a 100644 --- a/Koha/Schema/Result/Borrower.pm +++ b/Koha/Schema/Result/Borrower.pm @@ -726,6 +726,21 @@ __PACKAGE__->has_many( { cascade_copy => 0, cascade_delete => 0 }, ); +=head2 borrower_syncs + +Type: has_many + +Related object: L + +=cut + +__PACKAGE__->has_many( + "borrower_syncs", + "Koha::Schema::Result::BorrowerSync", + { "foreign.borrowernumber" => "self.borrowernumber" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + =head2 branchcode Type: belongs_to @@ -1102,8 +1117,8 @@ Composing rels: L -> course __PACKAGE__->many_to_many("courses", "course_instructors", "course"); -# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-08-18 13:01:05 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ZzZiKYN4b/LuEARX4rawhA +# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-11-14 09:56:24 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:UGa+abq4uilkf0nImxun/w # You can replace this text with custom content, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/BorrowerSync.pm b/Koha/Schema/Result/BorrowerSync.pm new file mode 100644 index 0000000000..1f2a509358 --- /dev/null +++ b/Koha/Schema/Result/BorrowerSync.pm @@ -0,0 +1,122 @@ +use utf8; +package Koha::Schema::Result::BorrowerSync; + +# Created by DBIx::Class::Schema::Loader +# DO NOT MODIFY THE FIRST PART OF THIS FILE + +=head1 NAME + +Koha::Schema::Result::BorrowerSync + +=cut + +use strict; +use warnings; + +use base 'DBIx::Class::Core'; + +=head1 TABLE: C + +=cut + +__PACKAGE__->table("borrower_sync"); + +=head1 ACCESSORS + +=head2 borrowersyncid + + data_type: 'integer' + is_auto_increment: 1 + is_nullable: 0 + +=head2 borrowernumber + + data_type: 'integer' + is_foreign_key: 1 + is_nullable: 0 + +=head2 synctype + + data_type: 'varchar' + is_nullable: 0 + size: 32 + +=head2 sync + + data_type: 'tinyint' + default_value: 0 + is_nullable: 0 + +=head2 syncstatus + + data_type: 'varchar' + is_nullable: 1 + size: 10 + +=head2 lastsync + + data_type: 'varchar' + is_nullable: 1 + size: 50 + +=head2 hashed_pin + + data_type: 'varchar' + is_nullable: 1 + size: 64 + +=cut + +__PACKAGE__->add_columns( + "borrowersyncid", + { data_type => "integer", is_auto_increment => 1, is_nullable => 0 }, + "borrowernumber", + { data_type => "integer", is_foreign_key => 1, is_nullable => 0 }, + "synctype", + { data_type => "varchar", is_nullable => 0, size => 32 }, + "sync", + { data_type => "tinyint", default_value => 0, is_nullable => 0 }, + "syncstatus", + { data_type => "varchar", is_nullable => 1, size => 10 }, + "lastsync", + { data_type => "varchar", is_nullable => 1, size => 50 }, + "hashed_pin", + { data_type => "varchar", is_nullable => 1, size => 64 }, +); + +=head1 PRIMARY KEY + +=over 4 + +=item * L + +=back + +=cut + +__PACKAGE__->set_primary_key("borrowersyncid"); + +=head1 RELATIONS + +=head2 borrowernumber + +Type: belongs_to + +Related object: L + +=cut + +__PACKAGE__->belongs_to( + "borrowernumber", + "Koha::Schema::Result::Borrower", + { borrowernumber => "borrowernumber" }, + { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" }, +); + + +# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-11-14 09:56:24 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:yQUJdr7d6/xD6RvZCH47Yw + + +# You can replace this text with custom code or comments, and it will be preserved on regeneration +1; -- 2.39.5