db.js

const spicedPg = require("spiced-pg");

const db = spicedPg(
    process.env.DATABASE_URL ||
        "postgres:postgres:postgres@localhost:5432/imageboard"
);

exports.getImages = function() {
    return db
        .query(
            `SELECT * FROM images
            ORDER BY id DESC
            LIMIT 6`
        )
        .then(({ rows }) => rows);
};

exports.getFirstImageId = function () {
    return db
        .query(
            `SELECT id FROM images
            ORDER BY id ASC
            LIMIT 1`
        ).then(({ rows }) => rows);
};

exports.getMoreImages = function(lowestId) {
    return db
        .query(
            `SELECT id, url, username, title, description, created_at, (
                SELECT id FROM images
                ORDER BY id ASC
                LIMIT 1
            ) AS "lowestId" FROM images
            WHERE id < $1
            ORDER BY id DESC
            LIMIT 6`,
            [lowestId]
        )
        .then(({ rows }) => rows).catch(err => {
            console.log('err in getMoreImages in db.js: ', err);
        });
};

exports.addImage = function(url, username, title, description) {
    return db
        .query(
            `INSERT INTO images (url, username, title, description)
            VALUES ($1, $2, $3, $4)
            RETURNING *`,
            [url, username, title, description]
        )
        .then(({ rows }) => rows);
};

// exports.getImage = function(id) {
//     return db
//         .query(
//             `SELECT * FROM images
//             WHERE id= $1`,
//             [id]
//         )
//         .then(({ rows }) => rows);
// };

exports.getImage = function(id) {
    return db
        .query(
            `SELECT *, (
                SELECT id FROM images
                WHERE id > $1
                ORDER BY id ASC
                LIMIT 1
            ) AS "previousId",  (
                SELECT id FROM images
                WHERE id < $1
                ORDER BY id DESC
                LIMIT 1
            ) AS "nextId"
            FROM images
            WHERE id= $1`,
            [id]
        )
        .then(({ rows }) => rows);
};

exports.getComments = function(img_id) {
    return db
        .query(
            `SELECT * FROM comments
            WHERE img_id=$1
            ORDER BY id DESC`,
            [img_id]
        )
        .then(({ rows }) => rows);
};

exports.addComment = function(comment, username, img_id) {
    return db
        .query(
            `INSERT INTO comments (comment, username, img_id)
            VALUES ($1, $2, $3)
            RETURNING *`,
            [comment, username, img_id]
        )
        .then(({ rows }) => rows);
};