node.js - 将表更改迁移到生产 sailsjs 表的最佳方法

Question

我刚刚从我的数据库中丢失了 11,000 条记录，只是运行了 sailsjs 的命令，其中没有 --prod 部分，所以我想我应该问一下，当 Model.js 被删除时，更改生产服务器上的表的最佳方法是什么变了？

谢谢

Answer 1

自动迁移永远不应该在生产环境中进行。这是适用于任何具有重要数据的生产系统的常识性做法。有一些解决方案可用于迁移 sails.js 数据库。

1. sails-db-migrate : 用于 sails.js 的 db-migrate 集成

db-migrate integration for Sails.js. This is a fairly simple wrapper, which provides grunt tasks for running and creating migrations.

1. sails-migrations : Octopus 失踪、迁徙的 ARM

sails-migrations provides an easy way to manage database migrations with sails, based on the amazing https://github.com/tgriesser/knex lib. This means you can have fine-grained control over your schema/data transformations between versions.

1. Sequelize migrations

Sequelize 2.0.0 introduces a new CLI which is based on gulp and combines sequelize-cli and gulp-sequelize. The CLI ships support for migrations and project bootstrapping. With migrations you can transfer your existing database into another state and vice versa