Method saveAnalysisToDatabase

MCP/scripts/fetch-issues.js:511–539

(issueNumber, analysis)

  }

  async saveAnalysisToDatabase(issueNumber, analysis) {
    const insertSQL = `
      INSERT OR REPLACE INTO article_analysis 
      (issue_number, css_properties, techniques, complexity_level, 
       browser_support, use_cases, code_snippets, demo_links, related_articles)
      VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
    `;

    return new Promise((resolve, reject) => {
      this.db.run(
        insertSQL,
        [
          issueNumber,
          analysis.css_properties,
          analysis.techniques,
          analysis.complexity_level,
          analysis.browser_support,
          analysis.use_cases,
          analysis.code_snippets,
          analysis.demo_links,
          analysis.related_articles
        ],
        function(err) {
          if (err) reject(err);
          else resolve();
        }
      );
    });
  }

  async saveIssuesToDatabase(issues) {
    console.log('💾 Saving and analyzing issues...');