DBIx::Class::Helper::ResultSet::AutoRemoveColumns(3pm)

Usage

 package MySchema::Result::Bar;
 use strict;
 use warnings;
 use parent 'DBIx::Class::Core';
 __PACKAGE__->table('KittenRobot');
 __PACKAGE__->add_columns(
    id => {
       data_type         => 'integer',
       is_auto_increment => 1,
    },
    kitten => {
       data_type         => 'integer',
    },
    robot => {
       data_type         => 'text',
       is_nullable       => 1,
    },
    your_mom => {
       data_type         => 'blob',
       is_nullable       => 1,
       remove_column     => 0,
    },
 );
 1;
 package MySchema::ResultSet::Bar;
 use strict;
 use warnings;
 use parent 'DBIx::Class::ResultSet';
 __PACKAGE__->load_components('Helper::ResultSet::AutoRemoveColumns');

Overview

This component automatically removes "heavy-weight" columns. To be specific, columns of type "text", "ntext", "blob", "clob", or "bytea". You may use the "remove_column" key in the column info to specify directly whether or not to remove the column automatically. See "NOTE" in DBIx::Class::Helper::ResultSet for a nice way to apply it to your entire schema.

Methods

_should_column_fetch

 $self->_should_column_fetch('kitten')

returns true if a column should be fetched or not. This fetches a column if it is not of type "text", "ntext", "blob", "clob", or "bytea" or the "remove_column" is set to true. If you only wanted to explicitly state which columns to remove you might override this method like this:

 sub _should_column_fetch {
    my ( $self, $column ) = @_;
    my $info = $self->result_source->column_info($column);
    return exists $info->{remove_column}
        ? $info->{remove_column}
        : 0;
 }

fetchable_columns

simply returns a list of columns that are fetchable.

Copyright and license

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

Releases

7 releases since Debian 7 (Wheezy); the text changed 6 times.

7
8
9
10
11
12
13