sequelize是nodejs版的orm库，用过laravelORM的能很快能上手

具体文档

  • 官网
  • github

简略代码demo

const { Sequelize, DataTypes, Model, QueryTypes, Op } = require("sequelize");const sequelize = new Sequelize("sqlite://sql.db", { logging: false });class User extends Model {}class Address extends Model {}User.init(  {    // 在这里定义模型属性    id: {      type: DataTypes.INTEGER,      primaryKey: true,      autoIncrement: true,    },    name: {      type: DataTypes.STRING,      unique: true,      // allowNull 默认为 true      validate: {        async isUnique(name) {          const res = await User.findOne({where: {name}})          if (res) throw new Error('用户名已存在')        },        // len: [1,2]      }    },  },  {    // 这是其余模型参数    sequelize, // 咱们须要传递连贯实例    // modelName: "User", // 咱们须要抉择模型名称    tableName:'users' // 表名，默认为模型名的复数单词  });Address.init(  {    id: {      type: DataTypes.INTEGER,      primaryKey: true,      autoIncrement: true,    },    name: {      type: DataTypes.STRING,      unique: true,      // allowNull 默认为 true    },  },  {    sequelize,    modelName: "Address",  });// 模型关系 多对多User.belongsToMany(Address, { through: "userAddress", as:'addres' }); // through 代表两头表的名字，as是查问别名Address.belongsToMany(User, { through: "userAddress" });(async () => {  try {    // await sequelize.sync({ alter: true });  // 同步模型到数据库-创立表    // const user = await User.findOne({ where: { name: {[Op.like]:'%小%'} } }); // 根本查问    const [user] = await User.findOrCreate({where:{name:'小小'},include:'addres'}); // 顺带查问到关联模型的数据        const [address] = await Address.findOrCreate({where:{name:'小小de地址'}});    await user.addAddress(address); // 关联减少    console.log(user.toJSON());  } catch (e) {    console.log(e);  }})();