Re: [RDBO] New "find" method type for one-to-many relationships

2007-02-01 Thread Mike Schilli
On Tue, 30 Jan 2007, [ISO-8859-1] Ask Bj?rn Hansen wrote: > (although I sometimes get tripped up by forgetting by how ->new->load > needs unique keys). Me too. Does new->load to be restricted to unique keys? Couldn't there be a way to provide a query and call the manager under the hood to find, s

Re: [RDBO] New "find" method type for one-to-many relationships

2007-02-01 Thread John Siracusa
On 2/1/07 1:14 PM, Mike Schilli wrote > On Tue, 30 Jan 2007, [ISO-8859-1] Ask Bjørn Hansen wrote: >> (although I sometimes get tripped up by forgetting by how ->new->load >> needs unique keys). > > Me too. Does new->load to be restricted to unique keys? Yes, because each object is linked to a sin

Re: [RDBO] New "find" method type for one-to-many relationships

2007-02-01 Thread Mike Schilli
On Thu, 1 Feb 2007, John Siracusa wrote: > I question the wisdom of not supplying a sort_by paramater, however. You're right, in the general case, sort_by is essential, but often times, the application knows that there's either exactly one matching record in the database or none. It's something

Re: [RDBO] New "find" method type for one-to-many relationships

2007-02-01 Thread John Siracusa
On 2/1/07 2:03 PM, Mike Schilli wrote: > On Thu, 1 Feb 2007, John Siracusa wrote: >> I question the wisdom of not supplying a sort_by paramater, however. > > You're right, in the general case, sort_by is essential, but often > times, the application knows that there's either exactly one matching >

Re: [RDBO] New "find" method type for one-to-many relationships

2007-02-01 Thread Mike Schilli
On Thu, 1 Feb 2007, John Siracusa wrote: > Maybe you should share that information with the database... :) Ha :). I can think of 3 different scenarios: 1) Two columns of a table form a combined unique key, but neither of them can be defined UNIQUE(). 2) You have a "unique key" that spans sev

Re: [RDBO] New "find" method type for one-to-many relationships

2007-02-01 Thread John Siracusa
On 2/1/07 3:21 PM, Mike Schilli wrote: > 1) Two columns of a table form a combined unique key, but neither >of them can be defined UNIQUE(). Then you'd just define a unique key using those two columns: SQL: UNIQUE(col1, col2), RDBO: unique_key => [ 'col1', 'col2' ], > 2) You have a

[RDBO] MySQL driver support for multiple databases

2007-02-01 Thread Chris Jacobson
Hello RDBO list members! I am currently in the midst of converting our internal applications from using Class::DBI over to Rose::DB::Object. One of the first problems I encountered was needing support for multiple databases. In searching the list archives, I found a solution that was

Re: [RDBO] MySQL driver support for multiple databases

2007-02-01 Thread John Siracusa
On 2/1/07 4:03 PM, Chris Jacobson wrote: > *{ 'Rose::DB::MySQL::supports_schema' } = sub { 1 }; > > This suits my purposes for the time being, but it would be nice to see > this feature included in a future release of Rose::DB::MySQL. It likely will be. > I should also say that I have not done