1) Can I do this without the where and id?
2) Are ...
# orm-helpi
Industrial
09/27/2018, 6:25 PM1) Can I do this without the where and id?
2) Are the create and update correct?
Copy code
mutation upsertMarket(
$trader: String!,
$base: String!,
$quote: String!,
$category: String!,
$type: String!
) {
upsertMarket(
where: {
id: "123"
},
create: {
trader: $trader
base: $base
quote: $quote
category: $category
type: $type
},
update: {
trader: $trader
base: $base
quote: $quote
category: $category
type: $type
}
)
}Industrial
09/27/2018, 6:35 PMI got it with
Copy code
mutation upsertMarket(
$trader: String!,
$base: String!,
$quote: String!,
$category: String!,
$type: String!
) {
upsertMarket(
where: {
id: ""
},
create: {
trader: $trader
base: $base
quote: $quote
category: $category
type: $type
},
update: {
trader: $trader
base: $base
quote: $quote
category: $category
type: $type
}
)
{
id
}
}Industrial
09/27/2018, 6:36 PMBut this creates a new entry in the DB every time because I do not supply the ID (or a nonexistant one)
Industrial
09/27/2018, 6:38 PMI'm running this query from an
ImporterIndustrial
09/27/2018, 6:38 PMThere also might be new entries, some removed and others get disabled: true, etc.
m
marcus
09/27/2018, 6:40 PMyou can supply any unique field in the where argument.
marcus
09/27/2018, 6:41 PMWhat’s your usecase? When should the update part be executed and when the create part?
i
Industrial
09/27/2018, 6:43 PMI'm importing the list of markets from many traders through their API's through a client interface (CCXT). I want to update this list every 24 hours so all the new reponses should be regarded as truth. Before Prisma I didn't have ID's in the tables but now that I do I see the problem; How do I know which existing items to remove (disabled: true)?
Industrial
09/27/2018, 6:44 PMI guess query first and if empty then just insert otherwise compare and disable the ones not in the new API response and update the rest?
h
harmony
09/27/2018, 6:44 PMtry to find something that's unique about them
harmony
09/27/2018, 6:44 PMmaybe
$traderi
Industrial
09/27/2018, 6:45 PMI tried
trader: $traderIndustrial
09/27/2018, 6:45 PM(in the where clause)
m
marcus
09/27/2018, 6:51 PMThere has to be a unique identifier for a market.
If not you could delete all markets before import but that does not sound useful to me. 🤷
2 Views