> these are the valid comparisons: > > print AB.this == A() mmh. i want these to be clauses, not plain comparisons i.e. AB.this==A.dbid --- same as tableAB.c.this==tableA.c.dbid instead it produces something like :param_1 = "AB".this_id
> print AB.this_id == A.name and.. why this way works and the other way not? and same thing as above, this is not the clause i expect. > On Jun 10, 2008, at 8:32 AM, [EMAIL PROTECTED] wrote: > > funny... just a plain relation, i've removed all the assoc > > stuff... what i am missing??? > > > > here the case, attached. > > no matter what, i doesnot work; older sa versions give different > > error... > > > > On Tuesday 10 June 2008 16:59:01 Michael Bayer wrote: > >> manytoone should be fine. try making a simplified test case > >> (just any old many to one). > >> > >> On Jun 10, 2008, at 9:39 AM, [EMAIL PROTECTED] wrote: > >>> g'day. > >>> i stepped on strange behavour (0.4 latest): > >>> class AB is an assoc proxy, .myb pointing to B; > >>> the clause > >>> AB.myb == B.dbid > >>> fails with NotImplementedError: > >>> File "sqlalchemy/sql/expression.py", line 1191, in __eq__ > >>> return self.operate(operators.eq, other) > >>> File "sqlalchemy/sql/expression.py", line 1315, in operate > >>> return o[0](self, op, other[0], *o[1:], **kwargs) > >>> File "sqlalchemy/sql/expression.py", line 1277, in __compare > >>> obj = self._check_literal(obj) > >>> File "sqlalchemy/sql/expression.py", line 1421, in > >>> _check_literal return other.expression_element() > >>> File "sqlalchemy/orm/attributes.py", line 53, in > >>> expression_element return self.comparator.expression_element() > >>> File "sqlalchemy/orm/interfaces.py", line 432, in > >>> expression_element return self.clause_element() > >>> File "sqlalchemy/sql/expression.py", line 1170, in > >>> clause_element raise NotImplementedError() > >>> NotImplementedError > >>> > >>> these work (not the .property): > >>> AB.myb.property == B.dbid > >>> AB.myb == 3 > >>> > >>> AB.myb.property.direction is MANYTOONE > >>> seems i'm missing something?? > >>> any idea or prepare a test case? > >>> svilen > > > > <aa.py> > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---