37 lines
1.4 KiB
JavaScript
37 lines
1.4 KiB
JavaScript
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(); |