Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change

Re: Re: Getting HASHES out of Class::DBI

by rkg (Hermit)
on Jan 07, 2004 at 04:12 UTC ( #319345=note: print w/replies, xml ) Need Help??

in reply to Re: Getting HASHES out of Class::DBI
in thread Getting HASHES out of Class::DBI

Just to clarify, what castaway is proposing is to use Ima::DBI methods, in effect skipping Class::DBI. That approach is fine, but it really just sort of skips the power of Class::DBI.

Class::DBI is about getting to your data using methods, not raw hash entries. If you do need to populate a hash (say to pass off to a templating system), then I'd explicitly show the mapping in the code:

# untested code my %hash = (name => lc $user->name, address => $user->address, groupname => $user->group->name);
In this snippet, you can see I changed the case of the name, and grabbed additional data for the template from another table with an implicit (hidden) join via Class::DBI. (I'm assuming the User class and the Group class were defined with a Class::DBI "has-a" relationship.)

Chaining method calls like this can be very powerful and time-saving.

On the other hand, if you really have 100s of fields in a table, and just want to punt them all over to a hash to go raw into a template system, then I'd suggest subclassing Class::DBI to add the "hashy" function (or an equivalent) offered below.

You'd add the code in one place, and have it in all your Class::DBI::WithHashy classes:

# untested code my %hash = $user->hashy; # pump all the fields into a hash

I'm a fan of Class::DBI, I guess.

Best of luck


Log In?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://319345]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others browsing the Monastery: (2)
As of 2023-06-01 14:59 GMT
Find Nodes?
    Voting Booth?

    No recent polls found