Method generateStats

MCP/scripts/fetch-issues.js:825–859

()

  }

  generateStats() {
    this.db.all('SELECT COUNT(*) as total FROM issues', (err, rows) => {
      if (err) {
        console.error('Error generating stats:', err);
        return;
      }

      console.log('\n📊 Database Statistics:');
      console.log(`   Total articles: ${rows[0].total}`);

      // 标签统计
      this.db.all(`
        SELECT labels, COUNT(*) as count 
        FROM issues 
        WHERE labels IS NOT NULL AND labels != '[]'
        GROUP BY labels 
        ORDER BY count DESC 
        LIMIT 10
      `, (err, labelRows) => {
        if (err) {
          console.error('Error getting label stats:', err);
          return;
        }

        console.log('\n🏷️ Top 10 Label Combinations:');
        labelRows.forEach((row, index) => {
          const labels = JSON.parse(row.labels);
          console.log(`   ${index + 1}. ${labels.join(', ')} (${row.count} articles)`);
        });

        console.log('\n🎉 Database update completed!');
        process.exit(0);
      });
    });
  }

  close() {
    this.db.close();