Merge branch 'cngarrison-test-fix'

[dbsrgits/DBIx-Class-Fixtures.git] / t / lib / ExtraTest / Schema.pm

diff --git a/t/lib/ExtraTest/Schema.pm b/t/lib/ExtraTest/Schema.pm
index e43643b..5484f9e 100644 (file)
--- a/t/lib/ExtraTest/Schema.pm
+++ b/t/lib/ExtraTest/Schema.pm
@@ -1,3 +1,52 @@
+package ExtraTest::Schema::Result::Album;
+
+use base 'DBIx::Class::Core';
+
+__PACKAGE__->table('album');
+__PACKAGE__->add_columns(
+  'albumid' => {
+    data_type => 'integer',
+    is_auto_increment => 1,
+  },
+  'name' => {
+    data_type => 'varchar',
+    size      => 100,
+    is_nullable => 1,
+  },
+);
+__PACKAGE__->set_primary_key('albumid');
+
+__PACKAGE__->has_many(
+    photos => 'ExtraTest::Schema::Result::Photo'
+);
+
+1;
+
+package ExtraTest::Schema::Result::Photographer;
+
+use base 'DBIx::Class::Core';
+
+__PACKAGE__->table('photographer');
+__PACKAGE__->add_columns(
+  'photographerid' => {
+    data_type => 'integer',
+    is_auto_increment => 1,
+  },
+  'name' => {
+    data_type => 'varchar',
+    size      => 100,
+    is_nullable => 1,
+  },
+);
+__PACKAGE__->set_primary_key('photographerid');
+
+__PACKAGE__->has_many(
+    photos => 'ExtraTest::Schema::Result::Photo'
+);
+
+1;
+
+
 package ExtraTest::Schema::Result::Photo;
 
 use strict;
@@ -13,9 +62,11 @@ __PACKAGE__->add_columns(
        data_type => 'integer',
        is_auto_increment => 1,
   },
+  album => {
+    data_type => 'integer',
+  },
   photographer => {
-    data_type => 'varchar',
-    size => 40,
+    data_type => 'integer',
   },
   file => {
        data_type => 'varchar',
@@ -26,6 +77,9 @@ __PACKAGE__->add_columns(
 
 __PACKAGE__->set_primary_key('photo_id');
 
+__PACKAGE__->belongs_to( photographer => 'ExtraTest::Schema::Result::Photographer' );
+__PACKAGE__->belongs_to( album => 'ExtraTest::Schema::Result::Album' );
+
 package ExtraTest::Schema;
 
 use strict;
@@ -34,6 +88,10 @@ use warnings;
 use base 'DBIx::Class::Schema';
 
 __PACKAGE__->register_class(
+  Album => 'ExtraTest::Schema::Result::Album');
+__PACKAGE__->register_class(
+  Photographer => 'ExtraTest::Schema::Result::Photographer');
+__PACKAGE__->register_class(
   Photo => 'ExtraTest::Schema::Result::Photo');
 
 sub load_sql {
@@ -53,9 +111,18 @@ sub init_schema {
 1;
 
 __DATA__
+CREATE TABLE album (
+  albumid INTEGER PRIMARY KEY NOT NULL,
+  name varchar(100) NOT NULL
+);
+CREATE TABLE photographer (
+  photographerid INTEGER PRIMARY KEY NOT NULL,
+  name varchar(100) NOT NULL
+);
 CREATE TABLE photo (
   photo_id INTEGER PRIMARY KEY NOT NULL,
-  photographer varchar(40) NOT NULL,
+  album INTEGER NOT NULL,
+  photographer INTEGER NOT NULL,
   file varchar(255) NOT NULL
 )