Method generateLabelStatistics

MCP/scripts/fetch-issues.js:1276–1342

()

  }

  async generateLabelStatistics() {
    console.log('\n📊 Label Statistics:');
    
    // 标签使用统计
    this.db.all(`
      SELECT 
        l.label,
        l.category,
        COUNT(al.issue_number) as usage_count,
        AVG(al.weight) as avg_weight
      FROM label_categories l
      LEFT JOIN article_labels al ON l.label = al.label
      GROUP BY l.label, l.category
      ORDER BY usage_count DESC
    `, [], (err, rows) => {
      if (err) {
        console.error('Error generating label stats:', err);
        return;
      }

      console.log('\n🏷️ Label Usage by Category:');
      const byCategory = {};
      rows.forEach(row => {
        if (!byCategory[row.category]) {
          byCategory[row.category] = [];
        }
        byCategory[row.category].push({
          label: row.label,
          count: row.usage_count,
          weight: row.avg_weight
        });
      });

      Object.entries(byCategory).forEach(([category, labels]) => {
        console.log(`\n${category}:`);
        labels.forEach(({label, count, weight}) => {
          console.log(`   ${label}: ${count} articles (avg weight: ${weight?.toFixed(2) || 0})`);
        });
      });

      // 标签关系统计
      this.db.all(`
        SELECT 
          label1,
          label2,
          cooccurrence_count,
          correlation_score
        FROM label_relations
        WHERE correlation_score > 0.3
        ORDER BY correlation_score DESC
        LIMIT 10
      `, [], (err, relations) => {
        if (err) {
          console.error('Error getting label relations:', err);
          return;
        }

        console.log('\n🔗 Strong Label Correlations:');