- What was your motivation?
- Learning to build a back-end structure for a e-commerce app.
- Why did you build this project?
- To understand how SQL and Node.js relate and work togather.
GIVEN a functional Express.js API
WHEN I add my database name, MySQL username, and MySQL password to an environment variable file
THEN I am able to connect to a database using Sequelize
WHEN I enter schema and seed commands
THEN a development database is created and is seeded with test data
WHEN I enter the command to invoke the application
THEN my server is started and the Sequelize models are synced to the MySQL database
WHEN I open API GET routes in Insomnia Core for categories, products, or tags
THEN the data for each of these routes is displayed in a formatted JSON
WHEN I test API POST, PUT, and DELETE routes in Insomnia Core
THEN I am able to successfully create, update, and delete data in my database
- What did you learn?
- MySQL, Server & Sequelize connection
- CRUD routing
- Mapping and returning elements from a database
- Insomnia functions
- Node.js
- JavaScript
- Sequalize
- MySQL
Please watch the next videos for usage details:
- https://developer.mozilla.org/en-US/docs/Learn/JavaScript/Asynchronous/Async_await
- https://sequelize.org/master/manual/assocs.html
- https://sequelize.org/master/manual/validations-and-constraints.html#-code-allownull--code--interaction-with-other-validators
- Class activities
- Enrique Del Castillo Chávez
- Application invoke passed
- Connection server with sequelize passed
- API GET route passed
- Each route is displayed in formatted JSON passed
- API POST, PUT and DELETE passed
- CREATE, UPDATE AND DELETE DATA passed