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 [email protected]
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
-~----------~----~----~----~------~----~------~--~---
