Re: [RDBO] Oracle username vs. schema

2006-02-28 Thread Ron Savage
On Wed, 01 Mar 2006 00:23:28 -0500, John Siracusa wrote: Hi John > It wouldn't, since no other Rose::DB driver class would return true > from its use_username_if_schema_is_undef_in_pk_info_calls() or > whatever crazy name I'd come up with :) Ahh, I see. That's fine by me. > Hm, okay. But what

Re: [RDBO] Docs for Metadata

2006-02-28 Thread Ron Savage
On Wed, 01 Mar 2006 00:05:02 -0500, John Siracusa wrote: Hi John > On 2/28/06 11:34 PM, Ron Savage wrote: >> When it says: "Here's a complete example..." how exactly do I >> tell the code to connect to a registry entry so as to read the >> metadata from the database? >> > > Er, tell what code? T

Re: [RDBO] Oracle username vs. schema

2006-02-28 Thread John Siracusa
On 3/1/06 12:03 AM, Ron Savage wrote: > I would not want code inside Rose to say the schema param to primary_key_info > (or any method, actually) comes from $self -> schema || $self -> username. > What about another vendor where it has to be undef, and schema is undef, and > username is set, as usu

Re: [RDBO] Oracle username vs. schema

2006-02-28 Thread Ron Savage
On Tue, 28 Feb 2006 22:44:48 -0500, John Siracusa wrote: Hi John > On 2/28/06 9:37 PM, Ron Savage wrote: >> The only call to primary_key_info I found is in >> Rose::DB::Object::Metadata::Auto, which will presumably just >> work, since it ultimately calls $db->schema, and the new docs >> will have

Re: [RDBO] Docs for Metadata

2006-02-28 Thread John Siracusa
On 2/28/06 11:34 PM, Ron Savage wrote: > When it says: "Here's a complete example..." how exactly do I tell the code to > connect to a registry entry so as to read the metadata from the database? Er, tell what code? The loader? A call to auto_initialize() from within a class? Something else? -

[RDBO] Docs for Metadata

2006-02-28 Thread Ron Savage
Hi John When it says: "Here's a complete example..." how exactly do I tell the code to connect to a registry entry so as to read the metadata from the database? -- Ron Savage [EMAIL PROTECTED] http://savage.net.au/index.html --- This SF.Net

Re: [RDBO] Oracle username vs. schema

2006-02-28 Thread John Siracusa
On 2/28/06 9:37 PM, Ron Savage wrote: > The only call to primary_key_info I found is in > Rose::DB::Object::Metadata::Auto, which will presumably just work, since it > ultimately calls $db->schema, and the new docs will have told the user to set > schema appropriately for Oracle, right? I really d

Re: [RDBO] Oracle username vs. schema

2006-02-28 Thread Ron Savage
On Tue, 28 Feb 2006 20:33:34 -0500, John Siracusa wrote: Hi John > "Any Rose::DB object method that sets a data source configuration > value is a valid parameter name." Well, yes, but it's been decades since I tried to memorize /all/ the documentation for a project. > Hm, I wonder if that's a f

Re: [RDBO] Oracle username vs. schema

2006-02-28 Thread John Siracusa
On 2/28/06 8:14 PM, Ron Savage wrote: > o If I want to set the schema I can do that in the call to > Rose::DB->register_db, just as I can with driver, database, etc, although I > have not yet found a Rose doc indicating this was possible http://search.cpan.org/dist/Rose-DB/lib/Rose/DB.pm#register_

Re: [RDBO] Oracle username vs. schema

2006-02-28 Thread Ron Savage
Hi Folks OK. I ran a series of tests: o If I want to set the schema I can do that in the call to Rose::DB->register_db, just as I can with driver, database, etc, although I have not yet found a Rose doc indicating this was possible o list_tables doesn't need a schema. All of: - undef

Re: [RDBO] Oracle username vs. schema

2006-02-28 Thread John Siracusa
On 2/28/06 10:58 AM, Rob Kinyon wrote: > On 2/28/06, John Siracusa <[EMAIL PROTECTED]> wrote: >> Okay, but what about the list_tables() situation? Should it pass the >> schema value or wildcard with %? > > Are you looking for all tables with that name in any schema that your > user has access to

Re: [RDBO] Oracle username vs. schema

2006-02-28 Thread Rob Kinyon
On 2/28/06, John Siracusa <[EMAIL PROTECTED]> wrote: > On 2/28/06 9:46 AM, Rob Kinyon wrote: > > Schema should default to username, but should be overridable. In other > > words, set it as normal, but in the intializer, set it to username if > > unset. > > Okay, but what about the list_tables() si

Re: [RDBO] Oracle username vs. schema

2006-02-28 Thread John Siracusa
On 2/28/06 9:46 AM, Rob Kinyon wrote: > Schema should default to username, but should be overridable. In other > words, set it as normal, but in the intializer, set it to username if > unset. Okay, but what about the list_tables() situation? Should it pass the schema value or wildcard with %? -

Re: [RDBO] Oracle username vs. schema

2006-02-28 Thread Rob Kinyon
On 2/28/06, John Siracusa <[EMAIL PROTECTED]> wrote: > Ron Savage is working on Oracle support for Rose::DB. He's currently > implicitly setting the schema() to the username(), but I'm not sure that's > such a great idea. Where we run into problems is in the list_tables() > method where the schem

Re: [RDBO] Object data as hash ref (was: cannot find sets that are clearly there)

2006-02-28 Thread John Siracusa
On 2/28/06 8:38 AM, Michael Lackhoff wrote: > which could already be written as: > > $form = MyPersonForm->new; # $form "isa" Rose::HTML::Form > $form->params($cgi->Vars); > $form->init_fields; > $person = $form->person_from_form; > > which isn't longer or less clear than the new params_f

Re: [RDBO] Object data as hash ref (was: cannot find sets that are clearly there)

2006-02-28 Thread Michael Lackhoff
On 28 Feb 2006 at 7:42, John Siracusa wrote: > What I was talking about was a convenience method to fill a Rose::HTML::Form > based on a CGI object. Then you'd use Rose::HTML::Form's existing > object_from_form() method to fill in the arbitrary object. Something like: Hmm, then I think it won'

[RDBO] Oracle username vs. schema

2006-02-28 Thread John Siracusa
Ron Savage is working on Oracle support for Rose::DB. He's currently implicitly setting the schema() to the username(), but I'm not sure that's such a great idea. Where we run into problems is in the list_tables() method where the schema arg apparently can't be left blank: $dbh->table_info($

Re: [RDBO] Object data as hash ref (was: cannot find sets that are clearly there)

2006-02-28 Thread John Siracusa
On 2/28/06 2:24 AM, [EMAIL PROTECTED] wrote: > On 27 Feb 2006 at 11:20, John Siracusa wrote: >> Yeah, I'll spell it out in the docs. Basically, all I need to for >> consumption by Rose::HTML::Form is build is a structure like this: > > Perhaps I misunderstood something here but I thought we are t