Function insertLedgerOnlyRow

tests/api/my-usage-readonly.test.ts:172–207

(params: {
  userId: number;
  key: string;
  model: string;
  endpoint: string;
  costUsd: string;
  inputTokens: number;
  outputTokens: number;
  createdAt: Date;
  clientIp?: string | null;
})

}

async function insertLedgerOnlyRow(params: {
  userId: number;
  key: string;
  model: string;
  endpoint: string;
  costUsd: string;
  inputTokens: number;
  outputTokens: number;
  createdAt: Date;
  clientIp?: string | null;
}) {
  const requestId = nextLedgerRequestId();
  const providerId = nextLedgerProviderId();

  await db.insert(usageLedger).values({
    requestId,
    userId: params.userId,
    key: params.key,
    providerId,
    finalProviderId: providerId,
    model: params.model,
    originalModel: params.model,
    endpoint: params.endpoint,
    apiType: "openai",
    statusCode: 200,
    isSuccess: true,
    blockedBy: null,
    costUsd: params.costUsd,
    inputTokens: params.inputTokens,
    outputTokens: params.outputTokens,
    clientIp: params.clientIp ?? null,
    createdAt: params.createdAt,
  });

  return requestId;
}

describe.skipIf(!process.env.DSN)("my-usage API：只读 Key 自助查询", () => {
  const createdUserIds: number[] = [];