Yes, the error was reproduced.
I'm using 0.4.7.
I couldn't import Session, any particular reason you imported it?
Here's the output, it seems to get the entry just fine: (I only get one
entry by id to minimize the output)
2012-02-27 16:19:37,080 INFO sqlalchemy.engine.base.Engine.0x..cL SHOW
VARIABLES LIKE 'sql_mode'
2012-02-27 16:19:37,080 INFO sqlalchemy.engine.base.Engine.0x..cL
{'charset': None}
2012-02-27 16:19:37,081 INFO sqlalchemy.engine.base.Engine.0x..cL DESCRIBE
`projects`
2012-02-27 16:19:37,081 INFO sqlalchemy.engine.base.Engine.0x..cL {}
2012-02-27 16:19:37,083 INFO sqlalchemy.engine.base.Engine.0x..cL DESCRIBE
`media`
2012-02-27 16:19:37,083 INFO sqlalchemy.engine.base.Engine.0x..cL {}
2012-02-27 16:19:37,084 INFO sqlalchemy.engine.base.Engine.0x..cL DESCRIBE
`media_variants`
2012-02-27 16:19:37,085 INFO sqlalchemy.engine.base.Engine.0x..cL {}
2012-02-27 16:19:37,086 INFO sqlalchemy.engine.base.Engine.0x..cL DESCRIBE
`image_variants`
2012-02-27 16:19:37,086 INFO sqlalchemy.engine.base.Engine.0x..cL {}
2012-02-27 16:19:37,087 INFO sqlalchemy.engine.base.Engine.0x..cL DESCRIBE
`media_attributes`
2012-02-27 16:19:37,087 INFO sqlalchemy.engine.base.Engine.0x..cL {}
2012-02-27 16:19:37,088 INFO sqlalchemy.engine.base.Engine.0x..cL DESCRIBE
`images`
2012-02-27 16:19:37,088 INFO sqlalchemy.engine.base.Engine.0x..cL {}
2012-02-27 16:19:37,096 INFO sqlalchemy.engine.base.Engine.0x..cL BEGIN
2012-02-27 16:19:37,096 INFO sqlalchemy.engine.base.Engine.0x..cL SELECT
media.id AS media_id, media.project_id AS media_project_id, media.status AS
media_status, media.row_type AS media_row_type
FROM media
WHERE media.id = %s ORDER BY media.id
LIMIT 0, 1
2012-02-27 16:19:37,096 INFO sqlalchemy.engine.base.Engine.0x..cL
[u'02pMhPqJkOQYm27sW0NAzxGoarN']
2012-02-27 16:19:37,098 INFO sqlalchemy.engine.base.Engine.0x..cL SELECT
images.media_id AS images_media_id, images.width AS images_width,
images.height AS images_height
FROM images
WHERE %s = images.media_id
2012-02-27 16:19:37,098 INFO sqlalchemy.engine.base.Engine.0x..cL
['02pMhPqJkOQYm27sW0NAzxGoarN']
2012-02-27 16:19:37,100 INFO sqlalchemy.engine.base.Engine.0x..cL SELECT
media_variants.id AS media_variants_id, media_variants.original_id AS
media_variants_original_id, media_variants.row_type AS
media_variants_row_type
FROM media_variants
WHERE media_variants.original_id = %s ORDER BY media_variants.id
2012-02-27 16:19:37,101 INFO sqlalchemy.engine.base.Engine.0x..cL
['02pMhPqJkOQYm27sW0NAzxGoarN']
2012-02-27 16:19:37,103 INFO sqlalchemy.engine.base.Engine.0x..cL SELECT
image_variants.mediavariant_id AS image_variants_mediavariant_id,
image_variants.width AS image_variants_width, image_variants.height AS
image_variants_height
FROM image_variants
WHERE %s = image_variants.mediavariant_id
2012-02-27 16:19:37,103 INFO sqlalchemy.engine.base.Engine.0x..cL [316956L]
Traceback (most recent call last):
File "delete_test2.py", line 63, in <module>
media.delete()
File "/usr/lib/python2.5/site-packages/elixir/entity.py", line 963, in
delete
return object_session(self).delete(self, *args, **kwargs)
File "/var/lib/python-support/python2.5/sqlalchemy/orm/session.py", line
961, in delete
for c, m in _cascade_iterator('delete', instance):
File "/var/lib/python-support/python2.5/sqlalchemy/orm/session.py", line
1253, in _cascade_iterator
for (o, m) in mapper.cascade_iterator(cascade, instance._state,
**kwargs):
File "/var/lib/python-support/python2.5/sqlalchemy/orm/mapper.py", line
1335, in cascade_iterator
instance, instance_mapper, corresponding_state = iterator.next()
File "/var/lib/python-support/python2.5/sqlalchemy/orm/properties.py",
line 451, in cascade_iterator
instances = attributes.get_as_list(state, self.key, passive=passive)
File "/var/lib/python-support/python2.5/sqlalchemy/orm/attributes.py",
line 1151, in get_as_list
x = attr.get(state, passive=passive)
File "/var/lib/python-support/python2.5/sqlalchemy/orm/attributes.py",
line 279, in get
value = callable_()
File "/var/lib/python-support/python2.5/sqlalchemy/orm/strategies.py",
line 466, in __call__
result = q.all()
File "/var/lib/python-support/python2.5/sqlalchemy/orm/query.py", line
878, in all
return list(self)
File "/var/lib/python-support/python2.5/sqlalchemy/orm/query.py", line
1017, in iterate_instances
context.attributes.get(('populating_mapper', ii),
_state_mapper(ii))._post_instance(context, ii)
File "/var/lib/python-support/python2.5/sqlalchemy/orm/mapper.py", line
1517, in _post_instance
p(state.obj(), **kwargs)
File "/var/lib/python-support/python2.5/sqlalchemy/orm/mapper.py", line
1547, in post_execute
self.populate_instance(selectcontext, instance, row, isnew=False,
instancekey=identitykey, ispostselect=True, only_load_props=only_load_props)
File "/var/lib/python-support/python2.5/sqlalchemy/orm/mapper.py", line
1484, in populate_instance
(newpop, existingpop, post_proc) = selectcontext.exec_with_path(self,
prop.key, prop.create_row_processor, selectcontext, self, row)
File "/var/lib/python-support/python2.5/sqlalchemy/orm/query.py", line
1703, in exec_with_path
return fn(*args, **kwargs)
File "/var/lib/python-support/python2.5/sqlalchemy/orm/interfaces.py",
line 532, in create_row_processor
return
self._get_context_strategy(selectcontext).create_row_processor(selectcontext,
mapper, row)
File "/var/lib/python-support/python2.5/sqlalchemy/orm/strategies.py",
line 75, in create_row_processor
elif self.columns[0] in row:
TypeError: argument of type 'NoneType' is not iterable
>
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/sqlalchemy/-/LhpRDeCqYNYJ.
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.
