ylrz_saas_pharmacy/adminui/scripts/check-tenant-db.js

const mysql = require('mysql2/promise')

const DB_CFG = {
  host: 'cq-cdb-8fjmemkb.sql.tencentcdb.com',
  port: 27220,
  user: 'root',
  password: 'Ylrz_1q2w3e4r5t6y',
  database: 'ylrz_saas'
}

function dbNameFromUrl(url) {
  if (!url) return null
  const m = String(url).match(/\/([^/?]+)(?:\?|$)/)
  return m ? m[1] : null
}

async function main() {
  const conn = await mysql.createConnection(DB_CFG)
  const tenantId = process.argv[2] || '32'
  const [rows] = await conn.query(
    'SELECT id, tenant_code, db_url FROM tenant_info WHERE id = ?',
    [tenantId]
  )
  console.log('tenant:', rows[0])
  const [tables] = await conn.query("SHOW TABLES LIKE 'lobster_channel%'")
  console.log('ylrz_saas lobster tables:', tables)
  const dbName = dbNameFromUrl(rows[0] && rows[0].db_url)
  if (dbName) {
    const tconn = await mysql.createConnection({ ...DB_CFG, database: dbName })
    const [tt] = await tconn.query("SHOW TABLES LIKE 'lobster_channel%'")
    console.log(dbName + ' lobster tables:', tt)
    await tconn.end()
  }
  await conn.end()
}

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