executeBatch method
Executes multiple SQL commands in a batch
Implementation
@override
Future<List<int>> executeBatch(
String sql, List<List<dynamic>> parametersList) async {
if (!_isConnected || _db == null) {
await connect();
}
try {
final results = <int>[];
for (var params in parametersList) {
_db!.execute(sql, params);
results.add(_db!.lastInsertRowId);
}
return results;
} catch (e) {
throw DatabaseQueryError('SQLite batch execute failed: $e');
}
}