const mysql = require('mysql2/promise')
const fs = require('fs')
const path = require('path')

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

async function main() {
  const sqlPath = path.join(__dirname, '../../java/sql/master/V20260701_01__lobster_qdrant_menu_restore.sql')
  const sql = fs.readFileSync(sqlPath, 'utf8')
  const conn = await mysql.createConnection(DB_CFG)
  await conn.query(sql)
  const [sysRows] = await conn.query('SELECT menu_id, menu_name, path FROM sys_menu WHERE menu_id = 29951')
  const [tsmRows] = await conn.query('SELECT menu_id, menu_name, path FROM tenant_sys_menu WHERE menu_id = 29951')
  const [tcmRows] = await conn.query('SELECT menu_id, menu_name, path FROM tenant_company_menu WHERE menu_id = 29951')
  console.log('sys_menu:', sysRows)
  console.log('tenant_sys_menu:', tsmRows)
  console.log('tenant_company_menu:', tcmRows)
  await conn.end()
}

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