Class::DBI::Plugin::PseudoColumnsAn interface to use some pseudo columns. | |
Download |
Class::DBI::Plugin::PseudoColumns Ranking & Summary
Advertisement
- License:
- Perl Artistic License
- Price:
- FREE
- Publisher Name:
- Koichi Taniguchi
- Publisher web site:
- http://search.cpan.org/~taniguchi/HTML-Entities-Numbered-0.04/lib/HTML/Entities/Numbered.pm
Class::DBI::Plugin::PseudoColumns Tags
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