logo
Free, unlimited AI code reviews that run on commit
git-lrc git-lrc GitHub Install Now We'd appreciate a star git-lrc - Free, unlimited AI code reviews that run on commit | Product Hunt git-lrc - Free, unlimited AI code reviews that run on commit | Product Hunt

DBIx::Class::Helper::ResultSet::AutoRemoveColumns - Automatically remove columns from a ResultSet

Author

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

Description

       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.

Name

       DBIx::Class::Helper::ResultSet::AutoRemoveColumns - Automatically remove columns from a ResultSet

Synopsis

        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');

See Also