dbix::class::resultclass::hashrefinflator(3) [osx man page]

DBIx::Class::ResultClass::HashRefInflator(3)		User Contributed Perl Documentation	      DBIx::Class::ResultClass::HashRefInflator(3)

NAME

       DBIx::Class::ResultClass::HashRefInflator - Get raw hashrefs from a resultset

SYNOPSIS

	use DBIx::Class::ResultClass::HashRefInflator;

	my $rs = $schema->resultset('CD');
	$rs->result_class('DBIx::Class::ResultClass::HashRefInflator');
	while (my $hashref = $rs->next) {
	  ...
	}

	 OR as an attribute:

	my $rs = $schema->resultset('CD')->search({}, {
	  result_class => 'DBIx::Class::ResultClass::HashRefInflator',
	});
	while (my $hashref = $rs->next) {
	  ...
	}

DESCRIPTION

       DBIx::Class is faster than older ORMs like Class::DBI but it still isn't designed primarily for speed. Sometimes you need to quickly
       retrieve the data from a massive resultset, while skipping the creation of fancy row objects.  Specifying this class as a "result_class"
       for a resultset will change "$rs->next" to return a plain data hash-ref (or a list of such hash-refs if "$rs->all" is used).

       There are two ways of applying this class to a resultset:

       o   Specify "$rs->result_class" on a specific resultset to affect only that resultset (and any chained off of it); or

       o   Specify "__PACKAGE__->result_class" on your source object to force all uses of that result source to be inflated to hash-refs - this
	   approach is not recommended.

METHODS

   inflate_result
       Inflates the result and prefetched data into a hash-ref (invoked by DBIx::Class::ResultSet)

CAVEATS

       o   This will not work for relationships that have been prefetched. Consider the following:

	    my $artist = $artitsts_rs->search({}, {prefetch => 'cds' })->first;

	    my $cds = $artist->cds;
	    $cds->result_class('DBIx::Class::ResultClass::HashRefInflator');
	    my $first = $cds->first;

	   $first will not be a hashref, it will be a normal CD row since HashRefInflator only affects resultsets at inflation time, and prefetch
	   causes relations to be inflated when the master $artist row is inflated.

       o   Column value inflation, e.g., using modules like DBIx::Class::InflateColumn::DateTime, is not performed.  The returned hash contains
	   the raw database values.

perl v5.16.2							    2012-10-18			      DBIx::Class::ResultClass::HashRefInflator(3)

DBIx::Class::Helper::ResultSet::SetOperations(3pm)	User Contributed Perl Documentation	DBIx::Class::Helper::ResultSet::SetOperations(3pm)

NAME

       DBIx::Class::Helper::ResultSet::SetOperations - Do set operations with DBIx::Class

VERSION

       version 2.013002

SYNOPSIS

	package MyApp::Schema::ResultSet::Foo;

	__PACKAGE__->load_components(qw{Helper::ResultSet::SetOperations});

	...

	1;

       And then elsewhere, like in a controller:

	my $rs1 = $rs->search({ foo => 'bar' });
	my $rs2 = $rs->search({ baz => 'biff' });
	for ($rs1->union($rs2)->all) { ... }

DESCRIPTION

       This component allows you to use various set operations with your ResultSets.  See "NOTE" in DBIx::Class::Helper::ResultSet for a nice way
       to apply it to your entire schema.

       Component throws exceptions if ResultSets have different ResultClasses or different "Columns Specs."

       The basic idea here is that in SQL if you use a set operation they must be selecting the same columns names, so that the results will all
       match.  The deal with the ResultClasses is that DBIC needs to inflate the results the same for the entire ResultSet, so if one were to try
       to apply something like a union in a table with the same column name but different classes DBIC wouldn't be doing what you would expect.

       A nice way to use this is with DBIx::Class::ResultClass::HashRefInflator.

       You might have something like the following sketch autocompletion code:

	my $rs1 = $schema->resultset('Album')->search({
	   name => { -like => "$input%" }
	}, {
	  columns => [qw( id name ), {
	     tablename => ['?', [{} => 'album']],
	  }],
	});

	my $rs2 = $schema->resultset('Artist')->search({
	   name => { -like => "$input%" }
	}, {
	  columns => [qw( id name ), {
	     tablename => ['?', [{} => 'artist']],
	  }],
	});

	my $rs3 = $schema->resultset('Song')->search({
	   name => { -like => "$input%" }
	}, {
	  columns => [qw( id name ), {
	     tablename => ['?', [{} => 'song']],
	  }],
	});

	$_->result_class('DBIx::Class::ResultClass::HashRefInflator')
	  for ($rs1, $rs2, $rs3);

	my $data = [$rs1->union([$rs2, $rs3])->all];

METHODS

   union
   union_all
   intersect
   intersect_all
   except
   except_all
       All of these methods take a single ResultSet or an ArrayRef of ResultSets as the parameter only parameter.

       On Oracle "except" will issue a "MINUS" operation.

AUTHOR

       Arthur Axel "fREW" Schmidt <frioux+cpan@gmail.com>

COPYRIGHT AND LICENSE

       This software is copyright (c) 2012 by Arthur Axel "fREW" Schmidt.

       This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself.

perl v5.14.2							    2012-06-18			DBIx::Class::Helper::ResultSet::SetOperations(3pm)