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' });