does anyone know if its possible to use prisma imp...
# orm-helpt
Tiago Correia
12/27/2018, 12:42 PMdoes anyone know if its possible to use prisma import in a way that it generates the id's? atm im importing a json file without id's and it trhows an error
h
Harshit
12/27/2018, 3:31 PMyou can use the client to input the data and use something like uuid or shortid to generate the id on the go
t
Tiago Correia
12/28/2018, 1:24 PMso you are pretty much saying to structure the json already with the id's right @Harshit?
h
Harshit
12/28/2018, 1:31 PMyou can also add the data using the prisma client. I don't think that your data will be formatted for prisma import to work
Harshit
12/28/2018, 1:31 PMIf you want personal assistance, DM me
t
Tiago Correia
12/28/2018, 2:55 PM Copy code
type Country {
id: ID! @unique
code: String! @unique
name: String!
}Tiago Correia
12/28/2018, 2:55 PMthis is how the schema is strutured
Tiago Correia
12/28/2018, 2:56 PMthe data I wont to import is similiar to this
Tiago Correia
12/28/2018, 2:56 PM Copy code
[
{
"code": "AF",
"name": "Afghanistan"
},
{
"code": "AX",
"name": "Åland Islands"
}
]Tiago Correia
12/28/2018, 2:56 PMhow would you do it?
h
Harshit
12/28/2018, 2:56 PMyou need to write an import script
Harshit
12/28/2018, 2:57 PMI will msg you a script in a while
t
Tiago Correia
12/28/2018, 3:06 PMthanks 🙂
h
Harshit
12/28/2018, 5:17 PM Copy code
import json from '/path/to/your/json/file'
import { prisma } from './generated/prisma-client'
async function nodeDoesntHaveTopLevelAwaitYet(){
json.forEach(el => {
await prisma.createCountry({
code: el.code,
name: el.name
})
});
}
nodeDoesntHaveTopLevelAwaitYet();Harshit
12/28/2018, 5:19 PM1. you need to generate the js client for this using
prisma generateHarshit
12/28/2018, 5:19 PMDM me if you have any problems 🙂
t
Tiago Correia
12/28/2018, 7:25 PMoh ok, I was trying to figure out if there was another way without plug atual code into it, but if its the best way of doing it I will take care of it, thank you so much for your time 🙂