How do I handle database migrations in Node.js?

How do I handle database migrations in Node.js?

You can use libraries like Sequelize or Knex.js to manage database migrations in Node.js. Would you like a code example?

Yes, please provide a code example using Sequelize.

Sure! First, install Sequelize and the database driver. Then, you can create a migration file using the CLI. Here's a basic example:

const { Sequelize } = require('sequelize');
const sequelize = new Sequelize('database', 'username', 'password', {
  host: 'localhost',
  dialect: 'mysql',
});

// Migration example
async function migrate() {
  await sequelize.query(`CREATE TABLE Users (id INT PRIMARY KEY, name VARCHAR(100));`);
}

migrate();

What if I want to roll back a migration?

You can create a down method in your migration file to handle rollbacks. For example:

async function down() {
  await sequelize.query(`DROP TABLE Users;`);
}