{"id":230,"date":"2021-01-01T21:33:41","date_gmt":"2021-01-01T20:33:41","guid":{"rendered":"https:\/\/www.davidestebanmunoz.com\/?p=230"},"modified":"2021-12-30T21:38:09","modified_gmt":"2021-12-30T20:38:09","slug":"wc-bilbao-telegram-bot-2","status":"publish","type":"post","link":"https:\/\/www.davidestebanmunoz.com\/?p=230&lang=es","title":{"rendered":"WC Bilbao Telegram Bot"},"content":{"rendered":"\n<p><a href=\"https:\/\/www.davidestebanmunoz.com\/?p=227\">This article can be read in english here<\/a><br>Este bot de telegram es accesible en <a href=\"http:\/\/t.me\/aseosbilbao_bot\">http:\/\/t.me\/aseosbilbao_bot<\/a><\/p>\n\n\n\n<p>Este bot se cre\u00f3 durante la pandemia de COVID19. Los bares y restaurantes fueron cerrados por el gobierno en Euskadi varias veces y si necesitabas ir a un WC urgentemente, no pod\u00edas hacer uso de los establecimientos hosteleros.<\/p>\n\n\n\n<p>El objetivo de este bot es tener los 3 WC publicos m\u00e1s cercanos a tu ubicaci\u00f3n. Asimismo, dado que es realmente simple, su c\u00f3digo puede servir como ejemplo para desarrollar otros bots de telegram en  python.<\/p>\n\n\n\n<p>La interacci\u00f3n con el usuario est\u00e1 basada en comandos de Telegram, el usuario le manda el comando \/aseo y el bot le ofrece mandarle la ubicaci\u00f3n. Finalmente el bot te manda la ubicaci\u00f3n de los 3 WCs m\u00e1s cercanos.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"489\" height=\"299\" src=\"https:\/\/www.davidestebanmunoz.com\/wp-content\/uploads\/2021\/12\/imagen-5.png\" alt=\"\" class=\"wp-image-228\" srcset=\"https:\/\/www.davidestebanmunoz.com\/wp-content\/uploads\/2021\/12\/imagen-5.png 489w, https:\/\/www.davidestebanmunoz.com\/wp-content\/uploads\/2021\/12\/imagen-5-300x183.png 300w\" sizes=\"auto, (max-width: 489px) 100vw, 489px\" \/><\/figure>\n\n\n\n<p>Su arquitectura est\u00e1 formada simplemente por un contenedor MariaDB y un contenedor Python<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"187\" src=\"https:\/\/www.davidestebanmunoz.com\/wp-content\/uploads\/2021\/12\/telegram_bot.drawio-300x187.png\" alt=\"\" class=\"wp-image-196\" srcset=\"https:\/\/www.davidestebanmunoz.com\/wp-content\/uploads\/2021\/12\/telegram_bot.drawio-300x187.png 300w, https:\/\/www.davidestebanmunoz.com\/wp-content\/uploads\/2021\/12\/telegram_bot.drawio.png 451w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/figure>\n\n\n\n<p>Se ha usado la libreria pyTelegramBotAPI para recoger las peticiones de telegram y una BBDD MariaDB para guardar las coordenadas de los WC y los nombres.<\/p>\n\n\n\n<p>El c\u00f3digo completo tanto del docker-compose como de la propia aplicaci\u00f3n est\u00e1n disponibles en <a href=\"https:\/\/github.com\/botmakerdvd\/wcbilbao_bot\">https:\/\/github.com\/botmakerdvd\/wcbilbao_bot<\/a><\/p>\n\n\n\n<p>Asimismo se incluye el script <a href=\"https:\/\/github.com\/botmakerdvd\/wcbilbao_bot\/blob\/master\/data\/handler\/import_wc_bilbao.py\">import_wc_bilbao.py<\/a> que lee los WC publicados por <a href=\"https:\/\/www.bilbao.eus\/Bilbaonet\/kml\/aseos_publicos.kml\">bilbao.eus<\/a>  y actualiza la BBDD.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Tipo: Bot Telegram<\/li><li>Ubicaci\u00f3n: Docker containers en VPS<\/li><li>Lenguajes and tecnologias usados: Python, MySQL<\/li><li>Github repo: si<\/li><\/ul>\n","protected":false},"excerpt":{"rendered":"<div class=\"more-link-wrapper\"><a class=\"more-link\" href=\"https:\/\/www.davidestebanmunoz.com\/?p=230&#038;lang=es\">Read More<span class=\"screen-reader-text\">WC Bilbao Telegram Bot<\/span><\/a><\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[25,67,69],"class_list":["post-230","post","type-post","status-publish","format-standard","hentry","category-proyectos-personales","tag-docker","tag-python-es","tag-sql-es","excerpt"],"_links":{"self":[{"href":"https:\/\/www.davidestebanmunoz.com\/index.php?rest_route=\/wp\/v2\/posts\/230","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.davidestebanmunoz.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.davidestebanmunoz.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.davidestebanmunoz.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.davidestebanmunoz.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=230"}],"version-history":[{"count":1,"href":"https:\/\/www.davidestebanmunoz.com\/index.php?rest_route=\/wp\/v2\/posts\/230\/revisions"}],"predecessor-version":[{"id":231,"href":"https:\/\/www.davidestebanmunoz.com\/index.php?rest_route=\/wp\/v2\/posts\/230\/revisions\/231"}],"wp:attachment":[{"href":"https:\/\/www.davidestebanmunoz.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=230"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.davidestebanmunoz.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=230"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.davidestebanmunoz.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=230"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}