For the checkpoint, we have worked on:
- Set up the back-end environment
- Set up the MySQL environment with some data
- Implemented a login/register system for our movie web application
- Created a simple UI of our dashboard with movies displaying after user logs in
- Created a simple "Trending" filter for now that displays different movie selections depending on the filter applied
-
Live server is up and running inside AWS EC2 instance on http://3.128.49.215:8081/.
-
Run and test production server locally on http://localhost:8081/:
docker-compose build && docker-compose up
# Stop production server by running:
docker-compose down
# There are five accounts pre-configured for testing:
# Username / Password
# test1 / 470test1
# test2 / 470test2
# test3 / 470test3
# test4 / 470test4
# test5 / 470test5
1. React Frontend on http://localhost:3000/:
cd client
npm install
npm start
2. Express Backend on http://localhost:3001/:
cd server
npm install
npm run dev
Steps 1 and 2 in a single script (Unix/Linux):
server/scripts/db_setup_linux.sh
Step 1. Populating database:
mysql -u root
source full/path/to/project/server/scripts/db_init.sql
source full/path/to/project/server/scripts/title_with_ratings.sql
Step 2. Knex migration:
npm i knex -g
cd server/config
knex migrate:latest
# knex migrate:rollback (nuke all tables)
Optional. Testing Bookshelf/Knex:
cd server/scripts
node test_movie_titles.js