30 Minutes notification message

[Goltred]

This PR includes the logic related to sending the 30 minutes notification message on configured channels. This includes:

• Some refactoring of the existing message functions so that they are reusable by other pieces of the bot.
• Implementation of a simple sqlite local database to record ops that have been notified so that we don't send multiple notifications for the same thing (only for 30 minutes notif right now)

@PatrickPedersen - I'm going to need some help completing those models that we need to get user and game information since i don't know the structure of the xenforo db :)

[thebwc-sonarqube[bot]]

• 53 New Issues (is greater than 0)
• 0.00% Coverage on New Code (is less than 80.00%)

Analysis Details

53 Issues

• 1 Bug
• 0 Vulnerabilities
• 52 Code Smells

Coverage and Duplications

• 0.00% Coverage (0.00% Estimated after merge)
• 0.00% Duplicated Code (0.00% Estimated after merge)

Project ID: THE-BWC_DiscordOperationsBot_AY3xt-Bgmgcb4U3BetPR

View in SonarQube

[PatrickPedersen]

@Goltred If you look at these queries, you should be able to get some, if not all of the way there: https://github.com/THE-BWC/Discord_OpServBot/blob/main/models/xenforo/xenProvider.js

Otherwise, I'll look at it later when I have more time.

[Goltred]

Yeah, no worries there's no pressure for this.

The queries do help but we might still run into issues it peewee doesn't like that I might be missing some fields in the model.

[thebwc-sonarqube[bot]]

• 53 New Issues (is greater than 0)
• 0.00% Coverage on New Code (is less than 80.00%)

Analysis Details

53 Issues

• 0 Bugs
• 0 Vulnerabilities
• 53 Code Smells

Coverage and Duplications

• 0.00% Coverage (0.00% Estimated after merge)
• 0.00% Duplicated Code (0.00% Estimated after merge)

Project ID: THE-BWC_DiscordOperationsBot_AY3xt-Bgmgcb4U3BetPR

View in SonarQube

[thebwc-sonarqube[bot]]

• 53 New Issues (is greater than 0)
• 0.00% Coverage on New Code (is less than 80.00%)

Analysis Details

53 Issues

• 0 Bugs
• 0 Vulnerabilities
• 53 Code Smells

Coverage and Duplications

• 0.00% Coverage (0.00% Estimated after merge)
• 0.00% Duplicated Code (0.00% Estimated after merge)

Project ID: THE-BWC_DiscordOperationsBot_AY3xt-Bgmgcb4U3BetPR

View in SonarQube

[thebwc-sonarqube[bot]]

• 42 New Issues (is greater than 0)
• 0.00% Coverage on New Code (is less than 80.00%)

Analysis Details

42 Issues

• 0 Bugs
• 0 Vulnerabilities
• 42 Code Smells

Coverage and Duplications

• 0.00% Coverage (0.00% Estimated after merge)
• 0.00% Duplicated Code (0.00% Estimated after merge)

Project ID: THE-BWC_DiscordOperationsBot_AY3xt-Bgmgcb4U3BetPR

View in SonarQube

[thebwc-sonarqube[bot]]

• 29 New Issues (is greater than 0)
• 0.00% Coverage on New Code (is less than 80.00%)

Analysis Details

29 Issues

• 0 Bugs
• 0 Vulnerabilities
• 29 Code Smells

Coverage and Duplications

• 0.00% Coverage (0.00% Estimated after merge)
• 0.00% Duplicated Code (0.00% Estimated after merge)

Project ID: THE-BWC_DiscordOperationsBot_AY3xt-Bgmgcb4U3BetPR

View in SonarQube

[thebwc-sonarqube[bot]]

• 29 New Issues (is greater than 0)
• 0.00% Coverage on New Code (is less than 80.00%)

Analysis Details

29 Issues

• 0 Bugs
• 0 Vulnerabilities
• 29 Code Smells

Coverage and Duplications

• 0.00% Coverage (0.00% Estimated after merge)
• 0.00% Duplicated Code (0.00% Estimated after merge)

Project ID: THE-BWC_DiscordOperationsBot_AY3xt-Bgmgcb4U3BetPR

View in SonarQube

[thebwc-sonarqube[bot]]

• 7 New Issues (is greater than 0)
• 0.00% Coverage on New Code (is less than 80.00%)

Analysis Details

7 Issues

• 0 Bugs
• 0 Vulnerabilities
• 7 Code Smells

Coverage and Duplications

• 0.00% Coverage (0.00% Estimated after merge)
• 0.00% Duplicated Code (0.00% Estimated after merge)

Project ID: THE-BWC_DiscordOperationsBot_AY3xt-Bgmgcb4U3BetPR

View in SonarQube

[thebwc-sonarqube[bot]]

• 3 New Issues (is greater than 0)
• 0.00% Coverage on New Code (is less than 80.00%)

Analysis Details

3 Issues

• 0 Bugs
• 0 Vulnerabilities
• 3 Code Smells

Coverage and Duplications

• 0.00% Coverage (0.00% Estimated after merge)
• 0.00% Duplicated Code (0.00% Estimated after merge)

Project ID: THE-BWC_DiscordOperationsBot_AY3xt-Bgmgcb4U3BetPR

View in SonarQube

[thebwc-sonarqube[bot]]

• 3 New Issues (is greater than 0)
• 0.00% Coverage on New Code (is less than 80.00%)

Analysis Details

3 Issues

• 0 Bugs
• 0 Vulnerabilities
• 3 Code Smells

Coverage and Duplications

• 0.00% Coverage (0.00% Estimated after merge)
• 0.00% Duplicated Code (0.00% Estimated after merge)

Project ID: THE-BWC_DiscordOperationsBot_AY3xt-Bgmgcb4U3BetPR

View in SonarQube

[thebwc-sonarqube[bot]]

• 2 New Issues (is greater than 0)
• 0.00% Coverage on New Code (is less than 80.00%)

Analysis Details

2 Issues

• 0 Bugs
• 0 Vulnerabilities
• 2 Code Smells

Coverage and Duplications

• 0.00% Coverage (0.00% Estimated after merge)
• 0.00% Duplicated Code (0.00% Estimated after merge)

Project ID: THE-BWC_DiscordOperationsBot_AY3xt-Bgmgcb4U3BetPR

View in SonarQube

[thebwc-sonarqube[bot]]

• 0.00% Coverage on New Code (is less than 80.00%)

Analysis Details

0 Issues

• 0 Bugs
• 0 Vulnerabilities
• 0 Code Smells

Coverage and Duplications

• 0.00% Coverage (0.00% Estimated after merge)
• 0.00% Duplicated Code (0.00% Estimated after merge)

Project ID: THE-BWC_DiscordOperationsBot_AY3xt-Bgmgcb4U3BetPR

View in SonarQube

[thebwc-sonarqube[bot]]

Analysis Details

0 Issues

• 0 Bugs
• 0 Vulnerabilities
• 0 Code Smells

Coverage and Duplications

• 0.00% Coverage (0.00% Estimated after merge)
• 0.00% Duplicated Code (0.00% Estimated after merge)

Project ID: THE-BWC_DiscordOperationsBot_AY3xt-Bgmgcb4U3BetPR

View in SonarQube

[PatrickPedersen]

@Goltred Sorry for all the pings. Technically this is now ready to merge with main. Is there anything else you want to do on this PR? Or should we just merge?

[Goltred]

Sorry, i think it should be good to go. I'm not merging without consent though so feel free to do so? :D