Object Relational Mapping ( ORM )
Developed for a social media startup, this application leverages SQL databases to efficiently manage substantial unstructured data. Powered by Express.js for seamless routing, it employs MySQL and sequelize 5.21.7 Object Relational Mapping ( ORM ) to ensure robust scalability and streamlined data handling.
-
Open your favorite text editor of choice
-
Open terminal and enter the following command:
npm start to start sever || npm run dev to to automatically restart server
-
Open API testing tool or Platform of choice & start testing routes
- express js 4.17.1
- mysql2 2.1.0
- sequelize 5.21.7
- node js 18.15.0
- dotenv 8.2.0
- dodemon 2.0.22
software:
- Insomnia Rest API
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 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
THEN I am able to successfully create, update, and delete data in my database
🔗 Github
Copyright (c) 2023 Ferny Castro