Authentication Level 1 - Registering Users with Email and Password

import express from "express";
import bodyParser from "body-parser";
import pg from "pg";

const app = express();
const port = 3000;

const db = new pg.Client({
  user: "postgres",
  host: "localhost",
  database: "secrets",
  password: "password",
  port: 5432,
});
db.connect();

app.use(bodyParser.urlencoded({ extended: true }));
app.use(express.static("public"));

app.get("/", (req, res) => {
  res.render("home.ejs");
});

app.get("/login", (req, res) => {
  res.render("login.ejs");
});

app.get("/register", (req, res) => {
  res.render("register.ejs");
});

app.post("/register", async (req, res) => {
  const email = req.body.username;
  const password = req.body.password;

  try {
    const result = await db.query("INSERT INTO users (email, password) VALUES ($1, $2)"
  , [email, password]);
    console.log(result);
    res.render("secrets.ejs");
  } catch(err) {
    console.log(err.message);
    res.redirect("/");
  }
});

app.post("/login", async (req, res) => {
  const email = req.body.username;
  const password = req.body.password;

  try {
    let check = await db.query("SELECT id FROM users WHERE email = $1 AND password = $2", [email, password]);
    if(check.rows.length > 0) {
      res.render("secrets.ejs");
    } else {
      res.send("Fail to Login");
      res.redirect("/");
    }
  } catch(err) {
    console.log(err.message);
    res.redirect("/");
  }

});

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