we have build the back end for an e-commerce site by modifying starter code. we have configure a working Express.js API to use Sequelize to interact with a MySQL database.
AS A manager at an internet retail company
I WANT a back end for my e-commerce website that uses the latest technologies
SO THAT my company can compete with other e-commerce companies
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
The following animation shows the application's GET routes to return all categories, all products, and all tags being tested in Insomnia Core:
The following animation shows the application's GET routes to return a single category, a single product, and a single tag being tested in Insomnia Core:
The following animation shows the application's POST, PUT, and DELETE routes for categories being tested in Insomnia Core:
Your database should contain the following four models, including the requirements listed for each model:
-
Category
-
id
-
Integer.
-
Doesn't allow null values.
-
Set as primary key.
-
Uses auto increment.
-
-
category_name
-
String.
-
Doesn't allow null values.
-
-
-
Product
-
id
-
Integer.
-
Doesn't allow null values.
-
Set as primary key.
-
Uses auto increment.
-
-
product_name
-
String.
-
Doesn't allow null values.
-
-
price
-
Decimal.
-
Doesn't allow null values.
-
Validates that the value is a decimal.
-
-
stock
-
Integer.
-
Doesn't allow null values.
-
Set a default value of
10
. -
Validates that the value is numeric.
-
-
category_id
-
Integer.
-
References the
Category
model'sid
.
-
-
-
Tag
-
id
-
Integer.
-
Doesn't allow null values.
-
Set as primary key.
-
Uses auto increment.
-
-
tag_name
- String.
-
-
ProductTag
-
id
-
Integer.
-
Doesn't allow null values.
-
Set as primary key.
-
Uses auto increment.
-
-
product_id
-
Integer.
-
References the
Product
model'sid
.
-
-
tag_id
-
Integer.
-
References the
Tag
model'sid
-
-
-
A walkthrough video demonstrating.
-
zoom_0.mp4
-
The URL of the GitHub repository. https://github.com/ru14/Object-Relational-Mapping