This repository contains the back-end database calls, and entire database scripts and seeds for the project ColourScape.
Got an amazing outfit but no walls to take photos in front of? Browse Toronto and its various neighbourhoods by your desired colour palettes with Colourscape.
- React
- JavaScript
- Postgres
- Google Cloud Platform Vision API
- Google Maps API
- Flickr API
Type the following on command line, and enter password when prompted.
psql -U <your_dbname> <your_username>
Once inside your database, run these three commands to clear your database and (more importantly,) to reset the IDs of the tables:
TRUNCATE TABLE imagesdb RESTART IDENTITY CASCADE;
TRUNCATE TABLE usersdb RESTART IDENTITY CASCADE;
TRUNCATE TABLE likesdb RESTART IDENTITY;
Exit database, and run the follow on command line to seed your database :)
knex seed:run