無法在sequelize中獲取用戶ID？

這是用戶模型

const { Model } = require("sequelize");
module.exports = (sequelize, DataTypes) => {
  class User extends Model {
    /**
     * Helper method for defining associations.
     * This method is not a part of Sequelize lifecycle.
     * The `models/index` file will call this method automatically.
     */
    static associate({ Kyc }) {
      // define association here
      this.hasOne(Kyc, { foreignKey: "userID" });
    }
  }
  User.init(
    {
      uuid: {
        type: DataTypes.UUID,
        defaultValue: DataTypes.UUIDV4,
        allowNull: false,
      },
      firstname: {
        type: DataTypes.STRING,
        allowNull: false,
      },
      lastname: {
        type: DataTypes.STRING,
        allowNull: false,
      },
      email: {
        type: DataTypes.STRING,
        allowNull: false,
      },
      role: {
        type: DataTypes.STRING,
        defaultValue: "user",
        allowNull: false,
        validate: {
          roles(value) {
            const rolesArray = ["user", "admin"];
            if (!rolesArray.includes(value)) {
              throw new Error('plese enter valid role "user or admin"');
            }
          },
        },
      },
      password: {
        type: DataTypes.STRING,
        allowNull: false,
      },
    },
    {
      sequelize,
      modelName: "User",
    }
  );
  return User;
};

這是kyc模型

const { Model } = require("sequelize");
module.exports = (sequelize, DataTypes) => {
  class Kyc extends Model {
    /**
     * Helper method for defining associations.
     * This method is not a part of Sequelize lifecycle.
     * The `models/index` file will call this method automatically.
     */
    static associate({ User }) {
      // define association here
      this.belongsTo(User, { foreignKey: "userID", as: "user" });
    }
  }
  Kyc.init(
    {
      uuid: {
        type: DataTypes.UUID,
        defaultValue: DataTypes.UUIDV4,
        allowNull: false,
      },
      docimg: {
        type: DataTypes.STRING,
        allowNull: false,
      },
      details: {
        type: DataTypes.STRING,
        allowNull: false,
      },
      status: {
        type: DataTypes.STRING,
        allowNull: false,
      },
      userID: {
        type: DataTypes.INTEGER,
        allowNull: false,
      },
    },
    {
      sequelize,
      modelName: "Kyc",
    }
  );
  return Kyc;
};

kyc中間件

const verifyKyc = async (req, res, next) => {
  // check that user has posted or not if yes then give error
  const user = await User.findByPk(req.user.id);

  const kyc = await Kyc.findOne({
    userID: req.user.id,
  });
  console.log(user.id);
  console.log(kyc);
  if (user.id === kyc) {
  }
  next();
};

錯誤

執行（默認）： SELECT "id", "uuid", "firstname", "lastname", "email", "role", "password", "createdAt", "updatedAt" FROM "Users" AS "User" WHERE "用戶"."id" = 1; （續集）警告：模型屬性（userID）傳遞到模型 Kyc 的 finder 方法選項中，但 options.where 物件為空。您是否忘記使用 options.where？執行（默認）：SELECT "id", "uuid", "docimg", "details", "status", "userID", "createdAt", "updatedAt" FROM "Kycs" AS "Kyc" LIMIT 1;

1
Kyc {
  dataValues: {
    id: 117,
    uuid: '99461f78-4781-42cc-a01f-b6541fda849d',
    docimg: 'admin.png',
    details: 'KSAPK0550P',
    status: 'pending',
    userID: 1,
    createdAt: 2022-06-04T10:59:21.039Z,
    updatedAt: 2022-06-04T10:59:21.039Z
  
  _previousDataValues: {
    id: 117,
    uuid: '99461f78-4781-42cc-a01f-b6541fda849d',
    docimg: 'admin.png',
    details: 'KSAPK0550P',
    status: 'pending',
    userID: 1,
    createdAt: 2022-06-04T10:59:21.039Z,
    updatedAt: 2022-06-04T10:59:21.039Z
  
 
  isNewRecord: false
}

我想列印用戶 ID 但給我這個錯誤謝謝你的幫助

uj5u.com熱心網友回復：

您忘記將您的條件包裝到where選項中：

const kyc = await Kyc.findOne({
    where: {
      userID: req.user.id,
    }
  });

標籤：节点.js PostgreSQL 表示 猫鼬 续集.js

上一篇：SyntaxError:Unexpectedtoken'for'inI:\CompleteWebDevelopmentCourse\EJS\ToDoList\views\

下一篇：如何在vercel上托管的expressjs中加載影像