In sails.js, how can we stop the automigration of the schema into the database. Sometimes,it gives error due to the migration. Is there a way that we can make the migration run only when the application is deployed?
In sails.js, how can we stop the automigration of the schema into the database. Sometimes,it gives error due to the migration. Is there a way that we can make the migration run only when the application is deployed?
Share Improve this question edited Nov 5, 2015 at 21:48 Joe Hill 3333 silver badges12 bronze badges asked Dec 10, 2013 at 9:40 Luja ShresthaLuja Shrestha 2,8572 gold badges24 silver badges29 bronze badges3 Answers
Reset to default 7You can also try something like this:
module.exports = {
// migrate: 'alter', // adds and/or removes columns on changes to the schema
// migrate: 'drop', // drops all your tables and then re-creates them. All data is deleted.
// migrate: 'safe', doesn't do anything on sails lift- for use in production.
attributes: { /* ... */ }
};
We can achieve that by specifying the migrate property in the model. Its default value is alter which attempt to auto-migrate the schema on every alteration.
module.exports = {
schema: true,
migrate: 'safe',
adapter: 'mysql',
attributes: {}
}
For all models you can change in confing/models.js
migrate: 'safe',