Skip to content

🏅 Database and API for Olympic Medalists from the 2008 Summer Games

Notifications You must be signed in to change notification settings

travisricks/api-solo-project

Repository files navigation

api-solo-project

This was created during my time as a student at Code Chrysalis

Summer Olympics 2008 Winners API

This is a CRUD API using Postgres, Knex and RESTful principles. It contains the medal winners from the 2008 Summer Olympics. It is displayed with an html frontend.

Frontend Screenshot


Getting Started

Postgres

You will need Postgres installed.

Create a database for this project by running:

    echo "CREATE DATABASE olympics;" | psql

Installing Dependencies and Startup

To install dependencies:

    yarn

To set up the database, run migrations and seeds:

    yarn migrate
    yarn seed

To start the app:

    nodemon .

To roll back migrations:

    yarn rollback

API endpoints

endpoint method result
api/winners GET Shows all winners
api/winners/countryCode GET Shows all winners from a specific country
index.html POST this form will add a winner

About

🏅 Database and API for Olympic Medalists from the 2008 Summer Games

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published