1
2
3
4
5
6
7
8
9

insert into node(name) values($name);
## 查所有父节点，建立关系
ids[] = {$parent_id}
ids[] += select id from node where current_id=$parent_id; 
distance = ids.length;
for (ancestor_id : ids) {
    insert into relation(current_id, ancestor_id, distance) values ($id, $ancestor_id, $distance);
    distance--;
}

1
2
3
4

ids[] = {$id}
ids += $(select id from relation where ancestor_id = ${id})
delete from relation where ancestor_id in ${ids} or current_id in ${ids}
delete from node where id in ${ids}

1

update node set info where id = $id

1

select * from node where id = $id

1
2
3

select * from relation
left join node on node.id = relation.current_id
where relation.ancestor_id = $id and distance = 1

1
2
3

select * from relation
left join node on node.id = relation.current_id
where relation.ancestor_id = $id

1
2
3
4
5
6
7
8

old_parent_id = select ancestor_id from relation where current_id = $id and distance = 1;
DEL # 执行上面的删除操作

objects = ${object(id)}
objects += $(select current_id, distance from relation where ancestor = $id)
for (object : $objects) {
    INSERT  # 执行上面的插入操作
}