[Catalyst] How to access DBIC schema from class method?

[Moritz Onken]

Hi,

you need to move this in the resultset class:

package MyApp::Schema::ResultSet::User;
use base 'DBIx::Class::ResultSet';
...

sub create_user {
    my ($rs, $params) = @_;
    return $rs->create({});
}   

then you can access it via $c->model('DB::User')->create_user($params) 


cheers,
mo

Am 11.08.2010 um 02:57 schrieb seasprocket at gmail.com:

> I'm confused about the "right" way to get a schema instance from within a class method. If I've already got a resultset or resultsource instance, it's easy. But from a class method within my model? Do I create a new connection every time I need one, ie. MyApp::Schema->connect()?
> 
> To be specific:
> 
> package MyApp::Schema::Result::User;
> use base 'DBIx::Class::Core';
> ...
> 
> sub create_user {
>     my ($class, $params) = @_;
>     # Want to call $user_rs->create() here after I've validated data.
>     # my $schema = MyApp::Schema->connect()?
> }   
> 
> My suspicion is that this should be an instance method, bc it represents the table, not a user object. And the way to get an instance is to call $rs->result_source on a result set. But when I call:
>       $c->model('DB::User')->result_source->create_user($params) it fails with the msg:
> 
> Can't locate object method "create_user" via package "DBIx::Class::ResultSource::Table"
> 
> 
> 
>  
> 
> 
> -- 
> Bikewise: http://www.bikewise.org
> 
> _______________________________________________
> List: Catalyst at lists.scsys.co.uk
> Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
> Searchable archive: http://www.mail-archive.com/catalyst@lists.scsys.co.uk/
> Dev site: http://dev.catalyst.perl.org/