User Story

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

Acceptance Criteria

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

Mock Up

Deliverables: 10%

• Your GitHub repository containing your application code.

Walkthrough Video: 37%

• A walkthrough video that demonstrates the functionality of the e-commerce back end must be submitted, and a link to the video should be included in your README file.

• The walkthrough video must show all of the technical acceptance criteria being met.

• The walkthrough video must demonstrate how to create the schema from the MySQL shell.

• The walkthrough video must demonstrate how to seed the database from the command line.

• The walkthrough video must demonstrate how to start the application’s server.

• The walkthrough video must demonstrate GET routes for all categories, all products, and all tags being tested in Insomnia Core.

• The walkthrough video must demonstrate GET routes for a single category, a single product, and a single tag being tested in Insomnia Core.

• The walkthrough video must demonstrate POST, PUT, and DELETE routes for categories, products, and tags being tested in Insomnia Core.

Technical Acceptance Criteria: 40%

Satisfies all of the preceding acceptance criteria plus the following:

• Uses the MySQL2 (Links to an external site.) and Sequelize (Links to an external site.) packages to connect to a MySQL database.

• Uses the dotenv package (Links to an external site.) to use environment variables to store sensitive data, like a user’s MySQL username, password, and database name.

• Syncs Sequelize models to a MySQL database on the server start.

• Includes column definitions for all four models outlined in the Challenge instructions.

• Includes model associations outlined in the Challenge instructions.

Repository Quality: 13%

• Repository has a unique name.

• Repository follows best practices for file structure and naming conventions.

• Repository follows best practices for class/id naming conventions, indentation, quality comments, etc.

• Repository contains multiple descriptive commit messages.

• Repository contains a high-quality README with description and a link to a walkthrough video.

• How to Submit the Challenge

You are required to submit BOTH of the following for review:

• A walkthrough video demonstrating the functionality of the application and all of the acceptance criteria being met.

• The URL of the GitHub repository. Give the repository a unique name and include a README describing the project.