import { VtDialect } from "https://esm.town/v/easrng/kyselyVtDialect";
import type { DB } from "https://nbbaier-kyselyVtTypes.web.val.run/?tables=users";
import { Kysely } from "npm:kysely@0.27.3";
export default async function main(req: Request): Promise<Response> {
const db = new Kysely<DB>({
dialect: new VtDialect(),
});
const rows = await db.selectFrom("users").selectAll().where("id", "=", "1").execute();
return Response.json({
description: "This val demonstrates using Kysely with Val Town's SQLite database.",
query: "SELECT * FROM users WHERE id = '1'",
result: rows
});
}