execute method

  1. @override
Future<int> execute(
  1. String sql, {
  2. List? parameters,
})
override

Executes a SQL command (INSERT, UPDATE, DELETE) and returns affected rows

Implementation

@override
Future<int> execute(String sql, {List<dynamic>? parameters}) async {
  if (!_isConnected || _db == null) {
    await connect();
  }

  try {
    _db!.execute(sql, parameters ?? []);
    return _db!.lastInsertRowId;
  } catch (e) {
    throw DatabaseQueryError('SQLite execute failed: $e');
  }
}