ylrz_saas_pharmacy/java/scripts/check-ai-scene-encoding.js

/**
 * Check admin_ai_scene names for workflow_llm & summary_generation
 */
const mysql = require('mysql2/promise')

const EXPECT = {
  workflow_llm: 'E5B7A5E4BD9CE6B5814C4C4DE59B9EE7AD94',
  summary_generation: 'E5AFB9E8AF9DE69198E8A681'
}

async function main() {
  const host = process.env.DB_HOST || 'cq-cdb-8fjmemkb.sql.tencentcdb.com'
  const port = Number(process.env.DB_PORT || 27220)
  const user = process.env.DB_USER || 'root'
  const password = process.env.DB_PASSWORD || 'Ylrz_1q2w3e4r5t6y'
  const masterDb = process.env.DB_NAME || 'ylrz_saas'

  const master = await mysql.createConnection({ host, port, user, password, database: masterDb, charset: 'utf8mb4' })
  const [rows] = await master.query(
    "SELECT scene_code, scene_name, HEX(scene_name) hx FROM admin_ai_scene WHERE scene_code IN ('workflow_llm','summary_generation')"
  )
  console.log(JSON.stringify(rows, null, 2))
  for (const r of rows) {
    const ok = r.hx === EXPECT[r.scene_code]
    console.log(r.scene_code, ok ? 'OK' : 'BAD', r.scene_name)
  }
  await master.end()
}

main().catch(e => { console.error(e); process.exit(1) })