如何在NodeJS管理员软件开发工具包中删除上次登录时间超过一定时间的匿名用户？

const express = require('express');
const mysql = require('mysql');

const app = express();

// 创建数据库连接
const connection = mysql.createConnection({
  host: 'localhost',
  user: 'root',
  password: 'password',
  database: 'mydatabase'
});

// 连接到数据库
connection.connect((err) => {
  if (err) {
    console.error('Error connecting to database: ', err);
    return;
  }
  console.log('Connected to database');
});

// 路由处理程序
app.get('/delete-anonymous-users', (req, res) => {
  const currentTime = new Date();
  const thresholdTime = new Date(currentTime.getTime() - (7 * 24 * 60 * 60 * 1000)); // 一周前的时间

  // 查询匿名用户的登录时间
  const query = `SELECT * FROM users WHERE isAnonymous = true AND lastLoginTime < '${thresholdTime.toISOString()}'`;
  connection.query(query, (err, results) => {
    if (err) {
      console.error('Error querying database: ', err);
      res.status(500).json({ error: 'Failed to delete anonymous users' });
      return;
    }

    const usersToDelete = results;

    // 删除匿名用户
    const deleteQuery = `DELETE FROM users WHERE id IN (${usersToDelete.map(user => user.id).join(',')})`;
    connection.query(deleteQuery, (err) => {
      if (err) {
        console.error('Error deleting users: ', err);
        res.status(500).json({ error: 'Failed to delete anonymous users' });
        return;
      }

      res.json({ message: 'Anonymous users deleted successfully' });
    });
  });
});

// 启动服务器
app.listen(3000, () => {
  console.log('Server started on port 3000');
});