Function createBotRequest

apps/web/src/lib/bot/request-logging.ts:31–52

(params: CreateBotRequestParams)

 * on this row existing, so a silent failure here would drop the result.
 */
export async function createBotRequest(params: CreateBotRequestParams): Promise<string> {
  const [row] = await db
    .insert(bot_requests)
    .values({
      created_by: params.createdBy,
      organization_id: params.organizationId,
      platform_integration_id: params.platformIntegrationId,
      platform: params.platform,
      platform_thread_id: params.platformThreadId,
      platform_message_id: params.platformMessageId,
      user_message: params.userMessage,
      model_used: params.modelUsed ?? null,
      status: 'pending',
    })
    .returning({ id: bot_requests.id });

  if (!row) {
    throw new Error('createBotRequest: insert returned no row');
  }

  return row.id;
}

type UpdateBotRequestParams = {
  status?: BotRequestStatus;