Re: [RDBO] MySQL FK constraint breaking RDBO::Loader?

2007-06-20 Thread Peter Leonard
Ok, no wonder I couldn't create a dummy test case. What happened was this - I already had a number of rudimentary RDBO objects that I'd created manually. In this particular case, I had a table 'user' and a table 'company', with a FK relationship between user.company_id and company.company_id.

Re: [RDBO] cache object for later use within a mod_perl request cycle

2007-06-20 Thread Perrin Harkins
On 6/20/07, Michael Lackhoff <[EMAIL PROTECTED]> wrote: > Is this possible? I tried $r->dir_config(user_obj => $rdbo_user_obj); from > the mod_perl > documentation but that didn't work. I think you're looking for this: $r->pnotes(user_obj => $rdbo_user_obj); - Perrin ---

[RDBO] cache object for later use within a mod_perl request cycle

2007-06-20 Thread Michael Lackhoff
I am using Apache2::AuthCookie for my authentification and authorisation. For both I have to get the user record from the database. For authorisation I have to do an additional lookup for an ordinary item that is requested by the user. I need this record to check e.g. if the requested item and

Re: [RDBO] MySQL FK constraint breaking RDBO::Loader?

2007-06-20 Thread Peter Leonard
The problem is more that the schema I have is large enough that I was hoping to come up with a more straightforward example that properly demonstrated the issue. ;) Ovid wrote: > - Original Message > From: Peter Leonard <[EMAIL PROTECTED]> > >> I'm still trying to create a simple test

Re: [RDBO] MySQL FK constraint breaking RDBO::Loader?

2007-06-20 Thread Ovid
- Original Message From: Peter Leonard <[EMAIL PROTECTED]> > I'm still trying to create a simple test case to demonstrate it. It's > definitely related to the presence of foreign keys in the database, but > so far the stripped-down schemas I've built don't replicate the issue. Have yo

[RDBO] MySQL FK constraint breaking RDBO::Loader?

2007-06-20 Thread Peter Leonard
Hello all, So I've been working with Rose::DB::Object::Loader for the last two days, and I think I've found a bug with how foreign keys are handled with a MySQL 5.0 database (InnoDB tables). In short, when RDBO::Loader->make_classes() calls $meta->auto_initialize(), and a foreign key relation

Re: [RDBO] Classless Rose::DB::Objects

2007-06-20 Thread John Siracusa
On 6/19/07, mla <[EMAIL PROTECTED]> wrote: > Could you expand a bit on that first sentence? What's the purpose of the > SQL abstraction? It's to provide a structured, mutable representation of SQL, rather than trying to deal with it as a big, opaque string. > I wouldn't mind using SQL and then ju