Criar layout do banco

[flgomes94]

Necessário criar uma documentação com todos os procedimentos úteis no banco de dados

[flgomes94]

[flgomes94]

@vpinheiro38 @antoniocsz novos endpoints criados

POST /users/ -- cria novos usuários

REQUEST: { "name":"Fabio Lopes", "email":"fabio@lopes.dev", "password":"123456" }

RESPONSE: { "message": "Usuário inserido com sucesso", "success": true, "data": { "id": 68, "email": "fabio@lopes.dev", "name": "Fabio Lopes", "created_at": "2021-11-21T23:57:14.000Z", "updated_at": "2021-11-21T23:57:14.000Z" } }

PUT /users/61 -- atualiza usuários

REQUEST { "name":"Fabio Lopes2", "email":"fabio@lopes.de2v", "password":"1234562" }

RESPONSE { "message": "usuário não encontrado||", "success": false }

GET /users/65 -- obtém usuários

REQUEST:

RESPONSE: { "id": 65, "email": "fabio@lopes.dev", "name": "Fabio Lopes", "created_at": "2021-11-21T22:37:40.000Z", "updated_at": "2021-11-21T22:37:40.000Z" }

DELETE /users/64 -- apaga usuário

REQUEST: RESPONSE: { "message": "usuário não encontrado||", "success": false }

[flgomes94]

@vpinheiro38 @antoniocsz novos endpoints criados

POST /priorities -- cria novas prioridades

REQUEST: { "description": "pode deixar para depois", "priority_number": 2 } RESPONSE: { "message": "Prioridade inserida com sucesso", "success": true, "data": { "description": "pode deixar para depois", "priority_number": null, "created_at": "2021-11-22T00:30:16.000Z", "updated_at": "2021-11-22T00:30:16.000Z" } }

GET /priorities -- retorna todas as prioridades REQUEST: RESPONSE: { "success": true, "message": "prioridades encontradas", "data": [ { "id": 1, "description": "urgente", "priority_number": null, "created_at": "2021-11-22T00:24:35.000Z", "updated_at": "2021-11-22T00:24:35.000Z" }, { "id": 2, "description": "mais ou menos", "priority_number": null, "created_at": "2021-11-22T00:24:41.000Z", "updated_at": "2021-11-22T00:24:41.000Z" }, { "id": 3, "description": "pode deixar para depois", "priority_number": null, "created_at": "2021-11-22T00:24:51.000Z", "updated_at": "2021-11-22T00:24:51.000Z" } ] }

[flgomes94]

@vpinheiro38 @antoniocsz novos endpoints criados

POST /tasks/ -- cria novos tasks

REQUEST: { "description": "Qualquer coisa", "completed":false, "task_priority":"1", "task_user":"65" }

RESPONSE: { "message": "Task criada com sucesso", "success": true, "data": { "user_name": "Fabio Lopes", "priority_id": 1, "priority_description": "urgente", "priority_number": null, "id": 3, "description": "Qualquer coisa", "completed": 0, "task_priority": 1, "task_user": 65, "created_at": "2021-11-22T01:40:35.000Z", "updated_at": "2021-11-22T01:40:35.000Z", "user_email": "fabio@lopes.dev" } }

PUT /tasks/61 -- atualiza tasks

REQUEST { "description": "Qualquer coisa2", "completed":true, "task_priority":"2", "task_user":"66" }

RESPONSE { "message": "Task editada com sucesso", "success": true, "data": { "user_name": "Fabio Lopes", "priority_id": 2, "priority_description": "mais ou menos", "priority_number": null, "id": 1, "description": "Qualquer coisa2", "completed": 1, "task_priority": 2, "task_user": 66, "created_at": "2021-11-22T01:38:13.000Z", "updated_at": "2021-11-22T01:42:41.000Z", "user_email": "fabio@lopes.dev" } }

GET /tasks/65 -- obtém tasks

REQUEST:

RESPONSE: { "user_name": "Fabio Lopes", "priority_id": 1, "priority_description": "urgente", "priority_number": null, "id": 2, "description": "Qualquer coisa", "completed": 0, "task_priority": 1, "task_user": 65, "created_at": "2021-11-22T01:40:01.000Z", "updated_at": "2021-11-22T01:40:01.000Z", "user_email": "fabio@lopes.dev" }

DELETE /tasks/64 -- apaga usuário

REQUEST: RESPONSE: { "message": "Task apagada com sucesso", "success": true }

[flgomes94]

@vpinheiro38 @antoniocsz novos endpoints criados

POST /disponibilities/ -- cria novas disponibilidades

REQUEST: { "routine_id":"1", "day_id":"2", "disponibility_morning":false, "disponibility_afternoon":false, "disponibility_night":true }}

RESPONSE: { "message": "Disponibilidade criada com sucesso", "success": true, "data": { "day_description": "Terça-feira", "routine_description": "criando uma rotina", "id": 1, "routine_id": 1, "day_id": 2, "disponibility_morning": 0, "disponibility_afternoon": 0, "disponibility_night": 1, "created_at": "2021-11-28T18:24:45.000Z", "updated_at": "2021-11-28T18:24:45.000Z" } }

PUT /disponibilities/1 -- atualiza disponibilidades

REQUEST { "routine_id":"1", "day_id":"3", "disponibility_morning":true, "disponibility_afternoon":true, "disponibility_night":true }

RESPONSE { "message": "Disponibilidade editada com sucesso", "success": true, "data": { "day_description": "Quarta-feira", "routine_description": "criando uma rotina", "id": 1, "routine_id": 1, "day_id": 3, "disponibility_morning": 1, "disponibility_afternoon": 1, "disponibility_night": 1, "created_at": "2021-11-28T18:24:45.000Z", "updated_at": "2021-11-28T18:28:05.000Z" } }

GET /disponibilities/1 -- obtém disponibilidade

REQUEST:

RESPONSE: { "success": false, "message": "disponibilidade não encontrada" }

DELETE /disponibilities/1 -- apaga usuário

REQUEST: RESPONSE: { "message": "Disponibilidade apagada com sucesso", "success": true }

[flgomes94]

@vpinheiro38 @antoniocsz novos endpoints criados

POST /categories/ -- cria novas categoria

REQUEST: { "description": "Qualquer coisa", "category_user":"2" }

RESPONSE: { "message": "Categoria criada com sucesso", "success": true, "data": { "id": 3, "description": "Qualquer coisa", "category_user": 65, "created_at": "2021-11-28T19:48:04.000Z", "updated_at": "2021-11-28T19:48:04.000Z", "user_email": "fabio@lopes.dev", "user_name": "Fabio Lopes", "user_id": 65 } }

PUT /categories/1 -- atualiza categoria

REQUEST { "description": "Qualquer coisa2", "category_user":"66" }

RESPONSE { "message": "Categoria editada com sucesso", "success": true, "data": { "id": 3, "description": "Qualquer coisa2", "category_user": 66, "created_at": "2021-11-28T19:48:04.000Z", "updated_at": "2021-11-28T19:48:27.000Z", "user_email": "fabio@lopes.dev", "user_name": "Fabio Lopes", "user_id": 66 } }

GET /categories/1 -- obtém categoria

REQUEST:

RESPONSE: { "id": 3, "description": "Qualquer coisa2", "category_user": 66, "created_at": "2021-11-28T19:48:04.000Z", "updated_at": "2021-11-28T19:48:27.000Z", "user_email": "fabio@lopes.dev", "user_name": "Fabio Lopes", "user_id": 66 }

DELETE /categories/1 -- apaga categoria

REQUEST: RESPONSE: { "message": "Categoria apagada com sucesso", "success": true }

[flgomes94]

@vpinheiro38 @antoniocsz novos endpoints criados

POST /routines/ -- cria novas rotinas

REQUEST: { "description": "criando uma rotina2", "routine_user":"65" }

RESPONSE: { "message": "Rotina criada com sucesso", "success": true, "data": { "id": 2, "description": "criando uma rotina2", "user_email": "fabio@lopes.dev", "user_name": "Fabio Lopes", "user_id": 65 } }

DELETE /routines/1 -- apaga rotinas

REQUEST: RESPONSE: { "message": "Rotina apagada com sucesso", "success": true }

[flgomes94]

@vpinheiro38 @antoniocsz novos endpoints criados

POST /users/login/ -- faz login no sistema

REQUEST: { "email":"fabio@lopes.dev", "password":"123456" }

RESPONSE: { "message": "Login encontrado", "success": true, "data": { "id": 65, "email": "fabio@lopes.dev", "name": "Fabio Lopes", "created_at": "2021-11-21T22:37:40.000Z", "updated_at": "2021-11-21T22:37:40.000Z" } }

[flgomes94]

@vpinheiro38 @antoniocsz novos endpoints criados

POST /tasks/ -- task com parametros de buscas

REQUEST: http://localhost:3001/tasks?user=65&priority=%5B1,2%5D&category=%5B1,2%5D

RESPONSE: { "succes": true, "message": "tasks encontradas", "data": [ { "user_id": 65, "user_name": "Fabio Lopes", "priority_id": 2, "priority_description": "mais ou menos", "priority_number": null, "id": 2, "description": "Qualquer coisa", "completed_at": null, "task_priority": 2, "task_user": 65, "created_at": "2021-11-22T01:40:01.000Z", "updated_at": "2021-11-29T04:04:52.000Z", "user_email": "fabio@lopes.dev", "category_task_id": 9, "category_task_category_id": 1, "category_task_task_id": 2 }, { "user_id": 65, "user_name": "Fabio Lopes", "priority_id": 1, "priority_description": "urgente", "priority_number": null, "id": 3, "description": "Qualquer coisa", "completed_at": null, "task_priority": 1, "task_user": 65, "created_at": "2021-11-28T21:02:10.000Z", "updated_at": "2021-11-28T21:02:10.000Z", "user_email": "fabio@lopes.dev", "category_task_id": 10, "category_task_category_id": 2, "category_task_task_id": 3 } ] }