Method testCategories

MCP/debug.js:136–179

()

  }

  async testCategories() {
    console.log('\n🏷️ Testing categories listing');
    
    return new Promise((resolve, reject) => {
      this.db.all(
        'SELECT labels, COUNT(*) as count FROM issues WHERE labels IS NOT NULL GROUP BY labels LIMIT 10',
        (err, rows) => {
    if (err) {
            console.error('❌ Categories query failed:', err.message);
            reject(err);
            return;
          }

          console.log(`✅ Found ${rows.length} label groups`);
          
          const categoryMap = new Map();
          
          rows.forEach(row => {
            if (row.labels) {
              try {
                const labels = JSON.parse(row.labels);
                labels.forEach(label => {
                  categoryMap.set(label, (categoryMap.get(label) || 0) + row.count);
                });
              } catch (parseErr) {
                console.warn(`⚠️ Failed to parse labels: ${row.labels}`);
              }
            }
          });

          const topCategories = Array.from(categoryMap.entries())
            .sort((a, b) => b[1] - a[1])
            .slice(0, 10);

          console.log('📊 Top categories:');
          topCategories.forEach(([label, count]) => {
            console.log(`   • ${label}: ${count} articles`);
          });
          
          resolve(topCategories);
        }
      );
    });
  }

  close() {
    if (this.db) {