import { readFileSync, writeFileSync } from 'node:fs';
import { dirname, join } from 'node:path';
import { fileURLToPath } from 'node:url';

const scriptDir = dirname(fileURLToPath(import.meta.url));
const root = join(scriptDir, '../..');

function writeUtf8(path, content) {
  writeFileSync(path, content.replace(/\r\n/g, '\n'), 'utf8');
}

const canonicalReplacements = [
  ['-- A.3 ??? sys_menu??UNHEX ?????????', '-- A.3 重建 sys_menu（UNHEX 保证中文名称）'],
  ['-- A.4 ??? company_menu??????????????', '-- A.4 同步 company_menu（销售端子集）'],
  ['-- A.5 ??????', '-- A.5 补全角色授权'],
  ['-- PART B ?? ???? tenant_sys_menu + tenant_company_menu??????????', '-- PART B ：逐租户 tenant_sys_menu + tenant_company_menu（模板库执行）'],
];

{
  const path = join(root, 'sql/lobster_menu_canonical_init.sql');
  let text = readFileSync(path, 'utf8').replace(/\r\n/g, '\n');
  for (const [from, to] of canonicalReplacements) {
    text = text.replace(from, to);
  }
  writeUtf8(path, text);
  console.log('fixed lobster_menu_canonical_init.sql comments');
}

console.log('sql comment fix done');