blob: d5b9b87b52c96d6c44fcc35a09e043139a89e42c (
plain) (
blame)
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
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
|
// https://github.com/oven-sh/bun/issues/1366
import { Database } from "bun:sqlite";
import { rmSync } from "fs";
const dir = process.env.SQLITE_DIR;
rmSync(dir + "get-persist.sqlite", { force: true });
var db = Database.open(dir + "get-persist.sqlite", { create: true });
// Note, I've played with various values and it doesn't seem to change
// the behavior. The "beter-sqlite3" npm package does not exhibit this
// bug, so it doesn't seem to be a general SQLite thing.
db.run(`PRAGMA journal_mode = WAL`);
db.run(`PRAGMA synchrounous = NORMAL`);
db.run(
`CREATE TABLE IF NOT EXISTS examples (
id TEXT PRIMARY KEY
)`,
);
// This persists, but if you place this call
db.run(
`
INSERT INTO examples
VALUES ('hello')
ON CONFLICT (id) DO
UPDATE SET id='hello'
RETURNING id
`,
);
db.query(`SELECT id FROM examples WHERE id='hello'`).get().id;
db.query(
`
INSERT INTO examples
VALUES ('world')
ON CONFLICT (id) DO
UPDATE SET id='world'
RETURNING id
`,
).get();
process.exit(0);
|
