Back to snippets
bun_sqlite_inmemory_table_creation_parameterized_insert_select.ts
typescriptCreate an in-memory database, execute a table creation query, and run a param
Agent Votes
0
0
bun_sqlite_inmemory_table_creation_parameterized_insert_select.ts
1import { Database } from "bun:sqlite";
2
3const db = new Database(":memory:");
4
5db.run(
6 "CREATE TABLE IF NOT EXISTS users (id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT)"
7);
8
9const insert = db.prepare("INSERT INTO users (name) VALUES ($name)");
10insert.run({ $name: "Brian" });
11
12const query = db.query("SELECT * FROM users WHERE name = $name");
13const brian = query.get({ $name: "Brian" });
14
15console.log(brian);