This app is a command-line interface (CLI) with an API (using Express.js) and MySQL database (using Sequelize) that allows the user to view, add, update and delete categories, products and tags.
Setup:
- (1) Fork the repo, (2) Clone the forked repo locally, (3) Run "npm install" (to install the dependencies).
Setup the Database Schema:
-
(1) Update or add an .env file. Include the following in the .env file as follows. Note that the .env variables are used in the conf folder, connection.js file.
- DB_NAME="ecommerce_db"
- DB_USER=""
- DB_PASSWORD=""
Seed the Database:
- Run Server: From the root directory, run either "npm run watch" to start nodeman or "node server.js".
If you'd like to use NPM nodemon as/if you make changes to the code, please install nodemon as a development dependency using "npm install --save-dev nodemon" (see https://www.npmjs.com/package//nodemon).
This app is a command-line interface (CLI) with an API (using Express.js) and MySQL database (using Sequelize).
This app includes features that allows the user to view, add, update and delete categories, products and tags from the API routes shown in the demo videos.
Video #1:
This video shows - the dotenv, sequelize sync, model associations, models, mysql database connection, source schema, seed model, start server and the code.
This video shows - the category routes including get all categories, get single category by id, post (add a new category), put (update a category by id), delete a category by id.
This video shows - the product routes including get all products, get single product by id, post (add a new product), put (update a product by id), delete a product by id.
This video shows - the category routes including get all tags, get single tag by id, post (add a new tag), put (update a tag by id), delete a tag by id.
No tests at this time.
Contributor Covenant Code of Conduct
- Project Manager: Steve Calla - GitHub Profile
- GitHub Repo: https://github.com/stevecalla/ecommerce-backend
- GitHub Hosted URL: None. This is command-line interface (CLI) using node.js.
- Contact: Email Steve
This project is licensed under the terms of the The MIT License. Please click on the license badge for more information.