Giphinator solution

This is my solution to the challenge below, originally cloned from here.

Future improvements

I tried to be as pragmatic as possible but also seperating module concerns/responsibilities properly.

Database dependency in tests can be mocked
cache.js can be converted into a function taking an abstraction of scema.js for future dependency injection
test.js can be separated into other files if development needs to continue

Giphinator code challenge

Requirements:

Nodejs (at least v5)
npm

Running:

Install dependencies - npm install Run migrations on your postgres instance - DATABASE_URL={YOUR_POSTGRES_DATABASE_URL} npm run migrations Run the application - DATABASE_URL={YOUR_POSTGRES_DATABASE_URL} PORT={YOUR_PORT} npm start

Instructions

This API should query the giphy API for any provided query string. This data should be cached on a PostgreSQL database using the provided migrations and schemas.

REQUIREMENTS:

Complete the ./lib/handlers/giphinate.js handler to call the giphy API and return the first GIF URL in the response. You should cache the data in the PostgreSQL database so the next time the same query is used, the GIF URL is returned from the database instead of the Giphy API.
Create a new DELETE route and controller which deletes the record associated with the query text sent up.
Create a set of tests for each endpoint

NOTES: