Re: [RDBO] finding rows in A using keyword table AK?

2006-01-28 Thread Mark D. Anderson
> If you don't care about or don't expect duplicates, do this instead: > > $foos = > Foo::Manager->get_foos(fetch_only => [ 't1' ], >require_objects => [ 'keywords' ], >query => [ keyword => 'tra' ]); > > and the DISTIN

Re: [RDBO] finding rows in A using keyword table AK?

2006-01-28 Thread John Siracusa
On 1/28/06 3:30 PM, Mark D. Anderson wrote: > So then we'd have something like: > > my $foo_keyword_rows = MyPackage::FooKeyword->get_foo_keywords(query > => [keyword => 'tra']); > my $matching_foo_rows = [map {$_->foo()} @$foo_keyword_rows]; > > this is dumb because I'm not fetching them w

[RDBO] finding rows in A using keyword table AK?

2006-01-28 Thread Mark D. Anderson
For reasons I won't get into, I'm planning on creating keyword indexing tables with names like FooKeyword and BarKeyword for some tables Foo, Bar. The keyword tables will be like this: keywordfoo_id train 1 trai1 tra 1 tram 2 tra 2 ... O