const mysql = require('mysql2/promise')

const DB = process.argv[2] || 'fs_tenant_cs1'
const cfg = {
  host: 'cq-cdb-8fjmemkb.sql.tencentcdb.com',
  port: 27220,
  user: 'root',
  password: 'Ylrz_1q2w3e4r5t6y',
  database: DB,
  charset: 'utf8mb4'
}

async function main() {
  const c = await mysql.createConnection(cfg)
  const [qdrantSys] = await c.query('SELECT menu_id, menu_name, path, visible FROM sys_menu WHERE menu_id = 29951')
  const [qdrantCm] = await c.query('SELECT menu_id, menu_name, path FROM company_menu WHERE menu_id = 29951')
  const [srm] = await c.query('SELECT COUNT(*) cnt FROM sys_role_menu WHERE menu_id = 29951')
  const [crm] = await c.query('SELECT COUNT(*) cnt FROM company_role_menu WHERE menu_id = 29951')
  const [tbl] = await c.query(
    "SELECT COUNT(*) cnt FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'lobster_sales_corpus_task'"
  )
  const [col] = await c.query(
    "SELECT COUNT(*) cnt FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'lobster_sales_corpus' AND COLUMN_NAME = 'task_id'"
  )
  console.log(JSON.stringify({
    db: DB,
    qdrantSysMenu: qdrantSys[0] || null,
    qdrantCompanyMenu: qdrantCm[0] || null,
    qdrantSysRoleGrants: srm[0].cnt,
    qdrantCompanyRoleGrants: crm[0].cnt,
    salesCorpusTaskTable: tbl[0].cnt === 1,
    salesCorpusTaskIdColumn: col[0].cnt === 1
  }, null, 2))
  await c.end()
}

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