Skip to content

Latest commit

 

History

History
39 lines (27 loc) · 4.01 KB

README.md

File metadata and controls

39 lines (27 loc) · 4.01 KB

Full-Stack Music Streaming Application

By Ahmad El-Zein, Saif Ahmad, Brody Smith on December 2, 2022

Technologies Used

Todo

To set up

Create your own MySQL database with the free music library data available online. You will need to create a few additional tables, such as User, PlaylistUser, Review, ReviewUser, etc.

Note on Secrets/Passwords

All passwords and secrets in this project have been revoked.

(RDS has since been decommissioned) To add RDS connection with pgAdmin 4

  1. (Saif:) send me your home IP and your IP when you're at Western and I will add you to the firewall whitelist
  2. Right click "servers" in the browser in the left pane
  3. Click register -> server
  4. Name it RDS (name is just a local alias and doesn't matter), click connection,
  5. In host, add the RDS endpoint: se3316.cdu9h2cspncm.us-east-1.rds.amazonaws.com, leave everything else alone
  6. Enter LPLtEQ4Sf4 as the password for the postgres user
  7. Click save, and you should be able to access the DB.

Getting Started

  1. use this guide (download postgres 14, not 15) and stop before the heading "creating a table in Postgres": https://blog.logrocket.com/crud-rest-api-node-js-express-postgresql/. Ahmad it doesn't say it in the guide but you will need to change your Path environment variable by typing in "env" to the windows search bar, clicking "edit system env variables", click "environment variables" button, in the box on the bottom scroll down to "Path" and double click it. Click "new" and add C:\Program Files\PostgreSQL\14\bin. Restart your command prompt and psql should work. If it doesn't, restart and try again.

  2. use pgAdmin 4. Click "servers" in the left pane, log in with your postgres user password, expand databases, expand api. Right click api, and click "restore". Have the filename input point toward this file (download it onto your pc first obviously) and just leave everything else alone and click restore. It will say it fails, but it's because you guys don't have a user named "brody" which is the postgres username I created my local db with. This will copy my local db to both of your computers. Note that they are not linked; these are static databases. Changes I make on my local computer wont affect either of you and vice versa.

    You can verify data is there by expanding "schemas" under "api" database in the left pane, then "tables", then right click whatever table and click "view/edit data" -> all rows. They all should be the same number of rows minus one (because the tables don't have the header rows like the csvs do) as the csv files.

    I want to reoptimize this database so we can use more SQL functionality (I didn't really set up foreign keys properly so there's a lot of missing links rn). I will do this today or tomorrow after I break ground on 3309.

  3. To make the web app work, open two terminals, cd to the root folder of this repository on both terminals. On one, cd into "server" folder. Write npm install package.json.

  4. Now edit app.js in server folder and replace it with your postgres user password on line 20. Make sure to remove this password and replace it with 'pw goes here' or an empty string when you commit to github so it doesn't leak your password, or don't if you made it a dummy password.

  5. Now, in the terminal you just installed the package with, type nodemon app.js. You should get a terminal output that says Listening on port 3000.... This means two things:
    a) the backend is working and ready to accept requests, and
    b) index.html is being served at localhost:3000. Enter just that (no prefix) into a browser and check. Some things might be broken because I've had to make a lot of on-the-fly changes for deployment to my AWS server for lab 3.

  6. If the playlists display on localhost:3000, then your database connection is established properly.