#db.query is not a function

29 messages · Page 1 of 1 (latest)

terse lark

Hello, I have a problem with my db when I make my command I have this error that appears, db.query is not a function

const { SlashCommandBuilder, EmbedBuilder } = require("discord.js");
const db = require("../../utils/database");

module.exports = {
  data: new SlashCommandBuilder()
    .setName("lock")
    .setDescription("Verrouille le salon")
    .addChannelOption((option) =>
      option.setName("salon").setDescription("Salon").setRequired(true)
    )
    .addStringOption((option) =>
      option
        .setName("reason")
        .setDescription("Raison du lock")
        .setRequired(true)
    ),
  async execute(interaction) {

    try {

      console.log(db)
      const channel = interaction.options.getChannel("salon");
      const reason = interaction.options.getString("reason");

      await db.query(`SELECT * FROM lockchannel WHERE GuildID = "${interaction.guild.id}" AND channel = "${channel.id}"`, (err, req) => {
      
        if(req.length > 1) {
          return interaction.reply({
            content: `> Le salon ${channel} est déjà verrouillé ![no](https://cdn.discordapp.com/emojis/1199859706424987740.webp?size=128 "no").`,
            ephemeral: true,
          });
        }
        if(req.length < 1) {

          const role = interaction.guild.roles.cache.find(
            (role) => role.name === "@everyone"
          );
    
          channel.permissionOverwrites.edit(role, {
            SendMessages: false,
          });

          const msg = new EmbedBuilder()
          .setTitle(
            ":cadenasverrouille: || Salon verrouillé"
          )
          .setColor("Red")
          .setFields(
            {
              name: `__**![profil](https://cdn.discordapp.com/emojis/1148950147829604402.webp?size=128 "profil") || Vérrouillé par**__`,
              value: `<@${interaction.user.id}>`,
            },
            {
              name: `__**![outilcrayon](https://cdn.discordapp.com/emojis/1199812967068356638.webp?size=128 "outilcrayon") || Raison**__`,
              value: `${reason}`,
            }
          )
          .setFooter({
            text: "Katsuki",
            iconURL: interaction.guild.iconURL()
              ? interaction.guild.iconURL()
              : "https://imgur.com/a06O1Wn.png",
          })
          .setTimestamp();

  
          db.query(`INTERT INTO lockchannel (GuildID, userID, channel, reason) VALUES ("${interaction.guild.id}", "${interaction.user.id}", "${channel.id}", "${reason.replace(/"/g, '\\"')}")`)

          channel.send({ embeds: [msg] });
        }
      
      })


    } catch (e) {
      console.log(e);
    }
  },
};
pulsar wharfBOT
  • 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
shadow lily

what is in the file ../../utils/database

terse lark 
const mysql = require("mysql")

module.exports = async () => {

  let db = mysql.createConnection({
    host: "localhost",
    user: "root",
    port: "3306",
    password: "",
    database: "discord"

  })

  db.connect(err => {
    if(err) throw err;
    console.log("[INFO] Database Connected !");
  })

  return db;
}```
shadow lily

ok well, you're exporting a function

and a function doesn't typically have other functions as properties

terse lark

So what do I do?

shadow lily

call the function that you export, it will return db

or export db itself, not a function that returns db

personally i would use an ORM like sequelize, but if you want to interact with the connector directly then you can just do what you're doing now

terse lark

Sorry but how can i do that ? I'm new to js 😅

I've tried sequelize but I can't do what I want to do

shadow lily

what issues did you have with sequelize?

terse lark

I wanted to retrieve information from the DB but couldn't without a copy of it.

shadow lily

a copy of what?

terse lark

For example, I wanted to search in my DB for a channel id to send a message there, but if I didn't have a copy of the id to search in my DB for the channel, it wouldn't work.

So i want to try mysql because i have a friend who uses mysql but when i asked him he saw no error

shadow lily

🤔 but you'll run into the same issue anyway

you need to know the ID to search for the ID

terse lark

No, with mysql I succeeded to do what I wanted in a function, but when I want to do it in my command, it gives me this error

shadow lily

i mean, ultimately it just the difference between

db.query(`SELECT * FROM lockchannel WHERE GuildID = "${interaction.guild.id}" AND channel = "${channel.id}"`, (err, req) => { ... });

and

LockChannels.findOne({ where: { GuildID: interaction.guild.id, channel: channel.id } });
terse lark

Yes but with sequelize we need the id of the channel for search in db

shadow lily

what's the difference? you need the ID anyway, looking at both lines of code

anyway, all you need to do is call the function you import

first of all, call the import something like makeConnection:

const makeConnection = require("../../utils/database");

then call it later:

const db = await makeConnection();
db.query(...);
terse lark

thanks it work ;)

And so I don't know I didn't succeed with sequelize

Maybe it's just me :')

shadow lily
terse lark

Where should I put this?