Node+TS+Koa+vue 商城全栈(三) sequelize 创建种子文件
1.用户表种子文件(示例):
seeders/20200204173530-user.js
const md5 = require('md5'); const moment = require('moment'); module.exports = { up: (queryInterface, Sequelize) => { /* Add altering commands here. Return a promise to correctly handle asynchronicity. Example: return queryInterface.bulkInert('Person', [{ name: 'John Doe', isBetaMember: false }], {}); */ return queryInterface.bulkInsert('user', [ { id: 1, username: 'mt', password: md5('123456'), disabled: false, mobile: '13000000000', email: 'mt@meishi.com', created_ip_at: '127.0.0.1', updated_ip_at: '127.0.0.1', created_at: moment().format('YYYY-MM-DD HH:mm:ss'), updated_at: moment().format('YYYY-MM-DD HH:mm:ss') }, { id: 2, username: 'zmouse', password: md5('123456'), disabled: false, mobile: '13000000000', email: 'zmouse@meishi.com', created_ip_at: '127.0.0.1', updated_ip_at: '127.0.0.1', created_at: moment().format('YYYY-MM-DD HH:mm:ss'), updated_at: moment().format('YYYY-MM-DD HH:mm:ss') }, { id: 3, username: 'reci', password: md5('123456'), disabled: false, mobile: '13000000000', email: 'reci@meishi.com', created_ip_at: '127.0.0.1', updated_ip_at: '127.0.0.1', created_at: moment().format('YYYY-MM-DD HH:mm:ss'), updated_at: moment().format('YYYY-MM-DD HH:mm:ss') }, { id: 4, username: 'kimoo', password: md5('123456'), disabled: false, mobile: '13000000000', email: 'kimoo@meishi.com', created_ip_at: '127.0.0.1', updated_ip_at: '127.0.0.1', created_at: moment().format('YYYY-MM-DD HH:mm:ss'), updated_at: moment().format('YYYY-MM-DD HH:mm:ss') } ]); }, down: (queryInterface, Sequelize) => { /* Add reverting commands here. Return a promise to correctly handle asynchronicity. Example: return queryInterface.bulkDelete('Person', null, {}); */ return queryInterface.bulkDelete('user', null, {}); } };
根据种子文件添加数据
.\node_modules\.bin\sequelize db:seed:all
根据种子文件清空数据
.\node_modules\.bin\sequelize db:seed:undo:all
2.项目目录: