- Overview
- What is Object Relational Mapping?
- Technologies Used
- Screen Capture
- Full Walkthrough Video
- Installation
- Usage
This repository is an exhibition of an e-commerce back end implementation. The user can consult the repo to learn how to create a back end for an e-commerce site effectively, using the object-relational mapping design pattern. The project makes use of Node.js to work with a back end, the Express package to design and configure an API, the dotenv package to classify environmental variables, and the MySQL2 as well as the Sequelize packages to manage and interact with the database.
Today, the majority of applications are written in OOP language and at the same time persist their data in relational databases. Due to this fundamental paradigm mismatch, a need for a more harmonic way to communicate between them arose. Object relational mapping allows one to call and manipulate data from the database using your language of choice instead of SQL.
- Fork and clone repository to local machine.
- Run integrated terminal in personal IDE.
- Run
npm i
to install dependencies in local project directory.
- Create database via command-line or in MySQL GUI.
- Insert synthetic "seed" data via command line or in MySQL GUI.
- Open integrated terminal in personal IDE.
- Run
my sql -u root -p
. - Enter MySQL GUI password.
- Run
source ./db/schema.sql
. - Run
exit
. - Run
npm run seed
. - Run
npm start
. - Test endpoints in API tester tool such as Insomnia.