Phrase Management

const phrases = await getPhrases(db);

if (phrases.length > 0) {
    const randomIndex = Math.floor(Math.random() * phrases.length);
    const randomPhrase = phrases[randomIndex];
    
    await message.reply({
        content: randomPhrase,
        allowedMentions: { repliedUser: false },
    });
}

/addphrase phrase:Hello there!

const checkPhraseExistsQuery = `SELECT COUNT(*) AS count FROM phrases WHERE phrase = ?`;

db.get(checkPhraseExistsQuery, [phrase], (err, row) => {
    if (row.count > 0) {
        const alreadyAddedEmbed = ErrorEmbed(`"${phrase}" is already a phrase.`);
        interaction.reply({ embeds: [alreadyAddedEmbed], ephemeral: true });
    } else {
        // Insert the new phrase
        const insertPhraseQuery = `INSERT INTO phrases (phrase) VALUES (?)`;
        db.run(insertPhraseQuery, [phrase]);
    }
});

/removephrase phrase:Hello there!

const deletePhraseQuery = `DELETE FROM phrases WHERE phrase = ?`;

db.run(deletePhraseQuery, [phraseToRemove], function (err) {
    if (err) {
        const errorEmbed = ErrorEmbed("Failed to remove the phrase from the database.");
        return interaction.reply({ embeds: [errorEmbed], ephemeral: true });
    }
    
    const successEmbed = SuccessEmbed(
        "Removed Phrase Successfully", 
        `\`\`\`"${phraseToRemove}" has been removed as a phrase.\`\`\``
    );
    interaction.reply({ embeds: [successEmbed], ephemeral: true });
});

/listphrases

const phrasesList = rows.map(row => row.phrase).join("\n- ");
const infoEmbed = InfoEmbed(`- ${phrasesList}`);
interaction.reply({ embeds: [infoEmbed] });

- Hello there!
- Welcome to the server
- Nice message!
- Thanks for sharing

if (rows.length === 0) {
    const noPhrasesEmbed = ErrorEmbed("No phrases have been added yet.");
    return interaction.reply({ embeds: [noPhrasesEmbed] });
}

db.serialize(() => {
    db.run(`CREATE TABLE IF NOT EXISTS phrases ( phrase TEXT PRIMARY KEY )`);
});

sqlite3 data/{serverId}.db

INSERT INTO phrases (phrase) VALUES 
  ('Hello!'),
  ('Welcome!'),
  ('Nice to see you!'),
  ('Thanks for chatting!');

SELECT * FROM phrases;

DELETE FROM phrases;

function initializeDatabase(serverId) {
    const dbFilePath = path.join(__dirname, "..", "..", "data", `${serverId}.db`);
    const db = new sqlite3.Database(dbFilePath);
    
    db.serialize(() => {
        db.run(`CREATE TABLE IF NOT EXISTS phrases ( phrase TEXT PRIMARY KEY )`);
    });
    
    return db;
}