gdoenlen / pinnacle-bot Goto Github PK

The TopBotCommand.java needs to be finished. The query in TopCookieRepository.java should probably be rewritten to be correct. The command should print the top 10 users who have the most amount of cookies.

select count(*) as num_cookies, user_id from cookies group by user_id order by num_cookies limit 10; maybe?

Number | User
 10  | George

use https://github.com/iNamik/java_text_tables to print the tables?

???

https://developers.redhat.com/articles/2022/04/19/java-17-whats-new-openjdks-container-awareness#tuning_defaults_for_containers

see how this repo does it:

https://github.com/SFXD/trust-bot/blob/master/.github/workflows/main.yml

should probably just need to run: mvn verify

The cookie command is half finished... we need to figure out how to get the body of the command (who is getting the cookie and the reason).

We also need to handle validation exceptions and send a response to the user "X used give cookie! Y now has N cookies"

see: https://slack.dev/java-slack-sdk/guides/getting-started-with-bolt#start-the-app-with-two-env-variables

We need to add the bot as an app in the slack server. Then to start the app we need these 2 env variables or they can be set in
application-dev.properties

this talks about using ngrok:
https://slack.dev/java-slack-sdk/guides/getting-started-with-bolt#enable-hello-command

does it work? this needs to be correct so the IsAllowedToGiveCookies validation works properly

    @Formula(
        select = "lgt.lastGivenCookieTimestamp",
        join = """
               join (
                 select MAX(createdAt) as lastGivenCookieTimestamp, from_id
                 from cookie group by from_id
               ) as lgt
               on cookie.from_id = ${ta}.id
               """
    )
    private Instant lastGivenCookieTimestamp;

Probably can write an integration test for this...