express 使用sequelize链接mysql数据库

1、安装mysql2，sequelize，sequelize-automate

npm install sequelize sequelize-automate mysql2 dotenv

2、配置sequelize和sequelize-automate

//utils文件夹下的 sequelize.js

const Sequelize = require('sequelize');
require('dotenv').config(); // 加载 .env 配置文件
const fs = require('fs');
// 连接到 MySQL 数据库
const sequelize = new Sequelize({
    dialect: process.env.DB_DIALECT || 'mysql',
    host: process.env.DB_HOST || 'localhost',
    port: process.env.DB_PORT || 3306,
    username: process.env.DB_USERNAME || '',
    password: process.env.DB_PASSWORD || '',
    database: process.env.DB_DATABASE || '',
    dialectModule: require('mysql2'),
    logging: false
})

 
module.exports = sequelize;

3、环境配置文件

// .env
DB_DIALECT=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=demo
DB_USERNAME=root
DB_PASSWORD=123456
BASE_URL=http://localhost:3002

4、app.js 引入数据库配置文件

const dbConfig = require('./utils/sequelize')
dbConfig.authenticate()  //用来测试数据库是否连接成功
          .then(()=>{
              console.log('数据库连接成功')
          }).catch((err)=>{
              console.log('数据库连接失败'+err)
          })