Class InspirationFetcher

MCP/scripts/fetch-inspiration.js:13–600

const __dirname = path.dirname(__filename);

class InspirationFetcher {
  constructor() {
    this.baseURL = 'https://api.github.com/repos/chokcoco/CSS-Inspiration';
    this.rawURL = 'https://raw.githubusercontent.com/chokcoco/CSS-Inspiration/master';
    this.dbPath = path.join(__dirname, '../data/icss.db');
    this.dataDir = path.join(__dirname, '../data');
    
    // GitHub Token
    this.githubToken = process.env.GITHUB_TOKEN;
    if (!this.githubToken) {
      console.warn('⚠️ No GITHUB_TOKEN found in environment variables. API rate limits will be restricted.');
    }
    
    // 确保数据目录存在
    if (!fs.existsSync(this.dataDir)) {
      fs.mkdirSync(this.dataDir, { recursive: true });
    }
    
    // 初始化数据库连接
    this.db = new Database.Database(this.dbPath, (err) => {
      if (err) {
        console.error('❌ Error opening database:', err);
        process.exit(1);
      }
    });

    // CSS-Inspiration 分类映射
    this.categoryMapping = {
      '3d': '3D 效果',
      'animation': '动画效果',
      'background': '背景效果',
      'blendmode': '混合模式',
      'border': '边框效果',
      'clippath': '裁剪路径',
      'cssdoodle': 'CSS-doodle',
      'filter': '滤镜效果',
      'layout': '布局技术',
      'others': '综合技巧',
      'pesudo': '伪类/伪元素',
      'shadow': '阴影效果',
      'svg': 'SVG 技术',
      'text': '文字效果'
    };

    this.initializeDatabase();
  }

  initializeDatabase() {
    console.log('🔧 Initializing CSS-Inspiration tables...');
    
    // CSS-Inspiration 项目表
    const createInspirationTableSQL = `
      CREATE TABLE IF NOT EXISTS css_inspiration (
        id INTEGER PRIMARY KEY,
        category TEXT NOT NULL,
        filename TEXT NOT NULL,
        title TEXT NOT NULL,
        description TEXT,