How to use

findOne

function

in

Model

test("loads one record", async () => {
  const User = await defineModel({
   keys: {"1": "uDiMcWVNTuz//naQ88sOcN+E40CyBRGzGTT7OkoBS6M="}
  });

  await User.create({email: "EMAIL", secret: "SECRET"});
  const user = await User.findOne();

  assert.equal(user.email, "EMAIL");
  assert.equal(user.secret, "SECRET");
 });

User.findOne({ where: { email } }).then((user) => {
  if (!user) return done(null, false, { message: `There is no record of the email ${email}.` });
  return user.comparePassword(password).then(
   (result) => {
    if (result) done(null, user);
    else done(null, false, { message: 'Your email/password combination is incorrect.' });
  });
 }).catch((err) => {
  console.log(err);
  done(null, false, { message: 'Something went wrong trying to authenticate' });
 })

// 获取数据库版本信息
const getDbVersionConfigAsync = async () => {
 return Config.findOne({
  attributes: ['configId', 'value'],
  where: {
   key: 'version'
  }
 })
}

User.findOne({
      where: {
        id: user_id
      }
    }).then(function(user) {
      if (user) {
        dfd.resolve(user.get('to_dict'));
      } else {
        dfd.reject();
      }
    });

// the function that sets up the global context for each resolver, using the req
const context = async ({ req }) => {
 // simple auth check on every request
 const auth = (req.headers && req.headers.authorization) || "";
 const email = Buffer.from(auth, "base64").toString("ascii");

 // if the email isn't formatted validly, return null for user
 if (!isEmail.validate(email)) return { user: null };
 // find a user by their email
 const users = await store.users.findOne({ where: { email } });
 const user = users && users[0] ? users[0] : null;

 return { user: { ...user.dataValues } };
}

const show = function(req, res) {
 const id = parseInt(req.params.id, 10);
 if (Number.isNaN(id)) return res.status(400).end();

 models.User.findOne({
  where: {id}
 }).then(user => {
  if (!user) return res.status(404).end();
  res.json(user);
 });
}

server.deserializeClient((id, done) => {
 db.Client.findOne({where: {id: id}})
 .then((client) => done(null, client))
 .catch((err) => done(new Error('Internal Server Error')))
})

const check = () => (ctx, next) =>
 Chats.findOne({ where: { id: ctx.update.message.chat.id } })
  .then((chat) => (chat && chat.dataValues.isActive)
   ? next()
   : debug('not started'))

passport.deserializeUser(function(id, done) {
  Model.User.findOne({
   where: {
    'id': id
   }
  }).then(function (user) {
   if (user == null) {
    done(new Error('Wrong user id.'))
   }
   
   done(null, user)
  })
 })

models.User.findOne({
  where: {
   id: id
  }
 }).then(user => {
  if (!user) {
   return res.status(404).json({error: 'No User'});
  }
  return res.json(user);
 });

models.Attack.findOne({where : {name: name}}).then(function(attack) {
  if(err){
   console.log(err)
   cb(err)
  }else{
   cb(attack)
  }
 })

/**
 * Gets a SavedRate from the database by UUID.
 *
 * @param {string} uuid
 */
function getSavedRateByUuid(uuid) {
 return SavedRate.findOne({ where: { uuid } })
  .then(getPlainObject);
}

function selectOneProject (id) {
 return Projects.findOne({
  where: { id: id },
  raw: true
 })
}

function selectOneApi(id) {
 return  Apis.findOne({
  where: {
   id: id,
   state: 1
  },
  raw: true
 })
}

function findOneApiByUrl (name) {
 return Apis.findOne({
  where: {
   url: name,
   state: 1
  },
  raw: true
 })
}