Running the RONIN client with a local database

client.ts

import { Database } from "bun:sqlite";
import ronin from 'ronin';
import { Transaction, type Model } from 'blade-compiler';
import * as rawModels from './schema';

const database = new Database('db.sqlite');
const models = Object.values(rawModels) as unknown as Array<Model>;

const { get } = ronin({
  fetch: (async (request: Request): Promise<Response> => {
    const { queries } = (await request.json()) as { queries: Array<object> };
    const transaction = new Transaction(queries, { models });

    const databaseTransaction = database.transaction(() => {
      return transaction.statements.map(({ statement, params }) => {
        return database.prepare(statement).all(...(params as Array<string>))
      });
    });

    const results = databaseTransaction() as Array<Array<Record<string, unknown>>>;

    return Response.json({
      results: transaction.formatResults(results),
    });
  }) as typeof fetch,
  token: 'empty'
});

await get.users();