{"info":{"_postman_id":"720d62d0-002a-4bef-ac52-610dfec5a60d","name":"PROJETO LABECOMMERCE - BACKEND - TURMA JEMISON - RENATO ALEXANDRINI","description":"

Projeto realizado com a finalidade de introduzir o conceito de criação de uma API, com um banco de daods fornecido pela Labenu e como podemos proteger os dados importantes utilizando o Dotenv.

O projeto simula um um sistema de E-Commerce, contendo as entidades usuários, produtos e compras, possuindo algumas funções que simulam funções reais, como cadastrar um produto, cadastrar um usuário e realizar uma compra.

\n","schema":"https://schema.getpostman.com/json/collection/v2.0.0/collection.json","toc":[],"owner":"24755055","collectionId":"720d62d0-002a-4bef-ac52-610dfec5a60d","publishedId":"2s8YzMXR12","public":true,"customColor":{"top-bar":"FFFFFF","right-sidebar":"303030","highlight":"EF5B25"},"publishDate":"2022-12-04T05:22:56.000Z"},"item":[{"name":"User Add","id":"09eaec20-d4ab-4a3e-aa1a-a1800a706e8b","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[{"key":"auth","value":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjgxMTk5Njg0LWU2ZTAtNDhhMy05YmFjLWZmMjkyNTY5MDRlMiIsImlhdCI6MTY3NTY1MTcwNywiZXhwIjoxNjc1NzM4MTA3fQ.YLxCfPNwRyGagoxmOQFV4AT2b1gQC2KfDrueGEF5Z7k","type":"text"}],"body":{"mode":"raw","raw":"","options":{"raw":{"language":"json"}}},"url":"https://projeto-labecommerce-backend-turma.onrender.com/users","description":"

Endpoint que adiciona um novo usuário ao banco de dados, utilizando os dados passados através do \"body\". Não sendo permitida a falta de nenhuma das propriedades e também a criação de um usuário com o email igual a outro usuário adicionado anteriormente.

Endpoint que não recebe nenhum tipo de parâmetro, apenas retorna um array com todos os usuários e todas as compras realizadas por ele, retornando um array de compras vazio caso o usuário não tenha realizado nenhuma compra anterior.

\n","urlObject":{"protocol":"https","path":["users"],"host":["projeto-labecommerce-backend-turma","onrender","com"],"query":[],"variable":[]}},"response":[{"id":"927b2246-899d-4db2-ae13-db427259106b","name":"All Users with Purchases","originalRequest":{"method":"GET","header":[],"body":{"mode":"raw","raw":"","options":{"raw":{"language":"json"}}},"url":"http://localhost:3003/users"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"X-Powered-By","value":"Express"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Content-Type","value":"application/json; charset=utf-8"},{"key":"Content-Length","value":"4847"},{"key":"ETag","value":"W/\"12ef-5pIIxZQ3LekPsu3L0fMCFsrWeJw\""},{"key":"Date","value":"Sun, 04 Dec 2022 21:53:47 GMT"},{"key":"Connection","value":"keep-alive"},{"key":"Keep-Alive","value":"timeout=5"}],"cookie":[],"responseTime":null,"body":"[\n {\n \"user\": {\n \"id\": \"1669937058740\",\n \"name\": \"Renato Alexandrini\",\n \"email\": \"re.alexandrini@gmail.com\",\n \"password\": \"pass987654321\"\n },\n \"purchases\": [\n {\n \"purchase_id\": \"1669946919539\",\n \"product_id\": \"1669946121114\",\n \"product_name\": \"The Manhattan Project\",\n \"unitary_value\": 162.26,\n \"quantity\": 3,\n \"total_price\": 486.78\n },\n {\n \"purchase_id\": \"1669946946952\",\n \"product_id\": \"1669946114161\",\n \"product_name\": \"Viticulture\",\n \"unitary_value\": 379,\n \"quantity\": 2,\n \"total_price\": 758\n },\n {\n \"purchase_id\": \"1669946991307\",\n \"product_id\": \"1669946716906\",\n \"product_name\": \"Wingspan\",\n \"unitary_value\": 425.9,\n \"quantity\": 4,\n \"total_price\": 1703.6\n }\n ]\n },\n {\n \"user\": {\n \"id\": \"1669937071727\",\n \"name\": \"Leonardo Correa de Lima\",\n \"email\": \"leo_lima54@gmail.com\",\n \"password\": \"pass986532741\"\n },\n \"purchases\": [\n {\n \"purchase_id\": \"1669947230382\",\n \"product_id\": \"1669944141537\",\n \"product_name\": \"The Thing: The Boardgame\",\n \"unitary_value\": 278.58,\n \"quantity\": 3,\n \"total_price\": 835.74\n },\n {\n \"purchase_id\": \"1669947265248\",\n \"product_id\": \"1669946107538\",\n \"product_name\": \"Terraforming Mars\",\n \"unitary_value\": 327.58,\n \"quantity\": 3,\n \"total_price\": 982.74\n },\n {\n \"purchase_id\": \"1670119992265\",\n \"product_id\": \"1669946114161\",\n \"product_name\": \"Viticulture\",\n \"unitary_value\": 379,\n \"quantity\": 3,\n \"total_price\": 1137\n },\n {\n \"purchase_id\": \"1670130490732\",\n \"product_id\": \"1669946114161\",\n \"product_name\": \"Viticulture\",\n \"unitary_value\": 379,\n \"quantity\": 3,\n \"total_price\": 1137\n },\n {\n \"purchase_id\": \"1670130501673\",\n \"product_id\": \"1669946114161\",\n \"product_name\": \"Viticulture\",\n \"unitary_value\": 379,\n \"quantity\": 3,\n \"total_price\": 1137\n }\n ]\n },\n {\n \"user\": {\n \"id\": \"1669937191899\",\n \"name\": \"Flavia Regini\",\n \"email\": \"regini1990@gmail.com\",\n \"password\": \"pass852963741\"\n },\n \"purchases\": [\n {\n \"purchase_id\": \"1669946927053\",\n \"product_id\": \"1669946716906\",\n \"product_name\": \"Wingspan\",\n \"unitary_value\": 425.9,\n \"quantity\": 1,\n \"total_price\": 425.9\n },\n {\n \"purchase_id\": \"1669947223652\",\n \"product_id\": \"1669946107538\",\n \"product_name\": \"Terraforming Mars\",\n \"unitary_value\": 327.58,\n \"quantity\": 2,\n \"total_price\": 655.16\n }\n ]\n },\n {\n \"user\": {\n \"id\": \"1669937201556\",\n \"name\": \"Diogo Saulo\",\n \"email\": \"di_saulo789@gmail.com\",\n \"password\": \"pass123789456\"\n },\n \"purchases\": [\n {\n \"purchase_id\": \"1669946997956\",\n \"product_id\": \"1669944133547\",\n \"product_name\": \"Fresco\",\n \"unitary_value\": 317,\n \"quantity\": 2,\n \"total_price\": 634\n },\n {\n \"purchase_id\": \"1669947257424\",\n \"product_id\": \"1669944552421\",\n \"product_name\": \"Ticket To Ride\",\n \"unitary_value\": 398.9,\n \"quantity\": 1,\n \"total_price\": 398\n }\n ]\n },\n {\n \"user\": {\n \"id\": \"1669937215444\",\n \"name\": \"Alessandra Nascimento\",\n \"email\": \"nasciAle123@gmail.com\",\n \"password\": \"pass684215973\"\n },\n \"purchases\": [\n {\n \"purchase_id\": \"1669947203226\",\n \"product_id\": \"1669946121114\",\n \"product_name\": \"The Manhattan Project\",\n \"unitary_value\": 162.26,\n \"quantity\": 1,\n \"total_price\": 162.26\n },\n {\n \"purchase_id\": \"1669947251936\",\n \"product_id\": \"1669946707649\",\n \"product_name\": \"Tapestry\",\n \"unitary_value\": 599.9,\n \"quantity\": 2,\n \"total_price\": 1199.8\n }\n ]\n },\n {\n \"user\": {\n \"id\": \"1669937232748\",\n \"name\": \"Rubens Silva\",\n \"email\": \"rubens_silva456@gmail.com\",\n \"password\": \"pass753914862\"\n },\n \"purchases\": [\n {\n \"purchase_id\": \"1669946983466\",\n \"product_id\": \"1669946716906\",\n \"product_name\": \"Wingspan\",\n \"unitary_value\": 425.9,\n \"quantity\": 3,\n \"total_price\": 1277.7\n },\n {\n \"purchase_id\": \"1669947208971\",\n \"product_id\": \"1669944552421\",\n \"product_name\": \"Ticket To Ride\",\n \"unitary_value\": 398.9,\n \"quantity\": 4,\n \"total_price\": 1595.6\n }\n ]\n },\n {\n \"user\": {\n \"id\": \"1669937330352\",\n \"name\": \"Patrícia Caldeira\",\n \"email\": \"patricia_c852@gmail.com\",\n \"password\": \"pass132798465\"\n },\n \"purchases\": [\n {\n \"purchase_id\": \"1669946933509\",\n \"product_id\": \"1669944120444\",\n \"product_name\": \"Istanbul\",\n \"unitary_value\": 193,\n \"quantity\": 5,\n \"total_price\": 965\n },\n {\n \"purchase_id\": \"1669947215684\",\n \"product_id\": \"1669948037685\",\n \"product_name\": \"Cyclades\",\n \"unitary_value\": 292.81,\n \"quantity\": 4,\n \"total_price\": 1171.24\n },\n {\n \"purchase_id\": \"1669947243278\",\n \"product_id\": \"1669948037685\",\n \"product_name\": \"Cyclades\",\n \"unitary_value\": 292.81,\n \"quantity\": 1,\n \"total_price\": 292.81\n }\n ]\n },\n {\n \"user\": {\n \"id\": \"1669937339352\",\n \"name\": \"Gilberto Conceição\",\n \"email\": \"gil_com6sao@gmail.com\",\n \"password\": \"pass963541728\"\n },\n \"purchases\": [\n {\n \"purchase_id\": \"1669946956313\",\n \"product_id\": \"1669944141537\",\n \"product_name\": \"The Thing: The Boardgame\",\n \"unitary_value\": 278.58,\n \"quantity\": 2,\n \"total_price\": 557.16\n },\n {\n \"purchase_id\": \"1669947237182\",\n \"product_id\": \"1669948163290\",\n \"product_name\": \"Zombicide: Black Plague\",\n \"unitary_value\": 799.9,\n \"quantity\": 5,\n \"total_price\": 3999.5\n }\n ]\n },\n {\n \"user\": {\n \"id\": \"1669937354378\",\n \"name\": \"Tainá Amaral\",\n \"email\": \"taamaral300@gmail.com\",\n \"password\": \"pass781296354\"\n },\n \"purchases\": [\n {\n \"purchase_id\": \"1669946967152\",\n \"product_id\": \"1669948163290\",\n \"product_name\": \"Zombicide: Black Plague\",\n \"unitary_value\": 799.9,\n \"quantity\": 6,\n \"total_price\": 4799.4\n },\n {\n \"purchase_id\": \"1669947192850\",\n \"product_id\": \"1669944120444\",\n \"product_name\": \"Istanbul\",\n \"unitary_value\": 193,\n \"quantity\": 7,\n \"total_price\": 1351\n }\n ]\n },\n {\n \"user\": {\n \"id\": \"1669937370723\",\n \"name\": \"Antônio Amorin\",\n \"email\": \"tonhomorim@gmail.com\",\n \"password\": \"pass513794682\"\n },\n \"purchases\": []\n },\n {\n \"user\": {\n \"id\": \"1670017215020\",\n \"name\": \"Aurélio Miguel\",\n \"email\": \"auaumiguel@gmail.com\",\n \"password\": \"pass2598754121551\"\n },\n \"purchases\": []\n }\n]"}],"_postman_id":"372cd0d5-7126-4b8a-a8e0-2f310b620da2"},{"name":"Product Add","id":"b9716774-d9cf-471e-98b7-816ae8e4d9d7","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\r\n \"name\": \"Abyss\",\r\n \"price\": 266.90 ,\r\n \"imageUrl\":\"https://ibb.co/6mYPFW1\"\r\n}","options":{"raw":{"language":"json"}}},"url":"https://projeto-labecommerce-backend-turma.onrender.com/products","description":"

Endpoint que adiciona um novo produto ao banco de dados, utilizando os dados passados através do \"body\". Não sendo permitida a falta de nenhuma das propriedades e também a criação de um produto com o nome igual a outro produto adicionado anteriormente.

\n","urlObject":{"protocol":"https","path":["products"],"host":["projeto-labecommerce-backend-turma","onrender","com"],"query":[],"variable":[]}},"response":[{"id":"212f0557-f472-433e-91ec-1cf466359dc6","name":"Product Add","originalRequest":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\r\n \"name\": \"Abyss\",\r\n \"price\": 266.90 ,\r\n \"imageUrl\":\"https://ibb.co/6mYPFW1\"\r\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:3003/products"},"status":"OK","code":200,"_postman_previewlanguage":"html","header":[{"key":"X-Powered-By","value":"Express"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Content-Type","value":"text/html; charset=utf-8"},{"key":"Content-Length","value":"26"},{"key":"ETag","value":"W/\"1a-AaqpDc1NJ3gmidNY8d7aLxXM5No\""},{"key":"Date","value":"Sun, 04 Dec 2022 22:01:42 GMT"},{"key":"Connection","value":"keep-alive"},{"key":"Keep-Alive","value":"timeout=5"}],"cookie":[],"responseTime":null,"body":"Produto criado com sucesso"}],"_postman_id":"b9716774-d9cf-471e-98b7-816ae8e4d9d7"},{"name":"All Products, Search and Order","id":"cfb2783f-9954-472e-96d0-d42fae536382","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"https://projeto-labecommerce-backend-turma.onrender.com/products?order=desc&search=a","description":"

Endpoint que retorna uma lista com todos os produtos do banco de dados, podendo ser passado através de uma query um termo para busca de produtos ou uma ordenação(crescente: \"ASC\" ou decrescente \"DESC\").
Todos os parâmetros(\"order\" e \"search\") são opcionais, gerando diferentes resultados, de acordo com o solicitado.

\n","urlObject":{"protocol":"https","path":["products"],"host":["projeto-labecommerce-backend-turma","onrender","com"],"query":[{"key":"order","value":"desc"},{"key":"search","value":"a"}],"variable":[]}},"response":[{"id":"d8fe431d-a353-44a8-afcd-1f7fdc62eee8","name":"All Products, Search and Order","originalRequest":{"method":"GET","header":[],"url":{"raw":"http://localhost:3003/products?order=desc&search=a","protocol":"http","host":["localhost"],"port":"3003","path":["products"],"query":[{"key":"order","value":"desc"},{"key":"search","value":"a"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"X-Powered-By","value":"Express"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Content-Type","value":"application/json; charset=utf-8"},{"key":"Content-Length","value":"881"},{"key":"ETag","value":"W/\"371-e85q4L3Jl14qJLeJvW5oT4DDoyY\""},{"key":"Date","value":"Sun, 04 Dec 2022 21:54:19 GMT"},{"key":"Connection","value":"keep-alive"},{"key":"Keep-Alive","value":"timeout=5"}],"cookie":[],"responseTime":null,"body":"[\n {\n \"id\": \"1669948163290\",\n \"name\": \"Zombicide: Black Plague\",\n \"price\": 799.9,\n \"image_url\": \"https://ibb.co/wQ3kr3L\"\n },\n {\n \"id\": \"1669946716906\",\n \"name\": \"Wingspan\",\n \"price\": 425.9,\n \"image_url\": \"https://ibb.co/kBxsJ7Y\"\n },\n {\n \"id\": \"1669944141537\",\n \"name\": \"The Thing: The Boardgame\",\n \"price\": 278.58,\n \"image_url\": \"https://ibb.co/RpYkN7D\"\n },\n {\n \"id\": \"1669946121114\",\n \"name\": \"The Manhattan Project\",\n \"price\": 162.26,\n \"image_url\": \"https://ibb.co/TWkMg1V\"\n },\n {\n \"id\": \"1669946107538\",\n \"name\": \"Terraforming Mars\",\n \"price\": 327.58,\n \"image_url\": \"https://ibb.co/fXf47sS\"\n },\n {\n \"id\": \"1669946707649\",\n \"name\": \"Tapestry\",\n \"price\": 599.9,\n \"image_url\": \"https://ibb.co/b53HVfT\"\n },\n {\n \"id\": \"1669944120444\",\n \"name\": \"Istanbul\",\n \"price\": 193,\n \"image_url\": \"https://ibb.co/qW0jhn8\"\n },\n {\n \"id\": \"1669948037685\",\n \"name\": \"Cyclades\",\n \"price\": 292.81,\n \"image_url\": \"https://ibb.co/WWQMGsT\"\n },\n {\n \"id\": \"1670110857410\",\n \"name\": \"Abyss\",\n \"price\": 266.9,\n \"image_url\": \"https://ibb.co/6mYPFW1\"\n }\n]"}],"_postman_id":"cfb2783f-9954-472e-96d0-d42fae536382"},{"name":"Purchase Add","id":"1451abaa-426e-436c-9653-a1ca055349e4","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\r\n \"user_id\": \"1669937071727\",\r\n \"product_id\": \"1669946114161\",\r\n \"quantity\": 3\r\n}","options":{"raw":{"language":"json"}}},"url":"https://projeto-labecommerce-backend-turma.onrender.com/purchases","description":"

Endpoint que adiciona uma nova compra ao banco de dados, utilizando os dados passados através do \"body\". Não sendo permitida a falta de nenhuma das propriedades e também havendo a verificação da existência do usuário e do produto pelo id informado.

\n","urlObject":{"protocol":"https","path":["purchases"],"host":["projeto-labecommerce-backend-turma","onrender","com"],"query":[],"variable":[]}},"response":[{"id":"84c36aaf-c951-4fc3-adc6-bc1edbaed93d","name":"Purchase Add","originalRequest":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\r\n \"user_id\": \"1669937071727\",\r\n \"product_id\": \"1669946114161\",\r\n \"quantity\": 3\r\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:3003/purchases"},"status":"OK","code":200,"_postman_previewlanguage":"html","header":[{"key":"X-Powered-By","value":"Express"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Content-Type","value":"text/html; charset=utf-8"},{"key":"Content-Length","value":"29"},{"key":"ETag","value":"W/\"1d-YEkmF/fg98D7VVyU4btmuZVhWDY\""},{"key":"Date","value":"Sun, 04 Dec 2022 21:55:01 GMT"},{"key":"Connection","value":"keep-alive"},{"key":"Keep-Alive","value":"timeout=5"}],"cookie":[],"responseTime":null,"body":"Compra realizada com sucesso!"}],"_postman_id":"1451abaa-426e-436c-9653-a1ca055349e4"},{"name":"User Purchases","id":"aab64110-168b-4eea-8045-a4827da10ec3","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"body":{"mode":"raw","raw":"","options":{"raw":{"language":"json"}}},"url":"https://projeto-labecommerce-backend-turma.onrender.com/purchases","description":"

Endpoint que recebe o id de um usuário através do \"path.params\", retornando as informações deste usuário junto com as compras realizadas por ele, havendo a verificação da existência do usuário através do id informado.

\n","urlObject":{"protocol":"https","path":["purchases"],"host":["projeto-labecommerce-backend-turma","onrender","com"],"query":[],"variable":[]}},"response":[{"id":"f28de0ce-b680-40b9-92ed-99b9e18b45ea","name":"User Purchases","originalRequest":{"method":"GET","header":[],"url":{"raw":"http://localhost:3003/users/:user_id/purchases","protocol":"http","host":["localhost"],"port":"3003","path":["users",":user_id","purchases"],"variable":[{"key":"user_id","value":"1669937058740"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"X-Powered-By","value":"Express"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Content-Type","value":"application/json; charset=utf-8"},{"key":"Content-Length","value":"584"},{"key":"ETag","value":"W/\"248-Zyl/IkuiCq55yxeVH7KfxeDMyag\""},{"key":"Date","value":"Sun, 04 Dec 2022 21:54:39 GMT"},{"key":"Connection","value":"keep-alive"},{"key":"Keep-Alive","value":"timeout=5"}],"cookie":[],"responseTime":null,"body":"[\n {\n \"userInfo\": [\n {\n \"id\": \"1669937058740\",\n \"name\": \"Renato Alexandrini\",\n \"email\": \"re.alexandrini@gmail.com\",\n \"password\": \"pass987654321\"\n }\n ],\n \"purchases\": [\n {\n \"purchase_id\": \"1669946919539\",\n \"product_id\": \"1669946121114\",\n \"product_name\": \"The Manhattan Project\",\n \"unitary_value\": 162.26,\n \"quantity\": 3,\n \"total_price\": 486.78\n },\n {\n \"purchase_id\": \"1669946946952\",\n \"product_id\": \"1669946114161\",\n \"product_name\": \"Viticulture\",\n \"unitary_value\": 379,\n \"quantity\": 2,\n \"total_price\": 758\n },\n {\n \"purchase_id\": \"1669946991307\",\n \"product_id\": \"1669946716906\",\n \"product_name\": \"Wingspan\",\n \"unitary_value\": 425.9,\n \"quantity\": 4,\n \"total_price\": 1703.6\n }\n ]\n }\n]"}],"_postman_id":"aab64110-168b-4eea-8045-a4827da10ec3"}]}