Bug 7295: (follow-up) update DBIx::Class schema classes
authorGalen Charlton <gmc@esilibrary.com>
Thu, 31 Oct 2013 16:32:51 +0000 (16:32 +0000)
committerGalen Charlton <gmc@esilibrary.com>
Thu, 31 Oct 2013 16:37:34 +0000 (16:37 +0000)
Signed-off-by: Galen Charlton <gmc@esilibrary.com>
Koha/Schema/Result/Aqbasket.pm
Koha/Schema/Result/Aqbasketuser.pm [new file with mode: 0644]
Koha/Schema/Result/Borrower.pm
Koha/Schema/Result/Branch.pm

index 2ce507d..7b5f5fe 100644 (file)
@@ -99,6 +99,13 @@ __PACKAGE__->table("aqbasket");
   is_nullable: 1
   size: 10
 
+=head2 branch
+
+  data_type: 'varchar'
+  is_foreign_key: 1
+  is_nullable: 1
+  size: 10
+
 =cut
 
 __PACKAGE__->add_columns(
@@ -133,6 +140,8 @@ __PACKAGE__->add_columns(
   { data_type => "varchar", is_nullable => 1, size => 10 },
   "billingplace",
   { data_type => "varchar", is_nullable => 1, size => 10 },
+  "branch",
+  { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 },
 );
 
 =head1 PRIMARY KEY
@@ -149,6 +158,21 @@ __PACKAGE__->set_primary_key("basketno");
 
 =head1 RELATIONS
 
+=head2 aqbasketusers
+
+Type: has_many
+
+Related object: L<Koha::Schema::Result::Aqbasketuser>
+
+=cut
+
+__PACKAGE__->has_many(
+  "aqbasketusers",
+  "Koha::Schema::Result::Aqbasketuser",
+  { "foreign.basketno" => "self.basketno" },
+  { cascade_copy => 0, cascade_delete => 0 },
+);
+
 =head2 aqorders
 
 Type: has_many
@@ -199,6 +223,26 @@ __PACKAGE__->belongs_to(
   { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
 );
 
+=head2 branch
+
+Type: belongs_to
+
+Related object: L<Koha::Schema::Result::Branch>
+
+=cut
+
+__PACKAGE__->belongs_to(
+  "branch",
+  "Koha::Schema::Result::Branch",
+  { branchcode => "branch" },
+  {
+    is_deferrable => 1,
+    join_type     => "LEFT",
+    on_delete     => "CASCADE",
+    on_update     => "CASCADE",
+  },
+);
+
 =head2 contractnumber
 
 Type: belongs_to
@@ -219,9 +263,19 @@ __PACKAGE__->belongs_to(
   },
 );
 
+=head2 borrowernumbers
+
+Type: many_to_many
+
+Composing rels: L</aqbasketusers> -> borrowernumber
+
+=cut
+
+__PACKAGE__->many_to_many("borrowernumbers", "aqbasketusers", "borrowernumber");
+
 
-# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 20:56:21
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:b4UNvDyA6jbgcTsaasbKYA
+# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-31 16:31:18
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:TCssMGPEqtE0MZ5INCufoA
 
 
 # You can replace this text with custom content, and it will be preserved on regeneration
diff --git a/Koha/Schema/Result/Aqbasketuser.pm b/Koha/Schema/Result/Aqbasketuser.pm
new file mode 100644 (file)
index 0000000..d4c6920
--- /dev/null
@@ -0,0 +1,99 @@
+use utf8;
+package Koha::Schema::Result::Aqbasketuser;
+
+# Created by DBIx::Class::Schema::Loader
+# DO NOT MODIFY THE FIRST PART OF THIS FILE
+
+=head1 NAME
+
+Koha::Schema::Result::Aqbasketuser
+
+=cut
+
+use strict;
+use warnings;
+
+use base 'DBIx::Class::Core';
+
+=head1 TABLE: C<aqbasketusers>
+
+=cut
+
+__PACKAGE__->table("aqbasketusers");
+
+=head1 ACCESSORS
+
+=head2 basketno
+
+  data_type: 'integer'
+  is_foreign_key: 1
+  is_nullable: 0
+
+=head2 borrowernumber
+
+  data_type: 'integer'
+  is_foreign_key: 1
+  is_nullable: 0
+
+=cut
+
+__PACKAGE__->add_columns(
+  "basketno",
+  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
+  "borrowernumber",
+  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
+);
+
+=head1 PRIMARY KEY
+
+=over 4
+
+=item * L</basketno>
+
+=item * L</borrowernumber>
+
+=back
+
+=cut
+
+__PACKAGE__->set_primary_key("basketno", "borrowernumber");
+
+=head1 RELATIONS
+
+=head2 basketno
+
+Type: belongs_to
+
+Related object: L<Koha::Schema::Result::Aqbasket>
+
+=cut
+
+__PACKAGE__->belongs_to(
+  "basketno",
+  "Koha::Schema::Result::Aqbasket",
+  { basketno => "basketno" },
+  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
+);
+
+=head2 borrowernumber
+
+Type: belongs_to
+
+Related object: L<Koha::Schema::Result::Borrower>
+
+=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.07025 @ 2013-10-31 16:31:18
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:X+Ki1d8QV21mBAIaB+t8jA
+
+
+# You can replace this text with custom code or comments, and it will be preserved on regeneration
+1;
index 67642d1..3d9f9ae 100644 (file)
@@ -606,6 +606,21 @@ __PACKAGE__->has_many(
   { cascade_copy => 0, cascade_delete => 0 },
 );
 
+=head2 aqbasketusers
+
+Type: has_many
+
+Related object: L<Koha::Schema::Result::Aqbasketuser>
+
+=cut
+
+__PACKAGE__->has_many(
+  "aqbasketusers",
+  "Koha::Schema::Result::Aqbasketuser",
+  { "foreign.borrowernumber" => "self.borrowernumber" },
+  { cascade_copy => 0, cascade_delete => 0 },
+);
+
 =head2 aqbudgetborrowers
 
 Type: has_many
@@ -1026,6 +1041,16 @@ __PACKAGE__->has_many(
   { cascade_copy => 0, cascade_delete => 0 },
 );
 
+=head2 basketnoes
+
+Type: many_to_many
+
+Composing rels: L</aqbasketusers> -> basketno
+
+=cut
+
+__PACKAGE__->many_to_many("basketnoes", "aqbasketusers", "basketno");
+
 =head2 budgets
 
 Type: many_to_many
@@ -1047,8 +1072,8 @@ Composing rels: L</course_instructors> -> course
 __PACKAGE__->many_to_many("courses", "course_instructors", "course");
 
 
-# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-31 01:30:23
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:eZfDBeShjI29Q8P6Z8CQNA
+# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-31 16:31:19
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:z4kW3xYX1CyrwvGdZu32nA
 
 
 # You can replace this text with custom content, and it will be preserved on regeneration
index a2cfba3..b7bc148 100644 (file)
@@ -173,6 +173,21 @@ __PACKAGE__->set_primary_key("branchcode");
 
 =head1 RELATIONS
 
+=head2 aqbaskets
+
+Type: has_many
+
+Related object: L<Koha::Schema::Result::Aqbasket>
+
+=cut
+
+__PACKAGE__->has_many(
+  "aqbaskets",
+  "Koha::Schema::Result::Aqbasket",
+  { "foreign.branch" => "self.branchcode" },
+  { cascade_copy => 0, cascade_delete => 0 },
+);
+
 =head2 authorised_values_branches
 
 Type: has_many
@@ -454,8 +469,8 @@ Composing rels: L</branchrelations> -> categorycode
 __PACKAGE__->many_to_many("categorycodes", "branchrelations", "categorycode");
 
 
-# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 20:56:21
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:7TY0QNDQkB33iQeLAgo1qg
+# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-31 16:31:19
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:PKoXMUUg0NUf/xVDBkPOqQ
 
 
 # You can replace this text with custom content, and it will be preserved on regeneration