Migrate database to clean up structure & rewrite database calls to match

Edit the structure

• CODE => NAME
• TITLE
• INFO
• ROLE_NAME
• CHANNEL_NAME
• ROLE_ID
• CHANNEL_ID
• UUID
• + DUPE
• + ACTIVE

This amounts to:

• Removing UUID, ROLE_NAME and CHANNEL_NAME.
• Cleaning up CODE and replacing it with NAME.
• Adding the DUPE field to signify if a class is a duplicate.
• Adding ACTIVE to specify if the course is being offered that semester. (Currently, all classes are considered active.)

Steps to migrate database and discord server

Run migrateDb command to migrate the database
Run CreateChannels command to update channel names from the database
Run CreateRoles command to update role names from the database

Link to github cards

#33
#35
#49
#50

Additions

• Add a helper function to create embeds
• Add migrateDB command to update the database to the new schema, update how duplicate codes are handled, and clean all strings.
• Add modified JS Docs to function. (Types are not added since this is specified in function definitions with typescript)

Changes

• Change db scheme
• Change role and channel db calls to reflect changes
• Change how duplicate classes are handled
• Use course title and info in channel topics

Bugfix

• replace all contiguous whitespace with a dash instead of replacing spaces with a dash
• Replace contiguous dashes with a dash in ROLE_NAME and CHANNEL_NAME
• Trim leading and trailing whitespace from TITLE
• Limit role name and channel name to 100 characters each
• Limit channel topic to 1024 characters each
• Only reply to role selection if role is actually assigned
• Add bottleneck package to limit the bot to 50 API calls per second
• Prefers matching on channel ID's rather than names