ImEgg Posts - Answer Overflow

ImEgg

Explore posts from servers

•Created by ImEgg on 10/28/2024 in #help-and-questions

Mongodb, Making Breaking changes to production database

Hi, I'm trying to understand what the suggested way or best practices for making breaking changes to a database in production are. for simplicity sake, let's say I have a schema for mongodb:

model User {
  id        String 
  tenant_id String 
  email     String   @unique
  password  String
  line_one  String
  city      String
  state     String
  zip       String
  @@map("users")
}

model User {
  id        String 
  tenant_id String 
  email     String   @unique
  password  String
  line_one  String
  city      String
  state     String
  zip       String
  @@map("users")
}

where there is already data present. let's say now I want to be able to have multiple addresses so I want the schema to be put like this:

model User {
  id        String 
  tenant_id String 
  email     String   @unique
  password  String
//assume type is of same fields
  address   Address[] 
  @@map("users")
}

model User {
  id        String 
  tenant_id String 
  email     String   @unique
  password  String
//assume type is of same fields
  address   Address[] 
  @@map("users")
}

To add the new address field is okay but the moving of existing data from the 4 separate fields to now the new address object is what I am having a hard time understanding how to do. I'd like to understand how people are doing these types of database changes for mongodb with prisma or just in general I suppose. thanks!

6 replies

Gaming

Programming