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',
  charset: 'utf8mb4',
  multipleStatements: true
}

const SQL = fs.readFileSync(
  path.join(__dirname, '../../java/sql/master/V20260623_02__lobster_message_dedup_system_menu.sql'),
  'utf8'
)

async function main() {
  const conn = await mysql.createConnection(DB_CFG)
  await conn.query('SET NAMES utf8mb4')
  const [rows] = await conn.query(SQL)
  await conn.query('UPDATE sys_menu SET menu_name = ? WHERE menu_id = 2621', ['锟斤拷锟斤拷锟斤拷息去锟斤拷'])
  const last = Array.isArray(rows) ? rows[rows.length - 1] : rows
  if (Array.isArray(last) && last.length) {
    console.log('menu:', last[0])
  }
  const [grants] = await conn.query(
    'SELECT COUNT(*) AS cnt FROM sys_role_menu WHERE menu_id = 2621'
  )
  console.log('role_grants:', grants[0].cnt)
  await conn.end()
}

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