Hi everyone, I have a problem using the following code (with sqlalchemy 0.3.6 and python2.5):
mapperA = mapper(MyClass, self.tables['report_ia'], entity_name = 'REPIA', primary_key=[self.tables['report_ia'].c.id]) mapperB = mapper(MyClass, self.tables['report_ib'], entity_name = 'REPIB', primary_key=[self.tables['report_ib'].c.id]) customSelect = select( [ mapperA.c.id, mapperA.c.uid, func.count(mapperA.c.itemcount).label("itemcount"), ], mapperA.c.owner.in_( 'User' ) ), group_by=[mapperA.c.uid, mapperA.c.id] ).alias("totals") customMapper = mapper(MyClass, customSelect, entity_name = "temporary", primary_key = [ customSelect.c.id ], ) result = self.session.query(customMapper).select() clear_mapper(customMapper) Running that I get: Processing Failure c /usr/lib/python2.5/site-packages/sqlalchemy/orm/__init__.py:110:clear_mapper] What am I doing wrong here? Any help would be appreciated. Thanks, Kevin --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---