On 5/3/06 7:41 PM, Guillermo Roditi wrote:
> SQL definitions are at the bottom if i am not clear enough....
> 
> yeah, i am basically trying to do a view, but myISAM doesnt support it [...]
> 
> I baiscally want the different types of property vlues to be as transparent
> to the interface as possible so i can load() a ::User  with=>
> 'prop_values' and it automatically gets both binary type vvalues and
> character type values.

A prop_values view is the cleanest solution.  Any chance you can upgrade to
Postgres? :)  Failing that, you could probably make a new relationship type
for this "pull values from many different tables depending on a column value
in another table" relationship, but I'm not sure how general-purpose it'd
be.

And in the end, your custom relationship would be running exactly the same
database queries that you'll run if you do it "manually" using Manager
queries and/or multiple standard relationships under the covers.  If you
want the load(with => ...) magic to work too, just override load(), rummage
through the with => ... arguments, and do whatever you need to to before
passing control on to the base class load().

-John




-------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Rose-db-object mailing list
Rose-db-object@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/rose-db-object

Reply via email to