Model of building the back-end for an e-commerce site. Taking a working Express.js API and configuring it to use Sequelize in order to interact with a MySQL database.

• Installation
• Usage
• Database Models
• Credits
• Questions

Clone this project and run npm install. On MySQL CLI create the database with the following command in the root of the project. source ./db/schema.sql.Then seed the tables using npm run seed. Finally start the server running this command npm start.

• Category

  • id

    • Integer
    • Not null
    • Primary key
    • Auto increment

  • category_name

    • String
    • Not null

• Product

  • id

    • Integer
    • Not null
    • Primary key
    • Auto increment

  • product_name

    • String
    • Not null

  • price

    • Decimal
    • Not null

  • stock

    • Integer
    • Not null
    • default 10

  • category_id

    • Integer

• Tag

  • id

    • Integer
    • Not null
    • Primary key
    • Auto increment

  • tag_name

    • String
    • Not null

• ProductTag (Through Table)

  • id

    • Integer
    • Not null
    • Primary key
    • Auto increment

  • product_id

    • Integer

  • tag_id

    • Integer

Use Insomnia to test RESTful API implementation with HTTP methods POST, GET, GET by id, PUT and DELETE by id.

• /api/categories
• /api/products
• /api/tags

https://youtu.be/Uht_zDZBbjY

Please send your questions here or visit github/dopecello.

William Locke