【Node.js】ユーザーアカウント登録→ログインを実装する

CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `mailaddress` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `password` text COLLATE utf8mb4_bin,
  `active` tinyint(1) DEFAULT NULL,
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin

  const { count, rows } = await db.Users.findAndCountAll({
    where: {
      mailaddress: req.body.mailaddress
    },
    offset: 0,
    limit: 1
  });
  if(count == 0){
    // 行がない場合のみアカウント登録処理
  } else {
    // アカウントが重複している旨エラーを返す
  }

  let hashed_password = bcrypt.hashSync(req.body.password, 10);
  // パスワードを平文で持たず暗号化します

  const newUser = await db.Users.create({
      name: req.body.name,
      mailaddress: req.body.mailaddress,
      password : hashed_password,
      active: true
    });
    if (newUser){
      req.session.user = {id: newUser.id};
      signup_failed_reason = '';
    } else {
      signup_failed_reason = 'アカウント登録に失敗しました。';
    }

router.post('/login', async function(req, res) {

  login_mailaddress = req.body.mailaddress;
  let hashed_password = bcrypt.hashSync(req.body.password, 10);

  const { count, rows } = await db.Users.findAndCountAll({
    where: {
      mailaddress: req.body.mailaddress,
      password: hashed_password,
    },
    offset: 0,
    limit: 1
  });

$password_query = sprintf("select HEX(AES_ENCRYPT('%s', '%s')) as enc_password", $this->request->getVar('update_password'), LOGIN_ENCRYPT_KEY);
$enc_password = $this->db->query($password_query)->getRowArray()['enc_password'];
// こいつを作ってアカウント検索時のwhere句に入れる

router.post('/login', async function(req, res) {

  login_mailaddress = req.body.mailaddress;

  const { count, rows } = await db.Users.findAndCountAll({
    raw: true,
    where: {
      mailaddress: req.body.mailaddress,
    },
    offset: 0,
    limit: 1
  });
  if(count == 0){
    login_failed_reason = 'アカウントがありません。';
    res.redirect('/');
  } else {
    var row = rows[0];
    if (bcrypt.compareSync(req.body.password, row.password) ) {
      req.session.user = {id: row.id};
    } else {
      login_failed_reason = 'パスワードが誤っています。';
    }
    res.redirect('/');
  }
});