const mysql = require('mysql2/promise');

(async () => {
  const conn = await mysql.createConnection({
    host: 'localhost', port: 33060,
    user: 'root', password: 'root', database: 'iot_platform'
  });

  // 查看 alarm 表结构
  const [cols] = await conn.query("DESCRIBE alarm");
  console.log('=== alarm 表结构 ===');
  cols.forEach(c => console.log(` ${c.Field} | ${c.Type} | ${c.Null} | ${c.Key} | ${c.Default}`));

  // 查看数据量
  const [[cnt]] = await conn.query("SELECT COUNT(*) as cnt FROM alarm");
  console.log('\n数据行数:', cnt.cnt);

  await conn.end();
})().catch(e => console.error('错误:', e.message));