egg.js删除mysql数据_egg学习笔记(6)--egg+mysql(sequelize)+vue实现curd

后台

项目

egg+mysql(sequelize)+vue实现curd

项目结构

mysql建表(collect)

CREATE TABLE `collect` (

`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '收藏id',

`author` varchar(255) DEFAULT NULL COMMENT '作者',

`date` varchar(255) DEFAULT NULL COMMENT '日期',

`link` varchar(255) DEFAULT NULL COMMENT '链接',

`title` varchar(255) DEFAULT NULL COMMENT '标题',

`created_at` datetime DEFAULT NULL COMMENT '创建时间',

`updated_at` datetime DEFAULT NULL COMMENT '更改时间',

PRIMARY KEY (`id`),

UNIQUE KEY `title` (`title`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='收藏表';

配置

egg安装模块

cnpm install egg-sequelize egg-cors --save

config/pulgin.js

exports.sequelize = {

enable: true,

package: 'egg-sequelize',

};

exports.cors = {

enable: true,

package: 'egg-cors',

};

config/config.default.js

//mysql配置开始

config.sequelize = {

dialect: 'mysql', // support: mysql, mariadb, postgres, mssql

dialectOptions: {

charset: 'utf8mb4',

},

database: 'egg04',

host: 'localhost',

port: '3306',

username: 'root',

password: '123456',

timezone: '+08:00',

};

//mysql配置结束

//cors配置开始

config.security = {

csrf: {

enable: false,

},

domainWhiteList: [ 'http://localhost:8080' ],

};

config.cors = {

credentials: true,

};

//cors配置结束

数据建模

model/collect.js

'use strict';

module.exports = app => {

const {

INTEGER,

STRING,

DATE

} = app.Sequelize;

const Collect = app.model.define(&#