/Cavisto

Personal wine assistant as a telegram bot.

Primary LanguageScala

Cavisto

Scala CI codecov
Telegram bot for saving and advising wine

Plan:

  1. Extract data about vines

    • For example, vivino.com is a good data source, but it requires data parsing for search. For example, search request for wine Baron d'Arignac. 
      > curl https://www.vivino.com/search/wines\?q\=baron%20d

<span class='header-smaller text-block wine-card__name'>
<a class="link-color-alt-grey" data-cartitemsource="text-search" href="/wines/1474107"><span class='bold'>
<mark>Baron</mark> <mark>d</mark>'Arignac Vin Rouge
</span>
    • Get data about countries 
      > curl https://www.vivino.com/api/countries
    • Get wine suggestions, for example wines of France with min rating and price range. Just what I want. 
      > curl 'https://www.vivino.com/api/explore/explore?country_code=FR&currency_code=EUR&min_rating=3&price_range_mix=7&price_range_max=20&order_by=price&order=asc'
"https://www.vivino.com/api/explore/explore",
params = {
    "country_code": "FR",
    "country_codes[]":"pt",
    "currency_code":"EUR",
    "grape_filter":"varietal",
    "min_rating":"1",
    "order_by":"price",
    "order":"asc",
    "page": 1,
    "price_range_max":"500",
    "price_range_min":"0",
    "wine_type_ids[]":"1"
},

  2. Setup database and write controllers for CRUD operations

  3. Add telegram bot interaction

    • Save user info to Postgres db
    • Save user wines (formalize name using vivino api), support photo uploading
    • Add '/advise' command with parameters, suggest user preferences based on saved vines
    • Add '/top' command to get most popular wines among users (Optional)
    • Add '/note' command for writing user's personal note about wine
    • Add '/search' command to search wines by name
    • Add '/notes' command to get all user's notes

TODO:

  • Init project
  • Write code for parsing vivino.com
  • Setup database with docker-compose and connect to it
  • Write functions for db usage
  • Integrate with telegram
    • Implement '/advise' command
    • Implement '/note' command
    • Implement '/search' command
    • Implement '/notes' command

Commands' showcase:

  • /start

  • /help

  • /advise

    • Country button
    • Type button
    • Food pairing button
    • Grape button
    • Price buttons
    • Advise button
    • Next button

  • /note

    • Edit wine name button
    • Edit Rating button
    • Edit Review button
    • Save button

  • /notes

    • User's list of notes is empty
    • User's list of notes is not empty (max 10 on page)

    • 10 button click (You can edit note)

  • /search cabernet