Auto db push for guilds

[Natemo2625]

Explain your suggestion
I wish that it would automatically check for guilds the bot is in when started and update the database accordingly so I don't have to kick and re-invite the bot to get slash commands to work for every server it's in

[Natemo2625]

Hello, has anyone seen this? Would really help with slash commands not working after system changed and/or DB loss

[Natemo2625]

Will someone please have a look at this? Would solve all of the problems that I'm facing if it were added.

[Natemo2625]

Could someone at least give me a starting point to fix it myself? It's really annoying

[OG-Nimbi]

That would be done via the bot start event emitter.

/*
* client is your discord.js Client
* commands obj is your command data you want to add to the guild
*/
client.on('ready', async (guild) => {
guild.commands.set(commands).then(() => 
console.log(`Commands deployed in guild ${guild.name}!`));
})

Naturally, it would need to be adjusted for this bot's code. But, that's the general idea of how it would be done the easiest.

Might also be a good idea to have some sort of check in there to prevent from updating anything that hasn't changed.

[Natemo2625]

Ah alright, thanks for the starting point, will comment here again if I've got it working

[OG-Nimbi]

Ah alright, thanks for the starting point, will comment here again if I've got it working

It looks like for this bot you might just need to add this to the client.on("ready", async () => { ... }); event emitter:

ApplicationCommandRegistries.setDefaultBehaviorWhenNotIdentical(
        RegisterBehavior.BulkOverwrite
);

So, basically the ready event in the index.ts file would go from this:

client.on('ready', async () => {
        client.music.connect(client.user!.id);
        client.user?.setActivity('/', {
                type: ActivityType.Watching
        });

        client.user?.setStatus('online');
        const token = client.twitch.auth.access_token;
        if (!token) return;

        // happens to be the first DB call at start up
        try {
                const notifyDB = await trpcNode.twitch.getAll.query();

                const query: string[] = [];
                for (const user of notifyDB.notifications) {
                        query.push(user.twitchId);
                        client.twitch.notifyList[user.twitchId] = {
                                sendTo: user.channelIds,
                                logo: user.logo,
                                live: user.live,
                                messageSent: user.sent,
                                messageHandler: {}
                        };
                }
                await notify(query).then(() =>
                        setInterval(async () => {
                                const newQuery: string[] = [];
                                // pickup newly added entries
                                for (const key in client.twitch.notifyList) {
                                        newQuery.push(key);
                                }
                                await notify(newQuery);
                        }, 60 * 1000)
                );
        } catch (err) {
                Logger.error('Prisma ' + err);
        }
});

to this:

client.on('ready', async () => {
        ApplicationCommandRegistries.setDefaultBehaviorWhenNotIdentical(
                RegisterBehavior.Overwrite
        );

        client.music.connect(client.user!.id);
        client.user?.setActivity('/', {
                type: ActivityType.Watching
        });

        client.user?.setStatus('online');
        const token = client.twitch.auth.access_token;
        if (!token) return;

        // happens to be the first DB call at start up
        try {
                const notifyDB = await trpcNode.twitch.getAll.query();

                const query: string[] = [];
                for (const user of notifyDB.notifications) {
                        query.push(user.twitchId);
                        client.twitch.notifyList[user.twitchId] = {
                                sendTo: user.channelIds,
                                logo: user.logo,
                                live: user.live,
                                messageSent: user.sent,
                                messageHandler: {}
                        };
                }
                await notify(query).then(() =>
                        setInterval(async () => {
                                const newQuery: string[] = [];
                                // pickup newly added entries
                                for (const key in client.twitch.notifyList) {
                                        newQuery.push(key);
                                }
                                await notify(newQuery);
                        }, 60 * 1000)
                );
        } catch (err) {
                Logger.error('Prisma ' + err);
        }
});

That should fix it if I'm not mistaken. There might be some indentation errors, however, since I made that edit entirely from GitHub mobile.

[OG-Nimbi]

Thinking about this a bit more. It might be better to have a command that updates all commands and then restarts the bot to load the changes in every guild.

[Natemo2625]

Hmm alright, I can try to do that