Re: [RDBO] multi-object help sought

2006-09-11 Thread Jonathan Vanasco
thanks a ton. i guess i was thinking too much in sql terms-- i had to add a bunch more relationships as rose metadata > The Manager interface is designed to allow people to think only in > terms of > objects and relationships. If you think in SQL instead, you just > need to > know what SQL

Re: [RDBO] Extending QueryBuilder to accept Postgresql style regex-es

2006-09-11 Thread John Siracusa
On 9/11/06 5:30 AM, Lucian Dragus wrote: > Because Pg does not support the REGEXP keyword, will be great if you can add > in QueryBuilder, specially for Pg, the ~, ~* and SIMILAR TO comparison > operators . It is only a small addition :) > > (patch for QueryBuilder v.0.75): Applied, thanks. -Joh

Re: [RDBO] multi-object help sought

2006-09-11 Thread John Siracusa
On 9/11/06 4:04 AM, Jonathan Vanasco wrote: > i've spent the past 4hours trying to coerce some sql into Rose, and > its not working. perhaps someone here can point me in the right > direction. > > My SQL is such: > SELECT > account.* , > wants_item.*, > item.* > FROM > account2item_has has_item >

[RDBO] Extending QueryBuilder to accept Postgresql style regex-es

2006-09-11 Thread Lucian Dragus
Hi John, Because Pg does not support the REGEXP keyword, will be great if you can add in QueryBuilder, specially for Pg, the ~, ~* and SIMILAR TO comparison operators . It is only a small addition :) (patch for QueryBuilder v.0.75): === --- site_perl/Rose/DB/Object/

[RDBO] multi-object help sought

2006-09-11 Thread Jonathan Vanasco
i've spent the past 4hours trying to coerce some sql into Rose, and its not working. perhaps someone here can point me in the right direction. My SQL is such: SELECT account.* , wants_item.*, item.* FROM account2i