ylrz_saas_pharmacy/adminui/scripts/bind-lobster-sys-role.js

const mysql = require('mysql2/promise')
const DB_CFG = {
  host: 'cq-cdb-8fjmemkb.sql.tencentcdb.com',
  port: 27220,
  user: 'root',
  password: 'Ylrz_1q2w3e4r5t6y',
  charset: 'utf8mb4'
}
const db = process.argv[2] || 'fs_tenant_cs1'

;(async () => {
  const conn = await mysql.createConnection({ ...DB_CFG, database: db })
  await conn.query(`
    INSERT IGNORE INTO sys_role_menu (role_id, menu_id)
    SELECT 1, menu_id FROM sys_menu WHERE parent_id = 29900 OR menu_id = 29900
  `)
  const [n] = await conn.query(`
    SELECT COUNT(*) c FROM sys_role_menu
    WHERE menu_id IN (SELECT menu_id FROM sys_menu WHERE parent_id = 29900 OR menu_id = 29900)
  `)
  console.log(db, 'sys_role_menu lobster bindings:', n[0].c)
  await conn.end()
})().catch(e => { console.error(e); process.exit(1) })