ylrz_saas_pharmacy/adminui/scripts/check-api-registry-schema.js

const mysql = require('mysql2/promise')
const DB = { host: 'cq-cdb-8fjmemkb.sql.tencentcdb.com', port: 27220, user: 'root', password: 'Ylrz_1q2w3e4r5t6y', charset: 'utf8mb4' }
async function main() {
  const db = process.argv[2] || 'fs_tenant_cs1'
  const conn = await mysql.createConnection({ ...DB, database: db })
  const [tables] = await conn.query("SHOW TABLES LIKE 'lobster_api_registry'")
  console.log('db', db, 'hasTable', tables.length > 0)
  if (!tables.length) { await conn.end(); return }
  const [cols] = await conn.query('SHOW COLUMNS FROM lobster_api_registry')
  console.log('columns', cols.map(c => c.Field).join(', '))
  const [rows] = await conn.query('SELECT api_key, api_name, category, enabled FROM lobster_api_registry LIMIT 20')
  console.log('rows', rows.length, JSON.stringify(rows, null, 2))
  await conn.end()
}
main().catch(e => { console.error(e); process.exit(1) })