Class InspirationTester

MCP/test-inspiration.js:10–195

const __dirname = path.dirname(__filename);

class InspirationTester {
  constructor() {
    this.dbPath = path.join(__dirname, 'data', 'icss.db');
    this.db = new Database.Database(this.dbPath, (err) => {
      if (err) {
        console.error('❌ Error opening database:', err);
        process.exit(1);
      }
    });
  }

  async testDatabaseIntegrity() {
    console.log('🔍 Testing database integrity...\n');
    
    // 测试表是否存在
    const tables = [
      'issues',
      'css_inspiration', 
      'code_snippets',
      'demo_styles'
    ];

    for (const table of tables) {
      await this.checkTable(table);
    }
  }

  checkTable(tableName) {
    return new Promise((resolve, reject) => {
      this.db.get(
        `SELECT COUNT(*) as count FROM ${tableName}`,
        (err, row) => {
          if (err) {
            console.error(`❌ Table ${tableName} error:`, err.message);
            reject(err);
          } else {
            console.log(`✅ Table ${tableName}: ${row.count} records`);
            resolve(row.count);
          }
        }
      );
    });
  }

  async testSearchFunctionality() {
    console.log('\n🔍 Testing search functionality...\n');
    
    // 测试 CSS-Inspiration 搜索
    await this.testQuery(
      'CSS-Inspiration Search',
      `SELECT * FROM css_inspiration WHERE search_content LIKE '%动画%' LIMIT 3`
    );

    // 测试分类统计
    await this.testQuery(
      'Category Statistics',
      `SELECT category, COUNT(*) as count FROM css_inspiration GROUP BY category ORDER BY count DESC LIMIT 5`
    );