Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Update multiple rows by where clause #111

Open
artpar opened this issue Apr 25, 2021 · 0 comments
Open

Update multiple rows by where clause #111

artpar opened this issue Apr 25, 2021 · 0 comments
Assignees
@artpar
Labels
enhancement
Projects
Daptin core
Milestone
1.0.0

Comments

@artpar
Copy link
Collaborator

artpar commented Apr 25, 2021

Need an outcome to update multiple rows by where clause. Currently whats available is update by id.

To fire queries like

UPDATE tree SET rgt = rgt + 2 WHERE rgt >= new_lft;

UPDATE tree SET lft = lft + 2 WHERE lft > new_lft;

This will make it possible to implement https://github.com/griffinqiu/go-nested-set using daptin actions.
@artpar artpar added this to To do in Daptin core via automation Apr 25, 2021
@artpar artpar self-assigned this Apr 25, 2021
@artpar artpar added this to the 1.0.0 milestone Apr 25, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@artpar artpar

Labels
enhancement
Projects
Daptin core
  
To do
Milestone
1.0.0
Development

No branches or pull requests
1 participant
@artpar