SLIDE 1
Additional Intro of MP3
SPRING 2020 CS 498RK Jinda Han April 1, 2020
Additional Intro of MP3 Jinda Han April 1, 2020 Getting Started - - PowerPoint PPT Presentation
Additional Intro of MP3 Jinda Han April 1, 2020 Getting Started - - PowerPoint PPT Presentation
CS 498RK SPRING 2020 Additional Intro of MP3 Jinda Han April 1, 2020 Getting Started Clone and initial the MP3 git alone https://gitlab.com/uiuc-web-programming/mp3.git mp3 cd mp3 npm install Run MP3 npm start http://localhost:4000/api/
SLIDE 2
SLIDE 3
Clone and initial the MP3
git alone https://gitlab.com/uiuc-web-programming/mp3.git mp3 cd mp3 npm install
SLIDE 4
Run MP3
npm start http://localhost:4000/api/ Environment good 👎
SLIDE 5
Postman
A useful Dev tool: “The Collaboration Platform for API Development”
SLIDE 6
Download Postman
- https:/
/www.postman.com/
SLIDE 7
Run Postman
Check API: localhost:4000/api/ Return like this (nothing) because you haven’t implemented your mp!
SLIDE 8
mongoDB Atlas
SLIDE 9
Register
- https:/
/www.mongodb.com/cloud/atlas
SLIDE 10
Build a New Cluster
SLIDE 11
SLIDE 12
Wait for a while!
SLIDE 13
Connect
SLIDE 14
mongodb+srv://test_d4:<password>@cs498rkmp3-jxf1h.mongodb.net/test?retryWrites=true&w=majority What is the password? Username Password
SLIDE 15
User and Password
mongodb+srv://test_d4:<password>@cs498rkmp3-jxf1h.mongodb.net/test?retryWrites=true&w=majority
SLIDE 16
Connect the Project
Type your Username, Password, and URL, not mine. mongodb+srv://test_d4:<password>@cs498rkmp3-jxf1h.mongodb.net/test?retryWrites=true&w=majority
SLIDE 17
Before Running anything…
SLIDE 18
Task
Implement an API with the following required endpoints (they would be preceded by something like http:/ /localhost:4000/api/*). Your implementation should use Node, Express and Mongoose.
SLIDE 19
Create the endpoints
This is an example, implementation may vary Simple Example, not full code You need to implement POST/ GET/PUT/DELETE
SLIDE 20
Complete Mongoose Schema
Complete the Schema for User and Task This is an example, implementation may vary
SLIDE 21
After you finish
SLIDE 22
Fill Database: dbFill.py
python3 dbFill.py -u "localhost" -p 4000 -n 20 -t 100 cd mp3/database_scripts/
SLIDE 23
Clean the Database
python3 dbClean.py -u "localhost" -p 4000 cd mp3/database_scripts/
SLIDE 24
Testing MP3
SLIDE 25
Query Example
SLIDE 26
Example Returns full list of tasks
localhost:4000/api/tasks
SLIDE 27
Return a list of completed Tasks
http://localhost:4000/api/tasks?where={"completed": true}
SLIDE 28
Returns tasks number from 61 to 80
http://localhost:4000/api/tasks?skip=60&limit=20
SLIDE 29
Tips
SLIDE 30
Basic Test Cases (70% total grade)
- Retrieve the list of users
- Insert a new user
- Retrieve a valid user
- Update a valid user
- Retrieve a valid user with parameters
- Retrieve user count
- Delete a valid user
- Retrieve an invalid user
- Delete an invalid user
- Retrieve the list of tasks
- Insert a new task
- Retrieve a valid task
- Update a valid task
- Retrieve a valid task with parameters
- Retrieve task count
- Delete a valid task
- Retrieve an invalid task
- Delete an invalid task
(Invalid user = nonexistent user) Extra test corner cases worth 30% points, will not release
SLIDE 31
Additional Resources
- Express Tutorial Using Database with Mongoose
- https:/
/developer.mozilla.org/en-US/docs/Learn/Server-side/ Express_Nodejs/mongoose
- Express Basic Routing
- https:/
/expressjs.com/en/starter/basic-routing.html
- Mongoose API Docs
- https:/
/mongoosejs.com/docs/api
- MongoDB Docs
- https:/
/docs.mongodb.com/manual/tutorial/query-documents/
- https:/
/docs.mongodb.com/manual/reference/database- references/
- HTTP Status Code
- https:/
/www.restapitutorial.com/httpstatuscodes.html
SLIDE 32
Thanks!
SLIDE 33
Reference
- Images: https://images.google.com/
- Questions Insight: https://piazza.com/ CS498rk SP19 and SP20