packetfire / apophis Goto Github PK

!qdb - quote database command

Implement pagination for music list with limit of 10 results.

Delete a song from a table and its corresponding audio file if it exists.

• Use a connection pool.
• Only acquire one database connection per message.

• postgres 11

Quart

For some of our configuration, we do something like the following:

bot_token = os.environ.get('BOT_TOKEN', config['bot_token'])

This throws an exception if bot_token isn't defined in the dictionary. We should rewrite these to only check config if the environmental variable isn't defined.

add separate file for list of emoji definitions

Define a configuration helper that can pull configuration values from environmental variables or files.

Currently, README.md lacks details about installation, configuration, running, and limitations of the project.
It would be nice to have a updated README.md detailing those steps.

shorten command to communicate with pfurl.me for shortened urls

Songs are being saved as mp3 files, so the bot is having to transcode from mp3 to opus on the fly. If we transcode to opus on download, we can avoid that expensive step during playback.

!theo - output random theo de raadt quotes
!qdb - quote database
!define - urban dictionary

Play any random song. can be separate from shuffling

This command will be used to organize our songs and relay them to rythm bot.

Acceptance criteria:

• When the bot is issued an !uptime command, it should print the amount of time it has been up.

Acceptance criteria:

• Users can enqueue songs to the music queue via a queue or qlucky command
• Users can view the queue
• Users can remove songs in the queue at a specified index

It might be a good idea to make this a command with multiple subcommands.

!define - urban dictionary definitions command

Need to setup a permissions module for user access.

Access levels
owner - ability to access all commands
admin - access admin level only commands
normal - all other normal commands for normal users

Acceptance criteria:

• The song should play the next queued song, or if one doesn't exist, the next song in the shuffle sequence.
• When a song finishes playing, automatically start playing the next one.

Acceptance criteria:

• When there is no song playing (that was explicitly asked for by a user), start playing a random song.
• Any song should never repeat until every other song has been played.
• A user can shuffle via a command.

Should the bot ever implicitly reshuffle?

Acceptance criteria:

• Every message should be logged. Relevant information includes: content, author, server, channel, time (both Discord time and receive time could be good)

Should edits and deletions be tracked?

• Flyway

any other alternatives?

Acceptance criteria:

• The database record for a song should indicate how many times it has been played.

!theo - output random theo de raadt quotes

Acceptance criteria:

• We can set a maximum duration via configuration.
• Any attempt to download a song longer than the specified maximum duration is rejected.

In both the songs and permissions tables, we are identifying a Discord user via their username. This can potentially fail in distinguishing two users: it is entirely possible that two Discord users share the same username (remember not pacifico?). It is also insufficient to use both the username and the user number, both these values can be changed at the discretion of a user.

The only field that distinguishes any two users is their Discord user ID, which is accessible in discord.py via message.author.id. It looks something like 327973168934463462. It is a very large number, but its also safe for us to save this as a string in postgres.

We should use the Discord user ID instead of the username/number to identify users.

should let us deploy apophis by running it alongside a pg container

Loading PCM-encoded audio streams gives us the ability to manipulate volume on the fly

https://anidiots.guide/first-bot/using-embeds-in-messages