const { initDB, getDB } = require('../database');

async function verifyData() {
  try {
    await initDB();
    
    // 检查省份数据
    const [provinces] = await getDB().query('SELECT code, name FROM china_regions WHERE level = 1 ORDER BY code LIMIT 10');
    console.log('省份数据样本:');
    provinces.forEach(p => console.log(`  ${p.code} - ${p.name}`));
    
    // 检查城市数据
    const [cities] = await getDB().query('SELECT code, name, parent_code FROM china_regions WHERE level = 2 ORDER BY code LIMIT 10');
    console.log('\n城市数据样本:');
    cities.forEach(c => console.log(`  ${c.code} - ${c.name} (${c.parent_code})`));
    
    // 检查区县数据
    const [districts] = await getDB().query('SELECT code, name, parent_code FROM china_regions WHERE level = 3 ORDER BY code LIMIT 10');
    console.log('\n区县数据样本:');
    districts.forEach(d => console.log(`  ${d.code} - ${d.name} (${d.parent_code})`));
    
    // 统计各级别数量
    const [stats] = await getDB().query('SELECT level, COUNT(*) as count FROM china_regions GROUP BY level ORDER BY level');
    console.log('\n各级别统计:');
    stats.forEach(row => {
      const levelName = row.level === 1 ? '省份' : row.level === 2 ? '城市' : '区县';
      console.log(`  ${levelName}(level ${row.level}): ${row.count} 个`);
    });
    
  } catch (error) {
    console.error('验证失败:', error);
  } finally {
    process.exit();
  }
}

verifyData();