How to loop through a structure obtained from Flask-SQLAlchemy?

Question

Flask

Here is the code for querying MySQL:

U = User
I = UserItem 
items = db.session.query(U, I).join(I).filter(U.id == user_id).all()

If you print it with print(items).
Then there will be something like this:

[
(<User(id=21, nickname=Olesya, [email protected], date=2011-11-09 11:02:51)>,
  <UserItem(id=79, user_id=21, name_item=en, razg=1, revers=0, share=None)>),
 (<User(id=21, nickname=Olesya, [email protected], date=2011-11-09 11:02:51)>, 
 <UserItem(id=81, user_id=21, name_item=en, razg=1, revers=2, share=None)>)
и т.д.
 ]

How to loop through a UserItem ID (To pull all ID values ​​from the UserItem dictionary)?
How to add new keys and values ​​to UserItem?

PS: The logic is that before sending items to the template, I need to first turn
to memcached and get something from there.

Answer 1

for i in items:
  print i.UserItem.id

The query returns an iterator, no need to call .all():
About adding keys, explain in more detail what you mean ...