Can a sqlite batch be reused in flutter?

[axelthat]

So if I have an sql batch can it be reused again and again? So for example,

await _db.transaction((txn) async {
  final batch = txn.batch();

  // Some queries that adds query to batch.
  
  await batch.commit();

  // Some queries that adds query to next set of batch.
  
  await batch.commit();

  // Some queries that adds query to next set of batch.
  
  await batch.commit();
});

So is it okay to use one batch and perform multiple set of queries?

[alextekartik]

So is it okay to use one batch and perform multiple set of queries?

No a batch can only be committed once. You have to create a new batch.

[axelthat]

Gotcha! Tysm