关于gqlalchemy OGM与Cypher处理供应链节点唯一约束的差异疑问

我在使用gqlalchemy的OGM与Cypher查询时，对节点属性唯一约束的执行逻辑存在困惑。我希望将供应链实体建模为节点，为每个实体强制设置唯一标识符：使用gqlalchemy OGM时，用已存在的唯一标识符创建节点不会触发报错，数据库中仅创建一次该节点；而通过Cypher执行相同的创建操作时，会触发唯一约束违反错误。

我的Python代码如下：

from typing import Optional
from gqlalchemy import Memgraph, Node, Field

db_connection = Memgraph()
db_connection.drop_database()

class SupplyEntity(Node):
    entity_id: str
    entity_name: str

class Manufacturer(SupplyEntity):
    entity_id: str = Field(unique=True, db=db_connection)
    entity_name: Optional[str] = Field(exists=True, db=db_connection)
    production_capacity: Optional[str]

Manufacturer(entity_id="M001", entity_name="AcmeCorp").save(db_connection)
print("Registered manufacturer AcmeCorp once")

Manufacturer(entity_id="M001", entity_name="AcmeCorp").save(db_connection)
print("Attempted to register AcmeCorp again")

SupplyEntity(entity_id="M001", entity_name="NewCo").save(db_connection)
print("Registered another entity with the same ID M001")

try:
    result = db_connection.execute(
        """
        CREATE (:Manufacturer:SupplyEntity {entity_id: "M001", entity_name: "AcmeCorp"});
        """
    )
except Exception as error:
    print("Direct Cypher query failed with error: ", error)
    Manufacturer(entity_id="M001", entity_name="AcmeCorp").save(db_connection)  # this works
    print("OGM approach succeeded despite expected constraint violation")

终端输出内容如下：

Registered manufacturer AcmeCorp once
Attempted to register AcmeCorp again
Registered another entity with the same ID M001
Direct Cypher query failed with error: Unable to commit due to unique constraint violation on :Manufacturer(entity_id)
OGM approach succeeded despite expected constraint violation

差异原因解析 #

• OGM的save()是UPSERT逻辑：GQLAlchemy的Node.save()方法底层并非直接执行CREATE，而是用类似MERGE的逻辑处理：先通过唯一约束字段（这里是entity_id）匹配对应标签的节点，找到则更新节点属性（属性无变化时不做操作），找不到才创建新节点。所以重复调用save()不会触发约束错误。
• 直接Cypher的CREATE是强制新建：CREATE语句会无条件尝试创建新节点，当数据库中已存在带有:Manufacturer标签且entity_id为M001的节点时，就会触发唯一约束违反的错误。
• 唯一约束的标签作用范围：你给Manufacturer类的entity_id设置的unique=True约束，仅对带有:Manufacturer标签的节点生效。SupplyEntity作为父类，创建的节点只有:SupplyEntity标签，不受该约束限制，因此可以用相同entity_id创建SupplyEntity节点。

内容的提问来源于stack exchange，提问作者Zet Hund Pet