On Feb 6, 2007, at 8:15 PM, Matt Schnitz wrote:
> There was a conversation back in September about left outer joins
> with additional where criteria:
> http://sourceforge.net/mailarchive/message.php?msg_id=34475671
>
> I was wondering if any progress had been made on the issue since
> then, or whether there are any new features we could use for
> dealing with this case.
>
> Also, I wanted to say I (partially) disagree with, or don't
> understand, the part that "it's okay to have a variety of
> conditions, but they each require a new named relationship". In a
> strict relational model, yeah, you're right. But left outers, even
> NULLs, have always been in the gray never-never land between pure
> relational algebra and hacked-up real-world database software.
>
> I tend not to think about the additional clauses in the left outers
> as a new named relationship. They're more a kind of data-driven
> relationship. Admitted, I know jack about your architecture, but
> maybe a generics/template model will satisfy the design?
>
Two suggestions:
a- use the OUTER: INNER: blocking like suggested in my example to
merge multiple managers. other archives have better formatting.
I've actually never needed to use labels on loops before, but in this
case they clarify things a lot
b- create a view on your db and a new rose class + manager to
represent it. migrate the functions you need to a mixin class and
inherit.
i use both, a lot. its not as nice as having more control, but it
works well.
// Jonathan Vanasco
| - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - - - - - - - - - - - - -
| SyndiClick.com
| - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - - - - - - - - - - - - -
| FindMeOn.com - The cure for Multiple Web Personality Disorder
| Web Identity Management and 3D Social Networking
| - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - - - - - - - - - - - - -
| RoadSound.com - Tools For Bands, Stuff For Fans
| Collaborative Online Management And Syndication Tools
| - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - - - - - - - - - - - - -
-------------------------------------------------------------------------
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
