index.js

const express = require("express");
const path = require("path");
const cookieParser = require("cookie-parser");
const session = require("express-session");
const bodyParser = require("body-parser");
const user = require("./user");
const serveStatic = require("serve-static");
const handlebars = require("express-handlebars");
const middlewares = require("./middlewares");
const userController = require("./controllers/userController");
const playlistsController = require("./controllers/playlistController");
const app = express();
const jwt = require("jsonwebtoken");
const multer = require("multer");
require("dotenv").config();
require("./setup.js");
const port = process.env.PORT || 3000;

const sqliteOptions = {
  client: "sqlite3",
  connection: {
    filename: "./dev.sqlite3"
  },
  useNullAsDefault: true
};
const knex = require("knex")(sqliteOptions);

const KnexSessionStore = require("connect-session-knex")(session);
const store = new KnexSessionStore({
  knex
});

app.locals.knex = knex;

app.set("port", port);
app.set("view engine", "handlebars");
app.set("views", `${__dirname}/components`);
app.use(bodyParser.urlencoded({ extended: true }));
app.use(cookieParser());
app.use(
  session({
    key: "user_sid",
    secret: "s3cr3t",
    resave: false,
    saveUninitialized: false,
    cookie: {
      expires: 1000 * 60 * 60 * 24 * 7
    },
    store
  })
);

const storage = multer.diskStorage({
  destination: (req, file, cb) => {
    cb(null, "public/uploads");
  },
  filename: (req, file, cb) => {
    cb(null, file.originalname);
  }
});
const upload = multer({
  storage: storage
  // fileFilter: (req, file, cb) => {
  //   console.log(file.mimetype);
  //   if (file.mimetype == "audio/mp3") {
  //     cb(null, true);
  //   } else {
  //     cb(null, false);
  //     cb("Please add mp3 files only for now");
  //   }
  // }
});

/* Global Middleware to conditional render stuff in views. */
app.use((req, res, next) => {
  if (req.cookies.user_sid && req.session.user) {
    res.locals.authenticated = true;
    res.locals.user = req.session.user;
  } else {
    res.locals.authenticated = false;
    res.clearCookie("user_sid");
  }
  next();
});

app.use(serveStatic(path.join(__dirname, "public")));
//Sets our app to use the handlebars engine
app.engine(
  ".hbs",
  handlebars({
    layoutsDir: `${__dirname}/components`,
    extname: ".hbs",
    defaultLayout: "layout",
    partialsDir: `${__dirname}/components/partials`
  })
);
app.set("view engine", ".hbs"); //Sets handlebars configurations (we will go through them later on)

app.get("/", userController.homePage);

app
  .route("/register")
  .get(middlewares.checkSession, userController.registerPage)
  .post(userController.register);
app
  .route("/login")
  .get(middlewares.checkSession, userController.loginPage)
  .post(userController.login);

app
  .route("/profile")
  .get(middlewares.authenticate, userController.userPlaylists);
app
  .route("/account-info")
  .get(middlewares.authenticate, userController.accountInfo)
  .post(middlewares.authenticate, userController.userStatus);

app
  .route("/edit-playlist/:playlistId")
  .get(middlewares.authenticate, playlistsController.editPlaylistPage)
  .post(middlewares.authenticate, playlistsController.editPlaylist);

app.get("/logout", userController.logout);
app.get("/playlists", playlistsController.listAllPlaylist);
app
  .route("/add-playlist")
  .get(middlewares.authenticate, playlistsController.addPlaylistPage)
  .post(middlewares.authenticate, playlistsController.createPlaylist);

app.get("/delete-playlist/:playlistId", (req, res) => {
  const { playlistId } = req.params;
  knex("playlists")
    .where("id", playlistId)
    .del()
    .then(() => {
      res.redirect("back");
    });
});
app.get("/delete-user", (req, res) => {
  const { user } = res.locals;
  knex("users")
    .where("id", user.id)
    .del()
    .then(() => {
      req.session.destroy(function(err) {
        res.clearCookie("jwt");
        res.redirect("/");
      });
    });
});
app.route("/playlist/:playlistId").get(playlistsController.playListPage);

app
  .route("/add-song/:playlistId")
  .get(middlewares.authenticate, playlistsController.addSongPage);

app.post("/add-song", upload.single("song"), playlistsController.addSong);
app.post("/add-song", (req, res) => {
  return res.json(req.body);
});

// app.post("/add-song/", upload.single("song"), playlistsController.addSong);
app.get("/delete-song/:songId", (req, res) => {
  const { songId } = req.params;
  knex("songs")
    .where("id", songId)
    .del()
    .then(() => {
      res.redirect("back");
    });
});

/* Accounts routes */
app.get("/accounts", middlewares.authenticate, userController.accountPage);
app.get("/account/:userId", middlewares.authenticate, userController.userPage);
app.get("/about", middlewares.authenticate, userController.aboutPage);
app.get("/contact", middlewares.authenticate, userController.contactPage);

app.use(middlewares.notFound);
app.listen(app.get("port"), () =>
  console.log(`Server running on ${app.get("port")}`)
);