server.js

"use strict";

require('dotenv').config();

const PORT            = process.env.PORT || 8080;
const ENV             = process.env.NODE_ENV || "development";
const express         = require("express");
const bodyParser      = require("body-parser");
const cookies         = require('cookie-session');
const sass            = require("node-sass-middleware");
const bcrypt          = require("bcrypt");
const methodOverride  = require("method-override");
const app             = express();

const knexConfig      = require("./knexfile");
const knex            = require("knex")(knexConfig[ENV]);
const morgan          = require('morgan');
const knexLogger      = require('knex-logger');

// Separated Routes for each Resource
const usersRoutes = require("./routes/users");
const linksRoutes = require("./routes/links");
const homeRoutes = require("./routes/home");
const ratingsRoutes = require("./routes/ratings");
const commentsRoutes = require("./routes/comments");
const usersboardRoutes = require("./routes/users_boards");
const learnedlinkRoutes = require("./routes/learned_links");
const userslinkRoutes = require("./routes/users_links");
const boards = require("./routes/boards");
const linksTopicsRoutes = require("./routes/linkstopics");
const searchRoutes = require("./routes/search");

// Encrypting user sessions
app.use(cookies({
  name: "session",
  keys: ["secretkey"]
}));

// 'dev' = Concise output colored by response status for development use.
//         The :status token will be colored red for server error codes, yellow for client error codes, cyan for redirection codes, and uncolored for all other codes.
app.use(morgan('dev'));

// Log knex SQL queries to STDOUT as well
app.use(knexLogger(knex));

app.set("view engine", "ejs");
app.use(bodyParser.urlencoded({ extended: true }));
app.use("/styles", sass({
  src: __dirname + "/styles",
  dest: __dirname + "/public/styles",
  debug: true,
  outputStyle: 'expanded'
}));
app.use(express.static("public"));
app.use(methodOverride("_method"));

// Mount all resource routes
app.use("/api/users", usersRoutes(knex));
app.use("/links", linksRoutes(knex));
app.use("/api/links", homeRoutes(knex));
app.use("/api/ratings", ratingsRoutes(knex));
app.use("/api/comments", commentsRoutes(knex));
app.use("/api/userboards", usersboardRoutes(knex));
app.use("/api/learnedlinks", learnedlinkRoutes(knex));
app.use("/api/userlinks", userslinkRoutes(knex));
app.use("/boards", boards(knex));
app.use("/api/linkstopics", linksTopicsRoutes(knex));
app.use("/results", searchRoutes(knex));

// Home page
app.get("/", (req, res) => {
  if (req.session.userid) {
  knex
    .select('*')
    .from('users')
    .where('id', req.session.userid)
    .then((userInfo) => {
      let templateVars = userInfo[0];
      return res.render('index', templateVars);
    });
  } else {
    let templateVars = { id: req.session.userid };
    return res.render('index', templateVars);
  }
});


// Account Page
app.get("/users/:userid", (req, res) => {
  knex.select('*').from('users')
    .join('boards',{'users.id' : 'boards.user_id'})
    .where('user_id', req.session.userid)
    .then(function(results) {
      if (results[0] === undefined) {
        knex.select('*')
          .from('users')
          .where('id', req.session.userid)
          .then(function(results) {
            const user = results[0];
            const template = {
              full_name: user.full_name,
              email: user.email,
              avatar: user.avatar,
              id: req.session.userid,
              username: user.username,
              date: user.create_date
            }
            return res.render('account_page', template);
          });
      } else {
        const walls = results[0];
        const templateVars = {
          full_name: walls.full_name,
          email: walls.email,
          avatar: walls.avatar,
          id: req.session.userid,
          date: walls.create_date,
          username: walls.username,
          title: walls.title
        }
        res.render('account_page', templateVars);
      }
    });
});

// User Profile
app.get("/users/:username/profile", (req, res) => {
  knex
  .select('id', 'full_name', 'username', 'email', 'avatar')
    .from('users')
    .where('id', req.session.userid)
    .then((userInfo) => {
      let templateVars = userInfo[0];
      return res.render('edit_profile', templateVars);
  });
});

// User Profile Update
app.put('/users/:username/profile/update', (req, res) => {
  const hashedPassword = bcrypt.hashSync(req.body.password, 10);
  knex('users')
    .where({id: req.session.userid})
    .update({full_name: req.body.fullName, email: req.body.email, password: hashedPassword, avatar: req.body.avatar})
    .then((results) => {
      return res.redirect(`/users/${req.body.username}/profile`);
    });
});


// Login
app.post("/login", (req, res) => {
  knex
    .select("*")
    .from("users")
    .then((results) => {
      for (let i = 0; i < results.length; i++) {
        if (req.body.username === results[i].username && bcrypt.compareSync(req.body.password, results[i].password) === true) {
          req.session.userid = results[i].id;
          console.log("MATCH");
          return res.redirect("/");
        }
      }
      return res.status(403).send("HTTP 403 - NOT FOUND: USERNAME OR PASSWORD INCORRECT!").end();
    });
});

// Register
app.post("/register", (req, res) => {
  const hashedPassword = bcrypt.hashSync(req.body.password, 10);
  knex
    .select("*")
    .from("users")
    .then((results) => {
      for(let i = 0;i < results.length;i++) {
        if (req.body.email === results[i].email) {
          return res.status(400).send("HTTP 400 - BAD REQUEST: E-MAIL ALREADY USED!").end();
        } else if (req.body.username === results[i].username) {
          return res.status(400).send("HTTP 400 - BAD REQUEST: USERNAME ALREADY USED!").end();
        }
      }
      knex("users")
        .insert({full_name: req.body.fullName, username: req.body.username, email: req.body.email, password: hashedPassword, avatar: `https://avatars.dicebear.com/v2/avataaars/${req.body.username}.svg`, create_date:knex.fn.now()})
        .then(() => {
          knex
            .select('id')
            .from('users')
            .where('username', req.body.username)
            .then((results) => {
              req.session.userid = results[0].id;
              knex("boards")
                .insert({user_id: req.session.userid, title: 'First Wall', create_date:knex.fn.now()})
                .then(() => {
                  return res.redirect(`/users/${req.body.username}`);
                });
            });
        });
    });
});

// Clears cookies upon logging out
app.post("/logout", (req, res) => {
  req.session = null;
  return res.redirect("/");
});

app.listen(PORT, () => {
  console.log("Example app listening on port " + PORT);
});