obviyus / superseriousbot Goto Github PK

• Generate a changelog between releases automatically
• Send the changelog to a channel with every release

Potential additions:

• all commands present in master
• installation instructions
• deployment guide

• /store allows the user to send an object in DM (video, photo, audio) with a caption
• /read allows any other user to retrieve by a caption search
• optionally add votes in a later update

Dependabot couldn't authenticate with https://pypi.python.org/simple/.

You can provide authentication details in your Dependabot dashboard by clicking into the account menu (in the top right) and selecting 'Config variables'.

View the update logs.

Checking the logs says:

File "/usr/local/lib/python3.8/site-packages/mysql/connector/connection_cext.py", line 508, in cmd_query
    raise errors.get_mysql_exception(exc.errno, msg=exc.msg,
mysql.connector.errors.DatabaseError: 2006 (HY000): MySQL server has gone away

Seems to be a timeout issue. Most likely because we make just one connection when the container starts and keep it running. Possible causes: https://stackoverflow.com/a/12444282/11940280

the search function returns NoneType, probably some changes on HLTB's side

• youtube_dl seems to be unmaintained and doesn't work for YT Shorts
• yt-dlp should help with age/geo restrictions

Once stats is merged, add a send message to clear().

i.e. right before the bot clears daily stats, it sends the day's stats.

• Also see if Reddit gallery images can be loaded (e.g. this doesn't work: https://www.reddit.com/gallery/pdaypi)

Preliminary testing shows 14x reduction in image size:

cmd=build info=results status='MINIFIED' by='14.26X' size.original='454 MB' size.optimized='32 MB'

QoL change: if context.args is empty, check for args in message.reply_to_message.

Everyday right before clearing the day's stats, record the Total Messages for the group. Goal is to see the number of messages vs. days.

the tables are pretty scattered at the moment, we need to consolidate them into a single database and maintain some form of easy reference for them