/nodejs-react-mysql

Primary LanguageTypeScript

Getting Started with Create React App

This project was bootstrapped with Create React App.

Available Scripts

In the project directory, you can run:

npm install

Downloads all dependencies

npm run start

Runs the app in the development mode.
Open http://localhost:3000 to view it in your browser.

The page will reload when you make changes.
You may also see any lint errors in the console.

what i used in this project

  • reactJs
  • Yub for data schema validation
  • TypeScript
  • Bootstrap
  • Axios

project structure

  • api for all api calls
  • pages
  • types
  • schemaValidation
  • utils

If i had more time i would have:

  • added tests
  • worked more on UI UX

Getting Started with the NodeJs App

Available Scripts

In the project directory, you can run:

npm install

Downloads all dependencies

npm run server

Runs the app

The page will reload when you make changes.
You may also see any errors in the console.

npx sequelize-cli db:migrate

process db migration

npx sequelize-cli db:seed:all

process db seed, adding demo company

Runs the app

what i used in this project

  • expressJs
  • sequelize
  • yup
  • bcryptjs
  • dotenv
  • jsonwebtoken
  • nodemon

project structure

project is 3-layer architecture:

  • Controllers layer
  • Services Layer
  • Data access layer

If i had more time i would have:

  • added tests
  • add more TypeScript
  • more control over errors handling

Getting Started with Mysql docker container

Available Scripts

In the project directory, you can run:

docker-compose -f mysql.yml up

Runs the Mysql docker container

Config

-ports:3306

-root username:root

-root password:root

-db name:magnitt