server.js

const express = require("express");
const {
    getImages,
    addImage,
    getImageInfo,
    getComments,
    addComment,
    getMoreImages,
    getThread,
    addReply,
} = require("./db");
const app = express();
const multer = require("multer");
const uidSafe = require("uid-safe");
const path = require("path");
const { upload } = require("./s3");
const { DataBrew } = require("aws-sdk");
const { s3Url } = require("./config");
const { nextTick } = require("process");

app.use(
    // express.urlencoded({
    //     extended: false,
    // })

    express.json()
);

app.use(express.static("./public"));

const diskStorage = multer.diskStorage({
    destination: function (req, file, callback) {
        callback(null, __dirname + "/uploads");
    },
    filename: function (req, file, callback) {
        uidSafe(24).then(function (uid) {
            callback(null, uid + path.extname(file.originalname));
        });
    },
});

// limit on the file size!
const uploader = multer({
    storage: diskStorage,
    limits: {
        fileSize: 2097152,
    },
});

app.post("/upload", uploader.single("file"), upload, (req, res) => {
    const { username, title, description, id } = req.body;
    addImage(s3Url + req.file.filename, username, title, description)
        .then((data) => {
            console.log("successful db entry");
            return res.json({
                url: s3Url + req.file.filename,
                username: username,
                title: title,
                description: description,
                id: data.rows[0].id,
            });
        })
        .catch((err) => {
            console.log("error in db entry", err);
        });
});

app.get("/board", (req, res) => {
    console.log("hit the board route");

    getImages()
        .then((data) => {
            res.json(data.rows);
        })
        .catch((err) => {
            console.log(err);
        });

    // res.json means we are no longer using res.render
    // res.render is used for rendering templates, in a SPA Vue is the boss.
    // the server is just getting stuff from the database and sending it back to Vue.
});

app.get("/image/:id", (req, res) => {
    getImageInfo(req.params.id)
        .then((data) => {
            // console.log(data.rows[0]);
            res.json(data.rows[0]);
        })
        .catch((err) => {
            console.log("error in getImageInfo: ", err);
        });
});

app.get("/comments/:id", (req, res) => {
    getComments(req.params.id)
        .then((data) => {
            res.json(data.rows);
        })
        .catch((err) => {
            console.log("error in getImageInfo: ", err);
        });
});

app.post("/comment", (req, res) => {
    const { name, comment, id } = req.body;
    addComment(name, comment, id)
        .then(({ rows }) => {
            res.json(rows[0]);
        })
        .catch((err) => {
            console.log("error in comment POST", err);
        });
});

app.get("/moreimages/:id", (req, res) => {
    console.log("req.params", req.params.id);
    getMoreImages(req.params.id)
        .then((data) => {
            console.log(
                "lowestId from data.rows[0].lowestId",
                data.rows[0].lowestId
            );
            res.json(data.rows);
        })
        .catch((err) => {
            console.log("error in getMoreImages: ", err);
        });
});

app.get("/replies/:id", (req, res) => {
    console.log("getting replies!");
    getThread(req.params.id)
        .then((data) => {
            console.log(data.rows);
            res.json(data.rows);
        })
        .catch((err) => {
            console.log("error getting thread: ", err);
        });
});

app.post("/replies/", (req, res) => {
    console.log("posting reply");
    const { reply, username, commentId } = req.body;
    addReply(reply, username, commentId)
        .then((data) => {
            res.json(data.rows[0]);
        })
        .catch((err) => {
            console.log("error in addreply");
        });
});

app.listen(8080, () => console.log("listening on 8080..."));