在 GAE 中建模好友关系
我正在与 GAE 合作并有一个用户表。现在我想对用户之间的朋友关系进行建模。我正在考虑拥有 3 个属性 user1、user2 和 request_status，但问题在于查询以查找特定用户的朋友。由于 GAE 不允许 OR 过滤，我必须合并两个查询。显然，这是非常低效的。这只是我的方法的一个问题。 如果有人可以提出一个解决方案，让我跟踪所有好友请求以及友谊，那么这将非常有帮助。
I am working with GAE and have a user table. Now I want to model friend relationships between users. I am thinking of having 3 properties user1, user2 and request_status, but the problem is in querying to find a particular user's friends. Since GAE does not allow OR filtering, I have to merge two queries. Clearly that is very inefficient. This is just one problem with my approach.
If someone could suggest a solution that lets me keep track of all friend requests as well as the friendship, then that would be very helpful.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
非规范化将使您可以通过单个查询更有效地找到用户的朋友。尝试在模型中存储另一个属性
users（db.ListProperty），其中包含user1和两者用户2。然后您可以简单地执行这样的查询来查找用户的朋友：优点是您只需要一个查询（更快）。缺点是您将需要一点额外的空间开销来存储
users属性及其上的（自动）索引。Denormalization will let you more efficiently find a user's friends with a single query. Try storing another property
users(adb.ListProperty) in your model which contains bothuser1anduser2. Then you can simply execute a query like this to find a user's friends:The advantage is that you only need a single query (faster). The disadvantage is that you will have a little extra space overhead to store the
usersproperty and the (automatic) index on it.