{"info":{"_postman_id":"068b9447-f605-4d14-8ea0-3aa3acff6ee8","name":"Case_FullStack","description":"<html><head></head><body><p>Documentação baseada em um sistema de compras para supermercado.</p>\n</body></html>","schema":"https://schema.getpostman.com/json/collection/v2.0.0/collection.json","toc":[],"owner":"24706667","collectionId":"068b9447-f605-4d14-8ea0-3aa3acff6ee8","publishedId":"2s8ZDU6Pxp","public":true,"customColor":{"top-bar":"10453b","right-sidebar":"000000","highlight":"10453b"},"publishDate":"2023-01-16T20:57:33.000Z"},"item":[{"name":"Buscar todos clientes","id":"d8effb06-5156-4f7c-9ab2-c971cb1b1793","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"https://full-stack-5o0a.onrender.com/clients","description":"<p>Endpoint trará todos clientes já em cadastro.</p>\n","urlObject":{"protocol":"https","path":["clients"],"host":["full-stack-5o0a","onrender","com"],"query":[],"variable":[]}},"response":[{"id":"53067403-ac7b-4b63-9850-9671a509ea41","name":"Buscar todos clientes","originalRequest":{"method":"GET","header":[],"url":"https://full-stack-5o0a.onrender.com/clients"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Mon, 16 Jan 2023 20:45:35 GMT"},{"key":"Content-Type","value":"application/json; charset=utf-8"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"CF-Ray","value":"78a9b214b8f6a5d7-GRU"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"ETag","value":"W/\"96-8OgF5A5pcASd7+/WYf4UfOnZNsk\""},{"key":"Vary","value":"Accept-Encoding"},{"key":"CF-Cache-Status","value":"DYNAMIC"},{"key":"x-powered-by","value":"Express"},{"key":"Server","value":"cloudflare"},{"key":"Content-Encoding","value":"br"},{"key":"alt-svc","value":"h3=\":443\"; ma=86400, h3-29=\":443\"; ma=86400"}],"cookie":[],"responseTime":null,"body":"[\n    {\n        \"id\": 4,\n        \"name\": \"Ana Bananinha\"\n    },\n    {\n        \"id\": 1,\n        \"name\": \"Bananinha\"\n    },\n    {\n        \"id\": 2,\n        \"name\": \"Carol Martins\"\n    },\n    {\n        \"id\": 5,\n        \"name\": \"Luis junior\"\n    },\n    {\n        \"id\": 3,\n        \"name\": \"Testando\"\n    }\n]"}],"_postman_id":"d8effb06-5156-4f7c-9ab2-c971cb1b1793"},{"name":"Buscar todos produtos","id":"0274735e-5cee-4bea-a964-ea944c2cb3a0","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"https://full-stack-5o0a.onrender.com/products","description":"<p>Endpoint trará todos produtos, quantidade e preço já em cadastro.</p>\n","urlObject":{"protocol":"https","path":["products"],"host":["full-stack-5o0a","onrender","com"],"query":[],"variable":[]}},"response":[{"id":"62b94654-b435-46e3-a537-3b2b6ffb8c68","name":"Buscar todos produtos","originalRequest":{"method":"GET","header":[],"url":"https://full-stack-5o0a.onrender.com/products"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Mon, 16 Jan 2023 20:45:20 GMT"},{"key":"Content-Type","value":"application/json; charset=utf-8"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"CF-Ray","value":"78a9b1af2fbea5d7-GRU"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"ETag","value":"W/\"95d-v2Oy/CQFjOONwASY+2YYZiTESXc\""},{"key":"Vary","value":"Accept-Encoding"},{"key":"CF-Cache-Status","value":"DYNAMIC"},{"key":"x-powered-by","value":"Express"},{"key":"Server","value":"cloudflare"},{"key":"Content-Encoding","value":"br"},{"key":"alt-svc","value":"h3=\":443\"; ma=86400, h3-29=\":443\"; ma=86400"}],"cookie":[],"responseTime":null,"body":"[\n    {\n        \"id\": 1,\n        \"name\": \"Tomate Italiano\",\n        \"price\": 7.99,\n        \"qty_stock\": 690\n    },\n    {\n        \"id\": 2,\n        \"name\": \"Couve Flor Bandeja 250G\",\n        \"price\": 7.99,\n        \"qty_stock\": 499\n    },\n    {\n        \"id\": 3,\n        \"name\": \"Repolho Roxo Orgânico Embalagem 350G\",\n        \"price\": 6.99,\n        \"qty_stock\": 299\n    },\n    {\n        \"id\": 4,\n        \"name\": \"Couve Kale Orgânica  150G\",\n        \"price\": 6.99,\n        \"qty_stock\": 200\n    },\n    {\n        \"id\": 5,\n        \"name\": \"Banana Nanica\",\n        \"price\": 7.99,\n        \"qty_stock\": 500\n    },\n    {\n        \"id\": 6,\n        \"name\": \"Uva Crimson 450G Bd\",\n        \"price\": 9.98,\n        \"qty_stock\": 600\n    },\n    {\n        \"id\": 7,\n        \"name\": \"Kiwi Importado 30/36\",\n        \"price\": 19.98,\n        \"qty_stock\": 600\n    },\n    {\n        \"id\": 8,\n        \"name\": \"Mamão Formosa\",\n        \"price\": 12.99,\n        \"qty_stock\": 760\n    },\n    {\n        \"id\": 9,\n        \"name\": \"Manga Palmer Kg\",\n        \"price\": 5.99,\n        \"qty_stock\": 760\n    },\n    {\n        \"id\": 10,\n        \"name\": \"Cranberries Pacote 70G\",\n        \"price\": 19.98,\n        \"qty_stock\": 600\n    },\n    {\n        \"id\": 11,\n        \"name\": \"Goiaba Vermelha kg\",\n        \"price\": 14.98,\n        \"qty_stock\": 60\n    },\n    {\n        \"id\": 12,\n        \"name\": \"Caju Bandeja 300G\",\n        \"price\": 14.9,\n        \"qty_stock\": 488\n    },\n    {\n        \"id\": 13,\n        \"name\": \"Ameixa Seca com Caroço 180G\",\n        \"price\": 12.9,\n        \"qty_stock\": 78\n    },\n    {\n        \"id\": 14,\n        \"name\": \"Coco Seco Kg\",\n        \"price\": 9.98,\n        \"qty_stock\": 600\n    },\n    {\n        \"id\": 15,\n        \"name\": \"Detergente Ypê Clear 500Ml\",\n        \"price\": 1.99,\n        \"qty_stock\": 565\n    },\n    {\n        \"id\": 16,\n        \"name\": \"Agua Sanitaria Candura 2L\",\n        \"price\": 6.49,\n        \"qty_stock\": 78\n    },\n    {\n        \"id\": 17,\n        \"name\": \"Limpador Perfumado Veja Aroma Sense Alegria 500Ml\",\n        \"price\": 9.99,\n        \"qty_stock\": 80\n    },\n    {\n        \"id\": 18,\n        \"name\": \"Amaciante Downy Brisa do Verão 500Ml\",\n        \"price\": 13.99,\n        \"qty_stock\": 207\n    },\n    {\n        \"id\": 19,\n        \"name\": \"Batata Frita Lisa Sal e Vinagre Lays 80G \",\n        \"price\": 9.99,\n        \"qty_stock\": 29\n    },\n    {\n        \"id\": 20,\n        \"name\": \"Sopa de Batata com Carne Vono Ajinomoto 18G\",\n        \"price\": 3.99,\n        \"qty_stock\": 80\n    },\n    {\n        \"id\": 21,\n        \"name\": \"Antisséptico Bucal Listerine Anticáries Zero Álcool 500Ml\",\n        \"price\": 23.99,\n        \"qty_stock\": 50\n    },\n    {\n        \"id\": 22,\n        \"name\": \"Escova Dental Colgate Classic Long Macia\",\n        \"price\": 6.99,\n        \"qty_stock\": 60\n    },\n    {\n        \"id\": 23,\n        \"name\": \"Toalha Umedecida Johnsons Baby Limpeza Suave Embalagem 44 Un\",\n        \"price\": 10.99,\n        \"qty_stock\": 80\n    },\n    {\n        \"id\": 24,\n        \"name\": \"Fanta Guaraná 350Ml\",\n        \"price\": 3.99,\n        \"qty_stock\": 50\n    },\n    {\n        \"id\": 25,\n        \"name\": \"Molho Shoyu Satis Suave 150Ml\",\n        \"price\": 4.29,\n        \"qty_stock\": 70\n    },\n    {\n        \"id\": 26,\n        \"name\": \"Sabonete Barra Antibactericida Carvão Detox Envoltório Protex 85G\",\n        \"price\": 3.29,\n        \"qty_stock\": 89\n    },\n    {\n        \"id\": 27,\n        \"name\": \"Desodorante Antitranspirante Rexona sem Perfume 50Ml\",\n        \"price\": 11.99,\n        \"qty_stock\": 208\n    },\n    {\n        \"id\": 28,\n        \"name\": \"Suco Del Valle 100% Laranja 1L\",\n        \"price\": 9.99,\n        \"qty_stock\": 456\n    },\n    {\n        \"id\": 29,\n        \"name\": \"Biscoito Recheado Milkshake de Morango Oreo 90G\",\n        \"price\": 3.99,\n        \"qty_stock\": 456\n    },\n    {\n        \"id\": 30,\n        \"name\": \"Cerveja Duplo Malte Puro Malte Br\",\n        \"price\": 3.99,\n        \"qty_stock\": 500\n    }\n]"}],"_postman_id":"0274735e-5cee-4bea-a964-ea944c2cb3a0"},{"name":"Buscar estoque","id":"91d882d5-4187-4deb-8693-e0939d81d4cc","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"https://full-stack-5o0a.onrender.com/stock","description":"<p>Endpoint trará todas quantidades dos produtos já em cadastro.</p>\n","urlObject":{"protocol":"https","path":["stock"],"host":["full-stack-5o0a","onrender","com"],"query":[],"variable":[]}},"response":[{"id":"27545a95-c221-4819-8c76-a852849e81e4","name":"New Request","originalRequest":{"method":"GET","header":[],"url":"https://full-stack-5o0a.onrender.com/stock"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Mon, 16 Jan 2023 20:46:18 GMT"},{"key":"Content-Type","value":"application/json; charset=utf-8"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"CF-Ray","value":"78a9b31ecd40a5d7-GRU"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"ETag","value":"W/\"8c5-rrGAe6rN87yi99Vzca1XxY29ZqI\""},{"key":"Vary","value":"Accept-Encoding"},{"key":"CF-Cache-Status","value":"DYNAMIC"},{"key":"x-powered-by","value":"Express"},{"key":"Server","value":"cloudflare"},{"key":"Content-Encoding","value":"br"},{"key":"alt-svc","value":"h3=\":443\"; ma=86400, h3-29=\":443\"; ma=86400"}],"cookie":[],"responseTime":null,"body":"[\n    [\n        {\n            \"name\": \"Tomate Italiano\",\n            \"qty_stock\": 690\n        },\n        {\n            \"name\": \"Couve Flor Bandeja 250G\",\n            \"qty_stock\": 499\n        },\n        {\n            \"name\": \"Repolho Roxo Orgânico Embalagem 350G\",\n            \"qty_stock\": 299\n        },\n        {\n            \"name\": \"Couve Kale Orgânica  150G\",\n            \"qty_stock\": 200\n        },\n        {\n            \"name\": \"Banana Nanica\",\n            \"qty_stock\": 500\n        },\n        {\n            \"name\": \"Uva Crimson 450G Bd\",\n            \"qty_stock\": 600\n        },\n        {\n            \"name\": \"Kiwi Importado 30/36\",\n            \"qty_stock\": 600\n        },\n        {\n            \"name\": \"Mamão Formosa\",\n            \"qty_stock\": 760\n        },\n        {\n            \"name\": \"Manga Palmer Kg\",\n            \"qty_stock\": 760\n        },\n        {\n            \"name\": \"Cranberries Pacote 70G\",\n            \"qty_stock\": 600\n        },\n        {\n            \"name\": \"Goiaba Vermelha kg\",\n            \"qty_stock\": 60\n        },\n        {\n            \"name\": \"Caju Bandeja 300G\",\n            \"qty_stock\": 488\n        },\n        {\n            \"name\": \"Ameixa Seca com Caroço 180G\",\n            \"qty_stock\": 78\n        },\n        {\n            \"name\": \"Coco Seco Kg\",\n            \"qty_stock\": 600\n        },\n        {\n            \"name\": \"Detergente Ypê Clear 500Ml\",\n            \"qty_stock\": 565\n        },\n        {\n            \"name\": \"Agua Sanitaria Candura 2L\",\n            \"qty_stock\": 78\n        },\n        {\n            \"name\": \"Limpador Perfumado Veja Aroma Sense Alegria 500Ml\",\n            \"qty_stock\": 80\n        },\n        {\n            \"name\": \"Amaciante Downy Brisa do Verão 500Ml\",\n            \"qty_stock\": 207\n        },\n        {\n            \"name\": \"Batata Frita Lisa Sal e Vinagre Lays 80G \",\n            \"qty_stock\": 29\n        },\n        {\n            \"name\": \"Sopa de Batata com Carne Vono Ajinomoto 18G\",\n            \"qty_stock\": 80\n        },\n        {\n            \"name\": \"Antisséptico Bucal Listerine Anticáries Zero Álcool 500Ml\",\n            \"qty_stock\": 50\n        },\n        {\n            \"name\": \"Escova Dental Colgate Classic Long Macia\",\n            \"qty_stock\": 60\n        },\n        {\n            \"name\": \"Toalha Umedecida Johnsons Baby Limpeza Suave Embalagem 44 Un\",\n            \"qty_stock\": 80\n        },\n        {\n            \"name\": \"Fanta Guaraná 350Ml\",\n            \"qty_stock\": 50\n        },\n        {\n            \"name\": \"Molho Shoyu Satis Suave 150Ml\",\n            \"qty_stock\": 70\n        },\n        {\n            \"name\": \"Sabonete Barra Antibactericida Carvão Detox Envoltório Protex 85G\",\n            \"qty_stock\": 89\n        },\n        {\n            \"name\": \"Desodorante Antitranspirante Rexona sem Perfume 50Ml\",\n            \"qty_stock\": 208\n        },\n        {\n            \"name\": \"Suco Del Valle 100% Laranja 1L\",\n            \"qty_stock\": 456\n        },\n        {\n            \"name\": \"Biscoito Recheado Milkshake de Morango Oreo 90G\",\n            \"qty_stock\": 456\n        },\n        {\n            \"name\": \"Cerveja Duplo Malte Puro Malte Br\",\n            \"qty_stock\": 500\n        }\n    ],\n    [\n        {\n            \"catalog\": \"def\",\n            \"db\": \"jbl-4416152-caroline-martins\",\n            \"table\": \"Case_Products\",\n            \"orgTable\": \"Case_Products\",\n            \"name\": \"name\",\n            \"orgName\": \"name\",\n            \"charsetNr\": 33,\n            \"length\": 765,\n            \"type\": 253,\n            \"flags\": 0,\n            \"decimals\": 0,\n            \"zeroFill\": false,\n            \"protocol41\": true\n        },\n        {\n            \"catalog\": \"def\",\n            \"db\": \"jbl-4416152-caroline-martins\",\n            \"table\": \"Case_Products\",\n            \"orgTable\": \"Case_Products\",\n            \"name\": \"qty_stock\",\n            \"orgName\": \"qty_stock\",\n            \"charsetNr\": 63,\n            \"length\": 11,\n            \"type\": 3,\n            \"flags\": 0,\n            \"decimals\": 0,\n            \"zeroFill\": false,\n            \"protocol41\": true\n        }\n    ]\n]"}],"_postman_id":"91d882d5-4187-4deb-8693-e0939d81d4cc"},{"name":"Criar novo cliente","id":"48820b36-82e3-42fe-9593-6909bb3376d5","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\r\n    \"name\": \"Reinaldo\"\r\n}","options":{"raw":{"language":"json"}}},"url":"https://full-stack-5o0a.onrender.com/clients","description":"<p>Endpoint cadastrará novos clientes.</p>\n","urlObject":{"protocol":"https","path":["clients"],"host":["full-stack-5o0a","onrender","com"],"query":[],"variable":[]}},"response":[{"id":"f0b19223-5dbf-4f17-aa79-41f2741d2e2f","name":"New Request","originalRequest":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\r\n    \"name\": \"Reinaldo\"\r\n}","options":{"raw":{"language":"json"}}},"url":"https://full-stack-5o0a.onrender.com/clients"},"status":"OK","code":200,"_postman_previewlanguage":"html","header":[{"key":"Date","value":"Mon, 16 Jan 2023 20:47:58 GMT"},{"key":"Content-Type","value":"text/html; charset=utf-8"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"CF-Ray","value":"78a9b58f197da5d7-GRU"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"ETag","value":"W/\"30-3oS/ktivPySwDwwHDugI56jmqas\""},{"key":"Vary","value":"Accept-Encoding"},{"key":"CF-Cache-Status","value":"DYNAMIC"},{"key":"x-powered-by","value":"Express"},{"key":"Server","value":"cloudflare"},{"key":"Content-Encoding","value":"br"},{"key":"alt-svc","value":"h3=\":443\"; ma=86400, h3-29=\":443\"; ma=86400"}],"cookie":[],"responseTime":null,"body":"message: cliente cadastrado com sucesso Reinaldo"}],"_postman_id":"48820b36-82e3-42fe-9593-6909bb3376d5"},{"name":"Criar pedido produtos","id":"815949eb-0b5f-4704-ad41-eb5c627cc9c5","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\r\n    \"fk_client\": 3,\r\n    \"delivery_date\":\"2023-11-30\",\r\n    \"products\":[\r\n        {\r\n            \"id\":1,\r\n            \"qty\":10\r\n        }]\r\n}","options":{"raw":{"language":"json"}}},"url":"https://full-stack-5o0a.onrender.com/order","description":"<p>Endpoint para cadastro de pedidos os inculando aos clientes.</p>\n","urlObject":{"protocol":"https","path":["order"],"host":["full-stack-5o0a","onrender","com"],"query":[],"variable":[]}},"response":[{"id":"621b9c91-ef36-45b5-af8f-ea27e305f86c","name":"New Request","originalRequest":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\r\n    \"fk_client\": 3,\r\n    \"delivery_date\":\"2023-11-30\",\r\n    \"products\":[\r\n        {\r\n            \"id\":1,\r\n            \"qty\":10\r\n        }]\r\n}","options":{"raw":{"language":"json"}}},"url":"https://full-stack-5o0a.onrender.com/order"},"status":"OK","code":200,"_postman_previewlanguage":"html","header":[{"key":"Date","value":"Mon, 16 Jan 2023 20:49:59 GMT"},{"key":"Content-Type","value":"text/html; charset=utf-8"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"CF-Ray","value":"78a9b8824a67a5d7-GRU"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"ETag","value":"W/\"1b-Uj1m2Dsw4Bl5BKH+NYoqsvlaK10\""},{"key":"Vary","value":"Accept-Encoding"},{"key":"CF-Cache-Status","value":"DYNAMIC"},{"key":"x-powered-by","value":"Express"},{"key":"Server","value":"cloudflare"},{"key":"Content-Encoding","value":"br"},{"key":"alt-svc","value":"h3=\":443\"; ma=86400, h3-29=\":443\"; ma=86400"}],"cookie":[],"responseTime":null,"body":"Pedido criado com sucesso!!"}],"_postman_id":"815949eb-0b5f-4704-ad41-eb5c627cc9c5"}]}