users.js - routes - server - create user - Instagram Clone React Node

users.js

app.post("/users/create", upload.single("avatar"), (req, res, next) => {
  const file = req.file;
  if (!file) {
    res.status(200).jsonp({
      message: "Please upload your avatar",
    });
  } else {
    const avatar = `/${file.filename}`;
    const { id, email, password, fullname } = req.body;
    if (email && password && fullname) {
      const findAccountByEmail = "SELECT * FROM user_account WHERE user_email = ?";
      dbConn.query(findAccountByEmail, [email], function (error, account) {
        if (account && account.length !== 0) {
          res.status(200).jsonp({ message: 'The email existed in the system' });
        } else {
          const users = [[id, email, password, fullname, avatar]];
          const registerUserSql = "INSERT INTO user_account (id, user_email, user_password, user_full_name, user_avatar) VALUES ?";
          dbConn.query(registerUserSql, [users], function (error, insertedUser) {
            if (insertedUser) {
              res.status(200).jsonp({ avatar, insertId: insertedUser.insertId });
            } else { 
              res.status(200).jsonp({ message: 'Cannot create your account, please try again' });
            }
          });
        }
      });
    } else {
      return res.status(200).jsonp({ message: "Please input required fields" });
    }
  }
});