Got a question for a SSS/Function. I want to creat...
# prisma-whats-newh
halborg
09/07/2017, 2:00 PMGot a question for a SSS/Function. I want to create a new statistics-entry if the user has none yet, or update the exisiting row if he/she does. The playground lets me know there’s an “updateOrCreateWidgetData” type, but I”m unsure how it works?
Any way I can look for exisiting entries in the subscription query and pass the ID along to my function?
m
mwickett
09/07/2017, 2:01 PMIs this triggered by some kind of user action?
h
halborg
09/07/2017, 2:02 PMYes, create/delete/update a journal
halborg
09/07/2017, 2:02 PMI do statistics calculations for the user based on his/her journals, and create a row called “widgetData”
halborg
09/07/2017, 2:03 PMI want the function that runs when the subscription fires to be able to either create a new row for the user if the user has no rows yet, or update the exisiting row if he does
halborg
09/07/2017, 2:03 PMSo I’m interested in the id of a potentially exisiting row beeing passed on to mu function from the subscription payload
m
mwickett
09/07/2017, 2:04 PMYou could run a query from inside the function that checks for existing rows
h
halborg
09/07/2017, 2:06 PMSure, but that leads to an extra request towards the monthly rate, and also more latency for the calculation 🙂
halborg
09/07/2017, 2:06 PMAlso another link in the chain of events that can fail
m
mwickett
09/07/2017, 2:09 PMTrue. You could include that widgetData as part of the query, and it should be included as part of the payload.
mwickett
09/07/2017, 2:10 PMIt would return all widgetData rows though, if more than one existed
h
halborg
09/07/2017, 2:10 PMAh, I think I can. I can just ask for references to the widget data table on the user - if none exists, I’ll create, otherwise I’ll update!
👍 1
4 Views