Beefy Boxes and Bandwidth Generously Provided by pair Networks Joe
go ahead... be a heretic
 
PerlMonks  

Class::DBI --> usage of group Others in __PACKAGE__->columns

by Mask (Pilgrim)
on Aug 25, 2005 at 14:54 UTC ( #486575=perlquestion: print w/ replies, xml ) Need Help??
Mask has asked for the wisdom of the Perl Monks concerning the following question:

Dear monks. I have a question related to Class::DBI package. Is it usefull to declare all fields in __PACKAGE__->columns? I've declared primary keys and essential fields, that I am using. 
__PACKAGE__->columns( Primary => qw{pk1});
__PACKAGE__->columns( Essential => qw{f1 f2 f3});

[download]
Do I need to declare the rest of fields. Is it usefull if i am not using them for anything? 
__PACKAGE__->columns( Others => qw{of1 of2 of3});

[download]

Comment on Class::DBI --> usage of group Others in __PACKAGE__->columns
Select or Download Code
Re: Class::DBI --> usage of group Others in __PACKAGE__->columns
by davidrw (Prior) on Aug 25, 2005 at 15:04 UTC
    Shouldn't need to declare them at all if never used. The one caveat though would be to make sure that an INSERT statement can succeed without them -- e.g. if of1 is a NOT NULL column and does not have a default, then __PACKAGE__->create() statements are going to bomb.
[reply]
[d/l]
[select]
      Thank you, davidrw. I am only reading from the database, no inserts or updates. Anyway, in case of some unexpected behaviour, I'll know where the problem can be. Thank you.
[reply]

Back to Seekers of Perl Wisdom

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://486575]
Approved by holli
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (5)
As of 2013-05-25 20:49 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The best material for plates (tableware) is:









    Results (520 votes), past polls