Question

请允许我说,我有两个实体:Post和Comment(在冷战时期):

component persistent="true" table="post"
{
    property name="Id" fieldtype="id";
    property name="Comments" fieldtype="one-to-many" cfc="Comment" fkcolumn="post_id" cascade="all";
}

component persistent="true" table="comment"
{
    property name="Id" fieldtype="id";
    property name="Post" fieldtype="many-to-one" cfc="Post" column="post_id";
}

Post has a collection of Comments. Now I d like to delete a Post, and have the Comments automatically deleted as well. I ve tried the straightforward method:

var post = EntityLoadByPK("Post", 13);
EntityDelete(post);

但是,我忘记了一种温和的错误,即:post_id不能被定为无效。我做了什么错误,我如何解决这个问题?

Answer 1

你们需要调整自己的地图。要求将评论后的财产不作废,并将职位的评论财产作反常的标记。

component persistent="true" table="post"
{
  property name="Id" fieldtype="id";
  property name="Comments" fieldtype="one-to-many" cfc="Comment" fkcolumn="post_id" cascade="all" inverse="true";
}

component persistent="true" table="comment"
{
  property name="Id" fieldtype="id";
  property name="Post" fieldtype="many-to-one" cfc="Post" column="post_id" notnull="true";
}

Answer 2

你们不得不在评论表上宣布职位无效。这样一来,便会删除。表格列出所有带有员额_id=13号的评论,然后删除员额_id ISNUL的所有评论。

友情链接