I don't understand this; If I want to insert somet...
# orm-helpi
Industrial
10/26/2018, 10:05 AMI don't understand this; If I want to insert something I do not have an ID and the
whereidh
huv1k
10/26/2018, 10:06 AMIf there is no id, it executes
createupdatei
Industrial
10/26/2018, 10:06 AMAh! alright
Industrial
10/26/2018, 10:13 AMIndustrial
10/26/2018, 10:24 AMI can't seem to leave out the ID from the object that I pass to the variables option of the query
h
huv1k
10/26/2018, 12:24 PMYe, it should work like this
huv1k
10/26/2018, 12:24 PMyou can have something like data = {...data, id: ""}
i
Industrial
10/26/2018, 2:50 PMok
Industrial
10/26/2018, 2:52 PM@huv1k Still this means that I can not upsert things by other where clauses then the ID. Why is this? Why can't I use other properties (that together make the document unique)?
Industrial
10/26/2018, 2:53 PMI am importin the data from an external source and it doesn't include ID's. So Every time I restart my service (and every 24 hours) I have the same data, without id's with maybe updated properties ..
Industrial
10/26/2018, 2:54 PMSo if I upsert that data I get new entries instead of updated ones
h
huv1k
10/26/2018, 2:54 PMSo do you have some unique constrain from your data already?
huv1k
10/26/2018, 2:55 PMBecause without unique constrain you can't decide what data changed or what data to update.
i
Industrial
10/26/2018, 2:55 PMIt's just an exchange (binance) for bitcoin data. it's api exposes a list of markets. That JSOn response does not contain id's but does have e.g.
{ base: 'BTC', quote: 'ETH', active: true }Industrial
10/26/2018, 2:56 PMI just want that data in my DB
Industrial
10/26/2018, 2:56 PMSo I will make a
findMarket(where: { base: $base, quote: $quote})Industrial
10/26/2018, 2:57 PMand then do a
updateMarket()createMarket()Industrial
10/26/2018, 2:57 PMbasically implement the upsert myself with a different where clause on the find 🙂
h
huv1k
10/26/2018, 2:57 PMso maybe use timestamp like unique constrain?
i
Industrial
10/26/2018, 2:57 PMSo my question is: Why can't the upsert Where clause include all properties instead of only ID?
h
huv1k
10/26/2018, 2:59 PMyea, for example 🙂
i
Industrial
10/26/2018, 3:00 PMmy Prisma server says I can only put "id" in the "where"
Industrial
10/26/2018, 3:00 PMI don't understand why
Industrial
10/26/2018, 3:01 PMIt's the
MarketWhereUniqueInputIndustrial
10/26/2018, 3:03 PMMaybe I can add a feature request for that.
Industrial
10/26/2018, 3:08 PMa
Arnab
10/29/2018, 8:21 AM@Industrial: What does your datamodel look like?
whereWHERE5 Views