Discord.js如何使用sqlite在express中发送消息作者

npm install discord.js sqlite3

const Discord = require('discord.js');
const sqlite3 = require('sqlite3').verbose();

const client = new Discord.Client();
client.login('YOUR_DISCORD_BOT_TOKEN');

client.on('ready', () => {
  console.log(`Logged in as ${client.user.tag}`);
});

const db = new sqlite3.Database('database.db');

db.serialize(() => {
  db.run('CREATE TABLE IF NOT EXISTS messages (content TEXT)');
  db.run('INSERT INTO messages (content) VALUES (?)', 'Hello, world!');
  db.all('SELECT * FROM messages', (err, rows) => {
    if (err) {
      console.error(err);
    } else {
      rows.forEach(row => {
        console.log(row.content);
      });
    }
  });
});

app.get('/send-message', (req, res) => {
  const channel = client.channels.cache.get('YOUR_DISCORD_CHANNEL_ID');
  channel.send('Hello, Discord!');
  res.send('Message sent');
});