Method generateEnhancedStats

MCP/scripts/fetch-issues.js:677–724

()

  }

  generateEnhancedStats() {
    console.log('\n📊 Enhanced Database Statistics:');
    
    // 技术分布统计
    this.db.all(`
      SELECT 
        techniques,
        COUNT(*) as count
      FROM article_analysis
      GROUP BY techniques
      ORDER BY count DESC
      LIMIT 10
    `, (err, techRows) => {
      if (err) {
        console.error('Error getting technique stats:', err);
        return;
      }

      console.log('\n🛠️ Top Techniques Distribution:');
      techRows.forEach((row, index) => {
        const techs = JSON.parse(row.techniques);
        console.log(`   ${index + 1}. ${techs.join(', ')} (${row.count} articles)`);
      });

      // 难度级别分布
      this.db.all(`
        SELECT 
          complexity_level,
          COUNT(*) as count
        FROM article_analysis
        GROUP BY complexity_level
        ORDER BY count DESC
      `, (err, complexityRows) => {
        if (err) {
          console.error('Error getting complexity stats:', err);
          return;
        }

        console.log('\n📈 Complexity Level Distribution:');
        complexityRows.forEach(row => {
          console.log(`   ${row.complexity_level}: ${row.count} articles`);
        });

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

  async fetchAllIssues() {
    console.log('🚀 Starting to fetch iCSS repository issues...');