Method buildLabelHierarchy

MCP/scripts/fetch-issues.js:460–509

()

  }

  async buildLabelHierarchy() {
    console.log('🌳 Building label hierarchy...');
    
    // 基于预定义的分类构建层级关系
    for (const [category, labels] of Object.entries(this.labelCategories)) {
      // 将分类作为父节点
      for (const label of labels) {
        await new Promise((resolve, reject) => {
          this.db.run(
            `INSERT OR REPLACE INTO label_hierarchy (parent_label, child_label, relation_type)
             VALUES (?, ?, ?)`,
            [category, label, 'category'],
            (err) => {
              if (err) reject(err);
              else resolve();
            }
          );
        });
      }
    }
    
    // 基于标签共现关系构建关联
    const relatedLabelsSQL = `
      SELECT label1, label2, correlation_score
      FROM label_relations
      WHERE correlation_score > 0.5
      ORDER BY correlation_score DESC
    `;
    
    this.db.all(relatedLabelsSQL, [], async (err, rows) => {
      if (err) {
        console.error('Error building label hierarchy:', err);
        return;
      }
      
      for (const row of rows) {
        await new Promise((resolve, reject) => {
          this.db.run(
            `INSERT OR REPLACE INTO label_hierarchy (parent_label, child_label, relation_type)
             VALUES (?, ?, ?)`,
            [row.label1, row.label2, 'related'],
            (err) => {
              if (err) reject(err);
              else resolve();
            }
          );
        });
      }
    });
  }

  async saveAnalysisToDatabase(issueNumber, analysis) {
    const insertSQL = `