From: David B. <db...@ge...> - 2001-10-19 23:42:19
|
On Fri, 19 Oct 2001, Michael G Schwern wrote: > On Fri, Oct 19, 2001 at 04:29:28PM -0600, David Block wrote: > > Remember me? The guy who posted to the list a couple of weeks ago and > > reinvented Class::DBI, etc? > > > > Well, I've got this feature, with defaults. :) I call it > > Feature::inMemory, and I use it for exactly the same purpose, except it's > > a bioinformatics app, and it's only now being released as open source. > > Could you explain how you do it? > Okay, I see now what you guys really want. I have defaults in Perl, not in the database, so it's not really there. Yes, that limits its usefulness for non-perl apps, or else requires you to repeat yourself... If you can't get defaults out of DBI any other way, inserting one row and reading it back, then deleting it would seem to be the way to go- I would do it way at object startup and store that-- Triggers could be bad news, you're right - How about a dummy row in the db that's left there, with only default values? Read that in at class definition time, and store those as class variables. Otherwise, a separate metadata store somewhere, accessible to all apps... There's some good ideas in here somewhere, but it's friday afternoon - have a good weekend, everyone! -- David Block db...@ge... http://bioinfo.pbi.nrc.ca/wiki NRC Plant Biotechnology Institute Saskatoon, SK, Canada |