ylrz_saas_pharmacy/java/scripts/verify-qdrant-menu.js

const mysql = require('mysql2/promise')

async function main() {
  const conn = await mysql.createConnection({
    host: 'cq-cdb-8fjmemkb.sql.tencentcdb.com',
    port: 27220,
    user: 'root',
    password: 'Ylrz_1q2w3e4r5t6y',
    database: 'ylrz_saas'
  })
  for (const [table, id] of [
    ['sys_menu', 29938],
    ['sys_menu', 29951],
    ['tenant_sys_menu', 29938],
    ['tenant_sys_menu', 29951],
    ['tenant_company_menu', 29938],
    ['tenant_company_menu', 29951]
  ]) {
    const [rows] = await conn.query(`SELECT menu_id, menu_name, path, component, visible FROM ${table} WHERE menu_id = ?`, [id])
    console.log(table, id, rows[0] || 'NOT FOUND')
  }
  await conn.end()
}

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