🛵 MotoShop

📌 Table of Contents

• Desciption
• Technology
• Task
• Install

📖 Description

this repo is a simple CRUD(create, read, update, delete) of seling motorcycle web app.

🛠️ Technology

• NodeJS
• typescript
• html
• css
• mysql
• Express Framework

📜 Task

• database with two tables, salesman and motocycle
• v1 show the description of one specifc motocycle, in this screen you can delete, motocycle
• v2 screen to create update motocycle.
• v3 display of motocycle, see all motocycle, filter by name price and selerman. Acces v1 of especyfic motocycle
• v4 selerman screen, see all motocycle of especyfic selerman, you can fillter by motocycle price, delete selerman and access to create seler man.
• v5 create selerman
• crud request for especific motocycle
• select all moto, filter by name and price
• crud request for especific selerman

📑 Require

• mysql
• NodeJS

⚙️ Install

if you want to start the program with some data on it you need to run backup.sql on workbench. This program use user: exclude and password: password, for this program to start you need to create this user on workbench, or alter the file backend/src/connection.ts with your user and password.
obs .: the authentication type for the user need to be standard.

import mysql from 'mysql';

const connection = mysql.createConnection({
    host: 'localhost',
    port: 3306,
    user: 'yourUser',
    password: 'yourPassword',
    database: 'motoShop'
})

export default connection;

to run the program

npm install
# 
cd backend
npm intall
#
cd ../frontend
npm install
#
cd ../backend
npm start