PonyORM仅Friend类报Reverse attribute not found错误的原因与解决

我定义了如下三个实体类：

class User(db.Entity):
    _table_ = "tbl_user"
    idUser = PrimaryKey(uuid.UUID,default = uuid.uuid4 ,column = 'id_user')
    username = Required(str, unique = True)
    email = Required(str, unique = True)
    password = Required(str)
    name = Optional(str,nullable = True)
    gender = Optional(str, nullable = True)
    address = Optional(str,nullable = True)
    birth = Optional(date, nullable = True)
    phoneNumber = Optional(str, column = "phone_number",nullable = True)
    dateRegister = Required(date,column = 'date_register')
    picture = Optional(str, nullable = True)
    isActivated = Required(bool)
    article = Set('Article')
    comment = Set('Comment')
    like = Set('Like')
class Article(db.Entity):
    _table_ = "tbl_article"
    idArticle = PrimaryKey(uuid.UUID,default=uuid.uuid4,column = 'id_article')
    comment = Set('Comment')
    like = Set('Like')
    articleTag = Set('ArticleTag')
    articleCategory = Set('ArticleCategory')
    user = Required(User,column = 'id_user')
    content = Required(Content,column = 'id_content')
class Friend(db.Entity):
    _table_ = "tbl_friend"
    userOne = Required(User,column="id_user_one")
    userTwo = Required(User,column="id_user_two")
    dateFriend = Required(datetime,column="date_friend")

执行db.generate_mapping()时抛出错误：

pony.orm.core.ERDiagramError: Reverse attribute for Friend.userOne not found

移除Friend类后错误消失。不解为何Article类可正常关联User的id_user外键，而Friend类会触发该错误？请问问题成因及解决方法？

• Pony ORM强制要求实体间的关联必须是双向的：
  • Article的user字段，在User类里对应有article = Set('Article')作为反向关联，ORM能识别这是一对多的双向绑定，所以可以正常生成映射。
  • Friend类里定义了两个指向User的字段，但User类中没有对应的反向关联属性，ORM无法解析这两个字段的关联逻辑，因此抛出“找不到反向属性”的错误。
• Friend属于用户自关联的多对多关系，这种特殊的关联结构必须明确双向绑定规则，否则ORM无法正确生成数据库表映射。

需要在User类中添加对应Friend的反向关联，并在Friend类中通过reverse参数指定对应的反向属性，同时为Friend设置复合主键（保证好友关系的唯一性）：

修改后的完整代码：

import uuid
from datetime import date, datetime
from pony.orm import db, PrimaryKey, Required, Optional, Set

class User(db.Entity):
    _table_ = "tbl_user"
    idUser = PrimaryKey(uuid.UUID, default=uuid.uuid4, column='id_user')
    username = Required(str, unique=True)
    email = Required(str, unique=True)
    password = Required(str)
    name = Optional(str, nullable=True)
    gender = Optional(str, nullable=True)
    address = Optional(str, nullable=True)
    birth = Optional(date, nullable=True)
    phoneNumber = Optional(str, column="phone_number", nullable=True)
    dateRegister = Required(date, column='date_register')
    picture = Optional(str, nullable=True)
    isActivated = Required(bool)
    article = Set('Article')
    comment = Set('Comment')
    like = Set('Like')
    # 添加两个方向的好友反向关联
    friends_as_one = Set('Friend', reverse='userOne')
    friends_as_two = Set('Friend', reverse='userTwo')

class Article(db.Entity):
    _table_ = "tbl_article"
    idArticle = PrimaryKey(uuid.UUID, default=uuid.uuid4, column='id_article')
    comment = Set('Comment')
    like = Set('Like')
    articleTag = Set('ArticleTag')
    articleCategory = Set('ArticleCategory')
    user = Required(User, column='id_user')
    content = Required(Content, column='id_content')

class Friend(db.Entity):
    _table_ = "tbl_friend"
    userOne = Required(User, column="id_user_one", reverse='friends_as_one')
    userTwo = Required(User, column="id_user_two", reverse='friends_as_two')
    dateFriend = Required(datetime, column="date_friend")
    # 设置复合主键，避免重复的好友关系
    PrimaryKey(userOne, userTwo)

如果想在User中用一个统一属性获取所有好友（不管是作为userOne还是userTwo），可以添加一个属性方法：

class User(db.Entity):
    # ... 其他属性保持不变 ...
    @property
    def all_friends(self):
        # 合并两个方向的好友并去重
        friends_set = set()
        for friend_rel in self.friends_as_one:
            friends_set.add(friend_rel.userTwo)
        for friend_rel in self.friends_as_two:
            friends_set.add(friend_rel.userOne)
        return friends_set

内容的提问来源于stack exchange，提问作者LLL