Hello guys! It is possible with prisma to rollback...
# orm-helpj
José Gomes
05/02/2019, 5:38 PMHello guys! It is possible with prisma to rollback to the previous migration? Like, if i added a new column by mistake, then i can say that i want to rollback to the last migration, or a to a migration ID. Thanks!
j
Jared
05/02/2019, 5:43 PMundo the commit, and deploy again?
j
José Gomes
05/02/2019, 5:50 PMbut, at certain point i will have an impossible deploy, because of the data that is needed, and prisma don't have default values for required fields.
José Gomes
05/02/2019, 5:52 PMif prisma had some functionality like this (a migration rollback) i think it works out of the box
José Gomes
05/02/2019, 5:52 PMit has?
j
Jared
05/02/2019, 5:57 PMwith any destructive migration, you are going to have to evaluate weather or not the deleted data is important. Sometimes just going in the playground and manually deleting some data is enogh to make the deploy safe
j
José Gomes
05/02/2019, 5:59 PMyeap, but even setting a default value for a required field, the deploy cannot be done
José Gomes
05/02/2019, 5:59 PMand i don't want to manually do stuff
José Gomes
05/02/2019, 5:59 PMthat destroys the workflow
j
Jared
05/02/2019, 5:59 PMprisma deploy --forceJared
05/02/2019, 5:59 PMtry locally first
Jared
05/02/2019, 6:00 PMalso
prisma deploy --dry-runj
José Gomes
05/02/2019, 6:00 PMYou are creating a required field but there are already nodes present that would violate that constraint.
José Gomes
05/02/2019, 6:00 PMeven with force
José Gomes
05/02/2019, 6:01 PMfieldExample: String! @default(value: "EXAMPLE")
José Gomes
05/02/2019, 6:01 PMwhy don't prisma just set the field with the default value when deploying?
José Gomes
05/02/2019, 6:01 PMdo i really need to make the field not required, then set the data for all rows, and then deploy again with the required?
j
Jared
05/02/2019, 6:02 PMIt depends what you are aiming for. running an updateall mutation might do the trick
Jared
05/02/2019, 6:05 PMsorry, the syntax is
updateManyUsersj
José Gomes
05/02/2019, 6:06 PMi expected to do it without programming, only editing the schema
José Gomes
05/02/2019, 6:07 PMi think it's kind of the main purpose here, to be easy
j
Jared
05/02/2019, 6:07 PM¯\_(ツ)_/¯
j
José Gomes
05/02/2019, 6:07 PMi change the schema, make it required, set a default value, and it just works
José Gomes
05/02/2019, 6:07 PMhm
José Gomes
05/02/2019, 6:07 PMbut i seems that it isn't like that
José Gomes
05/02/2019, 6:08 PMbut thanks anyway 🙂
j
Jared
05/02/2019, 6:08 PMsome migrations need a little help
t
tmoney
05/02/2019, 7:04 PMTis the reason they are working on a much more robust migrations solution: https://github.com/prisma/rfcs/blob/migrations/text/0000-migrations.md
tmoney
05/02/2019, 7:06 PMCouple of the proposed commands:
Copy code
prisma migrate rollback
prisma migrate rollback --pending18 Views