Can I create records based on the content of a Str...
# orm-helpa
Aaron Waller
05/21/2022, 9:21 AMCan I create records based on the content of a String Array?
I have a Explicit Many-to-Many relation (Category and Post) and I want to create a Post and assign categorys to it based on the content of the String Array.
Here the code:
Copy code
const assignCategories = await prisma.post.create({
data: {
title: 'First Post Title',
categories: {
create: [
{
category: {
create: {
name: myStringArray[0],
},
},
},
{
category: {
create: {
name: myStringArray[1],
},
},
},
],
},
},
}) Copy code
const myStringArray = ["Category1", "Category2", "Category3"];Aaron Waller
05/21/2022, 9:21 AMThis is obviously a pretty bad solution because the String Array with names has no fixed size in the end and is generated by the user depending on how many categories he chooses
r
Richard Ward
05/21/2022, 10:09 AMHi @Aaron Waller - so for each post you want to create multiple categories?
Richard Ward
05/21/2022, 10:11 AMyou should be able to use the `createMany inside your `create`` :
Copy code
const assignCategories = await prisma.post.create({
data: {
title: 'First Post Title',
categories: {
createMany: myStringArray.map(cat => ({
name: myStringArray[0],
}),
},
},
})Richard Ward
05/21/2022, 10:11 AMI think it may be something like that ..
a
Aaron Waller
05/21/2022, 11:03 AMThe docs say
ā¢ ā*Not* available in the context of a many-to-many relation - for example, you cannot
prisma.post.create(...)createManyAaron Waller
05/21/2022, 3:46 PMI solved it:
Copy code
const assignCategories = await prisma.post.create({
data: {
title: 'First Post Title',
categories: {
create: myStringArray.map((title) => ({
category: { create: { title } },
})),
},
},
});š 1
7 Views