sample_join.py

def sampleJoin():
  posts = Post.query(Post.is_draft == False).order(-Post.created)
  all_users = User.query()
  
  list_dict = []
  
  for p in posts:
    p_dict = {}
    for u in all_users:
      if p.user == u.key:
        p_dict['p_id'] = p.key.id()
        p_dict['p_title'] = p.title
        p_dict['p_content'] = p.content
        p_dict['p_created'] = p.created
        p_dict['a_name'] = u.fullname
        p_dict['a_key'] = u.key
        p_dict['a_id'] = u.key.id()
    
    list_dict.append(p_dict)
  return list_dict