A database for articles, comments and users with the ability to post and delete articles and comments as well as vote on both. It's reddit. I've basically just built a rubbish version of reddit.
Clone the the repo into your CLI npm install to install all dependencies node listen.js to start the server. The default port is set to 9090, but can be changed in the node ENV. You'll need to make a new knex file, which can be done by running knex init. Replace the data in the file with the following code:
const { DB_URL } = process.env;
module.exports = {
development: {
client: 'pg',
connection: {
database: '<development database here>',
},
migrations: {
directory: './db/migrations',
},
seeds: {
directory: './seeds',
},
},
test: {
client: 'pg',
connection: {
database: '<test database here>',
},
migrations: {
directory: './db/migrations',
},
seeds: {
directory: './seeds',
},
}
};You'll also need to run migrations and seed to get data into the databases. Some data has been provided for this purpose.
This project uses PSQL for the database. You should download it from here before starting.
Now you can get data out of the damn thing. Here's how:
You can start the server by running
node listen.js.Making a query to localhost:{PORT}/api/ will show a list of available endpoints for the server.
YES. OF COURSE. Here's how to test it and what the tests do:
Run
npm testThis runs a battery of tests on the code which checks that all endpoints provide the correct data - including queries - and checks that error handling is being done correctly.
Currently this project is hosted on Heroku here.
And a lotta love...
Sean Fisher
Big ups to the homeless guy across the street that had a domestic in front of the tram with his lady at 8:30am yesterday. Keep shining you crazy diamond.