joaorpereira / todo-list

Todo List Project

---

About • Technologies • How to download the project • License • Developer

---

🔖 About

Todo List is a system to manage your task.

A fullstack project where backend was developed using NodeJS to developer the Rest API, ReactJS to developer the Frontend and MySQL as a database.

---

🛠 Technologies

The following technologies/tools were used:

• Typescript;
• ECS6+;
• ReactJs;
• CSS3;
• Styled-Components;
• HTML5;
• Node.js;
• axios;
• Express;
• MySQL;
• Insomnia;
• Git;
• VSCode;

---

📎 How to download the project

👉 Tools needed:

• Vscode was used in this project;
• Node.Js - Installed on your machine;
• Git - Installed on your machine;

👉 Install dependencies:

#-> In the terminal:

# Clone repository:
$ git clone https://github.com/joaorpereira/todo-list.git

# To run the frontend:
-> $ cd client
-> $ cd api 

# Install dependencies:
$ npm install  # In the client folder
$ yarn # In the api folder

# Start the project
$ npm start # In the client folder
$ yarn dev # In the api folder

# After loading the project it will automatically open a tab in the default browser.

---

MySQL database

Create MySQL schema using MySQL Workbench:

MYSQL credentials:

  PORT=3003
  TYPEORM_CONNECTION = 
  TYPEORM_HOST = 
  TYPEORM_USERNAME = 
  TYPEORM_PASSWORD = 
  TYPEORM_DATABASE = 
  TYPEORM_PORT = 3306
  TYPEORM_MIGRATIONS = src/database/migrations/*.ts
  TYPEORM_MIGRATIONS_DIR = src/database/migrations
  TYPEORM_ENTITIES = src/entities/*.ts
  TYPEORM_ENTITIES_DIR = src/entities

Create MySQL migrations:

$ yarn typeorm migration:create -n CreateTasks

Run MySQL migrations:

$ yarn typeorm migration:run

Tssks Table

    id INT PRIMARY KEY,
    title VARCHAR(255) NOT NULL,
    description VARCHAR(255),
    username VARCHAR(255),
    status BOOL DEFAULT false,
    created_at DATETIME NOT NULL,

---

📜 License

This project is under the MIT license. See the LICENSE file for more details.

---

👨‍💻 Developer

_{Joao Paulo 🚀}

Developed by Joao Paulo.