School CUI CRUD App

Dumping Database

Loginning MySQL terminal

mysql -u root -p

Dumping DB file

DROP DATABASE IF EXISTS school;
CREATE DATABASE school;
USE school;
SOURCE /path/to/your/project/db/school.dmp

Installing Python Modules

pip install -r requirements.txt

Starting API Server

uvicorn dbaccess:app --reload

Showing Docs

localhost:8000/docs

Execute CRUDs

python.exe /path/to/your/project/crud/selectall.py