Dear list, I'm on SQLAlchemy 0.3.9 and SAContext 0.3.1 now with Pylons 0.9.6-rc1. A lot of knowledge is useless now that SQLAlchemy changed quite a few things regarding queries and Pylons doesn't have pylons.database any longer.
Currently I'm trying to get myself acquainted with a lot of syntax and wanted to use the "paster shell" to play around. But when using SAContext the way it's described (pydoc sacontext) I just get this error when I try to query the database: ************************************************************************* In [4]: model.sac.query(model.Contact).get(1) --------------------------------------------------------------------------- sqlalchemy.exceptions.InvalidRequestError Traceback (most recent call last) /home/chaas/projekte/pylons/phonebook/<ipython console> /usr/lib/python2.4/site-packages/sqlalchemy/orm/query.py in get(self, ident, **kwargs) 101 return ret 102 key = self.mapper.identity_key(ident) --> 103 return self._get(key, ident, **kwargs) 104 105 def load(self, ident, **kwargs): /usr/lib/python2.4/site-packages/sqlalchemy/orm/query.py in _get(self, key, ident, reload, lockmode) 945 try: 946 statement = self.compile(self._get_clause, lockmode=lockmode) --> 947 return self._select_statement(statement, params=params, populate_existing=reload, version_check=(lockmode is not None))[0] 948 except IndexError: 949 return None /usr/lib/python2.4/site-packages/sqlalchemy/orm/query.py in _select_statement(self, statement, params, **kwargs) 953 if params is None: 954 params = {} --> 955 return self.execute(statement, params=params, **kwargs) 956 957 def _should_nest(self, querycontext): /usr/lib/python2.4/site-packages/sqlalchemy/orm/query.py in execute(self, clauseelement, params, *args, **kwargs) 853 """ 854 --> 855 result = self.session.execute(self.mapper, clauseelement, params=params) 856 try: 857 return self.instances(result, **kwargs) /usr/lib/python2.4/site-packages/sqlalchemy/orm/session.py in execute(self, mapper, clause, params, **kwargs) 181 resources of the underlying ``Connection``, otherwise its a no-op. 182 """ --> 183 return self.connection(mapper, close_with_result=True).execute(clause, params, **kwargs) 184 185 def scalar(self, mapper, clause, params, **kwargs): /usr/lib/python2.4/site-packages/sqlalchemy/orm/session.py in connection(self, mapper, **kwargs) 168 return self.transaction.connection(mapper) 169 else: --> 170 return self.get_bind(mapper).contextual_connect(**kwargs) 171 172 def execute(self, mapper, clause, params, **kwargs): /usr/lib/python2.4/site-packages/sqlalchemy/orm/session.py in get_bind(self, mapper) 270 e = mapper.mapped_table.engine 271 if e is None: --> 272 raise exceptions.InvalidRequestError("Could not locate any Engine bound to mapper '%s'" % str(mapper)) 273 return e 274 InvalidRequestError: Could not locate any Engine bound to mapper 'Mapper|Contact|contacts' ************************************************************************* Using pylons.database it was formerly necessary to bind the metadata to an engine somehow using: model.meta.connect(model.session_context.current.bind_to) What should I do now with SAContext? Christoph --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "pylons-discuss" group. To post to this group, send email to pylons-discuss@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/pylons-discuss?hl=en -~----------~----~----~----~------~----~------~--~---