1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
import { PGlite } from "npm:@electric-sql/pglite";
const db = new PGlite();
await db.query(`
CREATE TABLE IF NOT EXISTS test (
id SERIAL PRIMARY KEY,
test TEXT,
counter INTEGER
);
`);
await db.query(`
INSERT INTO test (id, test, counter)
VALUES (1, 'valtown', 0);
`);
export default async function(req: Request): Promise<Response> {
await db.query(`
UPDATE test
SET counter = counter + 1
WHERE id = 1;
`);
return Response.json(await db.query("SELECT counter FROM test"));
}