Open flgomes94 opened 2 years ago
criar validações para email
Error: Cannot delete or update a parent row: a foreign key constraint fails (`projeto`.`categories_tasks`, CONSTRAINT `FK_categories_tasks_task_id` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`) ON DELETE NO ACTION)
{
"description": "Qualquer coisa2",
"deadline_at":null,
"completed_at":"2021-11-30T03:31:18.000",
"task_priority":"1",
"task_user":"69"
}
Error: Cannot delete or update a parent row: a foreign key constraint fails (`projeto`.`categories_tasks`, CONSTRAINT `FK_categories_tasks_category_id` FOREIGN KEY (`category_id`)
REFERENCES `categories` (`id`) ON DELETE NO ACTION)
Tem outra coisa tb, a ordem. Ta na ordem errada. Tipo, 4/11 vem depois de 18/11. Acho q tem q mudar pra ASC
Investigar por que tasks com várias categorias estão vindo duplicadas. Quando é usando o endpoint get de tasks, vem um objeto de tarefa duplicado para cada categoria que ela possui. Exemplo:
http://localhost:3001/tasks?user=69&completed=false
{
"success": true,
"message": "tasks encontradas",
"data": [
{
"user_id": 69,
"user_name": "Victor Pinheiro",
"priority_id": 1,
"priority_description": "urgente",
"priority_number": null,
"id": 9,
"description": "Qualquer coisa",
"completed_at": null,
"task_priority": 1,
"task_user": 69,
"created_at": "2021-12-01T22:19:23.000Z",
"updated_at": "2021-12-01T22:19:23.000Z",
"user_email": "victor@pinheiro.dev",
"deadline_at": null,
"category_task_id": 16,
"category_task_task_id": 9,
"category_description": "Categoria B",
"category_task_category_id": 7
},
{
"user_id": 69,
"user_name": "Victor Pinheiro",
"priority_id": 1,
"priority_description": "urgente",
"priority_number": null,
"id": 9,
"description": "Qualquer coisa",
"completed_at": null,
"task_priority": 1,
"task_user": 69,
"created_at": "2021-12-01T22:19:23.000Z",
"updated_at": "2021-12-01T22:19:23.000Z",
"user_email": "victor@pinheiro.dev",
"deadline_at": null,
"category_task_id": 17,
"category_task_task_id": 9,
"category_description": "Categoria C",
"category_task_category_id": 8
}
]
}
Trocar completed icon
email como único