[SQLObject] suggestion: sqlbuilder magic query object accept foreign key

[Karl C. <qu...@no...>]

I request/suggest syntax sugar so that you can do this:
  k = OtherTable.get(123)
  MyTable.select(MyTable.q.other == k)
Instead of only:
  MyTable.select(MyTable.q.otherID == k.id)


Second, I am trying to add a hook so that I can do this:
  MyTable.select(OtherTable.q.foo == 123)
and have it automatically add an ID match to get:
  MyTable.select(AND( OtherTable.q.foo == 123,
                      MyTable.q.otherID == OtherTable.q.id))

any suggestions on how to do this?


-- 
Karl 2004-06-21 02:48