/ORM_Challenge

Built a back end for an e-commerce site. Utilized a working Express.js API and configured it to use Sequelize to interact with a MySQL database.

Primary LanguageJavaScriptMIT LicenseMIT

ORM_Challenge

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

Demo

Creating schema, Seeding data & Starting server.

Creating.schema.Seeding.data.Starting.server.mp4

Get all/id routes for Categories, Products & Tags.

Get.routes.for.Categories.Products.Tags.mp4

Post/Put routes for Categories, Products & Tags.

Post_Put.routes.for.Categories.Products.Tags.mp4

Delete routes for Categories, Products & Tags.

Delete.routes.for.Categories.Products.Tags.mp4

Tools Used

  • Node.js
  • NPM mysql2
  • NPM sequelize
  • NPM dotenv
  • NPM express

Contact Information

Matthew Castoreno

Email: matthew.castoreno@yahoo.com