如何在Sequelize / Node.js中设置沙盒帐号？

module.exports = {
  development: {
    database: 'sandbox_db',
    username: 'sandbox_user',
    password: 'sandbox_password',
    host: 'localhost',
    port: 3306,
    dialect: 'mysql',
  },
  // 可以根据需要配置其他环境，如测试环境、生产环境等
};

const { DataTypes } = require('sequelize');
const sequelize = require('../config/sequelize');

const Sandbox = sequelize.define('Sandbox', {
  username: {
    type: DataTypes.STRING,
    allowNull: false,
  },
  password: {
    type: DataTypes.STRING,
    allowNull: false,
  },
  // 其他字段定义
});

module.exports = Sandbox;

const Sandbox = require('../models/sandbox');

// 创建沙盒帐号
const createSandboxAccount = async (username, password) => {
  try {
    const sandbox = await Sandbox.create({ username, password });
    console.log('沙盒帐号创建成功：', sandbox.toJSON());
  } catch (error) {
    console.error('沙盒帐号创建失败：', error);
  }
};

// 查询沙盒帐号
const findSandboxAccount = async (username) => {
  try {
    const sandbox = await Sandbox.findOne({ where: { username } });
    console.log('查询到的沙盒帐号：', sandbox.toJSON());
  } catch (error) {
    console.error('查询沙盒帐号失败：', error);
  }
};

// 更新沙盒帐号密码
const updateSandboxPassword = async (username, newPassword) => {
  try {
    const sandbox = await Sandbox.findOne({ where: { username } });
    if (sandbox) {
      sandbox.password = newPassword;
      await sandbox.save();
      console.log('沙盒帐号密码更新成功');
    } else {
      console.log('未找到该沙盒帐号');
    }
  } catch (error) {
    console.error('更新沙盒帐号密码失败：', error);
  }
};

// 删除沙盒帐号
const deleteSandboxAccount = async (username) => {
  try {
    const sandbox = await Sandbox.findOne({ where: { username } });
    if (sandbox) {
      await sandbox.destroy();
      console.log('沙盒帐号删除成功');
    } else {
      console.log('未找到该沙盒帐号');
    }
  } catch (error) {
    console.error('删除沙盒帐号失败：', error);
  }
};

// 调用示例
createSandboxAccount('sandbox_user1', 'sandbox_password1');
findSandboxAccount('sandbox_user1');
updateSandboxPassword('sandbox_user1', 'new_password');
deleteSandboxAccount('sandbox_user1');