migrate-dev failure when adding property to entity

Trying to perform a migration where I add an optional field to User, but since there already exist users in the DB the migration fails. For example:

Migrating from:

entity User {=psl
  id       Int        @id @default(autoincrement())
  email    String?    @unique
psl=}

entity User {=psl
  id       Int        @id @default(autoincrement())
  email    String?    @unique
psl=}

To:

entity User {=psl
  id       Int        @id @default(autoincrement())
  email    String?    @unique
  myField  String?
psl=}

entity User {=psl
  id       Int        @id @default(autoincrement())
  email    String?    @unique
  myField  String?
psl=}

run

wasp db migrate-dev

wasp db migrate-dev

Fails with

error TS2741: Property 'myField' is missing in type '{ email: string; }' but required in type 'Omit<GetResult<{ id: number; email: string; myField: string; }, unknown> & {}, "id">'.

error TS2741: Property 'myField' is missing in type '{ email: string; }' but required in type 'Omit<GetResult<{ id: number; email: string; myField: string; }, unknown> & {}, "id">'.

Wasp version: 0.13.2 (entities defined in

main.wasp

main.wasp

)

Wasp•2y ago•

29 replies

JakeLoew

migrate-dev failure when adding property to entity

Trying to perform a migration where I add an optional field to User, but since there already exist users in the DB the migration fails. For example:

Migrating from:

entity User {=psl
  id       Int        @id @default(autoincrement())
  email    String?    @unique
psl=}

entity User {=psl
  id       Int        @id @default(autoincrement())
  email    String?    @unique
psl=}

To:

entity User {=psl
  id       Int        @id @default(autoincrement())
  email    String?    @unique
  myField  String?
psl=}

entity User {=psl
  id       Int        @id @default(autoincrement())
  email    String?    @unique
  myField  String?
psl=}

run

wasp db migrate-dev

wasp db migrate-dev

Fails with

error TS2741: Property 'myField' is missing in type '{ email: string; }' but required in type 'Omit<GetResult<{ id: number; email: string; myField: string; }, unknown> & {}, "id">'.

error TS2741: Property 'myField' is missing in type '{ email: string; }' but required in type 'Omit<GetResult<{ id: number; email: string; myField: string; }, unknown> & {}, "id">'.

Wasp version: 0.13.2 (entities defined in

main.wasp

main.wasp

)

Continue the conversation

Join the Discord to ask follow-up questions and connect with the community

Wasp

Rails-like framework for React, Node.js and Prisma. Build your app in a day and deploy it with a single CLI command.

4,603 Members

Join

migrate-dev failure when adding property to entity

migrate-dev failure when adding property to entity

Continue the conversation

Wasp

Continue the conversation

Wasp

Similar Threads