Hello, I have been working on implementing a create statement that accepts an array of another model. Below are my schemas:
model House {
id String @id
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
property_name String @db.VarChar(30)
house_type String @db.VarChar(10)
beds Int
baths Int
workspace Int
occupied Boolean @default(false)
stay DateTime[]
amenities Amenity[]
room Room[]
zipcode String @db.VarChar(5)
address Address @relation(fields: [address_id], references: [id])
address_id Int
}
model Address {
id Int @id @default(autoincrement())
city String
state_code String @db.VarChar(2)
house House[]
}
model Amenity {
id Int @id @default(autoincrement())
amenity_name String
house House @relation(fields: [house_id], references: [id])
house_id String
}
model Room {
id Int @id @default(autoincrement())
room_number String
occupied Boolean @default(false)
house House @relation(fields: [house_id], references: [id])
house_id String
}
I have attempted to add houses with their corresponding relationships using the following approach:
createHomeDto.id = uuid();
const {
amenities,
room,
...home
} = createHomeDto;
await this.prisma.house.create({
data: home
});
Object.entries(amenities).map(async ([key, value]) => {
await this.prisma.amenity.create({
data: {
amenity_name: value.amenity_name,
house: {
connect: {
id: home.id
}
}
}
})
});
Object.entries(room).map(async ([key, value]) => {
await this.prisma.room.create({
data: {
room_number: value.room_number,
house: {
connect: {
id: home.id
}
}
}
})
})
Do you know if there is a more efficient solution for creating these relationships, or am I limited to this method?