Re: [RDBO] safe namespace for user data in rose objects ?

2007-03-01 Thread Ted Zlatanov
On Thu, 01 Mar 2007 11:01:05 -0800 [email protected] (Randal L. Schwartz) wrote: >> "Jonathan" == Jonathan Vanasco <[EMAIL PROTECTED]> writes: Jonathan> On Mar 1, 2007, at 11:30 AM, Ted Zlatanov wrote: Jonathan> so i've been caching results internally on the object, as such: RLS> You c

Re: [RDBO] safe namespace for user data in rose objects ?

2007-03-01 Thread Randal L. Schwartz
> "Jonathan" == Jonathan Vanasco <[EMAIL PROTECTED]> writes: Jonathan> On Mar 1, 2007, at 11:30 AM, Ted Zlatanov wrote: Jonathan> so i've been caching results internally on the object, as such: You could use an inside-out object approach. Create a table that is keyed by the RDBO-based objec

Re: [RDBO] safe namespace for user data in rose objects ?

2007-03-01 Thread Jonathan Vanasco
On Mar 1, 2007, at 11:30 AM, Ted Zlatanov wrote: > TZ> You could use a TEMP column. I don't know if it can be used to > store > TZ> arbitrary data, but I don't remember such a limitation when I > looked > TZ> at the code. I hope I understood what you are asking. > caveat: this just stores

Re: [RDBO] safe namespace for user data in rose objects ?

2007-03-01 Thread Ted Zlatanov
On Thu, 01 Mar 2007 09:44:37 -0500 Ted Zlatanov <[EMAIL PROTECTED]> wrote: TZ> On Wed, 28 Feb 2007 19:47:54 -0500 Jonathan Vanasco <[EMAIL PROTECTED]> wrote: JV> would it be possible to reserve a namespace within rose db objects JV> for user use? JV> i need to cache some calculated data in a

Re: [RDBO] safe namespace for user data in rose objects ?

2007-03-01 Thread John Siracusa
On 3/1/07 9:57 AM, Jonathan Vanasco wrote: > i'm actually doing reverse dns now -- as there are some things i've > considered submitting as patches or releasing via svn , and that made > sense -- but i just thought it might make sense if theres a > documented area or prefix ( even that ) for people

Re: [RDBO] safe namespace for user data in rose objects ?

2007-03-01 Thread Randal L. Schwartz
> "John" == John Siracusa <[EMAIL PROTECTED]> writes: John> Or just pick a unique name, which isn't too hard. For example, I really John> doubt anyone else will use the key "jonathan_vanasco" :) /me quickly and quietly changes his code :-) -- Randal L. Schwartz - Stonehenge Consulting Ser

Re: [RDBO] safe namespace for user data in rose objects ?

2007-03-01 Thread Jonathan Vanasco
On Mar 1, 2007, at 8:36 AM, John Siracusa wrote: > Or just pick a unique name, which isn't too hard. For example, I > really > doubt anyone else will use the key "jonathan_vanasco" :) If that's > to silly > for you, the "adult" equivalent it reverse-DNS style: > "com.mysite.rdbo", > where

Re: [RDBO] safe namespace for user data in rose objects ?

2007-03-01 Thread Ted Zlatanov
On Wed, 28 Feb 2007 19:47:54 -0500 Jonathan Vanasco <[EMAIL PROTECTED]> wrote: JV> would it be possible to reserve a namespace within rose db objects JV> for user use? JV> i need to cache some calculated data in an object for use over JV> multiple calls You could use a TEMP column. I don't

Re: [RDBO] MySQL SET columns not checking values()?

2007-03-01 Thread Adrian Howard
On 1 Mar 2007, at 13:44, John Siracusa wrote: > On 3/1/07 7:03 AM, Adrian Howard wrote: >> I've got some SET columns which RDBO seems to be parsing fine, since >> the column() values() are set okay, but it accepts things that aren't >> in values(). Bug? Expected behaviour? > > Bug, now fixed in S

Re: [RDBO] MySQL SET columns not checking values()?

2007-03-01 Thread John Siracusa
On 3/1/07 7:03 AM, Adrian Howard wrote: > I've got some SET columns which RDBO seems to be parsing fine, since > the column() values() are set okay, but it accepts things that aren't > in values(). Bug? Expected behaviour? Bug, now fixed in SVN. Thanks for the report. -John --

Re: [RDBO] safe namespace for user data in rose objects ?

2007-03-01 Thread John Siracusa
On 3/1/07 5:30 AM, Adrian Howard wrote: > On 1 Mar 2007, at 00:47, Jonathan Vanasco wrote: >> would it be possible to reserve a namespace within rose db objects >> for user use? > [snip] > > Using one of the inside-out object classes is one way around this. I > use Class::BuildMethods. Or just pi

Re: [RDBO] Complex update, need hand coded SQL?

2007-03-01 Thread John Siracusa
On 2/28/07 7:42 PM, Fred Cox wrote: > I haven't seen anything that indicates I can use a > subselect in the set clause of RDBOM->update_table. Yeah, there's no real support for subselects except as literals, and even that only seems to work in the where clause due to a bug. I'll try to fix the bu

Re: [RDBO] inflating/deflating columns using mysql functions

2007-03-01 Thread John Siracusa
On 2/28/07 7:39 PM, Michael Reece wrote: > On Feb 28, 2007, at 2:13 PM, Michael Reece wrote: >> this looks very promising! but what args are passed to select_sql, >> etc? [...] Right now, the args are the column metadata object, the db object, and the table name. > any suggestions on how to get

[RDBO] MySQL SET columns not checking values()?

2007-03-01 Thread Adrian Howard
I've got some SET columns which RDBO seems to be parsing fine, since the column() values() are set okay, but it accepts things that aren't in values(). Bug? Expected behaviour? Currently I'm wrapping my set columns with the moral equivalent of: sub some_column { my $self = shift; if

Re: [RDBO] safe namespace for user data in rose objects ?

2007-03-01 Thread Adrian Howard
On 1 Mar 2007, at 00:47, Jonathan Vanasco wrote: > would it be possible to reserve a namespace within rose db objects > for user use? [snip] Using one of the inside-out object classes is one way around this. I use Class::BuildMethods. Adrian --