Class::DBI::Plugin::PseudoColumns An interface to use some pseudo columns.
Download

Class::DBI::Plugin::PseudoColumns Ranking & Summary

Class::DBI::Plugin::PseudoColumns Tags

perl Perl interface columns pseudo columns pseudo

Class::DBI::Plugin::PseudoColumns Description

An interface to use some pseudo columns. Class::DBI::Plugin::PseudoColumns is a Perl interface to use some pseudo columns.SYNOPSIS package Music::CD; use base 'Music::DBI'; Music::CD->table('cd'); Music::CD->columns(All => qw/cdid artist title year reldate properties/); use Class::DBI::Plugin::PseudoColumns; Music::CD->pseudo_columns(properties => qw/asin tag/); use Music::CD; my $cds = Music::CD->search(artist => 'Steve Vai'); while (my $cd = $cds->next) { if ($cd->title =~ /^Reals+Illusions/i) { $cd->asin('B0007GADZO'); } $cd->tag(); $cd->update; } my $bought_cd = Music::CD->create({ artist => 'Rolling Stones', title => 'A Bigger Bang', year => 2005, reldate => '2005-11-22', asin => 'B000BP86LE', tag => , }); $bought_cd->set( artist => 'The Rolling Stones', title => 'A Bigger Bang - Special Edition', ); $bought_cd->update;This module provides an easy way to use pseudo column in your Class::DBI based table classes. The ``pseudo column'' means a kind of column that is including an optical hashref string (via Data::Dumper, by default). You can get and set with using the pseudo column accessors (same as always). But, you can't use the columns' name into your SQL, SQL interfaced methods, ORDER BY clause and GROUP BY clause, etc. This module is useful when you'd like to add an unimportant column without issuing ALTER TABLE, and when you'd like to have related multiple data without normalizing table. Requirements: · Perl

Class::DBI::Plugin::PseudoColumns Related Software