本仓 2026-08-12 从 ssw main (192.168.1.18:13300/ssw/ssw-mvp) 的 dacli/ subpath 抽取,作为独立仓托管到 gitea:3000/ssw/dacli.git。 - 工作树为 ssw main dacli subpath 最新版 (110 commit, 08-12) - 历史未带 ssw main 整体历史(避免大仓污染) - 此为新仓基线 commit,未来以本仓历史为主
113 lines
5.2 KiB
TypeScript
113 lines
5.2 KiB
TypeScript
/**
|
|
* test-kb.ts — KB 闭环测试 (假设 pg 已运行)
|
|
* 运行: cd dacli && npx tsx tests/test-kb.ts
|
|
*/
|
|
import { query, execute, close, SCHEMA } from '../src/commands/kb/_client.ts';
|
|
import { search } from '../src/commands/kb/_search.ts';
|
|
|
|
async function test() {
|
|
console.log('=== KB 闭环测试 ===\n');
|
|
|
|
// 1. 清理测试数据
|
|
console.log('1. 清理 test-kb-domain...');
|
|
await execute(`DELETE FROM ${SCHEMA}.domains WHERE domain = 'test-kb-domain'`);
|
|
console.log(' ✓\n');
|
|
|
|
// 2. 新建域
|
|
console.log('2. 新建 test-kb-domain...');
|
|
await execute(
|
|
`INSERT INTO ${SCHEMA}.domains (domain, title, tags, keywords) VALUES ($1, $2, $3, $4)`,
|
|
['test-kb-domain', '测试域', ['test'], ['test keyword']]
|
|
);
|
|
const domainId = (await query<{id:number}>(`SELECT id FROM ${SCHEMA}.domains WHERE domain = $1`, ['test-kb-domain']))[0].id;
|
|
await execute(`INSERT INTO ${SCHEMA}.source_files (domain_id, path) VALUES ($1, $2)`, [domainId, 'test/path.md']);
|
|
console.log(` ✓ Domain id=${domainId}\n`);
|
|
|
|
// 3. 新增条目
|
|
console.log('3. 新增条目...');
|
|
const r1 = await query<{id:number}>(
|
|
`INSERT INTO ${SCHEMA}.entries (domain_id, section, content) VALUES ($1, $2, $3) RETURNING id`,
|
|
[domainId, '关键决策', '**decision**: test 关键决策']
|
|
);
|
|
const r2 = await query<{id:number}>(
|
|
`INSERT INTO ${SCHEMA}.entries (domain_id, section, content) VALUES ($1, $2, $3) RETURNING id`,
|
|
[domainId, '踩坑教训', '**lesson**: test 踩坑教训']
|
|
);
|
|
console.log(` ✓ Entry #${r1[0].id} and #${r2[0].id}\n`);
|
|
|
|
// 4. 检索 (FTS)
|
|
console.log('4. search "test"...');
|
|
const results = await search({ query: 'test', limit: 5 });
|
|
console.log(` ✓ Found ${results.length} results`);
|
|
console.log(` [${results[0].domain}/${results[0].section}] ${results[0].snippet.slice(0, 80)}...\n`);
|
|
|
|
// 5. 过期测试
|
|
console.log('5. expire #1 to past...');
|
|
await execute(`UPDATE ${SCHEMA}.entries SET expires_on = '2026-07-01' WHERE id = $1`, [r1[0].id]);
|
|
const afterExpire = await search({ query: 'test', limit: 5 });
|
|
console.log(` ✓ After expire: ${afterExpire.length} results (was ${results.length})\n`);
|
|
|
|
// 6. search --all
|
|
console.log('6. search --all "test"...');
|
|
const allResults = await search({ query: 'test', includeAll: true, limit: 5 });
|
|
console.log(` ✓ Found ${allResults.length} results (all status)\n`);
|
|
|
|
// 7. renew
|
|
console.log('7. renew #1...');
|
|
await execute(`UPDATE ${SCHEMA}.entries SET expires_on = NULL, last_reviewed = NOW() WHERE id = $1`, [r1[0].id]);
|
|
const afterRenew = await search({ query: 'test', limit: 5 });
|
|
console.log(` ✓ After renew: ${afterRenew.length} results\n`);
|
|
|
|
// 8. archive
|
|
console.log('8. archive #2...');
|
|
await execute(`UPDATE ${SCHEMA}.entries SET status = 'archived' WHERE id = $1`, [r2[0].id]);
|
|
const afterArchive = await search({ query: 'test', limit: 5 });
|
|
console.log(` ✓ After archive: ${afterArchive.length} results\n`);
|
|
|
|
// 9. CJK 子串检索 (trigram + ILIKE 兜底)
|
|
console.log('9. search CJK "关键决策" via ILIKE fallback (matches section name)...');
|
|
await execute(`UPDATE ${SCHEMA}.entries SET status = 'active' WHERE id = $1`, [r2[0].id]); // 恢复 #2
|
|
const cjkResults = await search({ query: '关键决策', limit: 5 });
|
|
console.log(` ✓ Found ${cjkResults.length} results (expected ≥1)`);
|
|
if (cjkResults.length < 1) throw new Error(`CJK search should match section 关键决策, got ${cjkResults.length}`);
|
|
console.log();
|
|
|
|
// 10. CJK trigram 模糊 (3 字 query, 命中 content)
|
|
console.log('10. search CJK "踩坑教训" (trigram 模糊 + ILIKE)...');
|
|
const trigramResults = await search({ query: '踩坑教训', limit: 5 });
|
|
console.log(` ✓ Found ${trigramResults.length} results (expected ≥1)`);
|
|
if (trigramResults.length < 1) throw new Error('CJK search should match 踩坑教训');
|
|
console.log();
|
|
|
|
// 10b. 插入含 trigram 难字的新条目, 验证短查询命中
|
|
console.log('10b. insert CJK content + search 3-char query...');
|
|
await execute(
|
|
`INSERT INTO ${SCHEMA}.entries (domain_id, section, content) VALUES ($1, '中文', '这是测试条目内容含中文段落')`,
|
|
[domainId]
|
|
);
|
|
const trigramShort = await search({ query: '测试条目', limit: 5 });
|
|
console.log(` ✓ Found ${trigramShort.length} results (expected ≥1)`);
|
|
if (trigramShort.length < 1) throw new Error('CJK short trigram should match 测试条目');
|
|
console.log();
|
|
|
|
// 11. domain 过滤
|
|
console.log('11. search with --domain filter...');
|
|
const domainFilter = await search({ query: 'test', domain: 'test-kb-domain', limit: 5 });
|
|
const noDomain = await search({ query: 'test', domain: 'nonexistent', limit: 5 });
|
|
console.log(` ✓ With domain= '${domainFilter.length}', nonexistent= '${noDomain.length}' (expected 0)`);
|
|
if (noDomain.length !== 0) throw new Error('Domain filter should return 0 for nonexistent domain');
|
|
console.log();
|
|
|
|
// 12. 清理
|
|
console.log('12. 清理 test-kb-domain...');
|
|
await execute(`DELETE FROM ${SCHEMA}.domains WHERE domain = 'test-kb-domain'`);
|
|
console.log(' ✓\n');
|
|
|
|
console.log('=== 全部测试通过 ✓ (12 步: 8 原始 + CJK + domain filter) ===');
|
|
await close();
|
|
}
|
|
|
|
test().catch(e => {
|
|
console.error('✗ Test failed:', e);
|
|
process.exit(1);
|
|
}); |