Method getCssDemo

MCP/server.js:510–572

(demoId)

  }

  async getCssDemo(demoId) {
    debugLog(`🎯 Getting CSS demo #${demoId}`);
    
    return new Promise((resolve, reject) => {
      // 获取基本信息
      this.db.get(
        'SELECT * FROM css_inspiration WHERE id = ?',
        [demoId],
        (err, row) => {
          if (err) {
            debugLog(`❌ Database error for demo #${demoId}:`, err);
            reject(err);
            return;
          }

          if (!row) {
            debugLog(`❌ Demo #${demoId} not found`);
            reject(new Error(`CSS demo with ID ${demoId} not found`));
            return;
          }

          // 获取完整的演示代码
          this.db.get(
            'SELECT * FROM demo_styles WHERE inspiration_id = ?',
            [demoId],
            (err, demoRow) => {
              if (err) {
                debugLog(`❌ Error getting demo styles for #${demoId}:`, err);
                reject(err);
                return;
              }

              debugLog(`✅ Found demo #${demoId}: "${row.title}"`);

              const tags = JSON.parse(row.tags || '[]');
              const browserSupport = JSON.parse(row.browser_support || '{}');

              resolve({
                content: [
                  {
                    type: 'text',
                    text: `# ${row.title}\n\n` +
                          `**Category:** ${row.category} | **Difficulty:** ${row.difficulty_level}\n\n` +
                          `**Description:** ${row.description}\n\n` +
                          `**Tags:** ${tags.join(', ')}\n\n` +
                          `**Browser Support:**\n` +
                          Object.entries(browserSupport).map(([browser, support]) => 
                            `- ${browser}: ${support}`
                          ).join('\n') + '\n\n' +
                          `## HTML Code\n\n\`\`\`html\n${row.html_content || '<div class="demo">Demo</div>'}\n\`\`\`\n\n` +
                          `## CSS Code\n\n\`\`\`css\n${row.css_content}\n\`\`\`\n\n` +
                          (demoRow ? `## Complete Demo\n\n\`\`\`html\n${demoRow.complete_html}\n\`\`\`\n\n` : '') +
                          `**Demo URL:** ${row.demo_url}\n` +
                          `**Source:** ${row.source_url}`
                  }
                ]
              });
            }