//1.導(dǎo)入Sequelize模塊
const Sequelize = require('sequelize');
//2.使用Sequelize模塊配置和數(shù)據(jù)庫(kù)的連接信息
const mysql_Sequelize = new Sequelize('sales','root','syy2589',{
    host:'localhost', //數(shù)據(jù)庫(kù)服務(wù)器的IP地址或域名
    port:'3306', //數(shù)據(jù)庫(kù)使用的端口號(hào)，MySQL數(shù)據(jù)庫(kù)默認(rèn)端口號(hào)3306
    dialect: 'mysql', //數(shù)據(jù)庫(kù)的類型
    pool:{  //數(shù)據(jù)庫(kù)連接池：可以放若干個(gè)數(shù)據(jù)庫(kù)的連接對(duì)象，提高數(shù)據(jù)庫(kù)訪問(wèn)效率
        max:20, //數(shù)據(jù)庫(kù)連接池中連接對(duì)象的最大個(gè)數(shù)
        min:3, //數(shù)據(jù)庫(kù)連接池中連接對(duì)象的最少個(gè)數(shù)
        idle:20000 //等待延遲的時(shí)間，單位：毫秒
    },
    define:{
        'charset':'utf8' //處理MySQL中中文字符的問(wèn)題
    }
})
// 3.導(dǎo)出數(shù)據(jù)庫(kù)的連接對(duì)象
module.exports = mysql_Sequelize;

const mysqltest = require('./mysqlconfig.js');
mysqltest.authenticate() //用來(lái)測(cè)試數(shù)據(jù)庫(kù)是否連接成功
    .then(()=>{
        console.log('數(shù)據(jù)庫(kù)連接成功~')
    })
    .catch((err)=>{
        console.error(err);
    })

const  Sequelize = require(sequelize);
//1.導(dǎo)入數(shù)據(jù)庫(kù)的配置對(duì)象
const mysql_Sequelize = require('../config/mysqlconfig.js');
// 2.創(chuàng)建模型與數(shù)據(jù)庫(kù)中的表實(shí)現(xiàn)映射
const Employee = mysql_Sequelize.define('employee',{
    'e_id':{
        type:Sequelize.STRING,
        // type:Sequelize.INTEGER, 表示id的數(shù)據(jù)類型為int型
        autoIncrement:false, //表示id的值在表中是否自增
        allowNull:false, //表示id對(duì)象的值不能為空
        fields:'e_id',//實(shí)現(xiàn)模型的屬性名和表的列名之間的映射關(guān)系(對(duì)應(yīng)關(guān)系)
    },
    'e_name':{
        type:Sequelize.STRING,
        autoIncrement:false,
        allowNull:false,
        fields: 'e_name',
    },
    'sex':{
        type:Sequelize.STRING,
        autoIncrement:false,
        allowNull:false,
        fields: 'sex',
    },
    'apartment':{
        type:Sequelize.STRING,
        autoIncrement:false,
        allowNull:true,
        fields: 'apartment',
    },
    'phone':{
        type:Sequelize.STRING,
        autoIncrement:false,
        allowNull:true,
        fields: 'phone',
    },
    'address':{
        type:Sequelize.STRING,
        autoIncrement:false,
        allowNull:true,
        fields: 'address',
    },
},{
    freezeTableName:true, //不使用Sequelize給模型自定義的表名(自定義表名的命名規(guī)則：模型名后加s)
    timestamps:false //若為true，在獲取數(shù)據(jù)時(shí)會(huì)自動(dòng)添加兩列數(shù)據(jù)(createTime、updateTime)
});
// 導(dǎo)出模型
module.exports = Employee;

// http://localhost:9000/employee/addemp
Emprouter.post('/addemp',(req,res)=>{
    console.log(req.body);
    Employee.create({
        id:req.body.id,
        name:req.body.name,
        sex:req.body.sex,
        apartment:req.body.apartment,
        phone:req.body.phone,
        address:req.body.address
    }).then((result)=>{
        if(result){
            res.json({
                code:1002
            })
        }
    })
})

Emprouter.get('/findemp',(req,res)=>{
    if(req.url != './favicon.ico'){
        Employee.findAll().then((result)=>{
            res.send(JSON.stringify(result));
        })
    }
})

const Op = require('sequelize').Op;

Emprouter.post('/findlike',(req,res)=>{
    // 獲取前端發(fā)送的部門
    let apartment = req.body.apartment;
    // 進(jìn)行模糊查詢
    Employee.findAll({
        where:{
            apartment:{
                [Op.like]:apartment+'%'
            }
        }
    }).then((result)=>{
        res.json(result);
    }).catch((e)=>{
        console.log(e);
        res.json('查詢失敗~')
    })
})