mirror of
https://github.com/diegosouzapw/OmniRoute.git
synced 2026-07-26 09:52:11 +03:00
* perf: extract recharts into dynamic import wrappers
Bundle recharts behind next/dynamic boundaries to prevent its
large module graph from being included in the initial JS payload.
- CostOverviewTab.tsx → dynamic(() => import('./components/CostCharts'))
- ProviderUtilizationTab.tsx → dynamic(() => import('./components/ProviderCharts'))
- BurnRateChart.tsx → dynamic(() => import('./components/BurnRateChartInner'))
- Created 3 wrapper files with 'use client' and all recharts imports
Reduces initial bundle by ~35 kB (recharts + dependencies).
* perf: add pagination (limit/offset) to apiKeys, combos, providers, provider-nodes
Add optional limit/offset parameters to DB list functions and their
API route handlers. All list functions now return { items, total } when
called with parameters; backward compatible when called without args.
Affected modules:
- lib/db/apiKeys.ts - listApiKeys, getApiKeysByGroup
- lib/db/combos.ts - listCombos
- lib/db/providers.ts - listProviders, getProvidersByGroup
- lib/db/providers/nodes.ts - listProviderNodes, getProviderNodesByGroup
- Corresponding API routes pass through query params
Reduces memory pressure on large datasets by returning one page at a time.
* perf: add pagination (limit/offset) to webhooks, proxies, modelComboMappings, playgroundPresets
Add optional limit/offset parameters to DB list functions and their
API route handlers for the remaining data modules.
Affected modules:
- lib/db/webhooks.ts - getWebhooks returns { webhooks, total }
- lib/db/proxies.ts - listProxies
- lib/db/modelComboMappings.ts - listMappings
- lib/db/playgroundPresets.ts - listPresets
- Corresponding API routes pass through query params
- Re-exports updated: lib/localDb.ts, models/index.ts
Backward compatible: calling without args returns all rows.
* perf: batch pool building and add pagination to quotaPools
Replace per-pool N+1 queries with batch-loading pattern.
- Added batchBuildPools(rows) — collects all pool IDs, does 2 batch
queries (allocations + connections) instead of 2N individual queries
- getPoolsByGroup and listPools now use batchBuildPools
- Added optional limit/offset pagination params
- Fixed SQLite OFFSET-syntax bug: only emit OFFSET when LIMIT also present
- Added quota-pools.test.ts with 10 tests covering pagination edge cases,
batch loading, and the offset-without-limit guard
Reduces pool-page query count from 2N+1 to 3 (constant).
* perf: replace manual offset/limit parsing with Zod paginationSchema in combos GET handler
* fix: replace manual Number()/parseInt pagination with paginationSchema
Endpoints: model-combo-mappings, playground/presets, provider-nodes.
Uses existing Zod schema with z.coerce.number() for proper validation.
* chore: bump proxies.ts frozen baseline 1177->1208 for perf/api-pagination
PR #7046 backward-compatible pagination refactor grew proxies.ts
by +31 lines (1177->1208). Entries return plain array when no
pagination params provided, {items,total} when pagination requested.
* fix(db): finish listProxies()/getWebhooks() pagination shape migration
The pagination refactor changed listProxies(), listPools(),
getModelComboMappings(), listPlaygroundPresets() and getWebhooks() to
return a paginated envelope ({ items, total } / { webhooks, total })
instead of a bare array, but left three real production callers and
several tests on the old array-shaped API:
- src/lib/proxyEgress.ts (validateProxyPool default listProxies impl)
iterated the envelope directly -> "is not iterable" at runtime, hit
by /api/settings/proxies/egress (no injected deps).
- src/lib/proxyHealth/scheduler.ts (sweep()) read proxies.length on the
envelope (undefined), so the health-check sweep silently processed
zero proxies every run.
- open-sse/utils/proxyFallback.ts (getProxyCandidates()) iterated the
envelope inside a try/catch that swallowed the resulting TypeError,
so every user-configured proxy silently vanished from the fallback
candidate list.
Also fixes two TS2558/TS2339 typecheck errors in proxies.ts/webhooks.ts
(db.prepare<T>() generic not supported by this DB wrapper — cast the
query result instead, matching the existing pattern in both files) and
trims one blank re-export separator line in localDb.ts to stay within
the frozen file-size ratchet after 4 new *Count() exports.
Updates the pre-existing unit tests that called the changed functions
directly (db-quota-pools, quota-groups-migration, quota-pool-connections,
quota-pool-delete-prune, db-webhooks, model-combo-mappings-db,
db-playground-presets, db-proxies-crud, proxy-batch-routes-5918,
proxy-registry, error-message-sanitization) to destructure the new
envelope shape instead of treating the result as an array.
Implements the small, well-scoped performance-mark/measure
instrumentation ("omni-pipeline-start"/"omni-pipeline-end"/"omni-pipeline")
that tests/unit/chatcore-streaming-pipeline.test.ts already asserted for
assembleStreamingPipeline() but that had no corresponding source change.
Adds three new regression tests (TDD: each reproduces its bug against
the pre-fix code before the corresponding fix, then passes) covering
the three real production callers above:
tests/unit/proxy-egress-validate-pool-default.test.ts,
tests/unit/proxy-health-scheduler-listproxies-shape.test.ts,
tests/unit/proxy-fallback-candidates-listproxies-shape.test.ts.
Co-authored-by: diegosouzapw <diegosouza.pw@gmail.com>
* fix: resolve rebase conflict in proxies.ts — keep hasBlockingProxyAssignment but drop duplicate extraction leftovers
- Removed duplicate resolveScopePoolInternal, resolveProxyForConnectionFromRegistry,
resolveProxyForScopeFromRegistry already extracted to proxies/rotation.ts
- Removed duplicate hasBlockingProxyAssignment function body already re-exported from proxies/guards.ts
- Removed duplicate PROXY_ALIVE_PREDICATE import
- All typechecks and 45 affected tests pass
* fix(test): account for _reorderConnections in pagination test expectedOrder
createProviderConnection calls _reorderConnections after every insert
which reassigns priorities sequentially. The test was assuming creation
order determines priority order, leading to incorrect expected results.
Fix: query the DB after all inserts and use the actual priority order.
Also removes debug console.log from getRawProviderConnections.
* chore: remove debug tmp-*.mjs files left in PR branch
* test(proxy): migrate the dedup test to the paginated listProxies() shape
#7046 changed listProxies() to return { items, total }, and updated every
production caller plus three of the four test files — tests/unit/proxy-bulk-import-dedup-7594.test.ts
was missed, so its four `listed.length` assertions read `undefined` and the
file went red on the merge train (it passes on the pure release tip).
Test-only: destructure `{ items: listed }` at the four callsites. Verified
proxyEgress.ts needs no change — its local deps shim already unwraps .items,
and tests/unit/proxy-egress-validate-pool-default.test.ts guards exactly that.
Co-authored-by: diegosouzapw <8016841+diegosouzapw@users.noreply.github.com>
---------
Co-authored-by: oyi77 <oyi77@users.noreply.github.com>
Co-authored-by: diegosouzapw <diegosouza.pw@gmail.com>
Co-authored-by: diegosouzapw <8016841+diegosouzapw@users.noreply.github.com>
232 lines
6.8 KiB
TypeScript
232 lines
6.8 KiB
TypeScript
import test from "node:test";
|
|
import assert from "node:assert/strict";
|
|
import fs from "node:fs";
|
|
import os from "node:os";
|
|
import path from "node:path";
|
|
|
|
const TEST_DATA_DIR = fs.mkdtempSync(path.join(os.tmpdir(), "omniroute-model-combo-db-"));
|
|
process.env.DATA_DIR = TEST_DATA_DIR;
|
|
|
|
const core = await import("../../src/lib/db/core.ts");
|
|
const combosDb = await import("../../src/lib/db/combos.ts");
|
|
const mappingsDb = await import("../../src/lib/db/modelComboMappings.ts");
|
|
|
|
async function resetStorage() {
|
|
core.resetDbInstance();
|
|
fs.rmSync(TEST_DATA_DIR, { recursive: true, force: true });
|
|
fs.mkdirSync(TEST_DATA_DIR, { recursive: true });
|
|
}
|
|
|
|
test.beforeEach(async () => {
|
|
await resetStorage();
|
|
});
|
|
|
|
test.after(() => {
|
|
core.resetDbInstance();
|
|
fs.rmSync(TEST_DATA_DIR, { recursive: true, force: true });
|
|
});
|
|
|
|
async function createCombo(name, model, overrides = {}) {
|
|
return combosDb.createCombo({
|
|
name,
|
|
models: [{ provider: "openai", model }],
|
|
strategy: "priority",
|
|
config: { temperature: 0 },
|
|
...overrides,
|
|
});
|
|
}
|
|
|
|
test("model combo mappings CRUD joins combo names and preserves ordering", async () => {
|
|
const comboA = await createCombo("alpha", "gpt-4o");
|
|
const comboB = await createCombo("beta", "claude-sonnet-4");
|
|
|
|
const first = await mappingsDb.createModelComboMapping({
|
|
pattern: "gpt-*",
|
|
comboId: comboA.id,
|
|
priority: 20,
|
|
description: "primary",
|
|
});
|
|
const second = await mappingsDb.createModelComboMapping({
|
|
pattern: "claude-*",
|
|
comboId: comboB.id,
|
|
priority: 20,
|
|
enabled: false,
|
|
});
|
|
|
|
const { items: all } = await mappingsDb.getModelComboMappings();
|
|
|
|
assert.equal(all.length, 2);
|
|
assert.equal(all[0].id, first.id);
|
|
assert.equal(all[0].comboName, "alpha");
|
|
assert.equal(all[0].enabled, true);
|
|
assert.equal(all[0].description, "primary");
|
|
assert.equal(all[1].id, second.id);
|
|
assert.equal(all[1].comboName, "beta");
|
|
assert.equal(all[1].enabled, false);
|
|
|
|
const fetched = await mappingsDb.getModelComboMappingById(first.id);
|
|
assert.equal(fetched?.pattern, "gpt-*");
|
|
assert.equal(fetched?.comboName, "alpha");
|
|
assert.equal(fetched?.priority, 20);
|
|
});
|
|
|
|
test("updateModelComboMapping merges fields and returns the refreshed mapping", async () => {
|
|
const comboA = await createCombo("alpha", "gpt-4o");
|
|
const comboB = await createCombo("beta", "claude-sonnet-4");
|
|
|
|
const created = await mappingsDb.createModelComboMapping({
|
|
pattern: "gpt-*",
|
|
comboId: comboA.id,
|
|
priority: 1,
|
|
});
|
|
|
|
await new Promise((r) => setTimeout(r, 10));
|
|
|
|
const updated = await mappingsDb.updateModelComboMapping(created.id, {
|
|
pattern: "claude-*",
|
|
comboId: comboB.id,
|
|
priority: 99,
|
|
enabled: false,
|
|
description: "rerouted",
|
|
});
|
|
|
|
assert.ok(updated);
|
|
assert.equal(updated?.id, created.id);
|
|
assert.equal(updated?.pattern, "claude-*");
|
|
assert.equal(updated?.comboId, comboB.id);
|
|
assert.equal(updated?.comboName, "beta");
|
|
assert.equal(updated?.priority, 99);
|
|
assert.equal(updated?.enabled, false);
|
|
assert.equal(updated?.description, "rerouted");
|
|
assert.notEqual(updated?.updatedAt, created.updatedAt);
|
|
});
|
|
|
|
test("updateModelComboMapping returns null for unknown ids", async () => {
|
|
const updated = await mappingsDb.updateModelComboMapping("missing-id", {
|
|
pattern: "gpt-*",
|
|
});
|
|
|
|
assert.equal(updated, null);
|
|
});
|
|
|
|
test("deleteModelComboMapping reports whether a row existed", async () => {
|
|
const combo = await createCombo("alpha", "gpt-4o");
|
|
const created = await mappingsDb.createModelComboMapping({
|
|
pattern: "gpt-*",
|
|
comboId: combo.id,
|
|
});
|
|
|
|
assert.equal(await mappingsDb.deleteModelComboMapping(created.id), true);
|
|
assert.equal(await mappingsDb.deleteModelComboMapping(created.id), false);
|
|
assert.equal(await mappingsDb.getModelComboMappingById(created.id), null);
|
|
});
|
|
|
|
test("resolveComboForModel returns the highest-priority enabled combo", async () => {
|
|
const fallbackCombo = await createCombo("fallback", "gpt-4o-mini");
|
|
const priorityCombo = await createCombo("priority", "gpt-4o");
|
|
const disabledCombo = await createCombo("disabled", "gpt-4.1");
|
|
|
|
await mappingsDb.createModelComboMapping({
|
|
pattern: "*",
|
|
comboId: fallbackCombo.id,
|
|
priority: 1,
|
|
});
|
|
await mappingsDb.createModelComboMapping({
|
|
pattern: "gpt-4*",
|
|
comboId: priorityCombo.id,
|
|
priority: 10,
|
|
});
|
|
await mappingsDb.createModelComboMapping({
|
|
pattern: "gpt-*",
|
|
comboId: disabledCombo.id,
|
|
priority: 100,
|
|
enabled: false,
|
|
});
|
|
|
|
const resolved = await mappingsDb.resolveComboForModel("gpt-4o");
|
|
|
|
assert.ok(resolved);
|
|
assert.equal(resolved.name, "priority");
|
|
assert.deepEqual(resolved.models, [
|
|
{
|
|
id: "priority-model-1-openai-gpt-4o",
|
|
kind: "model",
|
|
providerId: "openai",
|
|
model: "openai/gpt-4o",
|
|
weight: 0,
|
|
},
|
|
]);
|
|
});
|
|
|
|
test("resolveComboForModel skips corrupted combo payloads and keeps scanning", async () => {
|
|
const brokenCombo = await createCombo("broken", "gpt-4o");
|
|
const fallbackCombo = await createCombo("fallback", "gpt-4o-mini");
|
|
|
|
await mappingsDb.createModelComboMapping({
|
|
pattern: "gpt-4*",
|
|
comboId: brokenCombo.id,
|
|
priority: 10,
|
|
});
|
|
await mappingsDb.createModelComboMapping({
|
|
pattern: "gpt-*",
|
|
comboId: fallbackCombo.id,
|
|
priority: 1,
|
|
});
|
|
|
|
const db = core.getDbInstance();
|
|
db.prepare("UPDATE combos SET data = ? WHERE id = ?").run("{not-json", brokenCombo.id);
|
|
|
|
const resolved = await mappingsDb.resolveComboForModel("gpt-4o");
|
|
|
|
assert.ok(resolved);
|
|
assert.equal(resolved.name, "fallback");
|
|
});
|
|
|
|
test("resolveComboForModel skips inactive mapped combos and keeps scanning", async () => {
|
|
const inactiveCombo = await createCombo("inactive", "gpt-4o", { isActive: false });
|
|
const fallbackCombo = await createCombo("fallback", "gpt-4o-mini");
|
|
|
|
await mappingsDb.createModelComboMapping({
|
|
pattern: "gpt-4*",
|
|
comboId: inactiveCombo.id,
|
|
priority: 10,
|
|
});
|
|
await mappingsDb.createModelComboMapping({
|
|
pattern: "gpt-*",
|
|
comboId: fallbackCombo.id,
|
|
priority: 1,
|
|
});
|
|
|
|
const resolved = await mappingsDb.resolveComboForModel("gpt-4o");
|
|
|
|
assert.ok(resolved);
|
|
assert.equal(resolved.name, "fallback");
|
|
});
|
|
|
|
test("resolveComboForModel returns null when only matching combo is inactive", async () => {
|
|
const inactiveCombo = await createCombo("inactive", "gpt-4o", { isActive: false });
|
|
|
|
await mappingsDb.createModelComboMapping({
|
|
pattern: "gpt-4*",
|
|
comboId: inactiveCombo.id,
|
|
});
|
|
|
|
const resolved = await mappingsDb.resolveComboForModel("gpt-4o");
|
|
|
|
assert.equal(resolved, null);
|
|
});
|
|
|
|
test("resolveComboForModel returns null when nothing matches", async () => {
|
|
const combo = await createCombo("alpha", "gpt-4o");
|
|
|
|
await mappingsDb.createModelComboMapping({
|
|
pattern: "claude-*",
|
|
comboId: combo.id,
|
|
enabled: false,
|
|
});
|
|
|
|
const resolved = await mappingsDb.resolveComboForModel("gpt-4o");
|
|
|
|
assert.equal(resolved, null);
|
|
});
|