Giter VIP home page Giter VIP logo

ecommece-5000's Introduction

Assignment 13, Object-Relational Mapping a.k.a "Ecommerce-5000"

Description

This is a MySQL2 built data base and back end application for an Ecommerce Website. This application uses MySql2, Express, Sequelize and DotEnv, aswell as Insomnia for testing endpoints.

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 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
THEN I am able to successfully create, update, and delete data in my database

Installation

  • npm init
  • npm install mysql2
  • npm install sequelize
  • npm install dotenv

Usage

Accsess the root file of this project using node and initialize MYSQL by entering mysql -u root -p , and enter the password when prompted.

After MySQL starts, enter the following commands -

  • source db/schema.sql;
  • quit
  • npm run seed
  • npm start

Once you start server via npm start, you may open the api endpoints via Insomnia to use the POST/ PUT / DELETE/ GET functions in Insomnia

GITHUB REPO LINK

Repository Link

DEMONSTRATION VIDEO LINK & SCREENCAPS

Demo Screen Capture

Walkthrough Video Link

ecommece-5000's People

Contributors

jhdk707 avatar

Watchers

 avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.