Login or Register to Ask a Question and Join Our Community

Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

dbix::class::helper::row::storagevalues(3pm) [debian man page]

DBIx::Class::Helper::Row::StorageValues(3pm)		User Contributed Perl Documentation	      DBIx::Class::Helper::Row::StorageValues(3pm)

NAME

       DBIx::Class::Helper::Row::StorageValues - Keep track of stored vs in-memory row values

VERSION

       version 2.013002

SYNOPSIS

	package MyApp::Schema::Result::BlogPost;

	use parent 'DBIx::Class::Core';

	__PACKAGE__->load_components(qw(Helper::Row::StorageValues));

	__PACKAGE__->table('BlogPost');
	__PACKAGE__->add_columns(
	   id => {
	      data_type 	=> 'integer',
	      is_auto_increment => 1,
	   },
	   title => {
	      data_type 	 => 'varchar',
	      length		 => 32,
	      keep_storage_value => 1,
	   },
	   body => {
	      data_type => 'text',
	   },
	);

	1;

	# elsewhere:

	my $post = $blog_rs->create({
	  title => 'Components for fun and profit',
	  body	=> '...',
	});

	$post->title('Components for fun');

	warn sprintf 'Changing title from %s to %s',
	  $post->storage_value('title'), $post->title;

	$post->update;

DESCRIPTION

       This component keeps track of the value for a given column in the database.  If you change the column's value and do not call "update", the
       "storage_value" will be different; once "update" is called the "storage_value" will be set to the value of the accessor.  Note that the
       fact that it uses the accessor is an important distinction.  If you are using DBIx::Class::FilterColumn or DBIx::Class::InflateColumn it
       will get the non-storage or inflated values, respectively.

METHODS

   _has_storage_value
	$self->_has_storage_value('colname')

       returns true if we should store the storage value from the database.  Override this if you'd like to enable storage on all integers or
       something like that:

	sub _has_storage_value {
	   my ( $self, $column ) = @_;

	   my $info = $self->column_info($column);

	   return defined $info->{data_type} && $info->{data_type} eq 'integer';
	}

   storage_value_columns
	$self->storage_value_columns

       returns a list of columns to store

   get_storage_value
	$self->get_storage_value('colname')

       returns the value for that column which is in storage

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::Row::StorageValues(3pm)

Check Out this Related Man Page

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

NAME

       DBIx::Class::Helper::ResultSet::Random - Get random rows from a ResultSet

VERSION

       version 2.013002

SYNOPSIS

	# note that this is normally a component for a ResultSet
	package MySchema::ResultSet::Bar;

	use strict;
	use warnings;

	use parent 'DBIx::Class::ResultSet';

	__PACKAGE__->load_components('Helper::ResultSet::Random');

	# in code using resultset:
	my $random_row	= $schema->resultset('Bar')->rand->single;

DESCRIPTION

       This component allows convenient selection of random rows.  See "NOTE" in DBIx::Class::Helper::ResultSet for a nice way to apply it to your
       entire schema.

       Currently this works by doing something akin to

	SELECT TOP($x) from $table ORDER BY RANDOM()

       Lots of people think this is slow.  My own benchmarks show that doing the above, for 10 rows in a table with just over 8 million rows, is
       nearly instant.	Although that was with SQL Server, and different databases will handle that differently.

       So please, if you have performance issues and want this to work with your database, get in touch and I will do what I can to get it to work
       quickly enough to suite your needs.

METHODS

   rand
       This method takes a single argument, being the size of the random ResultSet to return.  It defaults to 1.  This Component will throw
       exceptions if the argument is not an integer or not greater than zero.

   _rand_order_by
       This module currently does an "ORDER BY" on some db specific function.  If for some reason it guesses incorrectly for your database the
       easiest way to fix that in the short-term (ie without patching upstream) is to override this method.  So for example, if your db uses
       "RAND()" instead of "RANDOM()" and it's not in the predefined list of dbs you could just do the following in your ResultSet class:

	sub _rand_order_by { 'RAND()' }

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::Random(3pm)
Man Page