[Feature] asTreeCte支持额外列

[rocascent]

WITH RECURSIVE tree AS (
    SELECT 
        id, 
        parent_id, 
        id AS root_id   -- 额外列
    FROM table
    WHERE parent_id IS NULL

    UNION ALL

    SELECT 
        t.id, 
        t.parentId, 
        p.root_id
    FROM table t
    INNER JOIN tree p ON t.parent_id = p.id
)

[xuejmnet]

直接映射到dto加一个deep列就好了，deep=0就表示根节点

[xuejmnet]

@Data
@Table("t_comment")
@EntityProxy
@EasyAlias("t_comment")
@EasyAssertMessage("未找到对应的评论信息")
public class Comment implements ProxyEntityAvailable<Comment, CommentProxy> {
    @Column(primaryKey = true, comment = "评论id")
    private String id;
    @Column(comment = "父id")
    private String parentId;
    @Column(comment = "帖子内容")
    private String content;
    @Column(comment = "用户id", nullable = false)
    private String userId;
    @Column(comment = "帖子id", nullable = false)
    private String postId;
    @Column(comment = "回复时间")
    private LocalDateTime createAt;


    /**
     * 子评论
     **/
    @Navigate(value = RelationTypeEnum.OneToMany, selfProperty = {CommentProxy.Fields.id}, targetProperty = {CommentProxy.Fields.parentId})
    private List<Comment> children;
}


 List<MyComment> treeList = easyEntityQuery.queryable(Comment.class)
                .asTreeCTE(o -> {
                    o.setDeepColumnName("deep");
                })
                .selectAutoInclude(MyComment.class)
                .toTreeList();




@Data
public class MyComment {
    private String id;
    private String parentId;
    private String content;
    private String userId;
    private String postId;
    private LocalDateTime createAt;
    private Long deep;


    /**
     * 子评论
     **/
    @Navigate(value = RelationTypeEnum.OneToMany)
    private List<MyComment> children;
}

[rocascent]

deep列并不符合需求.添加相同的root_id列可以用于分组

[xuejmnet]

@rocascent 可以后续我看下既然可以加deep那么肯定也可以加root_id,或许先在表结构上面加一个root_id字段