Method testQuery

MCP/test-inspiration.js:76–97

(testName, sql)

  }

  testQuery(testName, sql) {
    return new Promise((resolve, reject) => {
      this.db.all(sql, (err, rows) => {
        if (err) {
          console.error(`❌ ${testName} failed:`, err.message);
          reject(err);
        } else {
          console.log(`✅ ${testName}: ${rows.length} results`);
          if (rows.length > 0) {
            console.log('   Sample results:');
            rows.slice(0, 2).forEach((row, index) => {
              console.log(`   ${index + 1}.`, Object.keys(row).slice(0, 3).map(key => 
                `${key}: ${String(row[key]).substring(0, 30)}`
              ).join(', '));
            });
          }
          console.log('');
          resolve(rows);
        }
      });
    });
  }

  async testCodeSnippets() {
    console.log('🔍 Testing code snippets...\n');