MySQL Data Insertion

const config = require("config");
const mysql = require("mysql2/promise");

const con = mysql.createConnection({
  connectionLimit: 50,
  host: config.get("dbHost"),
  user: config.get("dbUser"),
  password: config.get("dbPWD"),
  database: config.get("database"),
});

module.exports = con;

const config = require("config");
const bcrypt = require("bcrypt");
const connectDB = require("../utils/db.utils");

const createUser = async (data) => {
  try {
    const salt = await bcrypt.genSalt(config.get("saltFactor"));
    const passHash = bcrypt.hashSync(data.usrPass, salt);

    const userData = [data.usrName, data.usrEmail, passHash];

    const con = await connectDB;

    const sql =
      "INSERT INTO users (fullName, email, password) VALUES (?, ?, ?)";

    const [rows, fields] = await con.execute(sql, userData);
    return true;
  } catch (e) {
    return false;
  }
};

const checkEmail = async (email) => {
  try {
    const con = await connectDB;
    const sql = "SELECT COUNT(*) AS rowCount FROM users WHERE email = ?";
    const [rows, fields] = await con.execute(sql, [email]);

    if (rows[0].rowCount == 0) return true;
    else return false;
  } catch (e) {
    return false;
  }
};

const validUser = async (data) => {
  try {
    const con = await connectDB;
    const sql = "SELECT * FROM users WHERE email = ?";
    const [rows, fields] = await con.execute(sql, [data.usrEmail]);

    if (!rows) return false;

    const isValid = await bcrypt
      .compare(data.usrPass, rows[0].password)
      .catch((e) => false);

    if (!isValid) return false;
    else return rows[0].fullName;
  } catch (e) {
    return false;
  }
};

module.exports = { createUser, checkEmail, validUser };