Method generateStats

MCP/scripts/fetch-inspiration.js:552–595

()

  }

  generateStats() {
    console.log('\n📊 CSS-Inspiration Statistics:');
    
    this.db.all(`
      SELECT 
        category, 
        COUNT(*) as count,
        difficulty_level
      FROM css_inspiration 
      GROUP BY category, difficulty_level
      ORDER BY category, difficulty_level
    `, (err, rows) => {
      if (err) {
        console.error('Error generating stats:', err);
        return;
      }

      const stats = {};
      rows.forEach(row => {
        if (!stats[row.category]) {
          stats[row.category] = {};
        }
        stats[row.category][row.difficulty_level] = row.count;
      });

      Object.entries(stats).forEach(([category, difficulties]) => {
        const total = Object.values(difficulties).reduce((sum, count) => sum + count, 0);
        console.log(`   ${this.categoryMapping[category] || category}: ${total} 个案例`);
        Object.entries(difficulties).forEach(([level, count]) => {
          console.log(`     - ${level}: ${count} 个`);
        });
      });

      // 总体统计
      this.db.get('SELECT COUNT(*) as total FROM css_inspiration', (err, row) => {
        if (!err && row) {
          console.log(`\n   📈 总计: ${row.total} 个 CSS 演示案例`);
        }
        
        console.log('\n🎉 CSS-Inspiration 数据导入完成!');
        process.exit(0);
      });
    });
  }

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