Split the single twitch table into two tables: twitch_channels and twitch_notifications.
twitch_channels contains a unique entry for each Twitch.tv channel monitored by KeshBotics.
twitch_notifications contains twitch_user_id's matched with discord_channel_id's. This is used to determine where notifications should be sent.
Updated DB Schemas (GIT repo)
Added column for discord_guild_id in twitch_notifications
Removed some stream metrics integrations (pending rework)
Modifications to support new database schemas
Settings Changed 'oauth_token' to 'twitch_oauth_token'
In the settings table, changed the key 'oauth_token' to 'twitch_oauth_token'.
Updated SQL queries to reflect this change.
Changed variable naming in twitch_managment for oauth_token.
Added Discord Guild ID to YouTube Table
Added column disc_guild_id to the youtube table.
Updated command and API functions to reflect this change.
YouTube "/c/" Type URL Conversion Error
Fixed bug in "youtube_channel_id.py" - "custom_url_to_channel_id"
Error: "TypeError: the JSON object must be str, not 'bytes'"
Experienced when attempting to convert "/c/" type urls.
Tested a version of keshbotics3 from Decemeber 2020, and recieved the same error, however, I recall it working around that time period. GIT logs don't show anything meaningful changed in this function. Difficult to pinpoint what caused this error to spring up.
Split the single
twitchtable into two tables:twitch_channelsandtwitch_notifications.twitch_channelscontains a unique entry for each Twitch.tv channel monitored by KeshBotics.twitch_notificationscontains twitch_user_id's matched with discord_channel_id's. This is used to determine where notifications should be sent.Updated DB Schemas (GIT repo)
Added column for
discord_guild_idintwitch_notificationsRemoved some stream metrics integrations (pending rework)
Modifications to support new database schemas
Settings Changed 'oauth_token' to 'twitch_oauth_token'
settingstable, changed the key 'oauth_token' to 'twitch_oauth_token'.Added Discord Guild ID to YouTube Table
disc_guild_idto theyoutubetable.YouTube "/c/" Type URL Conversion Error Fixed bug in "youtube_channel_id.py" - "custom_url_to_channel_id" Error: "TypeError: the JSON object must be str, not 'bytes'" Experienced when attempting to convert "/c/" type urls.
Tested a version of keshbotics3 from Decemeber 2020, and recieved the same error, however, I recall it working around that time period. GIT logs don't show anything meaningful changed in this function. Difficult to pinpoint what caused this error to spring up.