How to properly pass Sequelize table into command handler?
I am sure this is very straightforward and I am just missing the obvious, but I am using the discord.js walkthrough https://discordjs.guide/sequelize/#adding-a-tag to setup a keyword system using Sequelize. I have also configured the event handler and command handler setups as recommended previously in the guide, so all my events/commands are in unique files. The guide shows how to add sequelize data when done all directly in your index.js file, but if I am trying to make it a separate command how do I properly require the sequelize table I defined as "Keywords" in my "ready.js" event handler file when setting up the add command as a separate "keyadd.js" command file?
Any help greatly appreciated! Here is my current command file to add the keyword:
const { SlashCommandBuilder, MessageFlags } = require('discord.js');
const { modRoleID } = require('../../config.json');
const { Keywords } = require('../../index');
module.exports = {
data: new SlashCommandBuilder()
.setName('keyadd')
.setDescription('Adds a new trigger word to storage.')
.addStringOption(option =>
option
.setName('keyword')
.setDescription('The trigger word to add.')
.setRequired(true)
)
.addStringOption(option =>
option
.setName('response')
.setDescription('The response for this keyword.')
.setRequired(true)
),
async execute(interaction) {
// Check if the member has the required mod role (or higher)
const modRole = interaction.guild.roles.cache.get(modRoleID);
if (!modRole) {
return await interaction.reply({ content: 'Moderator role not found in this server.', flags: MessageFlags.Ephemeral });
}
if (interaction.member.roles.highest.position < modRole.position) {
return await interaction.reply({ content: 'You do not have permission to use this command.', flags: MessageFlags.Ephemeral });
}
const keyword = interaction.options.getString('keyword');
const response = interaction.options.getString('response');
const msgTime = new Date();
try {
const key = await Keywords.create({
name: keyword,
last: msgTime,
response: response
});
await interaction.reply(Keyword `${key.name}` added at `${key.last}`.);
} catch (e) {
if (e.name === 'SequelizeUniqueConstraintError') {
return await interaction.reply({ content: 'That keyword already exists.', flags: MessageFlags.Ephemeral });
}
return await interaction.reply({ content: Something went wrong with adding the keyword: ${e}, flags: MessageFlags.Ephemeral });
}
},
};
2 Replies
- What's your exact discord.js
npm list discord.js and node node -v version?
- Not a discord.js issue? Check out #other-js-ts.
- Consider reading #how-to-get-help to improve your question!
- Explain what exactly your issue is.
- Post the full error stack trace, not just the top part!
- Show your code!
- Issue solved? Press the button!
- ✅ Marked as resolved by OP[email protected]
node v22.13.1
thank you, ended up figuring out in my ClientReady to do the following:
// Attach the models to the client for global access in other command files
client.Keywords = Keywords;
client.ntmWinners = ntmWinners;
Which then just allowed me to reference it directly as an object of the bot client in commands.
Thanks!