Method loadSearchIndex

MCP/debug-local.js:69–144

()

  }

  loadSearchIndex() {
    debugLog('🔍 Loading search index...');
    
    const query = `
      SELECT 
        i.*,
        GROUP_CONCAT(DISTINCT al.label) as tags,
        GROUP_CONCAT(DISTINCT al.category) as categories,
        GROUP_CONCAT(DISTINCT al.weight) as weights,
        GROUP_CONCAT(DISTINCT lc.description) as tag_descriptions
      FROM issues i
      LEFT JOIN article_labels al ON i.number = al.issue_number
      LEFT JOIN label_categories lc ON al.label = lc.label
      GROUP BY i.number
    `;

    this.db.all(query, [], (err, rows) => {
      if (err) {
        console.error('❌ Error loading search index:', err);
        this.dbInitFailed = true;
        return;
      }

      debugLog(`📊 Loaded ${rows.length} articles for search index`);

      // 处理数据
      const processedRows = rows.map(row => {
        const tags = row.tags ? row.tags.split(',') : [];
        const categories = row.categories ? row.categories.split(',') : [];
        const weights = row.weights ? row.weights.split(',').map(Number) : [];
        const descriptions = row.tag_descriptions ? row.tag_descriptions.split(',') : [];
        
        // 解析 JSON 格式的标签
        let labels = [];
        try {
          labels = row.labels ? JSON.parse(row.labels) : [];
        } catch (e) {
          debugLog(`⚠️ Failed to parse labels for issue #${row.number}`);
        }
        
        return {
          ...row,
          tags,
          categories,
          weights,
          descriptions,
          labels,
          // 合并所有可搜索的文本
          searchContent: [
            row.title,
            row.body,
            ...tags,
            ...categories,
            ...descriptions,
            ...labels
          ].filter(Boolean).join(' ')
        };
      });