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:
keyword foo_id
train 1
trai 1
tra 1
tram 2
tra 2
...
One convenient way to approach this within
Rose::DB is to do nothing fancy at all, but just use normal foreign key
mechanisms, as per Rose::DB::Object::Tutorial
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 with a single request.
(And there is probably shorter syntax too?)
So then instead I'd need to define a join to do this efficiently?
Any suggestions?
-mda
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642
_______________________________________________
Rose-db-object mailing list
Rose-db-object@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/rose-db-object
