server.js

require ('dotenv').config();

const bp = require('body-parser');
const express = require('express');
const app = express();
const pg = require('pg');
const fs = require('fs');
const PORT = process.env.PORT;
const cors = require('cors');
const superagent = require('superagent');
const MARS_API_KEY = process.env.MARS_API_KEY;

app.use(cors());
app.use(bp.json());
app.use(bp.urlencoded({extended: true}));

const client = new pg.Client(process.env.DATABASE_URL);

client.connect();

app.get('/api/v1/favorites', (req, res) => {
    client.query(`
    SELECT id FROM users WHERE name = $1`,[req.query.user])
        .then(data => 
            client.query(`SELECT url
                FROM images
                INNER JOIN favorites
                ON (favorites.images_id = images.image_id)
                WHERE favorites.user_id = $1`, [data.rows[0].id]))

        .then(data => res.send(data.rows));
});

app.post('/api/v1/favorites', (req, res) =>{
    client.query(`
    SELECT id FROM users WHERE name = $1`,[req.body.user])
        .then (data => {
            if(data.rows.length > 0) {
                const userId = data.rows[0].id;
                getImages(userId);
            } else {
                client.query(`INSERT INTO users (name) VALUES ($1) RETURNING id`, [req.body.user], (err,data) => {
                    getImages(data.rows[0].id);
                    if (err) console.log(err);
                });
            }
        });
    function getImages (userId) {
        console.log('getImages', userId);
        client.query(`SELECT image_id FROM images WHERE url = $1`, [req.body.url])
            .then (data => {
                if (data.rows.length > 0){
                    const imageId = data.rows[0].image_id;
                    addToFavorites(imageId,userId);
                } else {
                    client.query(`INSERT INTO images (image_id, rover, camera, url) VALUES ($1, $2, $3, $4) RETURNING image_id` , [req.body.image_id, req.body.rover, req.body.camera, req.body.url], (err,data) =>{
                        addToFavorites(data.rows[0].image_id, userId);
                        console.log('geturl', data.rows[0].image_id);
                        if (err) console.log(err);
                    });
                }

            })
            .catch(err => {
                console.log(err);
            });
    }
    function addToFavorites (imageId, userId){
        console.log(imageId,userId);
        client.query('INSERT INTO favorites (user_id, images_id) VALUES ($1, $2)', [userId, imageId]);
        res.send('done');
    }

});

app.get('/api/v1/nasa', (req, res) => {
    const rover = req.query.rover;
    const camera = req.query.camera;
    const date = req.query.date;
    const nasaUrl = 'https://api.nasa.gov/mars-photos/api/v1/rovers/';

    superagent.get(`${nasaUrl}${rover}/photos?earth_date=${date}&camera=${camera}&api_key=${MARS_API_KEY}`)
        .end((err, resp) => {
            const topPix = resp.body.photos.slice(0,25).map(image => {
                const returnImg = {
                    id: image.id,
                    rover: image.rover.name,
                    camera: image.camera.name,
                    url: image.img_src
                };

                return returnImg;
            });
            res.send(topPix);
        });
});

app.listen(PORT, () => {
    console.log(`Listening on Port ${PORT}`);

});