Method saveToDatabase

MCP/scripts/fetch-inspiration.js:334–380

(category, filename, parsedContent)

  }

  async saveToDatabase(category, filename, parsedContent) {
    const insertSQL = `
      INSERT OR REPLACE INTO css_inspiration 
      (category, filename, title, description, html_content, css_content, 
       demo_url, source_url, tags, difficulty_level, browser_support, 
       search_content, updated_at)
      VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, CURRENT_TIMESTAMP)
    `;

    const sourceUrl = `https://github.com/chokcoco/CSS-Inspiration/blob/master/${category}/${filename}`;
    const demoUrl = `https://chokcoco.github.io/CSS-Inspiration/${category}/${filename.replace('.md', '.html')}`;
    
    const searchContent = [
      parsedContent.title,
      parsedContent.description,
      category,
      this.categoryMapping[category] || category,
      ...JSON.parse(parsedContent.tags)
    ].join(' ');

    return new Promise((resolve, reject) => {
      this.db.run(
        insertSQL,
        [
          category,
          filename,
          parsedContent.title,
          parsedContent.description,
          parsedContent.htmlContent,
          parsedContent.cssContent,
          demoUrl,
          sourceUrl,
          parsedContent.tags,
          parsedContent.difficultyLevel,
          parsedContent.browserSupport,
          searchContent
        ],
        function(err) {
          if (err) {
            reject(err);
          } else {
            resolve(this.lastID);
          }
        }
      );
    });
  }

  async extractAndSaveCodeSnippets(inspirationId, htmlContent, cssContent) {
    if (!htmlContent && !cssContent) return;