Firstly, thanks sincerely for your contributions. Q. Are you interes

Hi there. Here is the documentation for transactions: <a href="https://sqlocal.dallash

Feature: Transaction about sqlocal HOT 3 CLOSED

michaelpeterlee commented on June 6, 2024

Feature: Transaction

from sqlocal.

Comments (3)

DallasHoff commented on June 6, 2024

Hi there. Here is the documentation for transactions: https://sqlocal.dallashoffman.com/api/transaction

from sqlocal.

michaelpeterlee commented on June 6, 2024

For reference: BEGIN/END TRANSACTION statements offer more functionality than SQLocal.transaction().

Eg.

await SQLocal.exec('BEGIN TRANSACTION')
await SQLocal.exec('INSERT')
await SQLocal.exec('SELECT')
// Do something
await SQLocal.exec('UPDATE')
// throw new Error('Insert and Update will rollback');
await SQLocal.exec('END TRANSACTION')

from sqlocal.

DallasHoff commented on June 6, 2024

If you'd prefer, you can open and close the transaction yourself by running it with the sql method.

const { sql } = new SQLocal('database.sqlite3');

async function addTagToLatestNote(newTagLabel: string) {
  await sql`BEGIN TRANSACTION`;
  
  try {
    const [{id: tagId}] = await sql`INSERT INTO tag (label) VALUES (${newTagLabel}) RETURNING id`; 
    const [{id: noteId}] = await sql`SELECT id FROM note ORDER BY createdAt desc LIMIT 1`;
    await sql`INSERT INTO noteTag (tagId, noteId) VALUES (${tagId}, ${noteId})`;
  } catch (err) {
    await sql`ROLLBACK`;
    return;
  }
  
  await sql`END`;
}