From 2eb79afb2ad8856cc15c98bc81d7031a0a33bb23 Mon Sep 17 00:00:00 2001 From: Jarred Sumner <709451+Jarred-Sumner@users.noreply.github.com> Date: Thu, 20 Jul 2023 18:14:34 -0700 Subject: Update sqlite.md --- docs/api/sqlite.md | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) (limited to 'docs/api/sqlite.md') 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 }); -- cgit v1.2.3