mikaelsiidorow / kipubot

Graphs for Friday bottle raffles.

Kipu Grapher 🍌

Telegram bot to graph friday bottle raffle progress. Currently supports graphing the raffle pool and expected values 📣

Getting Started

Add the bot on Telegram into your group and enjoy!

Watch the chart climb as you reach the raffle end date! 📈

Descend into sadness when every entry is the minimum amount and the expected value stays zero 😔

Developing KipuBot

Docker (Recommended)

1. Set PYTHONPATH=${PYTHONPATH}:kipubot in .env
2. Set BOT_TOKEN in .env
3. docker-compose -f docker-compose.dev.yml up

Pipenv

Using pipenv:

1. Set PYTHONPATH=${PYTHONPATH}:kipubot in .env
2. Set BOT_TOKEN in .env
3. Set DATABASE_URL in .env
4. pipenv install --dev
5. pipenv run dev

kipubot's Issues

[FEAT] Draw grid in graph plot

[FEAT] Make group-based commands usable in DMs -> you have to select channel

[FEAT] Implement /odotusarvo graph to plot expected value on entry

[FIX] Validate received excel formatting

[FIX] Verify end_date is actually later than start_date

[FEAT] Add historical data

Possible ideas:

• /week
  • display past week winners and pools
• /month
  • display days with biggest pools during the past month and winners (mby top3?)
• /alltime
  • display all time biggest pools and winners (n amount)

Pre-requisites for above commands:

• store previous raffles in database
  • mby add ended boolean?
  • or just use end dates?
  • --> raffles need own id and can't use chat_id as pk

[FIX] Update /winner to check user_id instead of naively accepting username

[FEAT] Save excel data to database on raffle setup --> use saved data to draw graphs instead of .xlsx file