How can I use Sequelize for seeding my database?

How can I use Sequelize for seeding my database?

You can use Sequelize's built-in seeding feature by creating seed files that define how to populate your database.

What does a typical seed file look like?

A typical seed file exports a function that takes a queryInterface and a Sequelize DataTypes object to define the data.

Can you show me an example of a seed file?

Sure! Here's a simple example:

'use strict';

module.exports = {
  up: async (queryInterface, Sequelize) => {
    await queryInterface.bulkInsert('Users', [
      { name: 'John Doe', email: '[email protected]', createdAt: new Date(), updatedAt: new Date() },
      { name: 'Jane Doe', email: '[email protected]', createdAt: new Date(), updatedAt: new Date() }
    ], {});
  },

  down: async (queryInterface, Sequelize) => {
    await queryInterface.bulkDelete('Users', null, {});
  }
};

How do I run the seed files after creating them?

You can run the seed files using the Sequelize CLI with the command npx sequelize-cli db:seed:all.