mysql - 如何为现有的 sails 项目设置 sequelize

Question

    // finding users
    find:  function (req, res, next) {
      var userId = req.body.userId;
      var userSchema = db.UserModel;
      try {

        db.sequelize.sync().then(function (params) {
          userSchema.findAll({where:{userId:userId}}).then(function (user) {

            return res.json({
              success:true,
              userData:user.get({
                plain:true
              })
            });

          });

        });

      } catch (ex) {
        res.json({
          success: false,
          exception: ex
        });
        return;
      }
    }

我正在为我的项目编写简单的 crud api。在执行上述代码时，我的控制台出现错误:

Executing (default): SELECT userId, firstname, lastname, email, createdAt, updatedAt FROM Users AS User WHERE User.userId = '1'; Unhandled rejection TypeError: Cannot read property 'get' of undefined at D:\tecsol\mtv\api\controllers\UserController.js:52:27 at processImmediate [as _immediateCallback] (timers.js:367:17)

Answer 1

user 是一个数组 - 使用 findOne或用户[0]