joaoh82 / rust_sqlite / 25233492072

69%

push

github

Phase 7g.5: Node.js SDK db.ask() / askRun() / AskConfig (#66)

napi-rs wrappers for natural-language → SQL via the engine's
`sqlrite::ask` module. Mirrors Python SDK 7g.4 with idiomatic JS
API shape (camelCase option-object instead of kwargs).

## Public surface

```js
import { Database, AskConfig } from '@joaoh82/sqlrite';

const db = new Database('foo.sqlrite');

// Path 1: env var (zero config — same env as REPL/Desktop/Python)
const resp = db.ask('How many users are over 30?');

// Path 2: explicit per-call config (overrides env)
const cfg = new AskConfig({
  apiKey: 'sk-ant-...',
  model: 'claude-haiku-4-5',
  maxTokens: 512,
  cacheTtl: '1h',
});
const resp = db.ask('How many users?', cfg);

// Path 3: per-connection config (set once, reuse)
db.setAskConfig(cfg);
const resp = db.ask('How many users?');

// Convenience: generate + execute in one call
const rows = db.askRun('list active users');
```

## What's new

  * `new AskConfig({apiKey, model, maxTokens, cacheTtl, baseUrl})` —
    camelCase option-object constructor. Each field optional; missing
    fields fall back to defaults (anthropic / claude-sonnet-4-6 /
    1024 / 5m).
  * `AskConfig.fromEnv()` — reads SQLRITE_LLM_* env vars.
  * `cfg.hasApiKey` / `cfg.model` / `cfg.maxTokens` / `cfg.cacheTtl` /
    `cfg.provider` — getters. Note `hasApiKey` (boolean) instead of
    exposing the key value.
  * `cfg.toString()` — human-readable representation that
    deliberately omits the API key value (shows `<set>` or `null`).
  * `Database.ask(question, config?)` → `AskResponse { sql,
    explanation, usage }`. Does NOT execute.
  * `Database.askRun(question, config?)` → executes generated SQL,
    returns rows directly (`Array<Object>`). Throws on empty SQL
    response (model declined) with the model's explanation.
  * `Database.setAskConfig(config | null)` — per-connection storage.
  * Auto-generated TypeScript types in `index.d.ts` for
    `AskConfigOptions`, `AskResponse`, `AskUsage` interfac... (continued)

0 of 102 new or added lines in 1 file covered. (0.0%)

5496 of 9536 relevant lines covered (57.63%)

1.18 hits per line