learn sequelize

index.js

import { Sequelize, DataTypes } from "sequelize";

const sequelize = new Sequelize("rainjn", "root", "", {
  host: "localhost",
  dialect: "mysql",
  define: {
    timestamps: false,
  },
});
const queryInterface = sequelize.getQueryInterface();

queryInterface.createTable("admins", {
  id: {
    type: DataTypes.INTEGER,
    primaryKey: true,
    autoIncrement: true,
  },
  name: DataTypes.STRING,
  age: DataTypes.INTEGER,
});
const Admin = sequelize.define("admins", {
  id: {
    type: DataTypes.INTEGER,
    primaryKey: true,
    autoIncrement: true,
  },
  name: DataTypes.STRING,
  age: DataTypes.INTEGER,
});

(async () => {
  const admins = await Admin.findAll();
  console.log(admins);
  await Admin.create({
    name: "javascript",
    age: 73,
  });
  const admins2 = await Admin.findAll();
  console.log(admins2);
})();