Upsert, move edges to another predicate

MichelDiz · May 4, 2020, 4:41pm

I don’t think thats possible. So I had created this issue

Feature: Add foreach() function.

opened 02:38AM - 30 Apr 20 UTC

kind/feature exp/expert status/needs-attention area/upsert area/querylang/function dgraph

## Experience Report ### What you wanted to do I would like to use loops i…n queries and upsert blocks. In this case something similar to "foreach". ### What you actually did There's nothing similar to this in Dgraph right now. ### Why that wasn't great, with examples A loop like foreach would be very useful. There are situations that we want to iterate over objects in a query. Whether to display a particular form structure in the response or to create specific mutations in the upsert block. Which is not currently supported in Dgraph. ##### Syntax I believe that Syntax from foreach would be very similar to the K-shortest path. ##### More examples I think a "foreach" func would be the solution for almost all the things like "groupby value". Ref of a DB doing something similar to it: https://neo4j.com/docs/cypher-manual/current/clauses/foreach/ https://docs.mongodb.com/manual/reference/method/cursor.forEach/ A foreach loop could solve this issue #4779 in a blink of an eye (eliminating the misuse of an extra block). I gonna add a comment there with an example using "foreach". > see https://github.com/dgraph-io/dgraph/issues/4779#issuecomment-621579502 In this link https://discuss.hypermode.com/t/foreach-func-in-graphql-loops-in-bulk-upsert/5533 I have other use cases. Most of them related to upsert block, issues with Facets bad responses (e.g: #4160), and so on. >Pay attention that this link is a little old. I used different syntax just to illustrate. > Reference for the group by issue: https://github.com/dgraph-io/dgraph/issues/4170 e.g: "for each group found in groupby create a new object to use in response". ``` foreach(in: PARAM1, title: PARAM2). ``` ``` > For each UID in PARAM1, create a new object in the response with the title in PARAM2 ``` ``` { var(func: has(kind)) @groupby(kind) { T as count(uid) } foreach(func: foreach(in: T, title: kind)) { name age total : val(T) } } ``` #### Desirable Result ```JSON { "data": { "q": [ { "dog": [ { "total": 1 }, { "uid": "0x1", "name": "Bingo", "age": "3" } ] }, { "animal": [ { "total": 2 }, { "uid": "0x1", "name": "Bingo", "age": "3" }, { "uid": "0x3", "name": "Angry Purr", "age": "1" } ] }, { "cat": [ { "total": 1 }, { "uid": "0x3", "name": "Angry Purr", "age": "1" } ] } ] } ``` ### Any external references to support your case https://discuss.hypermode.com/t/foreach-func-in-graphql-loops-in-bulk-upsert/5533

Share there your thoughts and use cases.

Cheers.

Topic		Replies	Views
FOREACH func in DQL (loops in Bulk Upsert) Dev proposal , discussion	8	3631	July 9, 2020
Upserting for a list of predicates Dgraph	10	678	June 24, 2020
Feature: Add foreach() function Dgraph dgraph , kind:feature , exp:expert , area:upsert , area:querylang:funct	6	1674	January 18, 2021
Bug with multi-level (nested bocks) in Upsert Block Dgraph dgraph , status:accepted , kind:bug , area:upsert	13	1012	April 30, 2020
How to do an upsert block with multiple linked variable from separate query blocks Dgraph mutation	5	1134	May 20, 2022

Upsert, move edges to another predicate

Related topics