cudatuda/CocktailBot

Bot for searching cocktails by their names, ingredients and tags 🍹

Cocktail Telegram bot

Link

Bot for searching cocktails by their names, ingredients and tags.

---

NOTE! Only Russian language is supported.

How bot works

The bot suggest you to choose search method:

• by name ( e.g маргарита ):
  Bot will search cocktail by its name ( levenshtein distance is used for fuzzy search )
• by ingredients ( e.g. джин, содовая):
  Bot will search cocktail by ingredients, separated by comma
• by tags ( e.g. шоты, цитрусовые):
  Bot will search cocktail by tags, separated by comma

How database works

One-to-many relationship ( cocktail - ingredient, cocktail - tag ).
There are 3 tables:

cocktail

Example:

id	name	ingredient_names	tag_names	recipe
1	дайкири	белый ром,сахарный сироп,лаймовый сок,лед в кубиках	крепкие/кислые/цитрусовые/на роме/классика	1. Налей в шейкер лаймовый сок 30 мл, сахарный сироп 15 мл и белый ром 60 мл 2. Наполни шейкер кубиками льда и взбей 3. Перелей через стрейнер в охлажденное шампанское блюдце

NOTE! See temporary workaround for details.

ingredient

Example:

id	name	amount	unit	🔑 cocktail_id	🔑 cocktail_name
1	белый ром	60	мл	1	дайкири
2	сахарный сироп	15	мл	1	дайкири

tag

Example:

id	name	🔑 cocktail_id	🔑 cocktail_name
1	крепкие	1	дайкири
2	классика	1	дайкири

Parser

Parser will parse one url, which contains all cocktails. Then all cocktail data will be parsed and saved to database.

Getting Started

Prerequisites

• Java 11 or higher

Installing

Simple clone this repository :)

Configuring

Database

Configure application.properties
spring.datasource.url - url to your PostgreSQL database
spring.datasource.username - database username
spring.datasource.password - database password

Also, you need to install fuzzystrmatch extension to PostgreSQL database:
simple execute query: CREATE EXTENSION fuzzystrmatch;

Parser

Configure parser.properties
NOTE! Only one site is supported, so there is no need to configure parser manually.
domain - main url
fullCocktailLink - url, which contains all cocktails.

Bot

Configure bot.properties
token - your Telegram bot token
username - your Telegram bot username

Usage

Run program

cd into cloned repo and run program by
mvn spring-boot:run

Update database

There is REST controller with updateCocktailDb mapping for database update.
So you can run curl <ip>:<port>/updateCocktailDb to update db.

Built using

• OpenJDK 11
• Maven
• Spring Data JPA
• Spring Boot
• PostgreSQL
• Telegram Bot Java Library
• Jsoup

Workarounds

This project is still under development, so there are some temporary workarounds, which should be fixed in the future.

Redundant columns for tags and ingredients

There are columns tag_names and ingredient_names in the cocktail table, while there are separate tables for tags and ingredients.

By this way I am able to search cocktails by substring with multiple ingredients or tags.

Way to fix:
Select cocktail from ingredient table or tag table, that contains all ingredients or tags from user input (use substring search for each element)