---- file 1 ----
package ORI::Schema::Result::Repo;
extends 'DBIx::Class::Core';
__PACKAGE__->table("repo");
__PACKAGE__->add_columns(
  "id"         => { data_type => "integer" },
  "system_url" => { data_type => "text" },
  "oaibaseurl" => { data_type => "text" },
  "lat"        => { data_type => "real" },
  "long"       => { data_type => "real" },
  "mandate"    => { data_type => "boolean" },
  "fulltext"   => { data_type => "boolean" },
  "openaccess" => { data_type => "boolean" },

);
__PACKAGE__->set_primary_key("id");
__PACKAGE__->has_many(
  "contentlinks" => "ORI::Schema::Result::Contentlink",
  { "foreign.repo_id" => "self.id" },
);
__PACKAGE__->many_to_many("contents", "contentlinks", "content");

##</code><code>##

---- file 2 ----
package ORI::Schema::Result::Contenttype;
extends 'DBIx::Class::Core';
__PACKAGE__->table("contenttypes");
__PACKAGE__->add_columns(
  "id"   => { data_type => "integer" },
  "text" => { data_type => "text" },
);
__PACKAGE__->set_primary_key("id");
_PACKAGE__->has_many(
  "contentlinks"         => "ORI::Schema::Result::Contentlink",
  { "foreign.content_id" => "self.id" },
);
__PACKAGE__->many_to_many("repos", "contentlinks", "repo");

##</code><code>##

---- file 3 ----
package ORI::Schema::Result::Contentlink;
extends 'DBIx::Class::Core';
_PACKAGE__->table("contentlinks");
__PACKAGE__->add_columns(
  "content_id" => { data_type => "integer" },
  "repo_id"    => { data_type => "integer" },
);
__PACKAGE__->set_primary_key("content_id", "repo_id");
__PACKAGE__->belongs_to(
  "content" => "ORI::Schema::Result::Contenttype",
  { id => "content_id" },
);
__PACKAGE__->belongs_to(
  "repo" => "ORI::Schema::Result::Repo",
  { id => "repo_id" },
);

##</code><code>##

---- within controller ----
    # Get the first 10 results (getting all crashes the system! )
    $c->stash( repos => [ $c->model('ORIdatabase::Repo')->search(
                          {}
                          {
                             rows     => '10'
                          }
                        )
                      ] );

---- In Template ----
[% FOREACH repo IN repos -%]
 <tr>
    <td>[% repo.oaibaseurl %]</td>
    <td>[% repo.system_url %]</td>
    <td>[% repo.lat %]</td>
    <td>[% repo.long %]</td>
    <td>[% repo.opstatus %]</td>
    <td>[% repo.fulltext %]</td>
    <td>[% repo.mandate %]</td>
[% END -%]

##</code><code>##

---- within controller ----
    # Get the first 10 results (getting all crashes the system! )
    # Add in a join to get all the contents (ManyToMany relationship)
    $c->stash( repos => [ $c->model('ORIdatabase::Repo')->search(
                          {}
                          {
                             join     => 'contents',
                             prefetch => 'contents',
                             rows     => '10'
                          }
                        )
                      ] );

---- In Template ----
[% FOREACH repo IN repos -%]
 <tr>
    <td>[% repo.oaibaseurl %]</td>
    <td>[% repo.system_url %]</td>
    <td>[% repo.lat %]</td>
    <td>[% repo.long %]</td>
    <td>[% repo.opstatus %]</td>
    <td>[% repo.fulltext %]</td>
    <td>[% repo.mandate %]</td>
    <td>[% repo.mandate %]</td>
    <td>
 [% # How to I get the list of content types? -%]
    </td>
[% END -%]