index.js

const { faker } = require('@faker-js/faker');
const mysql2 = require('mysql2');
const express = require("express");
const app = express();
const port = 8080
const path = require("path");
const { use } = require('react');
const methodOverride = require("method-override");

app.use(methodOverride("_method"));
app.use(express.urlencoded({extended: true}));
app.set("view engine", "ejs");
app.set("views", path.join(__dirname, "/views"));

const connection = mysql2.createConnection({
    host: 'localhost',
    user: 'root',
    database: 'delta_app',
    password: 'Querry@123'
});


let getRandomUser = () => {
  return [
    faker.string.uuid(),
    faker.internet.username(),
    faker.internet.email(),
    faker.internet.password(),
  ];
}



//HOME PAGE / HOME ROUTE 

app.get("/", (req, res) => {
  let q = `SELECT count(*) FROM user`;
  try{
    connection.query(q, (err, result)=>{
      if(err) throw err;
        let count = result[0]["count(*)"];
        // res.send(result[0]["count(*)"]);
        res.render("home.ejs", { count });
      }
    );
  }catch (err){
    console.log(err);
    res.send("some error in database");
  }
});

//SHOW USERS ROUTE
app.get("/user",(req,res)=>{
  let q = `SELECT * FROM user`;
  try{
    connection.query(q, (err, users)=>{
      if(err)throw err;
      res.render("showusers.ejs", { users });
    });
  }catch(err){
    console.log("some error occurred!");
    res.send("some error occurred!");
  }
});

// Edit route 
app.get("/user/:id/edit", (req, res) => {
  let { id } = req.params;
  let q = `SELECT * FROM user WHERE id='${id}'`;

  try {
    connection.query(q, (err, result) => {
      if (err) throw err;
      let user = result[0];
      res.render("edit.ejs", {user});
    });
  } catch (err) {
    console.log("some error occurred!");
    res.send("some error occurred!");
  }
});
//Update database route
app.patch("/user/:id",(req,res)=>{
  let {password: fromPass, username: newUsername}=req.body;
  let { id } = req.params;
  let q = `SELECT * FROM user WHERE id='${id}'`;

  try{
    connection.query(q, (err, result)=>{
      if(err)throw err;
      let user = result[0];
      if(fromPass != user.password){
        res.send("Incorrect Password");
      }else{
        let q2 = `UPDATE user SET username='${newUsername}' WHERE id='${id}'`;
        connection.query(q2,(err, result)=>{
          if(err) throw err;
          res.redirect("/user");
        })
      }
      // res.send(user);
    })
  }catch(err){
    console.log(err);
    res.send("Some error occured in Database!");
  }

})





app.listen(port, () => {
  console.log(`server is running on port:${port}`);
});




//inserting new data using placeholder
// let q = "insert into user (id, username, email, password) values ?";
// let data = [];
// for(let i=1; i<=100; i++){
//   data.push(getRandomUser());  // 100 fake user data generating by faker 
// }



// try{
//     connection.query(q, [data], (err, result)=>{
//         if(err) throw err;
//         console.log(result);
//     });
// }catch (err){
//     console.log(err);
// }

// connection.end();



// console.log(getRandomUser());