Flask-based API that provides a simple interface for managing a database of cafes. It allows users to perform various operations, including retrieving details about all cafes, getting a random cafe suggestion, searching for cafes by location, adding new cafes and updating specific cafe information.
\nname: string (unique values)
\nmap_url: string
\nimg_url: string
\nlocation: string
\nseats: string
\nhas_toilet: boolean
\nhas_wifi: boolean
\nhas_sockets: boolean
\ncan_take_calls: boolean
\ncoffee_price: string
\nThis endpoint returns a list of all cafes stored in the database. It retrieves information about the cafes and sends it back in JSON format.
\n","urlObject":{"protocol":"https","path":["all"],"host":["cafe-and-wifi","vercel","app"],"query":[],"variable":[]}},"response":[{"id":"07f82d46-b14a-46ad-a9f0-e333dfb4a093","name":"Get all cafes","originalRequest":{"method":"GET","header":[],"url":"https://cafe-and-wifi.vercel.app/all"},"_postman_previewlanguage":"json","header":[{"key":"Content-Type","value":"application/json","description":"","type":"text"}],"cookie":[],"responseTime":null,"body":"{\n \"cafes\": [\n {\n \"can_take_calls\": false,\n \"coffee_price\": \"\\u00a33.00\",\n \"has_sockets\": true,\n \"has_toilet\": true,\n \"has_wifi\": true,\n \"id\": 7,\n \"img_url\": \"https://lh3.googleusercontent.com/p/AF1QipP_NbZH7A1fIQyp5pRm1jOGwzKsDWewaxka6vDt=s0\",\n \"location\": \"Shoreditch\",\n \"map_url\": \"https://g.page/acehotellondon?share\",\n \"name\": \"Ace Hotel Shoreditch\",\n \"seats\": \"50+\"\n },\n {\n \"can_take_calls\": true,\n \"coffee_price\": \"\\u00a33.00\",\n \"has_sockets\": false,\n \"has_toilet\": true,\n \"has_wifi\": true,\n \"id\": 14,\n \"img_url\": \"https://images.adsttc.com/media/images/5014/ec99/28ba/0d58/2800/0d0f/large_jpg/stringio.jpg?1414576924\",\n \"location\": \"Barbican\",\n \"map_url\": \"https://goo.gl/maps/XPrcFj91LsQBvUa27\",\n \"name\": \"Barbican Centre\",\n \"seats\": \"50+\"\n },\n {\n \"can_take_calls\": false,\n \"coffee_price\": \"\\u00a32.80\",\n \"has_sockets\": true,\n \"has_toilet\": true,\n \"has_wifi\": true,\n \"id\": 13,\n \"img_url\": \"https://lh3.googleusercontent.com/p/AF1QipNJQIg-6YTOZhbLu12yGPN3klDxygs7cNAjEo0C=s0\",\n \"location\": \"Shoreditch\",\n \"map_url\": \"https://g.page/citizenm-london-shoreditch?share\",\n \"name\": \"Citizen M Hotel Shoreditch\",\n \"seats\": \"30-40\"\n },\n {\n \"can_take_calls\": true,\n \"coffee_price\": \"\\u00a32.40\",\n \"has_sockets\": true,\n \"has_toilet\": false,\n \"has_wifi\": true,\n \"id\": 21,\n \"img_url\": \"https://lh3.googleusercontent.com/p/AF1QipOhkJk2MBtFW1RydPU0zf3bf8upGkTQWyhDpXzZ=s0\",\n \"location\": \"Borough\",\n \"map_url\": \"https://g.page/fora---borough?share\",\n \"name\": \"FORA Borough\",\n \"seats\": \"20-30\"\n },\n {\n \"can_take_calls\": false,\n \"coffee_price\": \"\\u00a31.80\",\n \"has_sockets\": false,\n \"has_toilet\": false,\n \"has_wifi\": true,\n \"id\": 16,\n \"img_url\": \"https://lh3.googleusercontent.com/p/AF1QipOchpT9ipgb7tpqglcTKpp2E8kZhsKvlYjUZ4e1=s0\",\n \"location\": \"South Kensington\",\n \"map_url\": \"https://goo.gl/maps/GPFSEuGEiDvQG8BH7\",\n \"name\": \"Fernandez and Wells Exhibition Road\",\n \"seats\": \"10-20\"\n },\n {\n \"can_take_calls\": true,\n \"coffee_price\": \"\\u00a32.50\",\n \"has_sockets\": true,\n \"has_toilet\": true,\n \"has_wifi\": true,\n \"id\": 12,\n \"img_url\": \"https://lh3.googleusercontent.com/p/AF1QipPyJHFtVzxor4RyQrT-ZEk7ej7OxvmIQYZUHe6G=s0\",\n \"location\": \"Clerkenwell\",\n \"map_url\": \"https://goo.gl/maps/HC4e9FJL48kLRH8W9\",\n \"name\": \"Forage Cafe\",\n \"seats\": \"20-30\"\n },\n {\n \"can_take_calls\": false,\n \"coffee_price\": \"\\u00a32.65\",\n \"has_sockets\": true,\n \"has_toilet\": true,\n \"has_wifi\": true,\n \"id\": 5,\n \"img_url\": \"https://lh3.googleusercontent.com/p/AF1QipM9Dz_QMkOF2da1aNLuTzS_vPvVWBnE84rZLK_G=s0\",\n \"location\": \"Bermondsey\",\n \"map_url\": \"https://goo.gl/maps/ugP2B1AV7FELHSgn6\",\n \"name\": \"Fuckoffee Bermondsey\",\n \"seats\": \"20-30\"\n },\n {\n \"can_take_calls\": false,\n \"coffee_price\": \"\\u00a32.10\",\n \"has_sockets\": true,\n \"has_toilet\": true,\n \"has_wifi\": true,\n \"id\": 8,\n \"img_url\": \"https://lh3.googleusercontent.com/p/AF1QipPnOfo7wTICdiAyybF3iFhD3l5aoQjSO-GErma1=s0\",\n \"location\": \"Clerkenwell\",\n \"map_url\": \"https://goo.gl/maps/D9nXNYK3fa1cxwpK8\",\n \"name\": \"Goswell Road Coffee\",\n \"seats\": \"10-20\"\n },\n {\n \"can_take_calls\": false,\n \"coffee_price\": \"\\u00a32.80\",\n \"has_sockets\": true,\n \"has_toilet\": true,\n \"has_wifi\": true,\n \"id\": 6,\n \"img_url\": \"https://lh3.googleusercontent.com/p/AF1QipN-C650VmJ1XZhzOIBTg1bUu3_to_GHpyrmUplt=s0\",\n \"location\": \"Hackney\",\n \"map_url\": \"https://goo.gl/maps/DWnwaeeiwdYsBkEH9\",\n \"name\": \"Mare Street Market\",\n \"seats\": \"50+\"\n },\n {\n \"can_take_calls\": false,\n \"coffee_price\": \"\\u00a32.00\",\n \"has_sockets\": true,\n \"has_toilet\": false,\n \"has_wifi\": true,\n \"id\": 19,\n \"img_url\": \"https://www.nhm.ac.uk/content/dam/nhmwww/business-services/filming/Earth-Sciences-Library-1.jpg\",\n \"location\": \"South Kensington\",\n \"map_url\": \"https://goo.gl/maps/VU2PwnDDtH1WqCnK7\",\n \"name\": \"Natural History Museum Library\",\n \"seats\": \"40-50\"\n },\n {\n \"can_take_calls\": false,\n \"coffee_price\": \"\\u00a32.80\",\n \"has_sockets\": true,\n \"has_toilet\": false,\n \"has_wifi\": true,\n \"id\": 4,\n \"img_url\": \"https://lh3.googleusercontent.com/p/AF1QipPBAt6bYna7pv5c7e_PhCDPMKPb6oFf6kMT2VQ1=s0\",\n \"location\": \"Peckham\",\n \"map_url\": \"https://www.google.com/maps/place/Old+Spike+Roastery/@51.4651552,-0.0666088,17z/data=!4m12!1m6!3m5!1s0x487603a3a7dd838d:0x4105b39b30a737cf!2sOld+Spike+Roastery!8m2!3d51.4651552!4d-0.0666088!3m4!1s0x487603a3a7dd838d:0x4105b39b30a737cf!8m2!3d51.4651552!4d-0.0666088\",\n \"name\": \"Old Spike\",\n \"seats\": \"0-10\"\n },\n {\n \"can_take_calls\": false,\n \"coffee_price\": \"\\u00a32.75\",\n \"has_sockets\": true,\n \"has_toilet\": true,\n \"has_wifi\": true,\n \"id\": 3,\n \"img_url\": \"https://lh3.googleusercontent.com/p/AF1QipOMzXpKAQNyUvrjTGHqCgWk8spwnzwP8Ml2aDKt=s0\",\n \"location\": \"Peckham\",\n \"map_url\": \"https://g.page/one-all-cafe?share\",\n \"name\": \"One & All Cafe Peckham\",\n \"seats\": \"20-30\"\n },\n {\n \"can_take_calls\": true,\n \"coffee_price\": \"\\u00a32.40\",\n \"has_sockets\": true,\n \"has_toilet\": true,\n \"has_wifi\": false,\n \"id\": 1,\n \"img_url\": \"https://atlondonbridge.com/wp-content/uploads/2019/02/Pano_9758_9761-Edit-190918_LTS_Science_Gallery-Medium-Crop-V2.jpg\",\n \"location\": \"London Bridge\",\n \"map_url\": \"https://g.page/scigallerylon?share\",\n \"name\": \"Science Gallery London\",\n \"seats\": \"50+\"\n },\n {\n \"can_take_calls\": false,\n \"coffee_price\": \"\\u00a32.75\",\n \"has_sockets\": true,\n \"has_toilet\": true,\n \"has_wifi\": true,\n \"id\": 2,\n \"img_url\": \"https://images.squarespace-cdn.com/content/v1/5734f3ff4d088e2c5b08fe13/1555848382269-9F13FE1WQDNUUDQOAOXF/ke17ZwdGBToddI8pDm48kAeyi0pcxjZfLZiASAF9yCBZw-zPPgdn4jUwVcJE1ZvWQUxwkmyExglNqGp0IvTJZUJFbgE-7XRK3dMEBRBhUpzV8NE8s7067ZLWyi1jRvJklJnlBFEUyq1al9AqaQ7pI4DcRJq_Lf3JCtFMXgpPQyk/copeland-park-bar-peckham\",\n \"location\": \"Peckham\",\n \"map_url\": \"https://g.page/CopelandSocial?share\",\n \"name\": \"Social - Copeland Road\",\n \"seats\": \"20-30\"\n },\n {\n \"can_take_calls\": false,\n \"coffee_price\": \"\\u00a32.80\",\n \"has_sockets\": true,\n \"has_toilet\": false,\n \"has_wifi\": true,\n \"id\": 20,\n \"img_url\": \"https://lh3.googleusercontent.com/p/AF1QipNlBWFgXBiP9YjKARy4dgjHGePOmtsfuQPRwGvb=s0\",\n \"location\": \"Shoreditch\",\n \"map_url\": \"https://goo.gl/maps/gYX271NxyuawiMcK8\",\n \"name\": \"The Bike Shed\",\n \"seats\": \"10-20\"\n },\n {\n \"can_take_calls\": true,\n \"coffee_price\": \"\\u00a32.60\",\n \"has_sockets\": true,\n \"has_toilet\": false,\n \"has_wifi\": true,\n \"id\": 18,\n \"img_url\": \"https://lh3.googleusercontent.com/p/AF1QipOutkI7wjWNXiPSTdf8CX0jXwyVHFTwFnVhyVJE=s0\",\n \"location\": \"Peckham\",\n \"map_url\": \"https://goo.gl/maps/qpcpX7MWhFSS1qxH9\",\n \"name\": \"The Peckham Pelican\",\n \"seats\": \"0 - 10\"\n },\n {\n \"can_take_calls\": false,\n \"coffee_price\": \"\\u00a32.60\",\n \"has_sockets\": false,\n \"has_toilet\": true,\n \"has_wifi\": true,\n \"id\": 15,\n \"img_url\": \"https://lh3.googleusercontent.com/p/AF1QipOL6jxxpE_D3YS-Zzih61DqNXJKvRIDFiP6ieUI=s0\",\n \"location\": \"Clerkenwell\",\n \"map_url\": \"https://goo.gl/maps/mwAG272nQwSUc9bn8\",\n \"name\": \"The Slaughtered Lamb\",\n \"seats\": \"20-30\"\n },\n {\n \"can_take_calls\": true,\n \"coffee_price\": \"\\u00a32.30\",\n \"has_sockets\": true,\n \"has_toilet\": true,\n \"has_wifi\": true,\n \"id\": 9,\n \"img_url\": \"https://lh3.googleusercontent.com/p/AF1QipMrdTyRRozGBltwxAseQ4QeuNhbED6meQXlCPsx=s0\",\n \"location\": \"London Bridge\",\n \"map_url\": \"https://goo.gl/maps/LU1imQzBCRLFBxKUA\",\n \"name\": \"The Southwark Cathedral Cafe\",\n \"seats\": \"20-30\"\n },\n {\n \"can_take_calls\": true,\n \"coffee_price\": \"\\u00a32.70\",\n \"has_sockets\": false,\n \"has_toilet\": true,\n \"has_wifi\": true,\n \"id\": 11,\n \"img_url\": \"https://lh3.googleusercontent.com/p/AF1QipOFimpFQmUORVGg0ER3lrfEiEnKpnYJck5guFqC=s0\",\n \"location\": \"Bankside\",\n \"map_url\": \"https://goo.gl/maps/6RvPHyhsDDUPs1ox8\",\n \"name\": \"The Tate Modern Cafe\",\n \"seats\": \"30-40\"\n },\n {\n \"can_take_calls\": false,\n \"coffee_price\": \"\\u00a32.70\",\n \"has_sockets\": false,\n \"has_toilet\": true,\n \"has_wifi\": true,\n \"id\": 10,\n \"img_url\": \"https://lh3.googleusercontent.com/p/AF1QipNtHqqIc3kwhpjknrVcMdkhmpA77LDYKmpOJlxf=s0\",\n \"location\": \"Whitechapel\",\n \"map_url\": \"https://goo.gl/maps/v5tzRBVhPFueYp4x6\",\n \"name\": \"Trade Commercial Road\",\n \"seats\": \"20-30\"\n },\n {\n \"can_take_calls\": true,\n \"coffee_price\": \"\\u00a32.60\",\n \"has_sockets\": true,\n \"has_toilet\": false,\n \"has_wifi\": true,\n \"id\": 17,\n \"img_url\": \"https://lh3.googleusercontent.com/p/AF1QipOZ3WDAAxphLu657afVVATJ5TGxtturIOr8gt8u=s0\",\n \"location\": \"Whitechapel\",\n \"map_url\": \"https://goo.gl/maps/xv29seioiETAAZgN9\",\n \"name\": \"Whitechapel Grind\",\n \"seats\": \"30-40\"\n }\n ]\n}"}],"_postman_id":"e79d4bae-b55e-4bb6-9296-44d532fe8c37"},{"name":"Get random cafe","id":"48871c11-6f70-44ba-9d36-fa8c37c859d5","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"https://cafe-and-wifi.vercel.app/random","description":"This endpoint returns a randomly selected cafe from the database. It retrieves all cafes and randomly chooses one, sending back its information in JSON format.
\n","urlObject":{"protocol":"https","path":["random"],"host":["cafe-and-wifi","vercel","app"],"query":[],"variable":[]}},"response":[{"id":"50851917-be48-4d04-a8f7-4d66e6f63771","name":"Get random cafe","originalRequest":{"method":"GET","header":[],"url":"https://cafe-and-wifi.vercel.app/random"},"_postman_previewlanguage":"json","header":[{"key":"Content-Type","value":"application/json","description":"","type":"text"}],"cookie":[],"responseTime":null,"body":"{\n \"cafe\": {\n \"can_take_calls\": false,\n \"coffee_price\": \"\\u00a33.00\",\n \"has_sockets\": true,\n \"has_toilet\": true,\n \"has_wifi\": true,\n \"id\": 7,\n \"img_url\": \"https://lh3.googleusercontent.com/p/AF1QipP_NbZH7A1fIQyp5pRm1jOGwzKsDWewaxka6vDt=s0\",\n \"location\": \"Shoreditch\",\n \"map_url\": \"https://g.page/acehotellondon?share\",\n \"name\": \"Ace Hotel Shoreditch\",\n \"seats\": \"50+\"\n }\n}"}],"_postman_id":"48871c11-6f70-44ba-9d36-fa8c37c859d5"},{"name":"Search cafes by location","id":"8b8b1fe9-feb8-4442-8b7f-597567d9a092","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"https://cafe-and-wifi.vercel.app/search/?loc=city","description":"This endpoint allows users to search for cafes based on a specified location. It retrieves all cafes that match the provided location and returns the information in JSON format.
\nUse the loc parameter to pass a location name.
\n","urlObject":{"protocol":"https","path":["search",""],"host":["cafe-and-wifi","vercel","app"],"query":[{"key":"loc","value":"city"}],"variable":[]}},"response":[{"id":"ecb82f55-ee2c-47e5-b14b-3a2b0e7eb3b4","name":"Search cafes by location","originalRequest":{"method":"GET","header":[],"url":{"raw":"https://cafe-and-wifi.vercel.app/search/?loc=Bermondsey","protocol":"https","host":["cafe-and-wifi","vercel","app"],"path":["search",""],"query":[{"key":"loc","value":"Bermondsey"}]}},"_postman_previewlanguage":"json","header":[{"key":"Content-Type","value":"application/json","description":"","type":"text"}],"cookie":[],"responseTime":null,"body":"{\n \"cafes\": [\n {\n \"can_take_calls\": false,\n \"coffee_price\": \"\\u00a32.65\",\n \"has_sockets\": true,\n \"has_toilet\": true,\n \"has_wifi\": true,\n \"id\": 5,\n \"img_url\": \"https://lh3.googleusercontent.com/p/AF1QipM9Dz_QMkOF2da1aNLuTzS_vPvVWBnE84rZLK_G=s0\",\n \"location\": \"Bermondsey\",\n \"map_url\": \"https://goo.gl/maps/ugP2B1AV7FELHSgn6\",\n \"name\": \"Fuckoffee Bermondsey\",\n \"seats\": \"20-30\"\n }\n ]\n}"}],"_postman_id":"8b8b1fe9-feb8-4442-8b7f-597567d9a092"},{"name":"Add cafe","id":"9b82e604-d234-4b6e-974b-3b6b36725093","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"formdata","formdata":[{"key":"name","value":"cafe name","type":"text","id":0},{"key":"map_url","value":"google maps url","type":"text","id":1},{"key":"img_url","value":"image url","type":"text","id":2},{"key":"location","value":"city","type":"text","id":3},{"key":"seats","value":"how many seats","type":"text","id":4},{"key":"has_toilet","value":"True or False","type":"text","id":5},{"key":"has_wifi","value":"True or False","type":"text","id":6},{"key":"has_sockets","value":"True or False","type":"text","id":7},{"key":"can_take_calls","value":"True or False","type":"text","id":8},{"key":"coffee_price","value":"£","type":"text","id":9}]},"url":"https://cafe-and-wifi.vercel.app/add","description":"This endpoint allows users to add a new cafe to the database. Before adding the cafe, it checks if a cafe with the same name already exists. If a cafe with that name is found, an error message is returned. Otherwise, the new cafe is added to the database.
\n","urlObject":{"protocol":"https","path":["add"],"host":["cafe-and-wifi","vercel","app"],"query":[],"variable":[]}},"response":[{"id":"73ab06b2-0fd2-4f55-9dbf-ea648722a316","name":"Add cafe","originalRequest":{"method":"POST","header":[],"body":{"mode":"formdata","formdata":[{"key":"name","value":"Starbucks","type":"text","id":0},{"key":"map_url","value":"https://www.google.no/maps/place/Starbucks/@63.4306233,10.3944862,17z/data=!3m1!4b1!4m6!3m5!1s0x466d319bb323095b:0x7ae33518d153f841!8m2!3d63.4306233!4d10.3970611!16s%2Fg%2F1pxwrr12r?entry=ttu&g_ep=EgoyMDI1MDExMC4wIKXMDSoASAFQAw%3D%3D","type":"text","id":1},{"key":"img_url","value":"https://lh5.googleusercontent.com/p/AF1QipO6oU_ot58quJDvPAj45NuTKA7W-IAWXYMWCn0O=w408-h272-k-no","type":"text","id":2},{"key":"location","value":"Trondheim","type":"text","id":3},{"key":"seats","value":"20+","type":"text","id":4},{"key":"has_toilet","value":"True","type":"text","id":5},{"key":"has_wifi","value":"True","type":"text","id":6},{"key":"has_sockets","value":"False","type":"text","id":7},{"key":"can_take_calls","value":"True","type":"text","id":8},{"key":"coffee_price","value":"£4","type":"text","id":9}]},"url":"https://cafe-and-wifi.vercel.app/add"},"status":"Created","code":201,"_postman_previewlanguage":"JSON","header":null,"cookie":[],"responseTime":null,"body":"{\n\"success\": \"Successfully added the new cafe.\"\n}"},{"id":"b74dc37b-db73-47a4-9562-d8c6a53b2f16","name":"Add cafe error","originalRequest":{"method":"POST","header":[],"body":{"mode":"formdata","formdata":[{"key":"name","value":"Starbucks","type":"text","id":0},{"key":"map_url","value":"https://www.google.no/maps/place/Starbucks/@63.4306233,10.3944862,17z/data=!3m1!4b1!4m6!3m5!1s0x466d319bb323095b:0x7ae33518d153f841!8m2!3d63.4306233!4d10.3970611!16s%2Fg%2F1pxwrr12r?entry=ttu&g_ep=EgoyMDI1MDExMC4wIKXMDSoASAFQAw%3D%3D","type":"text","id":1},{"key":"img_url","value":"https://lh5.googleusercontent.com/p/AF1QipO6oU_ot58quJDvPAj45NuTKA7W-IAWXYMWCn0O=w408-h272-k-no","type":"text","id":2},{"key":"location","value":"Trondheim","type":"text","id":3},{"key":"seats","value":"20+","type":"text","id":4},{"key":"has_toilet","value":"True","type":"text","id":5},{"key":"has_wifi","value":"True","type":"text","id":6},{"key":"has_sockets","value":"False","type":"text","id":7},{"key":"can_take_calls","value":"True","type":"text","id":8},{"key":"coffee_price","value":"£4","type":"text","id":9}]},"url":"https://cafe-and-wifi.vercel.app/add"},"status":"Bad Request","code":400,"_postman_previewlanguage":"JSON","header":null,"cookie":[],"responseTime":null,"body":"{\n\"error\": {\n \"message\": \"A cafe with this name already exists.\"\n}\n}"}],"_postman_id":"9b82e604-d234-4b6e-974b-3b6b36725093"},{"name":"Update coffee price","id":"3763902f-237d-4ee4-914d-1154096ab0e2","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"PATCH","header":[],"url":"https://cafe-and-wifi.vercel.app/update/This endpoint allows users to update the coffee price of a specific cafe identified by its cafe_id. The new coffee price is passed as a query parameter. If a cafe with the specified ID exists, its coffee price will be updated; otherwise, a 404 Not Found error will be returned.
\n","urlObject":{"protocol":"https","path":["update","This endpoint allows users to delete a cafe entry from the database using its unique identifier, cafe_id.
\n","urlObject":{"protocol":"https","path":["delete","