Mike Friedman wrote:
Greetings,
I'm used to Class::DBI and very new to DBIx::Class.
>From the docs, it seems like to execute any search, I have to
1. Instantiate a schema object and connect it
Yes. Call it once and keep hold of it.
2. Call $schema->resultset('MyTableClass')->search( ... );
Yup, you have to do that every time.
In Class::DBI, since the table classes generally inherit from the main
DB class, I can just call MyTableClass->search( ... ) which seems a lot
simpler. (And less to type.)
It does however tie you to one and only one database connection. With
DBIx::Class you can use different DBI connections for the same tables/schema
Is there a similar way to achieve this simpler syntax with DBIx::Class,
or do I have to use $schema->resultset every time?
Is there a recommended way to encapsulate connection parameters, so I
don't have to call $schema->connect all over the place?
(Note: I'm not trying to be obnoxious, I just don't really quite
understand how DBIC is organized just yet.)
Thanks,
Mike
_______________________________________________
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/[email protected]/