[Dbix-class] A problem with Postgres schemas

[John Napiorkowski]

--- Brandon Black <blblack at gmail.com> wrote:

> On 12/28/06, Kevin Esteb <kesteb at wsipc.org> wrote:
> > I new to DBIx::Class, so please bear with me.
> >
> > I am running RHEL4 and have a postgres database
> with a schema named
> > "analog". The DBIx::Class modules are the latest
> and greatest from CPAN,
> > so is the DBD and the DBI for postgres. When I run
> the below code, I get
> > this error:
> >
> > DBIx::Class::Schema::resultset(): Can't find
> source for analog.master at
> > test9.pl line 28
> >
> 
> Your table named analog.master has a
> source/resultset name of "Master"
> in your example, so you should get at the resultset
> via
> $schema->resultset('Master'), instead of
> $schema->resultset('analog.master');
> 
> If you are going to have multiple postgres schemas
> used within this
> DBIx::Class::Schema, it is probably advisable to
> encode the schema
> name in the source name, which means changing
> Test::Schema::Master to
> Test::Schema::Analog::Master, and the accessing via
> $schema->resultset('Analog::Master');

Yeah, that's the way I have it setup, might solve your
ongoing troubles.  Here is my structure:

myapp (directory)
   Schema (directory)
   (db.pm, package myapp::Schema::db)
     db (directory)
       membership (directory)
       (members.pm, package
myapp::Schema::db::membership::members)
       wikis (directory)
       (pages.pm, package
myapp::Schema::db::wikis::pages)

And so on.  Basically I group all my postgres schemas
under the 'db' directory.  I find this just works.

I can forward a tar of my working setup to an address
of your choice if this still gives you trouble.

--john


--john

> 
> -- Brandon
> 
> _______________________________________________
> List:
>
http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class
> Wiki: http://dbix-class.shadowcatsystems.co.uk/
> IRC: irc.perl.org#dbix-class
> SVN:
>
http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/
> Searchable Archive:
>
http://www.mail-archive.com/dbix-class@lists.rawmode.org/
> 


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com