如何筛选一对多模型关系,以便只返回活动记录?

我们将此添加到所有模型json文件中:

  "scope": {
    "where": {
      "active": true
    }
  },

要删除,我们必须添加MIXIN:

  module.exports = function(Model, options) {
    console.log(`Adding softDelete mixin to model ${Model.name}`);
    Model.once("attached", function() {
      Model.deleteById = function(id, auth, cb) {
        // If your tables follow the TableNameID pattern for Ids, then do this: 
        //   `UPDATE ${Model.name} SET active=0 WHERE ${Model.name}ID = ?`;
        var query = `UPDATE ${Model.name} SET active=0 WHERE ID = ?`;

        Model.dataSource.connector.query(query, [id], function(err, result) {
          if (err) {
            console.log(err);
          }
          cb(null, { Success: "Record Deleted" });
        });
      };
    });
  };