diff options
author | 2023-07-20 18:14:34 -0700 | |
---|---|---|
committer | 2023-07-20 18:14:34 -0700 | |
commit | 2eb79afb2ad8856cc15c98bc81d7031a0a33bb23 (patch) | |
tree | faef49308acd66f5b1a7545e5390620b668fabd7 /docs/api/sqlite.md | |
parent | 020cf46346a66435b353c3914ef01e8fdc74779a (diff) | |
download | bun-2eb79afb2ad8856cc15c98bc81d7031a0a33bb23.tar.gz bun-2eb79afb2ad8856cc15c98bc81d7031a0a33bb23.tar.zst bun-2eb79afb2ad8856cc15c98bc81d7031a0a33bb23.zip |
Update sqlite.md
Diffstat (limited to '')
-rw-r--r-- | docs/api/sqlite.md | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/docs/api/sqlite.md b/docs/api/sqlite.md index 0774e6628..e04b8ded7 100644 --- a/docs/api/sqlite.md +++ b/docs/api/sqlite.md @@ -75,7 +75,7 @@ Note: `close()` is called automatically when the database is garbage collected. ```ts const olddb = new Database("mydb.sqlite"); const contents = olddb.serialize(); // => Uint8Array -const newdb = new Database(contents); +const newdb = Database.deserialize(contents); ``` Internally, `.serialize()` calls [`sqlite3_serialize`](https://www.sqlite.org/c3ref/serialize.html). @@ -250,7 +250,7 @@ Transactions are a mechanism for executing multiple queries in an _atomic_ way; ```ts const insertCat = db.prepare("INSERT INTO cats (name) VALUES ($name)"); -const insertCats = db.transaction((cats) => { +const insertCats = db.transaction(cats => { for (const cat of cats) insertCat.run(cat); }); ``` @@ -261,7 +261,7 @@ To execute the transaction, call this function. All arguments will be passed thr ```ts const insert = db.prepare("INSERT INTO cats (name) VALUES ($name)"); -const insertCats = db.transaction((cats) => { +const insertCats = db.transaction(cats => { for (const cat of cats) insert.run(cat); return cats.length; }); @@ -296,11 +296,11 @@ const insertExpense = db.prepare( "INSERT INTO expenses (note, dollars) VALUES (?, ?)", ); const insert = db.prepare("INSERT INTO cats (name, age) VALUES ($name, $age)"); -const insertCats = db.transaction((cats) => { +const insertCats = db.transaction(cats => { for (const cat of cats) insert.run(cat); }); -const adopt = db.transaction((cats) => { +const adopt = db.transaction(cats => { insertExpense.run("adoption fees", 20); insertCats(cats); // nested transaction }); |