Method updateRelatedArticles

MCP/scripts/fetch-issues.js:614–652

()

  }

  async updateRelatedArticles() {
    console.log('🔄 Updating article relations...');
    
    // 获取所有文章的分析数据
    const articles = await new Promise((resolve, reject) => {
      this.db.all(`
        SELECT 
          i.number,
          i.title,
          a.css_properties,
          a.techniques,
          a.complexity_level
        FROM issues i
        JOIN article_analysis a ON i.number = a.issue_number
      `, (err, rows) => {
        if (err) reject(err);
        else resolve(rows);
      });
    });

    // 计算文章间的相关性
    for (const article of articles) {
      const related = articles
        .filter(other => other.number !== article.number)
        .map(other => {
          const score = this.calculateRelationScore(article, other);
          return { number: other.number, score };
        })
        .sort((a, b) => b.score - a.score)
        .slice(0, 5)  // 取前5个最相关的文章
        .map(r => r.number);

      // 更新相关文章
      await this.saveAnalysisToDatabase(article.number, {
        ...article,
        related_articles: JSON.stringify(related)
      });
    }
  }

  calculateRelationScore(article1, article2) {
    let score = 0;