In this project I user this tools
- Sequelize ORM: https://sequelize.org
- SQLite3
- NodeJS 14
- MVC
- REST
- Xpress: https://expressjs.com/es/
- AUTH
- Middlewares
- WebSockets SocketIO
Create model and migrations
sequelize model:generate --name Task --attributes description:text
sequelize model:generate --name User --attributes email:string,password_hash:string
sequelize model:generate --name Category --attributes title:string,color:string
sequelize model:generate --name TaskCategories --attributes taskId:integer,categoryId:integer
Migrate DB structure
sequelize db:migrate
Seeders
sequelize seed:generate
Seeders
sequelize seed:generate --name generate_tasks
sequelize db:seed:all
sequelize db:seed:undo
sequelize db:seed:undo:all