| 38 | |
| 39 | // 测试搜索功能 |
| 40 | function testSearch(db, resolve, reject) { |
| 41 | console.log('\n2️⃣ Testing search functionality...'); |
| 42 | |
| 43 | db.all('SELECT * FROM issues LIMIT 10', (err, rows) => { |
| 44 | if (err) { |
| 45 | console.error('❌ Search test failed:', err.message); |
| 46 | reject(err); |
| 47 | return; |
| 48 | } |
| 49 | |
| 50 | if (rows.length === 0) { |
| 51 | console.error('❌ No data found for search test'); |
| 52 | reject(new Error('No data found')); |
| 53 | return; |
| 54 | } |
| 55 | |
| 56 | console.log('✅ Sample data retrieved successfully'); |
| 57 | console.log(`✅ First article: "${rows[0].title}"`); |
| 58 | |
| 59 | // 测试Fuse.js搜索 |
| 60 | const fuseOptions = { |
| 61 | keys: [ |
| 62 | { name: 'title', weight: 0.4 }, |
| 63 | { name: 'search_content', weight: 0.4 }, |
| 64 | { name: 'labels', weight: 0.2 } |
| 65 | ], |
| 66 | threshold: 0.3, |
| 67 | includeScore: true |
| 68 | }; |
| 69 | |
| 70 | const fuse = new Fuse(rows, fuseOptions); |
| 71 | const results = fuse.search('flex'); |
| 72 | |
| 73 | console.log(`✅ Search test completed: found ${results.length} results for "flex"`); |
| 74 | |
| 75 | db.close(); |
| 76 | resolve(); |
| 77 | }); |
| 78 | } |
| 79 | |
| 80 | // 测试MCP SDK导入 |
| 81 | function testMCPSDK() { |