aboutsummaryrefslogtreecommitdiff
path: root/docs/api/sqlite.md
diff options
context:
space:
mode:
authorGravatar Jarred Sumner <709451+Jarred-Sumner@users.noreply.github.com> 2023-07-20 18:14:34 -0700
committerGravatar Jarred Sumner <709451+Jarred-Sumner@users.noreply.github.com> 2023-07-20 18:14:34 -0700
commit2eb79afb2ad8856cc15c98bc81d7031a0a33bb23 (patch)
treefaef49308acd66f5b1a7545e5390620b668fabd7 /docs/api/sqlite.md
parent020cf46346a66435b353c3914ef01e8fdc74779a (diff)
downloadbun-2eb79afb2ad8856cc15c98bc81d7031a0a33bb23.tar.gz
bun-2eb79afb2ad8856cc15c98bc81d7031a0a33bb23.tar.zst
bun-2eb79afb2ad8856cc15c98bc81d7031a0a33bb23.zip
Update sqlite.md
Diffstat (limited to '')
-rw-r--r--docs/api/sqlite.md10
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
});