ylrz_saas_pharmacy/java/scripts/check-profile-config-data.js

// 检查 fs_tenant_cs1 中 company_lobster_profile_config 的数据分布
const mysql = require('mysql2/promise')

const DB = {
  host: 'cq-cdb-8fjmemkb.sql.tencentcdb.com',
  port: 27220,
  user: 'root',
  password: 'Ylrz_1q2w3e4r5t6y',
  multipleStatements: false
}

async function main() {
  const conn = await mysql.createConnection(DB)
  try {
    // 检查 company_lobster_profile_config 表数据
    const [configs] = await conn.query("SELECT company_id, COUNT(*) as cnt, GROUP_CONCAT(field_key) as keys_list FROM fs_tenant_cs1.company_lobster_profile_config GROUP BY company_id")
    console.log('=== fs_tenant_cs1.company_lobster_profile_config 数据分布 ===')
    configs.forEach(c => console.log(`  company_id=${c.company_id}, count=${c.cnt}, keys=${c.keys_list}`))

    // 检查 lobster_user_profile 数据
    const [profiles] = await conn.query("SELECT company_id, COUNT(*) as cnt FROM fs_tenant_cs1.lobster_user_profile WHERE deleted=0 GROUP BY company_id")
    console.log('\n=== fs_tenant_cs1.lobster_user_profile 数据分布 ===')
    profiles.forEach(p => console.log(`  company_id=${p.company_id}, count=${p.cnt}`))

    // 检查 company_lobster_profile_config 表结构
    const [cols] = await conn.query("SELECT COLUMN_NAME, DATA_TYPE FROM information_schema.COLUMNS WHERE TABLE_SCHEMA='fs_tenant_cs1' AND TABLE_NAME='company_lobster_profile_config' ORDER BY ORDINAL_POSITION")
    console.log('\n=== company_lobster_profile_config 表结构 ===')
    cols.forEach(c => console.log(`  ${c.COLUMN_NAME} (${c.DATA_TYPE})`))
  } finally {
    await conn.end()
  }
}

main().catch(err => {
  console.error('FAILED:', err.message || err)
  process.exit(1)
})