Never stop coding. Free MIT AI gateway: one endpoint, 375 providers (150+ free), 1,400+ models Kimi, Claude, GPT, Gemini, GLM, DeepSeek, MiniMax. Works with Claude Code, Codex, Cursor, OpenCode, Cline & Copilot. Quota-aware auto-fallback, RTK+Caveman compression saves 15-95% tokens, MCP/A2A, Desktop/PWA. Built by 900+ contributors
TypeScript a2aai-agentsai-gatewayanthropicclaudeclaude-codeclinecodexcopilotcursordeepseekfree-aigeminikimillm-gatewaymcpopenaiopenai-proxyqwentoken-saver
/**
* db/quotaGroups.ts — CRUD for the quota_groups table.
*
* Quota groups are first-class entities that pool multiple quota pools
* under a shared namespace. Pools reference groups via quota_pools.group_id.
*
* All SQL goes through prepared statements — never raw string interpolation.
* Import getDbInstance from ./core (Hard Rule #5).
*/
import { getDbInstance } from "./core";
import { invalidateModelCatalogCache } from "./readCache";
// ---------------------------------------------------------------------------
// Types
// ---------------------------------------------------------------------------
export interface QuotaGroup {
id: string;
name: string;
createdAt: string;
}
// ---------------------------------------------------------------------------
// Internal helpers
// ---------------------------------------------------------------------------
interface StatementLike<TRow = unknown> {
all: (...params: unknown[]) => TRow[];
get: (...params: unknown[]) => TRow | undefined;
run: (...params: unknown[]) => { changes: number };
}
interface DbLike {
prepare: <TRow = unknown>(sql: string) => StatementLike<TRow>;
}
function getDb(): DbLike {
return getDbInstance() as unknown as DbLike;
}
interface GroupRow {
id: string;
name: string;
created_at: string;
}
function rowToGroup(row: GroupRow): QuotaGroup {
return {
id: row.id,
name: row.name,
createdAt: row.created_at,
};
}
function makeId(): string {
return crypto.randomUUID();
}
// ---------------------------------------------------------------------------
// Public API
// ---------------------------------------------------------------------------
/**
* Create a new quota group with the given name.
* Returns the newly created QuotaGroup row.
*/
export function createGroup(name: string): QuotaGroup {
const id = makeId();
const now = new Date().toISOString();
getDb()
.prepare("INSERT INTO quota_groups (id, name, created_at) VALUES (?, ?, ?)")
.run(id, name, now);
return { id, name, createdAt: now };
}
/**
* Get a single quota group by id.
* Returns null if not found.
*/
export function getGroup(id: string): QuotaGroup | null {
const row = getDb()
.prepare<GroupRow>("SELECT id, name, created_at FROM quota_groups WHERE id = ?")
.get(id);
if (!row) return null;
return rowToGroup(row);
}
/**
* Convenience helper — returns just the group name, or null if not found.
*/
export function getGroupName(id: string): string | null {
const row = getDb()
.prepare<{ name: string }>("SELECT name FROM quota_groups WHERE id = ?")
.get(id);
return row ? row.name : null;
}
/**
* List all quota groups, ordered by created_at ascending.
*/
export function listGroups(): QuotaGroup[] {
const rows = getDb()
.prepare<GroupRow>("SELECT id, name, created_at FROM quota_groups ORDER BY created_at ASC")
.all();
return rows.map(rowToGroup);
}
/**
* Rename an existing group.
* Returns true if the row was updated, false if the group was not found.
*/
export function renameGroup(id: string, name: string): boolean {
const result = getDb().prepare("UPDATE quota_groups SET name = ? WHERE id = ?").run(name, id);
if (result.changes > 0) {
invalidateModelCatalogCache();
return true;
}
return false;
}
/**
* Delete a quota group by id.
*
* Throws if:
* - The group is the protected seed 'group-demo' — it must always exist.
* - Any quota_pools row still references this group via group_id — the caller
* must reassign or delete those pools first.
*
* Returns true if a row was deleted, false if the group was not found.
*/
export function deleteGroup(id: string): boolean {
// Protect the seed group.
if (id === "group-demo") {
throw new Error(
"Cannot delete the protected seed group 'group-demo'. Reassign its pools to another group first.",
);
}
// Guard: refuse deletion when pools still reference this group.
const refRow = getDb()
.prepare<{ cnt: number }>("SELECT COUNT(*) AS cnt FROM quota_pools WHERE group_id = ?")
.get(id);
if (refRow && refRow.cnt > 0) {
throw new Error(`Group '${id}' has pools; reassign or delete them first.`);
}
const result = getDb().prepare("DELETE FROM quota_groups WHERE id = ?").run(id);
return result.changes > 0;
}