Method getRandomCssTip

MCP/server.js:688–762

(source = 'both')

  }

  async getRandomCssTip(source = 'both') {
    debugLog(`🎲 Getting random CSS tip (source: ${source})`);
    
    return new Promise((resolve, reject) => {
      let queries = [];

      if (source === 'both' || source === 'icss') {
        queries.push({
          sql: 'SELECT *, "icss" as source_type FROM issues ORDER BY RANDOM() LIMIT 1',
          params: []
        });
      }

      if (source === 'both' || source === 'inspiration') {
        queries.push({
          sql: 'SELECT *, "inspiration" as source_type FROM css_inspiration ORDER BY RANDOM() LIMIT 1',
          params: []
        });
      }

      // 随机选择一个查询
      const randomQuery = queries[Math.floor(Math.random() * queries.length)];

      this.db.get(randomQuery.sql, randomQuery.params, (err, row) => {
        if (err) {
          debugLog('❌ Error getting random tip:', err);
          reject(err);
          return;
        }

        if (!row) {
          reject(new Error('No content available'));
          return;
        }

        if (row.source_type === 'icss') {
          debugLog(`✅ Random iCSS tip: "${row.title}" (Issue #${row.number})`);

          const labels = row.labels ? JSON.parse(row.labels) : [];
          const preview = this.extractPreview(row.body);

          resolve({
            content: [
              {
                type: 'text',
                text: `🎲 **Random CSS Tip** (from iCSS): ${row.title}\n\n` +
                      `**Issue #${row.number}** | **Tags:** ${labels.join(', ')}\n\n` +
                      `${preview}\n\n` +
                      `[Read full article](${row.html_url})`
              }
            ]
          });
        } else {
          debugLog(`✅ Random CSS-Inspiration demo: "${row.title}" (ID #${row.id})`);

          const tags = row.tags ? JSON.parse(row.tags) : [];
          
          resolve({