Re: [Sqlalchemy-users] Return lists in mapping

[Michael Bayer]

well other folks have been asking that it return a generator object which dynamically executes the query at the moment you ask for a slice of it. you can always go with orders = list(Order.mapper.select(limit=3)) to assure the type. any particular reason "list" is so important ?  whats python without duck typing? On Mar 26, 2006, at 2:55 PM, Koen Bok wrote: When I make a selection with a mapper I get back an <instance> object. Same goes for the mapper's relations. Is there any way to make SQLAlchemy returning standard <list> objects? Example: orders = list() print type(orders) # <type 'list'> orders = Order.mapper.select(limit=3) print type(orders) print orders <type 'instance'> [<Order id=1859>, <Order id=295>, <Order id=1360>] # Looks like a list, but is an instance! orders = list(Order.mapper.select(limit=3)) print type(orders) print orders <type 'list'> [<Order id=1859>, <Order id=295>, <Order id=1360>] # This is a list! But I had to convert it! And I'd also the relations to standard list objects.