The back end suite of services to support businesses of all sizes.
You can access the app here: https://github.com/avidrunner87/e-commerce-back-end.
AS A(N) 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 picture shows the website appearance and capabilities:
We also have a video that walks you through the entire application:
To fork this code to further improve the website, please follow these directions:
-
In Github fork the repository.
-
Clone the repository to your local computer.
This assumes that you have setup your own SSH keys to connect with Github.
-
Before running the employee tracker app, please ensure all the necessary node modules are installed:
npm install -
You will also need to setup your initial database for the application.
-
Log into your local mysql instance
-
Source the schema.sql file located in the db folder
-
-
Copy and update contents of the .env.example file to reflect your local computer
cp .env.example .env -
Seed the database with data.
npm run seed
You can run the application using the following command:
npm start
If you have any questions please reach out to me via Github or via email.