Could someone please explain the following behaviour: from django.http import HttpResponseRedirect, Http404 from django.shortcuts import render_to_response from df.tst import Path as ThePath from sqlalchemy import * from sqlalchemy.orm import * metadata = MetaData() u_table = Table('auth_user', metadata, \ Column('id', Integer, primary_key=True), \ Column('username', String(30)))
f_table = Table('fellowship_file', metadata, \ Column('id', Integer, primary_key=True), \ Column('user_id', None, ForeignKey("auth_user.id")), \ Column('ls', PickleType, nullable=False)) class User(object): pass class Path(ThePath): pass clear_mappers() mapper(User, u_table) mapper(Path, f_table) db = create_engine('...') metadata.create_all(db) context = create_session(bind=db) def ls(request, user=None): if not user: raise Http404 stuff = context.query(Path).filter(User.c.username==user).first() context.clear() context.close() return render_to_response('index.html', {'ls': stuff.id}) Traceback (most recent call last): File "/usr/lib/python2.4/site-packages/django/core/handlers/base.py" in get_response 77. response = callback(request, *callback_args, **callback_kwargs) File "/home/grey/src/df/fs/views.py" in ls 37. stuff = context.query(Path).filter(User.c.username==user).first() File "/usr/lib/python2.4/site-packages/sqlalchemy/orm/query.py" in first 920. ret = list(self[0:1]) File "/usr/lib/python2.4/site-packages/sqlalchemy/orm/query.py" in __iter__ 958. return iter(self.select_whereclause()) File "/usr/lib/python2.4/site-packages/sqlalchemy/orm/query.py" in select_whereclause 359. return self._select_statement(statement, params=params) File "/usr/lib/python2.4/site-packages/sqlalchemy/orm/query.py" in _select_statement 1072. return self.execute(statement, params=params, **kwargs) File "/usr/lib/python2.4/site-packages/sqlalchemy/orm/query.py" in execute 973. return self.instances(result, **kwargs) File "/usr/lib/python2.4/site-packages/sqlalchemy/orm/query.py" in instances 1032. self.select_mapper._instance(context, row, result) File "/usr/lib/python2.4/site-packages/sqlalchemy/orm/mapper.py" in _instance 1497. self.populate_instance(context, instance, row, identitykey, isnew) File "/usr/lib/python2.4/site-packages/sqlalchemy/orm/mapper.py" in populate_instance 1534. prop.execute(selectcontext, instance, row, identitykey, isnew) File "/usr/lib/python2.4/site-packages/sqlalchemy/orm/interfaces.py" in execute 163. self._get_context_strategy(selectcontext).process_row(selectcontext, instance, row, identitykey, isnew) File "/usr/lib/python2.4/site-packages/sqlalchemy/orm/strategies.py" in process_row 39. instance.__dict__[self.key] = row[self.columns[0]] File "/usr/lib/python2.4/site-packages/sqlalchemy/engine/base.py" in __getitem__ 1171. return self.__parent._get_col(self.__row, key) File "/usr/lib/python2.4/site-packages/sqlalchemy/engine/base.py" in _get_col 993. return rec[1].convert_result_value(row[rec[2]], self.dialect) File "/usr/lib/python2.4/site-packages/sqlalchemy/types.py" in convert_result_value 323. return self.pickler.loads(str(buf)) AttributeError at /users/grey/ 'module' object has no attribute 'Path' P.S. This is working without django. P.P.S. Django community is assured that this problem is not related to django in any sense. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---