How do I handle migrations in Node.js using an ORM?

How do I handle migrations in Node.js using an ORM?

You can use libraries like Sequelize or TypeORM for managing migrations in Node.js. Would you like a specific example?

Yes, please provide an example using Sequelize.

First, install Sequelize CLI: npm install --save-dev sequelize-cli. Then, create a migration file using npx sequelize-cli migration:generate --name create-users-table.

What should I include in the migration file?

In the migration file, define the up and down methods. For example, in up, you can create a table with queryInterface.createTable('Users', { id: { type: Sequelize.INTEGER, primaryKey: true, autoIncrement: true }, name: Sequelize.STRING });.

How do I run the migration after creating the file?

Run the migration with npx sequelize-cli db:migrate. This will apply the changes to your database.