I keep getting an exception deep within sqlalchemy whenever I try to select a bit of aggregate data using the Session (I'm using SA 0.5.0rc2). For now, assume that my metadata/mappers are sensible, because I can't get over the thought that I'm just doing something simple wrong with the query, but if there's nothing obviously wrong here, I'll post mappers, etc
Python 2.4.2 (#1, Apr 13 2007, 16:09:19) [GCC 4.1.0 (SUSE Linux)] on linux2 Type "help", "copyright", "credits" or "license" for more information. >>> from clusterbank.model import * >>> from sqlalchemy import func >>> Session.query(Project).all()[0] <Project name='systems' id=1L> >>> Session.query(Project).join(Project.allocations, >>> Allocation.charges).all()[0] <Project name='earlytesting' id=485L> >>> Session.query(Project, func.count(Charge)).join(Project.allocations, >>> Allocation.charges).group_by(Charge.id).all() Traceback (most recent call last): File "<stdin>", line 1, in ? File "/gpfs/home/janderso/lib/python/SQLAlchemy-0.5.0rc2-py2.4.egg/ sqlalchemy/orm/query.py", line 1019, in first ret = list(self[0:1]) File "/gpfs/home/janderso/lib/python/SQLAlchemy-0.5.0rc2-py2.4.egg/ sqlalchemy/orm/query.py", line 944, in __getitem__ return list(res) File "/gpfs/home/janderso/lib/python/SQLAlchemy-0.5.0rc2-py2.4.egg/ sqlalchemy/orm/query.py", line 1078, in __iter__ return self._execute_and_instances(context) File "/gpfs/home/janderso/lib/python/SQLAlchemy-0.5.0rc2-py2.4.egg/ sqlalchemy/orm/query.py", line 1081, in _execute_and_instances result = self.session.execute(querycontext.statement, params=self._params, mapper=self._mapper_zero_or_none(), _state=self._refresh_state) File "/gpfs/home/janderso/lib/python/SQLAlchemy-0.5.0rc2-py2.4.egg/ sqlalchemy/orm/session.py", line 749, in execute return self.__connection(engine, close_with_result=True).execute( File "/gpfs/home/janderso/lib/python/SQLAlchemy-0.5.0rc2-py2.4.egg/ sqlalchemy/engine/base.py", line 848, in execute return Connection.executors[c](self, object, multiparams, params) File "/gpfs/home/janderso/lib/python/SQLAlchemy-0.5.0rc2-py2.4.egg/ sqlalchemy/engine/base.py", line 899, in execute_clauseelement return self._execute_compiled(elem.compile(dialect=self.dialect, column_keys=keys, inline=len(params) > 1), distilled_params=params) File "/gpfs/home/janderso/lib/python/SQLAlchemy-0.5.0rc2-py2.4.egg/ sqlalchemy/engine/base.py", line 908, in _execute_compiled context = self.__create_execution_context(compiled=compiled, parameters=distilled_params) File "/gpfs/home/janderso/lib/python/SQLAlchemy-0.5.0rc2-py2.4.egg/ sqlalchemy/engine/base.py", line 952, in __create_execution_context return self.engine.dialect.create_execution_context(connection=self, **kwargs) File "/gpfs/home/janderso/lib/python/SQLAlchemy-0.5.0rc2-py2.4.egg/ sqlalchemy/databases/mysql.py", line 1532, in create_execution_context return MySQLExecutionContext(self, connection, **kwargs) File "/gpfs/home/janderso/lib/python/SQLAlchemy-0.5.0rc2-py2.4.egg/ sqlalchemy/engine/default.py", line 167, in __init__ self.compiled_parameters = [compiled.construct_params(m) for m in parameters] File "/home/janderso/lib/python/SQLAlchemy-0.5.0rc2-py2.4.egg/ sqlalchemy/sql/compiler.py", line 211, in construct_params pd[self.bind_names[bindparam]] = bindparam.value() TypeError: __init__() takes exactly 3 arguments (1 given) >>> --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---