在代码中创建Node.js枚举以匹配数据库中的值列表

const StatusEnum = {
  ACTIVE: 'active',
  INACTIVE: 'inactive',
  PENDING: 'pending'
};

module.exports = StatusEnum;

export default StatusEnum;

const StatusEnum = require('./StatusEnum'); // 或使用import语法导入

const user = {
  name: 'John',
  status: StatusEnum.ACTIVE
};

console.log(user.status); // 输出: active

const mysql = require('mysql');
const StatusEnum = require('./StatusEnum');

const connection = mysql.createConnection({
  host: 'localhost',
  user: 'root',
  password: 'password',
  database: 'mydatabase'
});

connection.connect();

const user = {
  name: 'John',
  status: StatusEnum.ACTIVE
};

connection.query('INSERT INTO users SET ?', { name: user.name, status: user.status }, (error, results) => {
  if (error) throw error;
  console.log('User inserted successfully');
});

connection.end();