I want to move node contains child nodes

[hayamat]

I have a question about the library sequelize-nested-set
I want to move node contains child nodes
Currently, there is only a way to get the each id of the node to move to the target one by one.

sample image

[fremail]

Hi @hayamat, thank you for the question.

All methods to move a record moves the record and all its descendants. The methods are listed here: https://github.com/fremail/sequelize-nested-set/wiki/Moving-a-record

Your Japanese example is too hard for me, sorry. Let's use a simplified one:
-- 1
--- 1.1
---- 1.1.1
--- 1.2

You want to move 1.1 (and 1.1.1) to be after 1.2, right? So the tree should look this way after update?

-- 1
--- 1.2
--- 1.1
---- 1.1.1

Then you can use moveAsNextSiblingOf or moveAsLastChildOf.

await one_one.moveAsNextSiblingOf(one_two);
// or
await one_one.moveAsLastChildOf(one);

[hayamat]

Hi, thank you for your reply.
The code I received didn't work.

Is there something wrong?

tree image

Data

soruce code

console error

[fremail]

Oh! @hayamat, I got your problem. You have incorrect values of lft and rgt fields.

You can check the theory of nested set model in Wikipedia: https://en.wikipedia.org/wiki/Nested_set_model#Example

The correct values for your example must be so:

[hayashitvb]

The test data was wrong.
Thank you for your advice!

[hayamat]

Thank You 😭