search

NIAEFEUP / website-niaefeup-backend

The backend for NIAFEUP's website.
2 stars 0 forks source link

db: handle database migrations #26

Open BrunoRosendo opened 2 years ago

BrunoRosendo commented 2 years ago

Currently, changing a model without changing or re-creating the database will result in the following exception:

org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "alter table event add column dummy integer not null" via JDBC Statement

We need to make sure we can easily do this kind of migrations when we have a production DB

BrunoRosendo commented 1 year ago

Consider the options specified in spring docs https://docs.spring.io/spring-boot/docs/2.1.1.RELEASE/reference/html/howto-database-initialization.html#howto-use-a-higher-level-database-migration-tool