nodejs, mysql 연동

https://sequelize.org/master/manual/getting-started.html

Manual | Sequelize

Getting Started In this tutorial you will learn to make a simple setup of Sequelize. Installing Sequelize is available via npm (or yarn). npm install --save sequelize You'll also have to manually install the driver for your database of choice: # One of the

sequelize.org

npm install --save sequelize
npm install --save mysql2

const { Sequelize } = require('sequelize');

const sequelize = new Sequelize('database', 'username', 'password', {
  host: 'localhost',
  dialect: /* one of 'mysql' | 'mariadb' | 'postgres' | 'mssql' */
});

sequelize와 db를 연동시켜줍니다.

try {
  await sequelize.authenticate();
  console.log('Connection has been established successfully.');
} catch (error) {
  console.error('Unable to connect to the database:', error);
}

위의 코드를 사용하면 디비연동 체크를 할 수가 있습니다.

그리고 모델을 만들어줍니다.

const User = sequelize.define("User", {
  firstName: {
    type: DataTypes.STRING,
    allowNull: false
  },
  lastName: {
    type: DataTypes.STRING,
    allowNull: false
  }
});

User.sync();