jiapengyu
59 lines
2.2 KiB
JavaScript
59 lines
2.2 KiB
JavaScript
const { Client } = require('ssh2');
|
|
const fs = require('fs');
|
|
|
|
const conn = new Client();
|
|
|
|
const cleanStations = [
|
|
{ id: 's1', cityId: '1', districtId: 'd1', name: '金融街融汇景苑' },
|
|
{ id: 's2', cityId: '1', districtId: 'd1', name: '金辉江山铭筑' },
|
|
{ id: 's3', cityId: '1', districtId: 'd2', name: '华兴里' },
|
|
{ id: 's4', cityId: '1', districtId: 'd2', name: '华兴南里' },
|
|
{ id: 's5', cityId: '1', districtId: 'mqugyhc6', name: '意境兰庭' }
|
|
];
|
|
|
|
conn.on('ready', () => {
|
|
console.log('=== 删除服务器上的重复站点数据 ===');
|
|
|
|
conn.sftp((err, sftp) => {
|
|
if (err) { console.log('SFTP ERR:', err); conn.end(); return; }
|
|
|
|
const cleanContent = JSON.stringify(cleanStations, null, 2);
|
|
const writeStream = sftp.createWriteStream('/www/huishou/server/data/stations.json');
|
|
writeStream.write(cleanContent);
|
|
writeStream.end();
|
|
|
|
writeStream.on('close', () => {
|
|
console.log('stations.json已清理');
|
|
sftp.end();
|
|
|
|
console.log('\n=== 重启后端容器 ===');
|
|
conn.exec('cd /www/huishou && docker-compose restart backend', (err2, stream2) => {
|
|
if (err2) { console.log('ERR2:', err2); conn.end(); return; }
|
|
stream2.on('data', (d) => console.log(d.toString()));
|
|
stream2.on('close', () => {
|
|
setTimeout(() => {
|
|
console.log('\n=== 验证结果 ===');
|
|
conn.exec('cat /www/huishou/server/data/stations.json', (err3, stream3) => {
|
|
if (err3) { console.log('ERR3:', err3); conn.end(); return; }
|
|
let data = '';
|
|
stream3.on('data', (d) => data += d.toString());
|
|
stream3.on('close', () => {
|
|
const json = JSON.parse(data);
|
|
const names = json.map(s => s.name);
|
|
console.log('站点名称:', names);
|
|
if (names.length === [...new Set(names)].length) {
|
|
console.log('\n✅ 重复数据已删除！');
|
|
} else {
|
|
console.log('\n⚠️ 仍有重复数据');
|
|
}
|
|
conn.end();
|
|
});
|
|
});
|
|
}, 3000);
|
|
});
|
|
});
|
|
});
|
|
});
|
|
});
|
|
|
|
conn.connect({ host: 'hs.yifenbao.cn', port: 22, username: 'root', password: 'Torch1112' }); |