On 5/22/07, Matt S Trout <[EMAIL PROTECTED]> wrote:
On Tue, May 22, 2007 at 12:16:20PM -0400, John Goulah wrote:
> >So I have a function like:
> >>
> >> sub get_some_data : ResultSet {
> >> my ($self) = @_;
> >> my $dbh = $self->result_source->schema->storage->dbh;
> >>
> >> my $sth = $dbh->prepare("select * from sometable");
> >> $sth->execute();
> >>
> >> ##### this doesn't work, how do I use this method?
> >> return $self->sth_to_objects($sth);
> >
> >You don't. That's a method on a resultset object, and the CDBICompat
stuff
> >won't show up there - which is a good thing, since sth_to_objects it
> >pretty
> >horrible since it's a COMPATIBILITY LAYER feature, not a DBIC feature.
> >
> >How about
> >
> > my @results;
> > while (my $hr = $sth->fetchrow_hashref) {
> > push(@results,
> > $self->result_class->inflate_result(
> > $self->result_source, $hr, {}
> > )
> > );
> > }
> > return @results;
> >
> >?
>
>
>
> Yes thats exactly what I was looking for, thank you. So if I were to
want
> this method shared on all my resultset objects, would you suggest
creating
> an object that inherits from the ResultSetManager (or somethign similar)
and
> putting it in there?
A class that uses base DBIx::Class::ResultSet and then just do
__PACKAGE__->resultset_class('My::ResultSet::Class');
in any table class that needs it. ResultSetManager is just a convenience
syntax to that, and causes enough problems in more complex cases there's
serious consideration being given to deprecating it in favour of saner
syntax.
That works fine, but I would rather scope the package under myDB rather than
MyApp, but when I put the ResultSet dir under myDB directory I get "Cannot
load schema class" errors (under MyApp its fine). I assume its trying to
load this class as a table class. Is there any way around this? If not
where is the recommended place to put these? It seems best to keep it
close to the DB classes, but I'm not sure Catalyst will let me.
Thanks!
John
_______________________________________________
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]/
