Reputation: 13
I have models defined in the project, where I need column insertion is needed, for that I have just added the new column and its type to the particular model file.
Also tried with {alter:true} but not reflected in Database table.Also having error while inserting a new record,
Unknown column 'isActive' in 'field list'
Upvotes: 0
Views: 1476
Reputation: 1
You can try this below after importing that file
await sequelize.sync({ alter: true })
.then(() => console.log('Database schema updated'))
.catch((error) => console.error('Error syncing database:', error));
Upvotes: 0
Reputation: 1918
The error is because of your database is not updated with the new model, so it's normal. After updating your database successfully it won't be a problem.
It's hard to say anything before looking at the code but I guess your import (require) logic is the problem. Even if you fix that you are using sync
function which is not good for production. It's just for testing purposes.
You should use sequelize migrations. With the help of it you can track your db changes and do not lose important data. It is a must in production but it's still good to use in development.
Read Sequelize Migrations
Upvotes: 0