Repository navigation
Expand file tree
/
Copy pathtest-sqlite-e2e.ts
More file actions
87 lines (73 loc) · 3.3 KB
/
Copy pathtest-sqlite-e2e.ts
File metadata and controls
87 lines (73 loc) · 3.3 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
// @ts-nocheck
import fs from 'node:fs';
import path from 'node:path';
import os from 'node:os';
import { DatabaseSync } from 'node:sqlite';
// create a real db
const dir = fs.mkdtempSync(path.join(os.tmpdir(), 'sqlite-e2e-'));
const dbPath = path.join(dir, 'sample.db');
console.log('dir', dir);
const db = new DatabaseSync(dbPath);
db.exec('CREATE TABLE users(id INTEGER PRIMARY KEY, name TEXT, active INTEGER); INSERT INTO users(name,active) VALUES ("alice",1),("bob",0),("carol",1); CREATE TABLE logs(id INTEGER PRIMARY KEY, msg TEXT);');
db.close();
console.log('db at', dbPath, 'exists', fs.existsSync(dbPath));
import { Effect, Layer } from 'effect';
import { SqliteTool } from 'opencode/src/tool/sqlite.ts';
import { InstanceRef } from 'opencode/src/effect/instance-ref.ts';
const ctx = {
sessionID: 'ses_test' as any,
messageID: 'msg_test' as any,
callID: 'test-call',
agent: 'build',
abort: AbortSignal.any([]),
messages: [],
metadata: () => Effect.void,
ask: (req: any) => Effect.sync(() => {
console.log('[ask]', req.permission, JSON.stringify(req.metadata));
}),
} as any;
const program = Effect.gen(function* () {
const toolInfo = yield* SqliteTool;
const tool = yield* toolInfo.init();
// SqliteTool.execute does NOT use ChildProcessSpawner anywhere now
const tables = yield* tool.execute({ action: "tables", db: "sample.db" }, ctx);
console.log('=== TABLES ===');
console.log(tables.output);
console.log('metadata', JSON.stringify(tables.metadata));
const schema = yield* tool.execute({ action: "schema", db: "sample.db" }, ctx);
console.log('=== SCHEMA ===');
console.log(schema.output);
const query = yield* tool.execute({ action: "query", db: "sample.db", sql: "SELECT name, active FROM users WHERE active = ? ORDER BY name", params: [1] }, ctx);
console.log('=== QUERY active=1 ===');
console.log(query.output);
console.log('metadata', JSON.stringify(query.metadata));
const dry = yield* tool.execute({ action: "run", db: "sample.db", sql: "INSERT INTO users(name, active) VALUES ('dave', 1)" }, ctx);
console.log('=== RUN dryRun ===');
console.log(dry.output);
const commit = yield* tool.execute({ action: "run", db: "sample.db", sql: "INSERT INTO users(name, active) VALUES ('eve', 1)", dryRun: false }, ctx);
console.log('=== RUN commit ===');
console.log(commit.output);
const exp = yield* tool.execute({ action: "explain", db: "sample.db", sql: "SELECT * FROM users WHERE active = 1" }, ctx);
console.log('=== EXPLAIN ===');
console.log(exp.output);
const expCsv = yield* tool.execute({ action: "export", db: "sample.db", sql: "SELECT name, active FROM users ORDER BY name", format: "csv", outputPath: "out/users.csv" }, ctx);
console.log('=== EXPORT ===');
console.log(expCsv.output);
console.log('csv content', fs.readFileSync(path.join(dir, 'out', 'users.csv'), 'utf8'));
return 'done';
});
const layer = Layer.succeed(InstanceRef, {
directory: dir,
worktree: dir,
} as any);
const final = Effect.provide(layer)(program);
const result = await Effect.runPromise(final);
console.log('RESULT', result);
console.log('ALL DONE');
// verify db changes
{
const verify = new DatabaseSync(dbPath, { readOnly: true });
console.log('final users', verify.prepare('SELECT * FROM users').all());
verify.close();
}
fs.rmSync(dir, { recursive: true, force: true });