Re: [RDBO] serializing rose objects

2007-12-11 Thread Adrian Howard
On 7 Dec 2007, at 16:41, Ken wrote: Hello, I don't know if this exists already, but I needed a way to serialize an entire rose object tree into json. To do this, I created the below methods in my base Rose::DB::Object class. [snip] column_values_as_json() in Rose::DB::Object::Helpers ?

Re: [RDBO] unique_keys problem

2007-12-11 Thread Adam Prime
Now that i've slept i'm wondering if the underlying problem might be related to the way that defaults are handled in RDBO. That's one thing that differs between the tables used in the original tests and the table in the test i submitted. Adam [EMAIL PROTECTED] wrote: With this patch,

Re: [RDBO] unique_keys problem

2007-12-11 Thread John Siracusa
On Dec 11, 2007 8:57 AM, Adam Prime [EMAIL PROTECTED] wrote: Now that i've slept i'm wondering if the underlying problem might be related to the way that defaults are handled in RDBO. That's one thing that differs between the tables used in the original tests and the table in the test i

Re: [RDBO] unique_keys problem

2007-12-11 Thread adam . prime
Quoting John Siracusa [EMAIL PROTECTED]: Did you use the Loader to make these classes? MySQL tends to offer up empty string default values for non-null character columns, and the Loader dutifully reflects that, having no way to distinguish between legitimate empty string default values that

Re: [RDBO] unique_keys problem

2007-12-11 Thread John Siracusa
On Dec 11, 2007 10:49 AM, [EMAIL PROTECTED] wrote: Will do. It might be worth noting in the loader documentation that mysql does this, and how it affects loader, if it isn't already there (it's entirely possible i missed it). I added a brief gotchas section to the Loader docs in SVN. -John

[RDBO] Last chance to suggest a better name for undef_sets_null

2007-12-11 Thread John Siracusa
The undef_sets_null feature that alters the behavior of default columns values will almost certainly go out in the next release (which is coming soon). It may or may not be public (depending on if I have time to do docs and add support for it to the rest of the column types), but the code will be

[RDBO] Lazy Loading and Oracle?

2007-12-11 Thread Justin Ellison
Hi all, I was wondering if load_on_demand and Oracle was working on .765? I'm a newb of 24 hours, but I like what I see thus far! I'm just doing some testing, and I can't seem to get lazy loading to work with our Oracle db. My test script works fine up until I change one blob column to use

Re: [RDBO] Lazy Loading and Oracle?

2007-12-11 Thread John Siracusa
On Dec 11, 2007 12:35 PM, Justin Ellison [EMAIL PROTECTED] wrote: I was wondering if load_on_demand and Oracle was working on .765? Can you post a self-contained example script that reproduces the problem? I don't have an Oracle database readily available to test against, but lazy loading

Re: [RDBO] Lazy Loading and Oracle?

2007-12-11 Thread Justin Ellison
Can you post a self-contained example script that reproduces the problem? No, it works fine when I try to put it in a self-contained script ;-) Must be something I'm doing wrong in my subclasses. My bad, sorry for the noise! Justin