Re: [RDBO] missing add_ for relationship?

2007-01-16 Thread John Siracusa
On 1/15/07, Praveen Ray <[EMAIL PROTECTED]> wrote: > create table products ( > idSERIAL PRIMARY KEY, > product_rating VARCHAR(100) > ); > > create table product_details ( > product_detail_id SERIAL PRIMARY KEY, > product_id INTEGER NOT NULL REFEREN

Re: [RDBO] conditional relationships

2007-01-16 Thread John Siracusa
On 1/15/07, Cory Bennett <[EMAIL PROTECTED]> wrote: > Ahh, found the magic. > In Rose::DB::Object::Metadata::Relationship::OneToMany I found the special > (but buried) 'query_args' variable. So this will do what I want: > relationships => [ > prices => { > type => 'on

[RDBO] ANNOUNCE: Rose::DB::Object 0.760 released

2007-01-16 Thread John Siracusa
Fixed a broken test; no code changes. -John 0.760 (01.16.2007) - John Siracusa <[EMAIL PROTECTED]> * Fixed a mistake in the test suite that caused spurious failures when testing against Pg without the CHKPASS column type installed. (Reported by Randal Schwartz) -

Re: [RDBO] conditional relationships

2007-01-16 Thread Ted Zlatanov
On 16 Jan 2007, [EMAIL PROTECTED] wrote: > On 1/15/07, Cory Bennett <[EMAIL PROTECTED]> wrote: > > Ahh, found the magic. > > In Rose::DB::Object::Metadata::Relationship::OneToMany I found the special > > (but buried) 'query_args' variable. So this will do what I want: > > relationships => [ >

Re: [RDBO] automatically create separate get_ and set_ methods for columns

2007-01-16 Thread Jud
Praveen Ray wrote: > I tried doing as you suggested..it all works fine except when I do this: > > my $new_product = Product->new(product_id => 100); > > above line dies with : > died: Can't locate object method "product_id" via package "t::Product" > at /usr/lib/perl5/site_perl/5.8.6/Rose/DB/Ob

Re: [RDBO] ANNOUNCE: Rose::DB::Object 0.759 released

2007-01-16 Thread Jonathan Vanasco
On Jan 15, 2007, at 2:38 PM, John Siracusa wrote: > Also, for anyone currently "stuffing" Rose::DB objects with $dbh > database handles pulled from elsewhere, your life is a lot easier now > that you can construct Rose::DB objects *without* having to register > any data sources. Where in the doc

Re: [RDBO] ANNOUNCE: Rose::DB::Object 0.759 released

2007-01-16 Thread John Siracusa
On 1/16/07, Jonathan Vanasco <[EMAIL PROTECTED]> wrote: > On Jan 15, 2007, at 2:38 PM, John Siracusa wrote: > > Also, for anyone currently "stuffing" Rose::DB objects with $dbh > > database handles pulled from elsewhere, your life is a lot easier now > > that you can construct Rose::DB objects *wit

Re: [RDBO] missing add_ for relationship?

2007-01-16 Thread Praveen Ray
- Original Message From: John Siracusa <[EMAIL PROTECTED]> >I suspect that if you put "use t::MoreProductDetail;" and "use >t::ProductDetail" in Product.pm, the call to auto_initialize() will >create the relationships you expect. >To avoid having to manually use() related modules, cons

[RDBO] hi Rose::DB developers, quick design question (if i may...)

2007-01-16 Thread Neal Clark
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Feel free to redirect me to another list. I am only posting/writing this here because y'all have been so helpful in the past, and the guys that write Rose::DB are definitely database experts in my opinion. Plus this is the only database list I am