I am changing my model to using "declarative".
I am getting an exception "bool' object has no attribute
'__visit_name__'" (full exception below) which was relatively difficult
for me to trace down.
The bool exception I get when I change this:
vrecingrwfit = sao.relation('Vrecingrwfit', primaryjoin=
(__table__.c.recipeid=='vrecingrwfit.fk_recipeid'),
passive_deletes=True)
to this:
vrecingrwfit = sao.relation('Vrecingrwfit', primaryjoin=
('Recipe.recipeid'=='vrecingrwfit.fk_recipeid'),
passive_deletes=True)
It happens as I did not define the primaryjoin correctly.
Correcting it to one string, i.e. removing the middle quotes fixed it:
vrecingrwfit = sao.relation('Vrecingrwfit', primaryjoin=
('Recipe.recipeid==vrecingrwfit.fk_recipeid'),
passive_deletes=True)
May I suggest to change/improve the exception, i.e. give some pointer
where in the model the problem is.
Werner
Traceback (most recent call last):
File "saTest.py", line 42, in <module>
x = session.query(dbmin.Prefminimal).get(1)
File
"c:\python25\lib\site-packages\sqlalchemy-0.5.0beta1-py2.5.egg\sqlalchemy\orm\session.py",
line 894, in query
return self._query_cls(entities, self, **kwargs)
File
"c:\python25\lib\site-packages\sqlalchemy-0.5.0beta1-py2.5.egg\sqlalchemy\orm\query.py",
line 97, in __init__
self.__setup_aliasizers(self._entities)
File
"c:\python25\lib\site-packages\sqlalchemy-0.5.0beta1-py2.5.egg\sqlalchemy\orm\query.py",
line 111, in __setup_aliasizers
mapper, selectable, is_aliased_class = _entity_info(entity,
ent.entity_name)
File
"c:\python25\lib\site-packages\sqlalchemy-0.5.0beta1-py2.5.egg\sqlalchemy\orm\util.py",
line 398, in _entity_info
mapper = class_mapper(entity, entity_name, compile)
File
"c:\python25\lib\site-packages\sqlalchemy-0.5.0beta1-py2.5.egg\sqlalchemy\orm\util.py",
line 488, in class_mapper
mapper = mapper.compile()
File
"c:\python25\lib\site-packages\sqlalchemy-0.5.0beta1-py2.5.egg\sqlalchemy\orm\mapper.py",
line 370, in compile
mapper.__initialize_properties()
File
"c:\python25\lib\site-packages\sqlalchemy-0.5.0beta1-py2.5.egg\sqlalchemy\orm\mapper.py",
line 391, in __initialize_properties
prop.init(key, self)
File
"c:\python25\lib\site-packages\sqlalchemy-0.5.0beta1-py2.5.egg\sqlalchemy\orm\interfaces.py",
line 378, in init
self.do_init()
File
"c:\python25\lib\site-packages\sqlalchemy-0.5.0beta1-py2.5.egg\sqlalchemy\orm\properties.py",
line 510, in do_init
self._determine_synchronize_pairs()
File
"c:\python25\lib\site-packages\sqlalchemy-0.5.0beta1-py2.5.egg\sqlalchemy\orm\properties.py",
line 605, in _determine_synchronize_pairs
eq_pairs = criterion_as_pairs(self.primaryjoin,
consider_as_foreign_keys=self._foreign_keys, any_operator=self.viewonly)
File
"c:\python25\lib\site-packages\sqlalchemy-0.5.0beta1-py2.5.egg\sqlalchemy\sql\util.py",
line 268, in criterion_as_pairs
visitors.traverse(expression, {}, {'binary':visit_binary})
File
"c:\python25\lib\site-packages\sqlalchemy-0.5.0beta1-py2.5.egg\sqlalchemy\sql\visitors.py",
line 123, in traverse
return traverse_using(iterate(obj, opts), obj, visitors)
File
"c:\python25\lib\site-packages\sqlalchemy-0.5.0beta1-py2.5.egg\sqlalchemy\sql\visitors.py",
line 115, in traverse_using
meth = visitors.get(target.__visit_name__, None)
AttributeError: 'bool' object has no attribute '__visit_name__'
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
