MaaBackend/seeders/20191202025223-EquipmentSeeder.js

'use strict'
const faker = require('faker')

module.exports = {
  up: async (queryInterface, Sequelize) => {
    await queryInterface.bulkInsert(
      'sites',
      Array.from(Array(4).keys()).map(index => ({
        name: `工地 ${index}`
      }))
    )

    const sites = (await queryInterface.sequelize.query('SELECT id FROM sites'))[0]

    await queryInterface.bulkInsert(
      'equipments',
      Array.from(Array(10).keys()).map(index => ({
        name: `輔具編號 ${index}`,
        site_id: sites[faker.random.number({ min: 0, max: sites.length - 1 })].id
      }))
    )
    /*
      Add altering commands here.
      Return a promise to correctly handle asynchronicity.

      Example:
      return queryInterface.bulkInsert('People', [{
        name: 'John Doe',
        isBetaMember: false
      }], {});
    */
  },

  down: (queryInterface, Sequelize) => {
    return queryInterface.bulkDelete('equipments', null, {})
    /*
      Add reverting commands here.
      Return a promise to correctly handle asynchronicity.

      Example:
      return queryInterface.bulkDelete('People', null, {});
    */
  }
}